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.
| 301. |
MS-EXCEL can be used to automate |
| A. | Financial statements, Business forecasting |
| B. | Transaction registers, inventory control |
| C. | Accounts receivable, accounts payable |
| D. | Any of the above |
| Answer» E. | |
| 302. |
In Excel to access the Go To Special feature, you can press |
| A. | Ctrl + G |
| B. | Ctrl + O |
| C. | Ctrl + Shift + G |
| D. | Ctrl + 1 |
| Answer» B. Ctrl + O | |
| 303. |
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 | |
| 304. |
In Excel 3-D reference in a formula |
| A. | Cannot be modified |
| B. | Only appears on summary worksheets |
| C. | Limits the formatting options |
| D. | Spans worksheets |
| Answer» E. | |
| 305. |
In Excel Multiple calculations can be made in a single formula using |
| A. | standard formulas |
| B. | array formula |
| C. | complex formulas |
| D. | smart formula |
| Answer» C. complex formulas | |
| 306. |
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 on the formula bar |
| Answer» D. Clicking on the formula bar | |
| 307. |
In Excel 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. | |
| 308. |
If you press …., the cell accepts your typing as its contents. |
| A. | Enter |
| B. | Ctrl + Enter |
| C. | TAB |
| D. | Insert |
| Answer» B. Ctrl + Enter | |
| 309. |
Which of the following function will use to find the highest number in a series of number? |
| A. | MAX(B1:B3) |
| B. | MAXIMUM (B1:B3) |
| C. | HIGH (B1:B3) |
| D. | HIGHEST(B1:B3) |
| Answer» B. MAXIMUM (B1:B3) | |
| 310. |
Which function will you use to enter current time in a woksheet cell? |
| A. | 0 |
| B. | 0 |
| C. | 0 |
| D. | 0 |
| Answer» C. 0 | |
| 311. |
You can open the scenario Manager dialog box by choosing scenarios from the ….. menu. |
| A. | View |
| B. | Insert |
| C. | Format |
| D. | Tools |
| Answer» E. | |
| 312. |
In Excel how do you change column width tofit 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» C. Press Alt and single click anywhere in the column | |
| 313. |
In Excel which is not an advantage of using computerized spreadsheets? |
| A. | Flexibility of moving entries |
| B. | Speed of calculation |
| C. | Ability of generate tables |
| D. | Cost of initial setup |
| Answer» E. | |
| 314. |
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 | |
| 315. |
In Excel how can you find specific information in a list? |
| A. | Select Tools > Finder from the menu |
| B. | Click the Find button on the standard toolbar |
| C. | Select Insert > Find from the menu |
| D. | Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button |
| Answer» E. | |
| 316. |
Comments can be added to cells using ….. |
| A. | Edit -> Comments |
| B. | Insert -> Comment |
| C. | File -> Comments |
| D. | View –> Comments |
| Answer» C. File -> Comments | |
| 317. |
In Excel 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 | |
| 318. |
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. | |
| 319. |
In Excel In a worksheet you can select |
| A. | The entire worksheet |
| B. | Rows |
| C. | Columns |
| D. | All of the above |
| Answer» C. Columns | |
| 320. |
In Excel this type of software is similar to anaccountant’s worksheet |
| A. | Word processing |
| B. | Database |
| C. | Spreadsheets |
| D. | Graphics |
| Answer» D. Graphics | |
| 321. |
Selecting the Column G & H then choose Insert->Column, What will happen? |
| A. | 2 Columns will be inserted after Column F |
| B. | 2 Columns will be inserted after Column G |
| C. | 2 Columns will be inserted after Column H |
| D. | 2 Columns will be inserted after Column I |
| Answer» B. 2 Columns will be inserted after Column G | |
| 322. |
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. | |
| 323. |
What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed |
| A. | Format Report |
| B. | Pivot Table |
| C. | Refresh Data |
| D. | Show Detail |
| Answer» D. Show Detail | |
| 324. |
In Excel AutoCalculate will quickly add selected cells if you |
| A. | right click on the status bar and select Sum |
| B. | click the AutoCalculate button on the toolbar |
| C. | use the key combination Ctrl+$ |
| D. | double click the selection |
| Answer» C. use the key combination Ctrl+$ | |
| 325. |
In Excel the numbers in our worksheet look like this: 1000. You want them to look like this: $1,000.00. How can you accomplish this? |
| A. | None of these |
| B. | Select Format > Money from the menu |
| C. | Click the Currency Style button on the formatting toolbar |
| D. | You have to retype everything and manually add the dollar signs, commas, and decimals. |
| Answer» D. You have to retype everything and manually add the dollar signs, commas, and decimals. | |
| 326. |
In Excel to move to the previous worksheet, press |
| A. | Alt + PgUp |
| B. | Ctrl + PgUp |
| C. | Ctrl + PgDn |
| D. | Shift + Tab |
| Answer» E. | |
| 327. |
In Excel which of the following is not a valid data type in excel |
| A. | Number |
| B. | Character |
| C. | Label |
| D. | Date/time |
| Answer» C. Label | |
| 328. |
In Excel which is used to perform what if analysis? |
| A. | Solver |
| B. | Goal seek |
| C. | Scenario Manager |
| D. | All of above |
| Answer» E. | |
| 329. |
In Excel 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 | |
| 330. |
In Excel how many characters can be typed in a single cell? |
| A. | 256 |
| B. | 1024 |
| C. | 32,000 |
| D. | 65,535 |
| Answer» E. | |
| 331. |
The box on the chart that contains the name of each individual record is called the ________. |
| A. | cell |
| B. | title |
| C. | axis |
| D. | legend |
| Answer» E. | |
| 332. |
In Excel 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. | |
| 333. |
In Excel to select a column the easiest method is to |
| A. | Double click any cell in the column |
| B. | Drag from the top cell in the column to the last cell in the column |
| C. | Click the column heading |
| D. | Click the column label |
| Answer» D. Click the column label | |
| 334. |
By default, how many sheets are provided in MS Excel 2010 workbook? |
| A. | One |
| B. | Seven |
| C. | Five |
| D. | Three |
| Answer» E. | |
| 335. |
A _______ consists of a set of rows and columns in excel. |
| A. | template |
| B. | worksheets |
| C. | work page |
| D. | work space |
| Answer» C. work page | |
| 336. |
In an Excel spreadsheet, the contents of cells are as follows:a) A1 contains the value 2b) A2 contains the value 3c) A3 contains the formula: =$A$1+A2Contents of cell A3 are copied to Cell A4. The value displayed in Cell A4 will be: |
| A. | 3 |
| B. | 8 |
| C. | 5 |
| D. | 7 |
| Answer» E. | |
| 337. |
In MS Excel, to add numeric values in column D, from rows D10 to D15, the formula that should be used is : |
| A. | SUM (D10, D15) |
| B. | COUNT (D10, D11, D12 D13, D14, D15) |
| C. | SUM (D10:D15) |
| D. | COUNT (D10, D15) |
| Answer» D. COUNT (D10, D15) | |
| 338. |
In MS Excel, ______ text function is useful for combining values from different cells into a single cell. |
| A. | ADD |
| B. | SUM |
| C. | CONCATENATE |
| D. | MERGE |
| Answer» C. CONCATENATE | |
| 339. |
In MS Excel 2010, a cell may display '______' if that cell contains a number or a date and the width of its column cannot display all the characters that its format requires. |
| A. | ##### |
| B. | **### |
| C. | ***** |
| D. | $ |
| Answer» B. **### | |
| 340. |
In MS - Excel, Insert Function are located on the _____. |
| A. | Vertical scroll bar |
| B. | Horizontal scroll bar |
| C. | Formula bar |
| D. | Standard toolbar |
| E. | None of the above |
| Answer» D. Standard toolbar | |
| 341. |
In MS Excel, the columns are numbered from A onwards till Z column is reached. After Z Column, the series start with ______ and so on. |
| A. | AA, AB, ... |
| B. | A1, A2... |
| C. | 1A, 2B... |
| D. | 11A, 22B... |
| Answer» B. A1, A2... | |
| 342. |
A typical worksheet has ________ number of columns. |
| A. | 28 |
| B. | 56 |
| C. | 024 |
| D. | 6384 |
| Answer» E. | |
| 343. |
Which menu option can be used to split windows into two |
| A. | ormat > window |
| B. | iew > window > split |
| C. | indow > split |
| D. | iew > split |
| Answer» C. indow > split | |
| 344. |
When you want to insert a blank embedded excel object in a word document you can |
| A. | lick the object command on the insert menu |
| B. | lick the office links button on the standard toolbar |
| C. | lick the create worksheet button on the formatting toolbar |
| D. | lick the import excel command on the file menu |
| Answer» B. lick the office links button on the standard toolbar | |
| 345. |
If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you: |
| A. | ress the Erase key |
| B. | ress Esc |
| C. | ress the Enter button |
| D. | ress the Edit Formula button |
| Answer» C. ress the Enter button | |
| 346. |
The numbers in our worksheet look like this 1000: You want them to look like this: $1,000.How can you accomplish this? |
| A. | ou have to retype everything and manually add the dollar signs, commas, and decimals |
| B. | elect Format > Money from the menu |
| C. | lick the Currency Style button on the formatting toolbar |
| D. | one of these |
| Answer» D. one of these | |
| 347. |
Excel probably considers the cell entry January 1, 2020 to be a |
| A. | abel |
| B. | alue |
| C. | ormula |
| D. | ext string |
| Answer» C. ormula | |
| 348. |
Which of following is Not one of Excel's what-if function? |
| A. | oal seek |
| B. | olver |
| C. | cenario manager |
| D. | uto Outline |
| Answer» E. | |
| 349. |
A worksheet can have a maximum of ________ number of rows. |
| A. | 56 |
| B. | 024 |
| C. | 5535 |
| D. | 048576 |
| Answer» E. | |
| 350. |
The Cancel and Enter buttons appear in the: |
| A. | itle bar |
| B. | ormula bar |
| C. | enu bar |
| D. | heet tabs |
| Answer» C. enu bar | |