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