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.
| 151. |
Right clicking something in Excel: |
| A. | Deletes the object |
| B. | Nothing the right mouse button is there for left handed people |
| C. | Opens a shortcut menu listing everything you can do to the object |
| D. | Selects the object |
| Answer» D. Selects the object | |
| 152. |
How can you delete a record? |
| A. | Delete the column from the worksheet |
| B. | Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button |
| C. | Select Data > Delete Record from the menu |
| D. | Click the Delete button on the Standard toolbar |
| Answer» C. Select Data > Delete Record from the menu | |
| 153. |
It is acceptable ot let long text flow into adjacent cells on a worksheet when |
| A. | Data will be entered in the adjacent cells |
| B. | No data will be entered in the adjacent cells |
| C. | There is nt suitable abbreviation of the text |
| D. | Tehere is not time to format the next |
| Answer» C. There is nt suitable abbreviation of the text | |
| 154. |
When you copy a formula |
| A. | Excel erases the original copy of the formula |
| B. | Excel edits cell references in the newly copied formula |
| C. | Excel adjusts absolute cell references |
| D. | Excel doesn t adjust relative cell references |
| Answer» C. Excel adjusts absolute cell references | |
| 155. |
Which menu option can be sued to split windows into two |
| A. | Format > window |
| B. | View > window > split |
| C. | Window > split |
| D. | View > split |
| Answer» D. View > split | |
| 156. |
The autofill feature |
| A. | extends a sequential series of data |
| B. | automatically adds range of cell values |
| C. | applies a boarder around the selected cells |
| D. | none of the above |
| Answer» E. | |
| 157. |
Files created with Lotus 1-2-3 have an extension |
| A. | DOC |
| B. | XLS |
| C. | 123 |
| D. | WK1 |
| Answer» D. WK1 | |
| 158. |
What's the easy way to apply varied animations to test on slides |
| A. | apply effects in the custom animation text pane |
| B. | apply an animation scheme |
| C. | customize bullets with animated clipart |
| D. | all of above |
| Answer» C. customize bullets with animated clipart | |
| 159. |
What's the best place to find animated images for your PowerPoint 2002 presentation? |
| A. | Microsoft online |
| B. | Word clipart |
| C. | PowerPoint tools and ins |
| D. | All of the above |
| Answer» C. PowerPoint tools and ins | |
| 160. |
Why is Each excel file called a workbook? |
| 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 | |
| 161. |
consolidate dialog box can also be opened by choosing from .. menu. |
| A. | Insert |
| B. | Format |
| C. | Tools |
| D. | Data |
| Answer» E. | |
| 162. |
From which menu are Macros run or executed ? |
| A. | Insert |
| B. | Frmat |
| C. | Tools |
| D. | Data |
| Answer» D. Data | |