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