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