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