MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 615 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Fundamentals knowledge and support exam preparation. Choose a topic below to get started.
| 251. |
In Excel value used in a formula that does not change is called a |
| A. | Cell address |
| B. | Constant |
| C. | Function |
| D. | Range |
| Answer» C. Function | |
| 252. |
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 | |
| 253. |
In Excel 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 | |
| 254. |
In Excel 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 that the calculated results |
| Answer» B. When you use addition and subtraction in a formula | |
| 255. |
In Excel to add two cells (A1 and A2) together you use the following formula |
| A. | 0 |
| B. | 0 |
| C. | 0 |
| D. | A1 plus A2 |
| Answer» B. 0 | |
| 256. |
In Excel Comments put in cells are called |
| A. | Smart tip |
| B. | Cell tip |
| C. | Web tip |
| D. | Soft tip |
| Answer» C. Web tip | |
| 257. |
Which of the following methods cannot be used to edit the contents of a cell In Excel? |
| A. | Press the Alt key |
| B. | Clicking the formula bar |
| C. | Pressing the F2 key |
| D. | Double clicking the cell |
| Answer» B. Clicking the formula bar | |
| 258. |
If 4/6 entered in a cell without applying any formats, Excel will treat this as |
| A. | Fraction |
| B. | Number |
| C. | Text |
| D. | Date |
| Answer» E. | |
| 259. |
In Excel you can enter which types of data into worksheet cells? |
| A. | Labels, values, and formulas |
| B. | Labels and values but not formulas |
| C. | Values and formulas but not labels |
| D. | Formulas only |
| Answer» B. Labels and values but not formulas | |
| 260. |
In Excel you can insert labels for |
| A. | All the data markers on a chart |
| B. | A data series |
| C. | A selected data marker |
| D. | All of the above |
| Answer» E. | |
| 261. |
Which is not the function of “Edit, Clear” command? |
| A. | Delete contents |
| B. | Delete notes |
| C. | Delete cells |
| D. | Delete formats |
| Answer» D. Delete formats | |
| 262. |
In Excel 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 | |
| 263. |
Which of the following shortcuts can be used to insert a new line in the same cell? |
| A. | Enter |
| B. | Alt + Enter |
| C. | Ctrl + Enter |
| D. | Shift + Enter |
| Answer» C. Ctrl + Enter | |
| 264. |
In Excel constant is another name for this type of data |
| A. | number |
| B. | equation |
| C. | formula |
| D. | description |
| Answer» B. equation | |
| 265. |
In Excel 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 | |
| 266. |
You can automatically adjust the size of text in a cell if they do not fit in width by |
| A. | Double clicking on the right border of column header |
| B. | From Format choose Columns and then Autofit Selection |
| C. | From Format Cells dialog box mark Shrink to fit check box |
| D. | All of above |
| Answer» D. All of above | |
| 267. |
In Excel on an excel sheet the active cell in indicated by |
| A. | A dark wide boarder |
| B. | A dotted border |
| C. | A blinking border |
| D. | None of above |
| Answer» B. A dotted border | |
| 268. |
In Excel comments can be added to cells using |
| A. | Edit > Comments |
| B. | Insert > Comments |
| C. | File > Comments |
| D. | View > Comments |
| Answer» C. File > Comments | |
| 269. |
In Excel when the formula bar is activated,you can see |
| A. | The Edit Formula button |
| B. | The Cancel button |
| C. | The Enter button |
| D. | All of above |
| Answer» E. | |
| 270. |
In Excel Text formulas |
| A. | Replace cell references |
| B. | Return ASCII values of characters |
| C. | Concatenate and manipulate text |
| D. | Show formula error value |
| Answer» D. Show formula error value | |
| 271. |
What will be the output if you format the cell containing 5436.8 as ‘#,##0.00′? |
| A. | 5430 |
| B. | 5436.8 |
| C. | 5436.8 |
| D. | 6.8 |
| Answer» C. 5436.8 | |
| 272. |
In Excel 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. | |
| 273. |
In Excel on an Excel sheet the active cell inindicated by |
| A. | A dark wide border |
| B. | A dotted border |
| C. | A blinking border |
| D. | None of above |
| Answer» B. A dotted border | |
| 274. |
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 | |
| 275. |
In Excel 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 | |
| 276. |
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 Copy and Apply Formatting dialog box, located under the Format>Copy and Apply menu. |
| C. | There is no way to copy and apply formatting in Excel – You have to do it manually |
| D. | The Format Painter button on the standard toolbar |
| Answer» E. | |
| 277. |
Which of the following function will return a value of 8? |
| A. | ROUNDUP(8.4999, 0) |
| B. | ROUNDDOWN(8.4999, 0) |
| C. | ROUND(8.4999, 0) |
| D. | Only B and C |
| Answer» E. | |
| 278. |
In Excel if you press ……, the cell accepts your typing as its contents. |
| A. | Enter |
| B. | Ctrl+Enter |
| C. | Tab |
| D. | Insert |
| Answer» B. Ctrl+Enter | |
| 279. |
Which is an example of a function? |
| A. | 0 |
| B. | 0 |
| C. | 0 |
| D. | A1+A2 |
| Answer» D. A1+A2 | |
| 280. |
In Excel Graphics objects on a chart are used to |
| A. | Add emphasis to chart data |
| B. | Add interest to a chart |
| C. | Help explain the chart data |
| D. | All the above |
| Answer» E. | |
| 281. |
A smart tag will be removed from a cell when |
| A. | the cell is moved |
| B. | the cell is hidden |
| C. | the data in the cell is changed or deleted |
| D. | the formatting of the cell is changed |
| Answer» D. the formatting of the cell is changed | |
| 282. |
This type of software is similar to an accountant’s worksheet |
| A. | Word processing |
| B. | Database |
| C. | Spreadsheets |
| D. | Graphics |
| Answer» D. Graphics | |
| 283. |
What is the quickest way to select entire worksheet? |
| A. | Choose Edit -> Select all from the Menu |
| B. | Click on the first column, press Ctrl, and then click on the last column |
| C. | Click on the first column, press Shift, and then click on the last column |
| D. | Click on the rectangle box on the upper left corner where column headings and row headings meet |
| Answer» E. | |
| 284. |
In Excel the following is not a basic step increating a worksheet |
| A. | Save the workbook |
| B. | Modify the worksheet |
| C. | Enter text and data |
| D. | Copy the worksheet |
| Answer» E. | |
| 285. |
In Excel data can be arranged in a worksheet in a easy to understand manner using |
| A. | Auto formatting |
| B. | Applying styles |
| C. | Changing fonts |
| D. | All of above |
| Answer» E. | |
| 286. |
In Excel 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 | |
| 287. |
In Excel which of the following is not a worksheet design criterion |
| A. | Efficiency |
| B. | Auditability |
| C. | Description |
| D. | Clarity Correct Answer: |
| Answer» D. Clarity Correct Answer: | |
| 288. |
In Excel the drag and drop method of copying or moving |
| A. | Can be used between worksheets but not workbooks |
| B. | Can be used between workbooks but not worksheets |
| C. | Can be used between workbooks but not worksheets |
| D. | None |
| Answer» D. None | |
| 289. |
In Excel 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. | B1-G10 |
| B. | B1.G10 |
| C. | B1;G10 |
| D. | B1:G10* |
| Answer» E. | |
| 290. |
1What is the shortcut key to hide entire row? |
| A. | CTRL + H |
| B. | CTRL + R |
| C. | CTRL + 9 |
| D. | CTRL + - |
| Answer» D. CTRL + - | |
| 291. |
In Excel 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. | |
| 292. |
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» C. Using the Format – Cells – Font menu item | |
| 293. |
Give me an example of a cell address. |
| A. | 11 25 |
| B. | 911 |
| C. | 41A |
| D. | A21 |
| Answer» E. | |
| 294. |
In Excel you can print |
| A. | A range of cells by range name |
| B. | An entire worksheet |
| C. | A single worksheet |
| D. | All of the above |
| Answer» E. | |
| 295. |
Clear the contents by pressing “DELETE” key from a keyboard will clear |
| A. | Text Only |
| B. | Format Only |
| C. | Contents Only |
| D. | Both Contents and Format |
| Answer» D. Both Contents and Format | |
| 296. |
In Excel you can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that? |
| A. | & (ampersan(D) |
| B. | 0 |
| C. | (space) |
| D. | All of the above |
| Answer» B. 0 | |
| 297. |
“New Comment” option can be found under _________ tab |
| A. | Insert |
| B. | Data |
| C. | Review |
| D. | View |
| Answer» D. View | |
| 298. |
In Excel the chart wizard |
| A. | Can place a chart on a new chart sheet or on any sheet in the workbook |
| B. | Can only place a chart on new chart sheet |
| C. | Can only place a chart on a new blank worksheet |
| D. | Can only be used to create embedded charts |
| Answer» C. Can only place a chart on a new blank worksheet | |
| 299. |
To show/hide the grid lines in Microsoft Excel 2007 |
| A. | Page Layout -> Grid lines -> View |
| B. | Insert -> Grid lines -> View |
| C. | View -> Grid lines -> View |
| D. | Edit -> Grid lines -> View |
| Answer» B. Insert -> Grid lines -> View | |
| 300. |
In Excel 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. | |