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