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