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