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.
| 101. |
What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer. |
| A. | Spreadsheet program |
| B. | Database program |
| C. | Word processor program |
| D. | Desktop publisher program |
| Answer» B. Database program | |
| 102. |
You can use the horizontal and vertical scroll bars to |
| A. | Split a worksheet into two panes |
| B. | View different rows and columns |
| C. | Edit the contents of a cell |
| D. | View different worksheets |
| Answer» C. Edit the contents of a cell | |
| 103. |
To edit data in an embedded Excel worksheet object in a Word document |
| A. | Use the Excel menu bar and toolbars inside the word application |
| B. | Edit the hyperlink |
| C. | Edit the data in a Excel source application |
| D. | Use the Word menu bar and toolbars |
| Answer» B. Edit the hyperlink | |
| 104. |
Status indicators are located on the |
| A. | Vertical scroll bar |
| B. | Horizontal scroll bar |
| C. | Formula bar |
| D. | Formatting toolbar |
| Answer» D. Formatting toolbar | |
| 105. |
You can open the scenario Manager dialog box by choosing scenarios from the .. menu. |
| A. | View |
| B. | Insert |
| C. | Format |
| D. | Tools |
| Answer» E. | |
| 106. |
Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet? |
| A. | Use Ctrl to select all three cells, then click the paste button on the standard toolbar |
| B. | Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify |
| C. | Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to |
| D. | All of above |
| Answer» D. All of above | |
| 107. |
To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the |
| A. | Unfreeze panes command on the window menu |
| B. | Freeze panes command on the window menu |
| C. | Hold titles command on the edit menu |
| D. | Split command on the window menu |
| Answer» C. Hold titles command on the edit menu | |
| 108. |
When you see a cell with a red triangle in the top right corner, what does this signify? |
| A. | There is an error in the cell |
| B. | There is a comment associated with the cell |
| C. | The font color for text in the cell is red |
| D. | A formula cannot be entered into the cell |
| Answer» C. The font color for text in the cell is red | |
| 109. |
Weight refers to |
| A. | The print density of characters |
| B. | The height of the printed character |
| C. | Upright or slanted shape |
| D. | The design and appearance of characters |
| Answer» B. The height of the printed character | |
| 110. |
When you link data maintained in Excel workbook to a Word document |
| A. | The Word document cannot be edited |
| B. | The Word document contains a reference to the original source application |
| C. | The word document must contain a hyperlink |
| D. | The word document contains a copy of the actual data |
| Answer» C. The word document must contain a hyperlink | |
| 111. |
You can group noncontiguous worksheets with |
| A. | The group button on the standard toolbar |
| B. | The shift key and the mouse |
| C. | The ctrl key and mouse |
| D. | The alt+enter key |
| Answer» D. The alt+enter key | |
| 112. |
when you print preview a worksheet |
| A. | the entire worksheet is displayed |
| B. | the selected range is displayed |
| C. | the active portion of the worksheet is displayed |
| D. | a, b and c |
| Answer» E. | |
| 113. |
Hyperlinks cannot be |
| A. | Special shapes like stars and banners |
| B. | Drawing objects like rectangles ovals |
| C. | Pictures |
| D. | All can be hyperlinks |
| Answer» E. | |
| 114. |
when you work with large worksheets, you may need to |
| A. | size the worksheet to fit on the specific number of pages |
| B. | add and remove page breaks |
| C. | specify only certain print areas |
| D. | all of above |
| Answer» E. | |
| 115. |
What symbol is used before a number to make it a label? |
| A. | (quote) |
| B. | = (equal) |
| C. | _ (underscore) |
| D. | (apostrophe) |
| Answer» C. _ (underscore) | |
| 116. |
Which of the following is an absolute cell reference? |
| A. | !A!1 |
| B. | $A$1 |
| C. | #a#1 |
| D. | A1 |
| Answer» C. #a#1 | |
| 117. |
The default header for a worksheet is |
| A. | Your name |
| B. | The date and time |
| C. | None |
| D. | The sheet tab name |
| Answer» D. The sheet tab name | |
| 118. |
This type of software is similar to an accountant s worksheet |
| A. | Word processing |
| B. | Database |
| C. | Spreadsheets |
| D. | Graphics |
| Answer» D. Graphics | |
| 119. |
When you group worksheets |
| A. | You can enter variable data on multiple worksheets at one time |
| B. | You can print more than one worksheet at a time |
| C. | You can enter common data, formats, and formulas on multiple worksheets at one time |
| D. | b, and c |
| Answer» E. | |
| 120. |
You can use the format painter multiple times before you turn it off by |
| A. | You can use the format painter button only one time when you click it |
| B. | Double clicking the format painter button |
| C. | Pressing the Ctrl key and clicking the format painter button |
| D. | Pressing Alt key and clicking the format painter button |
| Answer» C. Pressing the Ctrl key and clicking the format painter button | |
| 121. |
You can not link Excel worksheet data to a Word document |
| A. | With the right drag method |
| B. | With a hyperlink |
| C. | With the copy and paste special commands |
| D. | With the copy and paste buttons on the standard toolbar |
| Answer» E. | |
| 122. |
A worksheet range is a |
| A. | A command used for data modeling |
| B. | A range of values such as from 23 to 234 |
| C. | A group of cells |
| D. | A group of worksheets |
| Answer» D. A group of worksheets | |
| 123. |
You can zoom a worksheet |
| A. | With the mouse pointer in Print Preview |
| B. | With the zoom button on the Print Preview toolbar |
| C. | With the Zoom command on the view menu |
| D. | All of the above |
| Answer» E. | |
| 124. |
You can copy data or formulas |
| A. | With the copy, paste and cut commands on the edit menu |
| B. | With commands on a shortcut menu |
| C. | With buttons on the standard toolbar |
| D. | All of the above |
| Answer» E. | |
| 125. |
Rounding errors can occur |
| A. | When you use multiplication, division or exponentiation in a formula |
| B. | When you use addition and subtraction in a formula |
| C. | Because Excel uses hidden decimal places in computation |
| D. | When you show the results of formulas with different decimal places than the calculated results |
| Answer» B. When you use addition and subtraction in a formula | |
| 126. |
A data map is helpful |
| A. | When you have too much data to chart |
| B. | To show a geographic distribution of data |
| C. | To compare data points |
| D. | To show changes in data over time |
| Answer» C. To compare data points | |
| 127. |
when working in the page break preview, you can |
| A. | view exactly where each page break occurs |
| B. | add or remove page breaks |
| C. | change the print area |
| D. | all of above |
| Answer» E. | |
| 128. |
You can open the Sort dialog box by choosing Sort from the .. menu |
| A. | View |
| B. | Format |
| C. | Tools |
| D. | Data |
| Answer» E. | |
| 129. |
Tab scrolling button |
| A. | Allow you to view a different worksheet |
| B. | Allow you to view additional worksheet rows down |
| C. | Allow you to view additional worksheet columns to the right |
| D. | Allow you to view additional sheets tabs |
| Answer» E. | |
| 130. |
Getting data from a cell located in a different sheet is called |
| A. | Accessing |
| B. | Referencing |
| C. | Updating |
| D. | Functioning |
| Answer» C. Updating | |
| 131. |
The Chart wizard term data categories refers to; |
| A. | A chart plot area |
| B. | A horizontal axis |
| C. | The organization of individual values with a chart s data series |
| D. | The data range that supply chart data |
| Answer» C. The organization of individual values with a chart s data series | |
| 132. |
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 |
| Answer» C. A set of values you plot in a chart | |
| 133. |
Which of the following is not an example of a value? |
| A. | 350 |
| B. | May 10, 2001 |
| C. | 57% |
| D. | Serial Number 50771 |
| Answer» E. | |
| 134. |
You can use the drag and drop method to |
| A. | Copy cell contents |
| B. | Move cell contents |
| C. | Add cell contents |
| D. | a and b |
| Answer» E. | |
| 135. |
Which elements of worksheet can be protected from accidental modification |
| A. | Contents |
| B. | Objects |
| C. | Scenarios |
| D. | All of above |
| Answer» E. | |
| 136. |
You can select a single range of cells by |
| A. | Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells |
| B. | Pressing the Ctrl key while dragging over the desired cells |
| C. | Pressing the Shift key and an arrow key |
| D. | Dragging over the desired cells |
| Answer» E. | |
| 137. |
You can edit a cell by |
| A. | Clicking the formula button |
| B. | Double clicking the cell to edit it in-place |
| C. | Selecting Edit>Edit Cell from the menu |
| D. | None of above |
| Answer» C. Selecting Edit>Edit Cell from the menu | |
| 138. |
To save a workbook, you: |
| A. | Click the save button on the standard toolbar from the menu |
| B. | Press Ctrl+F5 |
| C. | Click Save on the Windows Start button |
| D. | Select Edit>Save |
| Answer» B. Press Ctrl+F5 | |
| 139. |
to view a cell comment |
| A. | click the edit comment command on the insert menu |
| B. | click the display comment command on the window menu |
| C. | position the mouse pointer over the cell |
| D. | click the comment command on the view menu |
| Answer» D. click the comment command on the view menu | |
| 140. |
When you want to insert a blank imbedded excel object in a word document you can |
| A. | Click the object command on the insert menu |
| B. | Click the office links button on the standard toolbar |
| C. | Click the create worksheet button on the formatting toolbar |
| D. | Click the import excel command on the file menu |
| Answer» B. Click the office links button on the standard toolbar | |
| 141. |
The auto calculate feature |
| A. | Can only add values in a range of cells |
| B. | Provides a quick way to view the result of an arithmetic operation on a range of cells |
| C. | Automatically creates formulas and adds them to a worksheet |
| D. | A and c |
| Answer» C. Automatically creates formulas and adds them to a worksheet | |
| 142. |
Excel uniquely identifies cells within a worksheet with a cell name |
| A. | Cell names |
| B. | Column numbers and row letters |
| C. | Column letters and row numbers |
| D. | Cell locator coordinates |
| Answer» D. Cell locator coordinates | |
| 143. |
You can use drag-and-drop to embed excel worksheet data in a word document |
| A. | By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key |
| B. | By dragging a range of excel data to the word button on the taskbar while pressing Shift key |
| C. | By dragging a range of excel data to the word button on the taskbar while pressing Alt key |
| D. | None of above |
| Answer» B. By dragging a range of excel data to the word button on the taskbar while pressing Shift key | |
| 144. |
A worksheet can have a maximum of . Number of rows |
| A. | 256 |
| B. | 1024 |
| C. | 32,000 |
| D. | 65,535 |
| Answer» E. | |
| 145. |
Which of the following is the latest version of Excel |
| A. | Excel 2000 |
| B. | Excel 2002 |
| C. | Excel ME |
| D. | Excel XP |
| Answer» E. | |
| 146. |
To copy cell contents using drag and drop press the |
| A. | End key |
| B. | Shift key |
| C. | Ctrl key |
| D. | Esc key |
| Answer» E. | |
| 147. |
Which of the following is not a worksheet design criterion? |
| A. | Efficiency |
| B. | Aditibility |
| C. | Description |
| D. | Clarity |
| Answer» D. Clarity | |
| 148. |
Comments can be added to cells using |
| A. | Edit > Comments |
| B. | Insert > Comments |
| C. | File > Comments |
| D. | View > Comments |
| Answer» C. File > Comments | |
| 149. |
To delete an embedded objects, first |
| A. | Double click the object |
| B. | Select the object by clicking it |
| C. | Press the Shift + Delete keys |
| D. | Select it and then press the delete key |
| Answer» E. | |
| 150. |
Documentation should include |
| A. | Destination and users of the output data |
| B. | Source of input data |
| C. | Information on the purpose of the workbook |
| D. | All of the above |
| Answer» E. | |