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.
| 351. |
B7:B9 indicates: |
| A. | ells B7 and cell B9 only |
| B. | ells B7 through B9 |
| C. | ell B8 only |
| D. | one of the above |
| Answer» C. ell B8 only | |
| 352. |
A ________ is a grid with labeled columns and rows. |
| A. | ialog box |
| B. | orksheet |
| C. | lipboard |
| D. | oolbar |
| Answer» C. lipboard | |
| 353. |
In help menu of Excel, which of the following tabs are found? |
| A. | ontents tab |
| B. | nswer Wizard tab |
| C. | ndex tab |
| D. | ll of the above |
| Answer» E. | |
| 354. |
In Excel, the Fill Color button on the Formatting toolbar is used for what? |
| A. | o insert a background |
| B. | o add borders |
| C. | o select a distribution of figures |
| D. | o add shading or color to a cell range |
| Answer» E. | |
| 355. |
What are the tabs that appear at the bottom of each workbook called? |
| A. | eference tabs |
| B. | osition tabs |
| C. | ocation tabs |
| D. | heet tabs |
| Answer» E. | |
| 356. |
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) |
| A. | n absolute cell address is created |
| B. | ell address will change when it is copied to another cell |
| C. | he sheet tab is changed |
| D. | he status bar does not display the cell address |
| Answer» B. ell address will change when it is copied to another cell | |
| 357. |
What do you call the chart that shows the proportions of how one or more data elements relate to another data element? |
| A. | Y Chart |
| B. | ine Chart |
| C. | ie Chart |
| D. | olumn Chart |
| Answer» D. olumn Chart | |
| 358. |
Excel displays the current cell address in the ________ |
| A. | ormula bar |
| B. | tatus Bar |
| C. | ame Box |
| D. | itle Bar |
| Answer» D. itle Bar | |
| 359. |
Excel files have a default extension of in Excel-2003 |
| A. | ls |
| B. | lw |
| C. | k1 |
| D. | 23 |
| Answer» B. lw | |
| 360. |
The command Edit > Fill Across Worksheet is active only when |
| A. | ne sheet is selected |
| B. | hen many sheets are selected |
| C. | hen no sheet is selected |
| D. | one of above |
| Answer» C. hen no sheet is selected | |
| 361. |
The shortcut key Ctrl + R is used in Excel to |
| A. | ight align the content of cell |
| B. | emove the cell contents of selected cells |
| C. | ill the selection with active cells to the right |
| D. | one of above |
| Answer» D. one of above | |
| 362. |
Long text can be broken down into many lines within a cell. You can do this through |
| A. | rap Text in Format > Cells |
| B. | ustify in Edit > Cells |
| C. | ext Wrapping in Format > Cells |
| D. | ll of above |
| Answer» B. ustify in Edit > Cells | |
| 363. |
You can auto fit the width of column by |
| A. | ouble clicking on the column name on column header |
| B. | ouble click on the cell pointer in worksheet |
| C. | ouble clicking on column right border on column header |
| D. | ouble clicking on the column left border of column header |
| Answer» D. ouble clicking on the column left border of column header | |
| 364. |
Which of the cell pointer indicate that you can move the content to other cell? |
| A. | octor’s symbol (Big Plus) |
| B. | mall thin plus icon |
| C. | ouse Pointer with anchor at the tip |
| D. | one of above |
| Answer» D. one of above | |
| 365. |
Edit > Delete command |
| A. | eletes the content of a cell |
| B. | eletes Formats of cell |
| C. | eletes the comment of cell |
| D. | eletes selected cells |
| Answer» E. | |
| 366. |
Which command will you choose to convert a column of data into row? |
| A. | ut and Paste |
| B. | aste Special > Transpose |
| C. | oth of above |
| D. | one of above |
| Answer» C. oth of above | |
| 367. |
Which of the following option is not available in Paste Special dialog box? |
| A. | dd |
| B. | ubtract |
| C. | ivide |
| D. | QRT |
| Answer» E. | |
| 368. |
How can you show or hide the gridlines in Excel Worksheet? |
| A. | o to Tools > Options > View tab and mark or remove the check box named Gridline |
| B. | lick Gridline tool on Forms toolbar |
| C. | oth of above |
| D. | one of above |
| Answer» D. one of above | |
| 369. |
You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that? |
| A. | ustom List |
| B. | uto Fill Options |
| C. | ill Across Worksheet |
| D. | ill Series |
| Answer» B. uto Fill Options | |
| 370. |
What will be the output if you format the cell containing 5,436.8 as '#,##0.00' ? |
| A. | 430 |
| B. | 436.8 |
| C. | 436.8 |
| D. | 0.8 |
| Answer» C. 436.8 | |
| 371. |
Microsoft Excel is a powerful ________ |
| A. | ord processing package |
| B. | preadsheet package |
| C. | ommunication S/W Package |
| D. | BMS package |
| Answer» C. ommunication S/W Package | |
| 372. |
In EXCEL, you can sum a large range of data by simply selecting a tool button called ________. |
| A. | utoFill |
| B. | uto correct |
| C. | uto sum |
| D. | uto format |
| Answer» D. uto format | |
| 373. |
A numeric value can be treated as label value if ________ precedes it. |
| A. | postrophe ( ‘ ) |
| B. | xclamation ( ! ) |
| C. | ash ( # ) |
| D. | ilde ( ~ ) |
| Answer» B. xclamation ( ! ) | |
| 374. |
Getting data from a cell located in a different sheet is called ________ |
| A. | ccessing |
| B. | eferencing |
| C. | pdating |
| D. | unctioning |
| Answer» C. pdating | |
| 375. |
MS-EXCEL is based on ________ |
| A. | INDOWS |
| B. | OS |
| C. | NIX |
| D. | S/2 |
| Answer» B. OS | |
| 376. |
An Excel Workbook is a collection of ________ |
| A. | orkbooks |
| B. | orksheets |
| C. | harts |
| D. | orksheets and Charts |
| Answer» E. | |
| 377. |
Multiple calculations can be made in a single formula using ________ |
| A. | tandard Formulas |
| B. | rray Formula |
| C. | omplex Formulas |
| D. | mart Formula |
| Answer» C. omplex Formulas | |
| 378. |
Comments can be added to cells using ________ |
| A. | ome > Comments |
| B. | nsert > Comment |
| C. | ata > Comments |
| D. | iew > Comments |
| Answer» C. ata > Comments | |
| 379. |
What is the shortcut key to replace a data with another in sheet? |
| A. | trl + R |
| B. | trl + Shift + R |
| C. | trl + H |
| D. | trl + F |
| Answer» D. trl + F | |
| 380. |
In MS Excel, a worksheet, also known as a ______, is a table into which you enter data and data lebel. |
| A. | Data set |
| B. | Data Room |
| C. | ROM |
| D. | Spreadsheet |
| Answer» E. | |
| 381. |
In an MS Excel sheet, a cell address is composed of the _____. |
| A. | cell's row |
| B. | worksheet number |
| C. | cell's column |
| D. | cell's column and row |
| Answer» E. | |
| 382. |
In MS Excel, ______ are numbered from 1 to onwards and ______ are numbered from A to onwards. |
| A. | Columns, rows |
| B. | Rows, slides |
| C. | Slides, rows |
| D. | Rows, columns |
| Answer» E. | |
| 383. |
By default Excel provides three worksheets. If you need only two of them, then how will you delete the third one ? |
| A. | Right click on the Sheet Tab of thr third sheet and chooses Delete from the context menu |
| B. | Click on sheet and from View menu choose Delete |
| C. | Left click on Sheet Tab of the third sheet and chooses Delete from the context menu |
| D. | None of the above |
| Answer» B. Click on sheet and from View menu choose Delete | |
| 384. |
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 | |
| 385. |
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 | |
| 386. |
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 | |
| 387. |
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 | |
| 388. |
Files created with Lotus 1-2-3 have an extension%! |
| A. | DOC |
| B. | XLS |
| C. | 123 |
| D. | WK1 |
| Answer» D. WK1 | |
| 389. |
Which of the following is the latest version of Excel%! |
| A. | Excel 2000 |
| B. | Excel 2002 |
| C. | Excel ME |
| D. | Excel XP |
| Answer» E. | |
| 390. |
What symbol is used before a number to make it a label?%! |
| A. | ” ( quote ) |
| B. | = ( equal ) |
| C. | _ ( underscore ) |
| D. | ‘ ( apostrophe ) |
| Answer» E. | |
| 391. |
How many characters can be typed in a single cell in Excel?%! |
| A. | 256 |
| B. | 1024 |
| C. | 32000 |
| D. | 65535 |
| Answer» E. | |
| 392. |
Which of the following is a correct order of precedence in formula calculation?%! |
| A. | Multiplication and division exponentiation positive and negative values |
| 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. | |
| 393. |
You want to track the progress of the stock market on a daily basis. Which type of chart should you use?%! |
| A. | Pie chart |
| B. | Row chart |
| C. | Line chart |
| D. | Column chart |
| Answer» D. Column chart | |
| 394. |
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 | |
| 395. |
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. | |
| 396. |
The command Edit >> Fill Across Worksheet is active only when%! |
| A. | One sheet is selected |
| B. | When many sheets are selected |
| C. | When no sheet is selected |
| D. | None of above |
| Answer» C. When no sheet is selected | |
| 397. |
Which of the following is not the correct method of editing the cell content?%! |
| A. | Press the Alt key |
| B. | Press the F2 key |
| C. | Click the formula bar |
| D. | Double click the cell |
| Answer» B. Press the F2 key | |
| 398. |
How can you show or hide the gridlines in Excel Worksheet?%! |
| A. | Go to Tools >> Options >> View tab and mark or remove the check box named Gridline |
| B. | Click Gridline tool on Forms toolbar |
| C. | Both of above |
| D. | None of above |
| Answer» D. None of above | |
| 399. |
Which menu option can be used to split windows into two?%! |
| A. | Format -> Window |
| B. | View -> Window-> Split |
| C. | Window -> Split |
| D. | View –> Split |
| Answer» D. View ‚Äö√Ñ√¨> Split | |
| 400. |
MS-EXCEL is based on .........?%! |
| A. | WINDOWS |
| B. | DOS |
| C. | UNIX |
| D. | OS/2 |
| Answer» B. DOS | |