Electronic Spreadsheet – Set 8 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. 1234567891011121314151617181920212223242526272829303132333435363738 Electronic Spreadsheet – Set 8 Dear ! This is Electronic Spreadsheet – Set 8 Quiz and it contains 38 questions. Keep Learning! 1 / 38 1) you can open the consolidate dialog box by choosing consolidate from the ……. menu. Insert Format Tools Data 2 / 38 2) 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 3 / 38 3) A function inside another function is called a ………function Nested Round Sum Text 4 / 38 4) 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 5 / 38 5) Which function calculates your monthly mortage payment ? PMT (payment) NPER (number of periods) PV (present value) All 6 / 38 6) 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 7 / 38 7) 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 8 / 38 8) When the formula bar is activated , you can see The Edit Formula bar button The Cancel button The Enter button All of these 9 / 38 9) 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 10 / 38 10) The software which contain rows and columns is called ……….. Database Drawing Spreadsheet WordProcessing 11 / 38 11) An excel workbook is a collection of Workbooks Worksheets Charts Worksheets and charts 12 / 38 12) 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 13 / 38 13) You can merge the main document with data source in Excel. In mail merge operation, Word is usually? Server Source Client None of these 14 / 38 14) 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 15 / 38 15) The cell reference for cell range of G2 to M12 is …………. G2.M12 G2;M12 G2:M12 G2 M12 16 / 38 16) 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 17 / 38 17) Merge cells option can be applied from Format cells dialog box Alignment Tab Formatting toolbar Both of these None of these 18 / 38 18) 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 19 / 38 19) To drag a selected range of data to another worksheet in the same workbook, use the Tab key Alt key Shift key Ctrl key 20 / 38 20) 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 21 / 38 21) Excel files have a default extension of Xls Xlw Wk1 123 22 / 38 22) The default header for a worksheet is Username Date and Time Sheet tab Name None 23 / 38 23) Status indicators are located on the Vertical scroll bar Horizontal scroll bar Formula bar Standard toolbar 24 / 38 24) 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 25 / 38 25) 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 26 / 38 26) 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 27 / 38 27) Which of the following is not an option of the spelling dialog box ? Ignore Ignore all Edit Change 28 / 38 28) Except for the ………. function , a formula with a logical function shows the word “TRUE” or “FALSE” as a result IF AND OR NOT 29 / 38 29) Which function will you use to enter current time in a worksheet cell ? =today =now() =Time() current time() 30 / 38 30) Formula in Excel start with % = + – 31 / 38 31) How are data organized in a spreadsheet ? Lines and spaces Layers and planes Rows and Columns Height and width 32 / 38 32) Which of the following is not an underline option in the format cells dialog box ? Double Single Accounting Double Accounting Single Engineering 33 / 38 33) 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 34 / 38 34) 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 35 / 38 35) 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 36 / 38 36) Macros are “run” or executed from the ……..menu. Insert Format Tools Data 37 / 38 37) How can you update the values of formula cells if Auto calculate mode of Excel is disabled? F8 F9 F10 F11 38 / 38 38) 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) 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
