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