

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.
401. |
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 | |
402. |
How do you display current date and time in MS Excel?%! |
A. | date () |
B. | Today () |
C. | now () |
D. | time () |
Answer» D. time () | |
403. |
Long text can be broken down into many lines within a cell. You can do this through%! |
A. | Wrap Text in Format >> Cells |
B. | Justify in Edit >> Cells |
C. | Text Wraping in Format >> Cells, Layout tab |
D. | All of above |
Answer» B. Justify in Edit >> Cells | |
404. |
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 | |
405. |
To remove the content of selected cells you must issue ______ command%! |
A. | Edit >> Delete |
B. | Edit >> Clear >> Contents |
C. | Edit >> Clear >> All |
D. | Data >> Delete |
Answer» C. Edit >> Clear >> All | |
406. |
While Finding and Replacing some data in Excel, which of the following statement is valid?%! |
A. | You can Find and Replace within the sheet or workbook |
B. | Excel does not have option to match case for find |
C. | Both are valid |
D. | None are valid |
Answer» B. Excel does not have option to match case for find | |
407. |
When a range is selected, how can you activate the previous cell?%! |
A. | Press the Alt key |
B. | Press Tab |
C. | Press Enter |
D. | None of above |
Answer» E. | |
408. |
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 | |
409. |
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 | |
410. |
*/*_Concatenation of text can be done using? |
A. | Apostrophe ( ‘ ) |
B. | Exclamation ( ! ) |
C. | Hash ( # ) |
D. | Ampersand ( & ) |
Answer» E. | |
411. |
*/*_MS-EXCEL is based on .........?? |
A. | WINDOWS |
B. | DOS |
C. | UNIX |
D. | OS/2 |
Answer» B. DOS | |
412. |
*/*_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 | |
413. |
*/*_How do you display current date and time in MS Excel?? |
A. | date () |
B. | Today () |
C. | now () |
D. | time () |
Answer» D. time () | |
414. |
*/*_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 | |
415. |
*/*_Long text can be broken down into many lines within a cell. You can do this through? |
A. | Wrap Text in Format >> Cells |
B. | Justify in Edit >> Cells |
C. | Text Wraping in Format >> Cells, Layout tab |
D. | All of above |
Answer» B. Justify in Edit >> Cells | |
416. |
*/*_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 | |
417. |
*/*_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 | |
418. |
*/*_When a range is selected, how can you activate the previous cell?? |
A. | Press the Alt key |
B. | Press Tab |
C. | Press Enter |
D. | None of above |
Answer» E. | |
419. |
*/*_While Finding and Replacing some data in Excel, which of the following statement is valid?? |
A. | You can Find and Replace within the sheet or workbook |
B. | Excel does not have option to match case for find |
C. | Both are valid |
D. | None are valid |
Answer» B. Excel does not have option to match case for find | |
420. |
*/*_To remove the content of selected cells you must issue ______ command? |
A. | Edit >> Delete |
B. | Edit >> Clear >> Contents |
C. | Edit >> Clear >> All |
D. | Data >> Delete |
Answer» C. Edit >> Clear >> All | |
421. |
*/*_Which of the following is not information you can specify using the solver?? |
A. | Input cells |
B. | Constraints |
C. | Target cell |
D. | Changing cells |
Answer» B. Constraints | |
422. |
*/*_In the formula, which symbol specifies the fixed columns or rows?? |
A. | $ |
B. | * |
C. | % |
D. | & |
Answer» B. * | |
423. |
*/*_How many worksheets can a workbook have?? |
A. | 3 |
B. | 8 |
C. | 255 |
D. | none of above |
Answer» E. | |
424. |
*/*_You cannot link excel worksheet data to a word document? |
A. | With the right drag method |
B. | With a hyperlink |
C. | With the copy and paste special commands |
D. | With the copy and paste buttons on the standard toolbar |
Answer» E. | |
425. |
*/*_To create a formula, you can use:? |
A. | Values but not cell references |
B. | Cell references but not values |
C. | Values or cell references although not both at the same time |
D. | Value and cell references |
Answer» E. | |
426. |
*/*_In a worksheet you can select? |
A. | The entire worksheet |
B. | Rows |
C. | Columns |
D. | All of the above |
Answer» E. | |
427. |
*/*_You can use the formula palette to? |
A. | Format cells containing numbers |
B. | Create and edit formulas containing functions |
C. | Enter assumptions data |
D. | Copy a range of cells |
Answer» C. Enter assumptions data | |
428. |
*/*_How do you insert a row?? |
A. | Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu |
B. | Select the row heading where you want to insert the new row and select Edit >Row from the menu |
C. | Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar |
D. | All of the above |
Answer» B. Select the row heading where you want to insert the new row and select Edit >Row from the menu | |
429. |
*/*_Which of the following methods cannot 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 | |
430. |
*/*_A __________ is a grid with labeled columns and rows.? |
A. | Dialog box |
B. | Worksheet |
C. | Clipboard |
D. | Toolbar |
Answer» C. Clipboard | |
431. |
*/*_What are the tabs that appear at the bottom of each workbook called?? |
A. | Reference tabs |
B. | Position tabs |
C. | Location tabs |
D. | Sheet tabs |
Answer» E. | |
432. |
*/*_The name box? |
A. | Shows the location of the previously active cell |
B. | Appears to the left of the formula bar |
C. | Appears below the status bar |
D. | Appears below the menu bar |
Answer» C. Appears below the status bar | |
433. |
*/*_To center worksheet titles across a range of cells, you must? |
A. | Select the cells containing the title text plus the range over which the title text is to be centered |
B. | Widen the columns |
C. | Select the cells containing the title text plus the range over which the title text is to be enfettered |
D. | Format the cells with the comma style |
Answer» B. Widen the columns | |
434. |
*/*_How many characters can be typed in a single cell in Excel?? |
A. | 256 |
B. | 1024 |
C. | 32000 |
D. | 65535 |
Answer» E. | |
435. |
*/*_What symbol is used before a number to make it a label?? |
A. | ” ( quote ) |
B. | = ( equal ) |
C. | _ ( underscore ) |
D. | ‘ ( apostrophe ) |
Answer» E. | |
436. |
*/*_When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply? |
A. | Use =if() function to format the required numbers red |
B. | Apply Conditional Formatting command on Format menu |
C. | Select the cells that contain number between 0 and 100 then click Red color on Text Color tool |
D. | All of above |
Answer» C. Select the cells that contain number between 0 and 100 then click Red color on Text Color tool | |
437. |
*/*_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. | |
438. |
*/*_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. | |
439. |
*/*_A 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 | |
440. |
*/*_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 | |
441. |
*/*_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 | |
442. |
*/*_Which of the following is the latest version of Excel? |
A. | Excel 2000 |
B. | Excel 2002 |
C. | Excel ME |
D. | Excel XP |
Answer» E. | |
443. |
*/*_Files created with Lotus 1-2-3 have an extension? |
A. | DOC |
B. | XLS |
C. | 123 |
D. | WK1 |
Answer» D. WK1 | |
444. |
*/*_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. | |
445. |
*/*_Documentation should include? |
A. | Destination and users of the output data |
B. | Source of input data |
C. | Information on the purpose of the workbook |
D. | All of the above |
Answer» E. | |
446. |
*/*_To copy cell contents using drag and drop press the? |
A. | End key |
B. | Shift key |
C. | Ctrl key |
D. | Esc key |
Answer» D. Esc key | |
447. |
*/*_Which of the following is an absolute cell reference?? |
A. | !A!1 |
B. | $A$1 |
C. | #a#1 |
D. | A1 |
Answer» C. #a#1 | |
448. |
*/*_A typical worksheet has ..... Number of columns? |
A. | 128 |
B. | 256 |
C. | 512 |
D. | 1024 |
Answer» C. 512 | |
449. |
*/*_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 | |
450. |
*/*_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 | |