Electronic Spreadsheet – Set 8 January 28, 2025 by aasi Home › Computer › MS Excel MS Excel Electronic Spreadsheet – Set 8 📝 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. 1234567891011121314151617181920212223242526272829303132333435363738 Electronic Spreadsheet – Set 8 Dear ! This is Electronic Spreadsheet – Set 8 Quiz and it contains 38 questions. Keep Learning! 1 / 38 1) How can you show or hide the gridlibes in Excel Worksheet? Go to Tools>>options>> View tab and mark or remove the check box named gridlie Click Gridline tool on forms toolbar Both of these None of these 2 / 38 2) To create a formula , you can use : Values but not cell references cell references but not values Values or cell references although not both at the same time Value and cell references 3 / 38 3) you can group noncontiguous worksheets with The alt+enter key The ctrl key and mouse The shift key and the mouse The group button on the standard toolbar 4 / 38 4) Pre made sheet formats like sample , Classic and Accounting , Colorful etc can be applied from from Format >> cells from Format>> Autoformat from Table >> Autoformat All of these 5 / 38 5) Which of the following methods will not enter data in a cell ? Pressing the Esc key Pressing an arrow key Pressing the tab key clicking enter button to the formula bar 6 / 38 6) Which of the following is not an underline option in the format cells dialog box ? Double Single Accounting Double Accounting Single Engineering 7 / 38 7) When the formula bar is activated , you can see The Edit Formula bar button The Cancel button The Enter button All of these 8 / 38 8) Except for the ………. function , a formula with a logical function shows the word “TRUE” or “FALSE” as a result IF AND OR NOT 9 / 38 9) Status indicators are located on the Vertical scroll bar Horizontal scroll bar Formula bar Standard toolbar 10 / 38 10) The default header for a worksheet is Username Date and Time Sheet tab Name None 11 / 38 11) Which function calculates your monthly mortage payment ? PMT (payment) NPER (number of periods) PV (present value) All 12 / 38 12) Excel files have a default extension of Xls Xlw Wk1 123 13 / 38 13) can you set 0.5 inch left indentation for a cell in excel ? Excel does not have indentation feature you can specify indentation only if you turn the rule on Indentation can be from Format Cells dialog box The indentation can be specified only when printing 14 / 38 14) If you need a text to show vertically in a cell . how will you achieve this ? Choose vertical on Text alignment in Format Cells dialog box Choose 90 degree in orientation of Format cells dialog box Choose Distributed from the vertical drop down list of Format cells dailog box Choose Center across Selection from Horizontal combo box in Format Cells dialog box 15 / 38 15) Where can you change automatic or manual calculation mode in Excel? Double CAL indicator on status bar Go to Tools>>Options>>Calculation and mark the corresponding radio button Both of these None of these 16 / 38 16) Merge cells option can be applied from Format cells dialog box Alignment Tab Formatting toolbar Both of these None of these 17 / 38 17) Macros are “run” or executed from the ……..menu. Insert Format Tools Data 18 / 38 18) Gridlines a. May be turned off for display but turned on for printing b. May be turned on or off for printing c. The be turned off for display and printing d. (a),(b)and(c) 19 / 38 19) Formula in Excel start with % = + – 20 / 38 20) Special category of number tab in Format cells dialog box can be used to apply format like Zip code Phone Number Both of these None of these 21 / 38 21) Which function will you use to enter current time in a worksheet cell ? =today =now() =Time() current time() 22 / 38 22) You can merge the main document with data source in Excel. In mail merge operation, Word is usually? Server Source Client None of these 23 / 38 23) Which of the following is not the correct method of editing the cell content ? Press the Alt key Press the F2 key Click the formula bar Double click the cell 24 / 38 24) How are data organized in a spreadsheet ? Lines and spaces Layers and planes Rows and Columns Height and width 25 / 38 25) you can automatically adjust the size of text in a cell if they do not fit in width by Double clicking on the right border of column header From Format choose columns and then Auto fit selection From Format choose columns and then shrink to fit check box All of these 26 / 38 26) A function inside another function is called a ………function Nested Round Sum Text 27 / 38 27) You can use the formula palette to? Format cells containing numbers Create and edit formula containing functions Enter assumptions data Copy a range of cells 28 / 38 28) The cell reference for cell range of G2 to M12 is …………. G2.M12 G2;M12 G2:M12 G2 M12 29 / 38 29) The software which contain rows and columns is called ……….. Database Drawing Spreadsheet WordProcessing 30 / 38 30) Each excel file is a workbook that contains different sheets. Which of the following cannot be a sheet in workbook? Work sheet Chart sheet Module sheet Data sheet 31 / 38 31) The name box on to the left of formula bar? Shows the name of workbook currently working on Shows the name of worksheet currently working on Shows the name of cell or range currently working on None of these 32 / 38 32) you can open the consolidate dialog box by choosing consolidate from the ……. menu. Insert Format Tools Data 33 / 38 33) To drag a selected range of data to another worksheet in the same workbook, use the Tab key Alt key Shift key Ctrl key 34 / 38 34) To edit in an embedded excel worksheet object in a word document Use the excel menu bar and toolbars inside the word application Edit the hyperlink Edit the data in a excel source application Use the word menu bar and toolbars 35 / 38 35) Which of the following is not an option of the spelling dialog box ? Ignore Ignore all Edit Change 36 / 38 36) How can you update the values of formula cells if Auto calculate mode of Excel is disabled? F8 F9 F10 F11 37 / 38 37) An excel workbook is a collection of Workbooks Worksheets Charts Worksheets and charts 38 / 38 38) Tab scroll buttons are place on Excel screen? Towards the buttom right corner Towards the bottom left corner Towards the top right corner Towards the top left corner 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
