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