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