

MCQOPTIONS
Saved Bookmarks
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.
451. |
*/*_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 | |
452. |
*/*_Which elements of worksheet can be protected from accidental modification? |
A. | Contents |
B. | Objects |
C. | Scenarios |
D. | All of above |
Answer» E. | |
453. |
*/*_Which of the following action removes a sheet from workbook?? |
A. | Select the sheet, then choose Edit >> Delete Sheet |
B. | Select the sheet then choose Format >> Sheet >> Hide |
C. | Both of above |
D. | None of above |
Answer» B. Select the sheet then choose Format >> Sheet >> Hide | |
454. |
*/*_Edit >> Delete command? |
A. | Deletes the content of a cell |
B. | Deletes Formats of cell |
C. | Deletes the comment of cell |
D. | Deletes selected cells |
Answer» E. | |
455. |
*/*_The short cut key Ctrl + R is used in Excel to? |
A. | Right align the content of cell |
B. | Remove the cell contents of selected cells |
C. | Fill the selection with active cells to the right |
D. | None of above |
Answer» D. None of above | |
456. |
*/*_You can auto fit the width of column by? |
A. | double clicking on the column name on column header |
B. | Double click on the cell pointer in worksheet |
C. | Double clicking on column right border on column header |
D. | Double clicking on the column left border of column header |
Answer» D. Double clicking on the column left border of column header | |
457. |
*/*_Which command will you choose to convert a column of data into row?? |
A. | Cut and Paste |
B. | Edit >> Paste Special >> Transpose |
C. | Both of above |
D. | None of above |
Answer» C. Both of above | |
458. |
*/*_Where can you change automatic or manual calculation mode in Excel?? |
A. | Double CAL indicator on status bar |
B. | Go to Tools >> Options >> Calculation and mark the corresponding radio button |
C. | Both of above |
D. | None of above |
Answer» C. Both of above | |
459. |
*/*_Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?? |
A. | work sheet |
B. | chart sheet |
C. | module sheet |
D. | data sheet |
Answer» E. | |
460. |
*/*_You can use the formula pallette to? |
A. | format cells containing numbers |
B. | create and edit formula containing functions |
C. | enter assumptions data |
D. | copy a range of cells |
Answer» C. enter assumptions data | |
461. |
*/*_What will be the output if you format the cell containing 5436.8 as '#,##0.00' ?? |
A. | 5430 |
B. | 5436.80 |
C. | 5436.8 |
D. | 6.8 |
Answer» C. 5436.8 | |
462. |
*/*_Comments can be added to cells using ......? |
A. | Edit -> Comments |
B. | Insert -> Comment |
C. | File -> Comments |
D. | View –> Comments |
Answer» C. File -> Comments | |
463. |
*/*_A numeric value can be treated as label value if ...... precedes it.? |
A. | Apostrophe ( ‘ ) |
B. | Exclamation ( ! ) |
C. | Hash ( # ) |
D. | Tilde ( ~ ) |
Answer» B. Exclamation ( ! ) | |
464. |
*/*_What do you mean by a Workspace?? |
A. | Group of Columns |
B. | Group of Worksheets |
C. | Group of Rows |
D. | Group of Workbooks |
Answer» E. | |
465. |
*/*_Which function is not available in the Consolidate dialog box?? |
A. | Pmt |
B. | Average |
C. | Max |
D. | Sum |
Answer» B. Average | |
466. |
_ A numeric value can be treated as label value if ...... precedes it.$? |
A. | Apostrophe ( ‘ ) |
B. | Exclamation ( ! ) |
C. | Hash ( # ) |
D. | Tilde ( ~ ) |
Answer» B. Exclamation ( ! ) | |
467. |
_ What do you mean by a Workspace?$? |
A. | Group of Columns |
B. | Group of Worksheets |
C. | Group of Rows |
D. | Group of Workbooks |
Answer» E. | |
468. |
_ Which function is not available in the Consolidate dialog box?$? |
A. | Pmt |
B. | Average |
C. | Max |
D. | Sum |
Answer» B. Average | |
469. |
_ What will be the output if you format the cell containing 5436.8 as '#,##0.00' ?$? |
A. | 5430 |
B. | 5436.80 |
C. | 5436.8 |
D. | 6.8 |
Answer» C. 5436.8 | |
470. |
_ Comments can be added to cells using ......$? |
A. | Edit -> Comments |
B. | Insert -> Comment |
C. | File -> Comments |
D. | View –> Comments |
Answer» C. File -> Comments | |
471. |
_ The short cut key Ctrl + R is used in Excel to$? |
A. | Right align the content of cell |
B. | Remove the cell contents of selected cells |
C. | Fill the selection with active cells to the right |
D. | None of above |
Answer» D. None of above | |
472. |
_ You can auto fit the width of column by$? |
A. | double clicking on the column name on column header |
B. | Double click on the cell pointer in worksheet |
C. | Double clicking on column right border on column header |
D. | Double clicking on the column left border of column header |
Answer» D. Double clicking on the column left border of column header | |
473. |
_ Which command will you choose to convert a column of data into row?$? |
A. | Cut and Paste |
B. | Edit >> Paste Special >> Transpose |
C. | Both of above |
D. | None of above |
Answer» C. Both of above | |
474. |
_ Where can you change automatic or manual calculation mode in Excel?$? |
A. | Double CAL indicator on status bar |
B. | Go to Tools >> Options >> Calculation and mark the corresponding radio button |
C. | Both of above |
D. | None of above |
Answer» C. Both of above | |
475. |
_ Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?$? |
A. | work sheet |
B. | chart sheet |
C. | module sheet |
D. | data sheet |
Answer» E. | |
476. |
_ You can use the formula pallette to$? |
A. | format cells containing numbers |
B. | create and edit formula containing functions |
C. | enter assumptions data |
D. | copy a range of cells |
Answer» C. enter assumptions data | |
477. |
_ Which of the following action removes a sheet from workbook?$? |
A. | Select the sheet, then choose Edit >> Delete Sheet |
B. | Select the sheet then choose Format >> Sheet >> Hide |
C. | Both of above |
D. | None of above |
Answer» B. Select the sheet then choose Format >> Sheet >> Hide | |
478. |
_ Edit >> Delete command$? |
A. | Deletes the content of a cell |
B. | Deletes Formats of cell |
C. | Deletes the comment of cell |
D. | Deletes selected cells |
Answer» E. | |
479. |
_ When you insert an excel file into a word document. The data are$? |
A. | Hyperlinked placed in a word table |
B. | Linked |
C. | Embedded |
D. | Use the word menu bar and toolbars |
Answer» C. Embedded | |
480. |
_ What is the short cut key to highlight the entire column?$? |
A. | Ctrl+C |
B. | Ctrl+Enter |
C. | Ctrl+Page Up |
D. | Ctrl+Space Bar |
Answer» E. | |
481. |
_ Which of the following is not a term of MS-Excel?$? |
A. | Cells |
B. | Rows |
C. | Columns |
D. | Document |
Answer» E. | |
482. |
_ You can copy data or formulas$? |
A. | With the copy, paste and cut commands on the edit menu |
B. | With commands on the shortcut menu |
C. | With buttons on the standard toolbars |
D. | All of the above |
Answer» E. | |
483. |
_ To edit 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 | |
484. |
_ 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. | |
485. |
_ You can use the format painter multiple times before you turn it off by$? |
A. | You can use the format painter button on ly 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 the Alt key and clicking the format painter button |
Answer» C. Pressing the Ctrl key and clicking the format painter button | |
486. |
_ 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 | |
487. |
_ The Cancel and Enter buttons appear in the:$? |
A. | Title bar |
B. | Formula bar |
C. | Menu bar |
D. | Sheet tabs |
Answer» C. Menu bar | |
488. |
_ In help menu of Excel, which of the following tabs are found?$? |
A. | Contents tab |
B. | Answer Wizard tab |
C. | Index tab |
D. | all of the above |
Answer» E. | |
489. |
_ What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)$? |
A. | An absolute cell address is created |
B. | Cell address will change when it is copied to another cell |
C. | The sheet tab is changed |
D. | The status bar does not display the cell address |
Answer» B. Cell address will change when it is copied to another cell | |
490. |
_ The spelling dialog box can be involved by choosing spelling from ________ menu.$? |
A. | insert |
B. | file |
C. | tools |
D. | view |
Answer» D. view | |
491. |
_ When a label is too long to fit within a worksheet cell, you typically must$? |
A. | Shorten the label |
B. | Increase the column width |
C. | Decrease the column width |
D. | Adjust the row height |
Answer» C. Decrease the column width | |
492. |
_ To create a formula, you first:$? |
A. | Select the cell you want to place the formula into |
B. | Type the equals sign (=) to tell Excel that you’re about to enter a formula |
C. | Enter the formula using any input values and the appropriate mathematical operators that make up your formula |
D. | Choose the new command from the file menu |
Answer» C. Enter the formula using any input values and the appropriate mathematical operators that make up your formula | |
493. |
__A typical worksheet has ..... Number of columns__ |
A. | 128 |
B. | 256 |
C. | 512 |
D. | 1024 |
Answer» C. 512 | |
494. |
__Which of the following is an absolute cell reference?__ |
A. | !A!1 |
B. | $A$1 |
C. | #a#1 |
D. | A1 |
Answer» C. #a#1 | |
495. |
__You can set Page Border in Excel from__ |
A. | From Border tab in Format Cells dialog box |
B. | From Border tool in Formatting toolbar |
C. | From Line Style tool in Drawing toolbar |
D. | You can not set page border in Excel |
Answer» E. | |
496. |
__All worksheet formula__ |
A. | Manipulate values |
B. | Manipulate labels |
C. | Return a formula result |
D. | Use the addition operator |
Answer» D. Use the addition operator | |
497. |
__Concatenation of text can be done using__ |
A. | Apostrophe (&lsquo |
B. | Exclamation (!) |
C. | Hash (#) |
D. | Ampersand (& |
Answer» E. | |
498. |
__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 | |
499. |
__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 | |
500. |
__Which of the following options is not located in the Page Setup dialog box?__ |
A. | Page Break Preview |
B. | Page Orientation |
C. | Margins |
D. | Headers and Footers |
Answer» B. Page Orientation | |