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