MS Excel |Set-1 MS-Excel April 20, 2022April 20, 2022GyanBazarLeave a Comment on MS Excel |Set-1 You can practice in this section operating system MCQ which is important for exam point of view. /53 4 Created on April 20, 2022 By GyanBazar MS Excel Set-1 In this section we can find out the ms-excel related most important mcq collections. 1 / 53 1. In Excel default style for new data keyed in a new workbook is a. Comma b. Per cent c. Normal d. Currency 2 / 53 2. This type of software is similar to an accountant's worksheet a. Word processing b. Graphics c. Spreadsheets d. Database 3 / 53 3. What happens when dollar signs ($) are entered In a cell address? a. An absolute cell address is created b. The status bar does not display the cell address c. Cell address will change when it is copied to another cell d. The sheet tab is changed 4 / 53 4. To create a formula, you can use: a. Values but not cell references b. Value and cell references c. Values or cell references although not both at the same time d. Cell references but not values 5 / 53 5. In Excel you can activate a cell by a. Pressing the Tab key b. Pressing an arrow key c. Clicking the cell d. All of above 6 / 53 6. The chart wizard term data series refers to a. A chart legend b. A collection of chart data markers c. A set of values you plot in a chart d. A data label 7 / 53 7. What are the basic rectangular building blocks of a spreadsheet? a. Cells b. Help button c. Zoom slide d. All of these 8 / 53 8. How can you show or hide the gridlines in Excel Worksheet? a. Click Gridline tool on Forms toolbar b. Go to Tools >> Options > > View tab and mark or remove the check box named Gridline c. Both of above d. none of the above 9 / 53 9. In Excel, the Fill Color button on the Formatting toolbar is used for what? a. To insert a background. b. To add shading or color to a cell range c. To select a distribution of figures. d. None of the above 10 / 53 10. Which of the following formulas will Excel Not be able to calculate? a. =SUM(Sales)-A3 b. =SUM(A1:A5)-10 c. =SUM(A1:A5)/(10-10) d. =SUM(A1:A5)*.5 11 / 53 11. What is an expression that tells how the numbers in a determined set of cells are to be calculated? a. Formula b. Query c. Data d. Field 12 / 53 12. In help menu of Excel, which of the following tabs are found? a. Contents tab b. Index tab c. Answer Wizard tab d. all of the above 13 / 53 13. You can add a hyperlink to your worksheet by pressing a. Alt + K b. Ctrl + Shift + K c. Ctrl + H d. Ctrl + K 14 / 53 14. If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you can... a. Press the Erase key b. Press the Edit Formula button c. Press the Enter button d. Press Esc 15 / 53 15. You can print a. An entire worksheet b. A range of cells by range name c. A single worksheet d. All of the above 16 / 53 16. Which of the following is not an option in the spelling dialog box? a. Edit b. Change c. Ignore all d. Ignore 17 / 53 17. Without using the mouse or the arrow keys, what is the fastest way of getting to cell Al in a spreadsheet? a. Press Ctrl +Home b. Press Alt + Home c. Press Shift + Home d. Press Home 18 / 53 18. When you start typing the same value as of some cells on same column, Excel automatically shows that text. This feature is known as a. AutoFill b. AutoFormat c. AutoComplete d. AutoCorrect 19 / 53 19. In Excel concatenation of text can be done using a. Apostrophe (‘) b. Hash (#) c. Ampersand (&) d. Exclamation (!) 20 / 53 20. The Cancel and Enter buttons appear In the: a. Title bar b. Menu bar c. Formula bar d. None of the above 21 / 53 21. What are the tabs that appear at the bottom of each workbook called? a. Reference tabs b. Sheet tabs c. Location tabs d. Position tabs 22 / 53 22. You can use the horizontal and vertical scroll bars to a. Split a worksheet into two panes b. View different worksheets c. Edit the contents of a cell d. View different rows and columns 23 / 53 23. In Excel the following is not an example of a value a. 350 b. Serial Number 50771 c. 57&per cent d. May 10, 2001 24 / 53 24. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data has not changed than... a. Format Report b. Show Detail c. Refresh Data d. Pivot Table 25 / 53 25. In order to perform a calculation in a spreadsheet, you need to use a: a. table b. variable c. field d. formula 26 / 53 26. To copy formatting from one area in a worksheet and apply it to another area you would use a. The Edit > Copy Format and Edit>Paste Format commands form the menu. b. The Format Painter button on the standard toolbar c. There is no way to copy and apply formatting in Excel You have to do it manually d. The Copy and Apply Formatting dialog box, located under the Formats Copy and Apply menu. 27 / 53 27. Excel files have a default extension of a. Xls b. 123 c. doc d. Xlw 28 / 53 28. .......cells involves creating a single cell by combining two or more selected cells a. Formatting b. Splitting c. Embedding d. Merging 29 / 53 29. What will be the output If you format the cell containing 5436.8 as '#,##0.00'? a. 5,430.00 b. c) 5,436.8 c. b) 5,436.80 d. none of the above 30 / 53 30. The arrows created by Auditing can be removed by a. Click on the arrow and press Delete b. Click on Remove All arrows on Formula Auditing toolbar c. Both of above d. none of the above 31 / 53 31. Which command will you choose to convert a column of data into row? a. Cut and Paste b. Edit » Paste Special » Transpose c. Both of above d. none of the above 32 / 53 32. In Excel typical worksheet has …. Number of columns a. 512 XFD b. 16,384 XFD c. 1024 IV d. 256 IV 33 / 53 33. An excel workbook is a collection of a. Workbooks b. Charts c. Worksheets d. Worksheets and charts 34 / 53 34. In Excel Hyperlinks can be a. Text b. Pictures c. Drawing objects d. All of above 35 / 53 35. In Excel Graphics objects on a chart are used to a. Add interest to a chart b. Help explain the chart data c. Add emphasis to chart data d. All the above 36 / 53 36. Which of the following is a popular DOS based spreadsheet package? a. Word b. Excel c. Lotus 1-2-3 d. Smart cell 37 / 53 37. You can open the scenario Manager dialog box by choosing scenarios from the ... menu. a. View b. Tools c. Format d. Insert 38 / 53 38. In Excel advantage of using a spreadsheet is a. calculations can be done automatically. b. more flexibility c. changing data automatically updates calculations d. all of the above 39 / 53 39. In Excel to open the Format Cells dialog box, press a. Alt + 1 b. F1 c. Ctrl + Shift + 1 d. Ctrl + 1 40 / 53 40. The intersection of a row and column is called... a. data b. a cell c. a field d. none of the above 41 / 53 41. Which of the following methods can not be used to enter data in a cell a. Pressing an arrow key b. Clicking on the formula bar c. Pressing the Esc key d. Pressing the Tab key 42 / 53 42. The box on the chart that contains the name of each Individual record Is called the__. a. cell b. legend c. axis d. title 43 / 53 43. If you want all of the white cats grouped together In the database, you need to sort by__. a. Color, then Gender b. Color, then Pet Name c. Pet Type, then Gender d. Pet Type, then Color 44 / 53 44. Which of the following is invalid regarding the Protection in Excel? a. Protect Sheet b. Protect Workspace c. Protect Workbook d. All of above are valid 45 / 53 45. Which button do you click to add up a series of numbers? a. The autosum button b. The quick total button c. The total button d. The Formula button 46 / 53 46. In Excel you cannot link excel worksheet data to a word document a. With the right drag method b. With the copy and paste buttons on the standard toolbar c. With the copy and paste special commands d. With a hyperlink 47 / 53 47. Which of the following is the oldest spreadsheet package? a. VisiCalc b. StarCalc c. Excel d. Lotus 1-2-3 48 / 53 48. Comments put in cells are called..... a. Smart Tip b. Web Tip c. Cell Tip d. none of the above 49 / 53 49. To activate the previous cell in a pre-selected range press a. the Alt key b. the Enter key c. the Tab key d. All of above 50 / 53 50. Which of the cell pointer indicate that you can move the content to other cell? a. Doctor's symbol (Big Plus) b. Mouse Pointer with anchor at the tip c. small thin plus icon d. All of above 51 / 53 51. What do you mean by a Workspace? a. Group of Columns b. Group of Workbooks c. Group of Worksheets d. Group of Rows 52 / 53 52. What does the VLOOKUP function do? a. Looks up text that contain V b. Finds related records c. Checks whether text is the same in one cell as in the next d. All of above 53 / 53 53. To delete an embedded objects, first a. Double click the object b. Select the object by clicking it c. Select it and then press the delete key d. Press the Shift + Delete ' keys Your score is The average score is 21% 0% Restart quiz
