Electronic Spreadsheet – Set 4 January 28, 2025 by aasi 0% Report a question What’s wrong with this question? You cannot submit an empty report. Please add some details. 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950 Electronic Spreadsheet – Set 4 Dear ! This is Electronic Spreadsheet – Set 4 Quiz and it contains 50 questions. Keep Learning! 1 / 50 1) Which function is used to calculate depreciation , rates of return , future values and loan payment amounts ? Math & Trigonometry Logical Financial Statistical 2 / 50 2) Which of the following formulas is not entered correctly? =B7*B1 10+50 =B7+14 =10+50 3 / 50 3) In help menu of Excel , which of the following tabs are found ? All of these Index tab Answer Wizard tab Content tab 4 / 50 4) Which chart can be created in Excel ? Area Line Pie All of these 5 / 50 5) To active the previous cell in a pre-selected range,press? The Alt key None of these The Tab key The Enter key 6 / 50 6) To record a sequence of keystrokes and mouse actions to play back later we use: Sound Recorder Media player Calculator Macro Recorder 7 / 50 7) To drag a selected range of data to another worksheet in the same workbook,use the? Ctrl key Shift key Alt key Tab key 8 / 50 8) You can open the sort dialog box by choosing short from the…….menu? View Format Tools Data 9 / 50 9) How many worksheets can workbook have ? 8 3 None of these 255 10 / 50 10) Which of the following is an absolute cell reference ? #a#1 !A!1 $A$1 A1 11 / 50 11) Whic area in an excel window allows entering values and formulas? Menu bar Formula bar Standard toolbar Title bar 12 / 50 12) How can you remove borders applied in cells? None of these B.Open the list on Border tool in formatting toolbar then choose first tool(no border) A.Choose None on Border tab of format cell C.Both A&B 13 / 50 13) A ———– is a grid with labeled columns and rows. Toolbar Worksheet Dialog box Clipboard 14 / 50 14) Which of the following format you can decide to apply or not in AutoFormat dialog box? Number format Border format All of these Font format 15 / 50 15) To drag a selected range of data to another worksheet in the same workbook, use the? Shift key Ctrl key Alt key Tab key 16 / 50 16) Which of the following methods cannot be used to enter data in a cell? Pressing an arrow key Clicking on the formula bar Pressing the tab key Pressing the Esc key 17 / 50 17) To insert three columns between columns D & E you would? Select column E Select column Select column E,F and G Select columns D,E and F 18 / 50 18) What do you call the chart that shows the proportions of how one or more data elements relate to another data element Column Chart Line Chart Pie Chart XY Chart 19 / 50 19) Excel uniquely identifies cells within a worksheet with a cell name? Column letters and row numbers Cell names Cell lacator coordinates Column numbers and row letters 20 / 50 20) Which of the following is not a term of MS Excel ? Rows Columns Document Cells 21 / 50 21) We can save and protect the workbook by Write Reservation password Protection Password Any of these Read only Recommended 22 / 50 22) The auto calculate feature ? Can only add values in a range of cells Automatically creates formulas and adds them to a worksheet All of these Provides a quick way to the result of a arithmetic operation on a range of cells 23 / 50 23) Which key do you press to check spelling ? F5 F9 F3 F7 24 / 50 24) The active cell : b. Receives the data the user enters a. is defined by a hold border around the cell c. It is the formula bar d. only A and B 25 / 50 25) A worksheet range is a? A range of values such as from 23 to 234 A command used for data modeling A group of worksheets A group of cells 26 / 50 26) In a worksheet you can select ? Rows The entire worksheet Columns All of these 27 / 50 27) Which would you choose to create a bar diagram ? Edit, Chart Tools , Chart Format, Chart Insert , Chart 28 / 50 28) You can check the conditions against_________when applying conditional formatting? B.Formula A.Cell value C.Both A & B D.None of these 29 / 50 29) Which of the following is not a valid Zoom percentage in Excel? 10 300 100 500 30 / 50 30) The spelling tool is placed on_____toolbar? Formatting Standard Drawing Reviewing 31 / 50 31) What is entered by the function =today()? The date value for the day according to system clock Todays date as text format All of these The time value according to system clock 32 / 50 32) Which button do you click to add up a series of numbers? The formula button The quicktotal button The total The autosum button 33 / 50 33) Which symbol must all formula begin with? ( @ + = 34 / 50 34) You can add an image to a template by clicking the insert picture from file button on the………Toolbar? Standard Picture Formatting Drawing 35 / 50 35) In Excel , the Fill Color button on the formatting toolbar is used for what ? To selected a distribution of figures To insert a background To add borders To add shading or color to a cell range 36 / 50 36) Formatting a cell in Number foemat you can’t set? Currency symbol Negative numbers Decimal places Use 1000 seperator 37 / 50 37) In Excel , a Data Series is defined as what ? A division of results A collection of related data A cell reference A type of chart 38 / 50 38) What will be the output if you format the cell containing 5436.8 as ‘#,##,0.00’ ? 5,430.00 5,436.8 5,436.80 6.8 39 / 50 39) How can set page Border in Excel from? From Border tool in Formatting toolbar You cannot set page border in Excel From Border tab in Format Cells dialog box From line style tool in drawing toolbar 40 / 50 40) Formatting a cell in currency, you can specify? C)Both A & B D)None of these A)Decimal places B)Currency symbol 41 / 50 41) Which setting you must modify to print a worksheet using letterhead ? Layout Orientation Paper Margin 42 / 50 42) Hyperlinks can be ? All of these Drawing objects Text Pictures 43 / 50 43) The spelling dialog box can be involved by choosing spelling from ———-menu file tools insert view 44 / 50 44) Hyperlinks cannot be? Special shapes like star and banners Pictures Drawing objects like rectangles ovals All can be hyperlinks 45 / 50 45) Which of the following formulas will Excel Not be able to calculate ? Sum(A1:A5)*.5 =SUM(Sales) A3 =sum(A2:A5) 10 =sum(A1:A5)/(10 10) 46 / 50 46) Which function will you use to enter current time in a worksheet cell? A)=today() =currentTime() =time() =now() 47 / 50 47) When working in the page break preview, you can? Change the print area Add or remove page breaks View exactly where each page break occurs All of these 48 / 50 48) When the formula bar is active, you can see? The cancel button All of these The edit formula button The enter button 49 / 50 49) When you print preview a worksheet? All of these The selected range is displayed The active portion of the worksheet is displayed The entire worksheet is displayed 50 / 50 50) Which language is used to create macros in Excel ? Visual C++ C Visual Basic Java Your score isThe average score is 0%🎉 Challenge alert! 💡 Share this quiz with your friends and see who scores the highest! 🏆🤩🔥 LinkedIn Facebook Follow Us @ 0% Restart quiz Exit We’d love to hear your thoughts! 📝 Share your valuable review with us. 🙌 🌟 Thank you for your support! Your feedback means the world to us. 🙏💖 Send feedback