MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 162 Mcqs, each offering curated multiple-choice questions to sharpen your MS Excel knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
When creating a vertical page break |
| A. | The active cell must be A1 |
| B. | The active cell can be anywhere in the worksheet |
| C. | The active cell must be in row 1 |
| D. | The active cell must be in column A |
| Answer» D. The active cell must be in column A | |
| 52. |
Got functions? No? You need the insert function dialog box. How do you get it? |
| A. | Right click a cell and then click insert |
| B. | Click the insert menu and then click function |
| C. | Type = in a cell |
| D. | All of the above |
| Answer» C. Type = in a cell | |
| 53. |
Which of the following describes how to select all the cells in a single column? |
| A. | Right click on column and select Pick from list |
| B. | Use data text to columns menu item |
| C. | Left click on the gray column title button |
| D. | Pressing Ctrl + A on the keyboard |
| Answer» D. Pressing Ctrl + A on the keyboard | |
| 54. |
Which of the following methods cannot be used to edit the content of cell? |
| A. | Pressing the Alt key |
| B. | Clicking the formula bar |
| C. | Pressing F2 |
| D. | Double clicking the cell |
| Answer» B. Clicking the formula bar | |
| 55. |
What term refers to a specific set of values saved with the workbook? |
| A. | Range |
| B. | Scenario |
| C. | Trend line |
| D. | What-if analysis |
| Answer» C. Trend line | |
| 56. |
The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is . |
| A. | G1-G10 |
| B. | B1.G10 |
| C. | B1;G10 |
| D. | B1:G10 |
| Answer» E. | |
| 57. |
You can edit existing Excel data by pressing the |
| A. | F1 key |
| B. | F2 key |
| C. | F3 key |
| D. | F4 key |
| Answer» C. F3 key | |
| 58. |
Qtr 1, Qtr 2, Qtr 3 is an example of a |
| A. | Formula |
| B. | Function |
| C. | Series |
| D. | Syntax |
| Answer» D. Syntax | |
| 59. |
What is an expression that tells how the numbers in a determined set of cells are to be calculated? |
| A. | Formula |
| B. | Field |
| C. | Data |
| D. | Query Correct Answer: |
| Answer» B. Field | |
| 60. |
you can use the formula palette to |
| A. | format cells containing numbers |
| B. | create and edit formulas containing functions |
| C. | entered assumptions data |
| D. | copy a range of cells |
| Answer» C. entered assumptions data | |
| 61. |
What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells? |
| A. | F3 |
| B. | F5 |
| C. | F7 |
| D. | F11 |
| Answer» E. | |
| 62. |
What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chaschanged |
| A. | Format Report |
| B. | Pivot Table |
| C. | Refresh Data |
| D. | Show Detail |
| Answer» D. Show Detail | |
| 63. |
If you press ., the cell accepts your typing as its contents. |
| A. | Enter |
| B. | Ctrl + Enter |
| C. | TAB |
| D. | Insert |
| Answer» B. Ctrl + Enter | |
| 64. |
To copy cell contents using drag and drop, press the |
| A. | End key |
| B. | Shift key |
| C. | Esc key |
| D. | None of above |
| Answer» E. | |
| 65. |
Macros are run or executed from the .. menu. |
| A. | Insert |
| B. | Format |
| C. | Tools |
| D. | Data |
| Answer» D. Data | |
| 66. |
You can open the consolidate dialog box byt choosing Consolidate from the .. menu. |
| A. | Insert |
| B. | Format |
| C. | Tools |
| D. | Data |
| Answer» E. | |
| 67. |
Except for the function, a formula with a logical function shows the word TRUE or FALSE as a result |
| A. | IF |
| B. | AND |
| C. | OR |
| D. | NOT |
| Answer» B. AND | |
| 68. |
Youar German supplier still invoices for parts in deutsche marks. How can you have Excel convert those sums to Euros? |
| A. | On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign. |
| B. | On the tools menu, click Add-Ins, and select the Euro Currency Tools check box |
| C. | Apply a selected background color |
| D. | All of above |
| Answer» C. Apply a selected background color | |
| 69. |
How should you print a selected area of a worksheet, if you ll want to print a different area next time? |
| A. | On the file menu, point to print area, and then click set print area. |
| B. | On the file menu, click print, and then click selection under print what |
| C. | On the view menu, click custom views, then click add |
| D. | All of above |
| Answer» C. On the view menu, click custom views, then click add | |
| 70. |
A function inside another function is called a .. function. |
| A. | Nested |
| B. | Round |
| C. | Sum |
| D. | Text |
| Answer» B. Round | |
| 71. |
What does the VLOOKUP function do? |
| A. | Looks up text that contain v |
| B. | Checks whether text is the same in one cell as in the next |
| C. | Finds related records |
| D. | All of above |
| Answer» D. All of above | |
| 72. |
Which of the following is a correct order of precedence in a formula calculation? |
| A. | Multiplication and division, exponential positive and negative value |
| B. | Multiplication and division, positive and negative values, addition and subtraction |
| C. | Addition and subtraction, positive and negative values, exponentiation |
| D. | None of above |
| Answer» E. | |
| 73. |
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 |
| Answer» E. | |
| 74. |
You can print only an embedded chart by |
| A. | Moving the chart to a chart sheet before you print. |
| B. | Formatting the chart before you print |
| C. | Selecting the chart before you print |
| D. | a and c |
| Answer» E. | |
| 75. |
Each excel file is called a workbook because |
| A. | It can contain text and data |
| B. | It can be modified |
| C. | It can contain many sheets including worksheets and chart sheets |
| D. | You have to work hard to create it |
| Answer» D. You have to work hard to create it | |
| 76. |
How are data organized in a spreadsheet? |
| A. | Lines and spaces |
| B. | Layers and planes |
| C. | Rows and columns |
| D. | Height and width |
| Answer» D. Height and width | |
| 77. |
Which types of charts can excel produce? |
| A. | Line graphs and pie charts only |
| B. | Only line graphs |
| C. | Bar charts, line graphs and pie charts |
| D. | Bar charts and line graphs only |
| Answer» D. Bar charts and line graphs only | |
| 78. |
When you insert an Excel file into a Word document, the data are |
| A. | Hyperlinked |
| B. | Placed in a word table |
| C. | Linked |
| D. | Embedded |
| Answer» C. Linked | |
| 79. |
What function displays row data in a column or column data in a row? |
| A. | Hyperlink |
| B. | Index |
| C. | Transpose |
| D. | Rows |
| Answer» D. Rows | |
| 80. |
what term describes a background that appears as a grainy, non smooth surface |
| A. | gradient |
| B. | pattern |
| C. | solid |
| D. | texture |
| Answer» B. pattern | |
| 81. |
To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called |
| A. | HTML |
| B. | Pivot Table Field List |
| C. | Pivot Table List |
| D. | Pivot Table Report |
| Answer» E. | |
| 82. |
Excel is a |
| A. | Graphic program |
| B. | None of these |
| C. | Word processor |
| D. | A spreadsheet |
| Answer» E. | |
| 83. |
What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula? |
| A. | Goal Seek |
| B. | Scenario Summary report |
| C. | Forecasting |
| D. | Trend line |
| Answer» E. | |
| 84. |
A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this? |
| A. | Go to File-Save As Save As Type Excel worksheet |
| B. | Right click on the spreadsheet tab and select DELETE |
| C. | Right click on the spreadsheet and select Insert Entire Column |
| D. | None of above |
| Answer» C. Right click on the spreadsheet and select Insert Entire Column | |
| 85. |
Which of the following methods can not be used to enter data in a cell? |
| A. | Pressing an arrow key |
| B. | Pressing the tab key |
| C. | Pressing the Esc key |
| D. | Clicking the enter button to the formula bar |
| Answer» D. Clicking the enter button to the formula bar | |
| 86. |
Which of the following will not set text in selected cells to italics? |
| A. | Pressing Ctrl + I on the keyboard |
| B. | Using the Tools Wizard Web Form menu item |
| C. | Using the Format Cells Font menu item |
| D. | None of the above |
| Answer» E. | |
| 87. |
If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature? |
| A. | Point to speech on the tools menu, and then click show text to speech toolbar. |
| B. | Click validation on the data menu |
| C. | Point to speech on the tools menu, and then click speech recognition |
| D. | All of above |
| Answer» B. Click validation on the data menu | |
| 88. |
Which function calculates your monthly mortage payment? |
| A. | PMT (payments) |
| B. | NPER (number of periods) |
| C. | PV (present value) |
| D. | All of above |
| Answer» B. NPER (number of periods) | |
| 89. |
How do you change column width to fit the contents? |
| A. | Single-click the boundary to the left to the column heading |
| B. | Double click the boundary to the right of the column heading |
| C. | Press Alt and single click anywhere in the column |
| D. | All of above |
| Answer» E. | |
| 90. |
Charts tips can |
| A. | Show the formatting of a data label |
| B. | Show the name of a data series |
| C. | Show the value of data point |
| D. | b and c |
| Answer» E. | |
| 91. |
The Name box |
| A. | Shows the location of the previously active cell |
| B. | Appears t the left of the formula bar |
| C. | Appears below the status bar |
| D. | Appears below the menu bar |
| Answer» C. Appears below the status bar | |
| 92. |
To center worksheet titles across a range of cell, you must |
| A. | Select the cells containing the title text and use the fill handle to center the text across a range of cells |
| B. | Widen the columns |
| C. | Select the cells containing the title text and use the fill handle to center the text across a range of cells |
| D. | Widen the column |
| Answer» B. Widen the columns | |
| 93. |
When integrating Ms-Word and Excel, Word is usually the |
| A. | Server |
| B. | Source |
| C. | Client |
| D. | None |
| Answer» D. None | |
| 94. |
To insert three columns between columns D and E you would |
| A. | Select column D |
| B. | Select column E |
| C. | Select columns E, F and G |
| D. | Select columns D, E, and F. |
| Answer» C. Select columns E, F and G | |
| 95. |
What s a quick way to extend these numbers to a longer sequence, for instance 1 through 20? |
| A. | Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows |
| B. | Select the range you want, include both cells, point to fill on the Edit menu, and then click down. |
| C. | Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special |
| D. | All of above |
| Answer» B. Select the range you want, include both cells, point to fill on the Edit menu, and then click down. | |
| 96. |
Which of the following is not a basic step in creating a worksheet? |
| A. | Save the workbook |
| B. | Modify the worksheet |
| C. | Enter text and data |
| D. | Copy the worksheet |
| Answer» E. | |
| 97. |
Paper spreadsheets can have all the same advantages as an electronic spreadsheet except which of the following? |
| A. | Rows and columns |
| B. | Headings |
| C. | Speed |
| D. | None |
| Answer» D. None | |
| 98. |
when you use the fill effects in the format data series dialog box, you can not |
| A. | rotate text on the chart |
| B. | select a fore ground color |
| C. | select a pattern |
| D. | select a background color |
| Answer» B. select a fore ground color | |
| 99. |
Which of the following setup options can not be set in the page setup dialog box? |
| A. | Printer selection |
| B. | Vertical or horizontal placement |
| C. | Orientation |
| D. | Row and column titles |
| Answer» B. Vertical or horizontal placement | |
| 100. |
You can activate a cell by |
| A. | Pressing the Tab key |
| B. | Clicking the cell |
| C. | Pressing an arrow key |
| D. | All of above |
| Answer» E. | |