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.
| 551. |
Tab scroll buttons are place on Excel screen |
| A. | towards the bottom right corner |
| B. | towards the bottom left corner |
| C. | towards the top right corner |
| D. | towards the top left corner |
| Answer» C. towards the top right corner | |
| 552. |
Which of the following is not true regarding Conditional Formatting? |
| A. | You can add more than one condition to check |
| B. | You can set condition to look for Bold and apply Italics on them |
| C. | You can apply Font, border and pattern formats that meets the specified conditions |
| D. | You can delete any condition from Conditional Formatting dialog box if it is not requried |
| Answer» C. You can apply Font, border and pattern formats that meets the specified conditions | |
| 553. |
If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must |
| A. | From Edit menu choose Clear and then Formats |
| B. | From Edit menu choose Delete |
| C. | Click on Remove Formatting tool on Standard Toolbar |
| D. | Double click the Format Painter and then press Esc key in keyboard |
| Answer» B. From Edit menu choose Delete | |
| 554. |
Which of the following you can paste selectively using Paste Special command? |
| A. | Validation |
| B. | Formats |
| C. | Formulas |
| D. | All of above |
| Answer» E. | |
| 555. |
A circular reference is |
| A. | Geometric modeling tool |
| B. | A cell that points to a drawing object |
| C. | A formula that either directly or indirectly depends on itself |
| D. | Always erroneous |
| Answer» D. Always erroneous | |
| 556. |
How do you wrap the text in a cell? |
| A. | Format, cells, font |
| B. | Format, cells, protection |
| C. | Format, cells, number |
| D. | Format, cells, alignment |
| Answer» E. | |
| 557. |
What is the correct way to refer the cell A10 on sheet3 from sheet1? |
| A. | sheet3!A10 |
| B. | sheet1!A10 |
| C. | Sheet3.A10 |
| D. | A10 |
| Answer» B. sheet1!A10 | |
| 558. |
Which of the following is the oldest spreadsheet package? |
| A. | VisiCalc |
| B. | Lotus 1-2-3 |
| C. | Excel |
| D. | StarCalc |
| Answer» B. Lotus 1-2-3 | |
| 559. |
Which area in an excel window allows entering values and formulas |
| A. | Title bar |
| B. | Menu bar |
| C. | Formula bar |
| D. | Standard toolbar |
| Answer» D. Standard toolbar | |
| 560. |
Which button do you click to add up a series of numbers? |
| A. | The autosum button |
| B. | The Formula button |
| C. | The quicktotal button |
| D. | The total button |
| Answer» B. The Formula button | |
| 561. |
An excel workbook is a collection of |
| A. | Workbooks |
| B. | Worksheets |
| C. | Charts |
| D. | Worksheets and charts |
| Answer» E. | |
| 562. |
Which of the following is not a way to complete a cell entry? |
| A. | Pressing enter |
| B. | Pressing any arrow key on the keyboard |
| C. | Clicking the Enter button on the Formula bar |
| D. | Pressing spacebar |
| Answer» E. | |
| 563. |
Which function is used to calculate depreciation, rates of return, future values and loan payment amounts? |
| A. | Logical |
| B. | Math & Trigonometry |
| C. | Statistical |
| D. | Financial |
| Answer» E. | |
| 564. |
In Excel, a Data Series is defined as what? |
| A. | A type of chart |
| B. | A cell reference |
| C. | A collection of related data |
| D. | A division of results |
| Answer» D. A division of results | |
| 565. |
We can save and protect the workbook by |
| A. | Write Reservation Password |
| B. | Protection Password |
| C. | Read-only Recommended |
| D. | Any of the above |
| Answer» E. | |
| 566. |
Which setting you must modify to print a worksheet using letterhead? |
| A. | Paper |
| B. | Margin |
| C. | Layout |
| D. | Orientation |
| Answer» C. Layout | |
| 567. |
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. | |
| 568. |
How do you select an entire column? |
| A. | Select Edit > Select > Column from the menu |
| B. | Click the column heading letter |
| C. | Hold down the shift key as you click anywhere in the column |
| D. | Hold down the Ctrl key as you click anywhere in the column |
| Answer» C. Hold down the shift key as you click anywhere in the column | |
| 569. |
Which of the following formulas is not entered correctly?a. b. c. d. |
| A. | =10+50 |
| B. | =B7*B1 |
| C. | =B7+14 |
| D. | 10+50 |
| Answer» E. | |
| 570. |
The autofill feature |
| A. | extends a sequential series of data |
| B. | automatically adds range of cell values |
| C. | applies a boarder around the selected cells |
| D. | All of the above |
| Answer» E. | |
| 571. |
How can you remove borders applied in cells? |
| A. | Choose None on Border tab of Format cells |
| B. | Open the list on Border tool in Formatting toolbar then choose first tool (no border) |
| C. | Both of above |
| D. | None of above |
| Answer» D. None of above | |
| 572. |
Excel probably considers the cell entry January 1, 2000 to be a |
| A. | Label |
| B. | Value |
| C. | Formula |
| D. | Text string |
| Answer» C. Formula | |
| 573. |
Tab scrolling button |
| A. | Allow you to view a different worksheet |
| B. | Allow you to view additional worksheet rows down |
| C. | Allow you to view additional worksheet columns to the right |
| D. | Allow you to view additional sheets tabs |
| Answer» E. | |
| 574. |
Which of the following is not an example of a value? |
| A. | 350 |
| B. | May 10, 2001 |
| C. | 0.57 |
| D. | Serial Number 50771 |
| Answer» E. | |
| 575. |
Which of the following methods can not be used to edit the contents of a cell? |
| 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 | |
| 576. |
The numbers in our worksheet look like this: You want them to look like this: $1,000.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 | |
| 577. |
Comments can be added to cells using |
| A. | Edit > Comments |
| B. | Insert > Comments |
| C. | File > Comments |
| D. | View > Comments |
| Answer» C. File > Comments | |
| 578. |
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 | |
| 579. |
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 | |
| 580. |
Which area in an Excel window allows entering values and formulas? |
| A. | Title Bar |
| B. | Menu Bar |
| C. | Formula Bar |
| D. | Standard Tool Bar |
| Answer» D. Standard Tool Bar | |
| 581. |
In EXCEL, you can sum a large range of data by simply selecting a tool button called .....? |
| A. | AutoFill |
| B. | Auto correct |
| C. | Auto sum |
| D. | Auto format |
| Answer» D. Auto format | |
| 582. |
Microsoft Excel is a powerful ........... |
| A. | Word processing package |
| B. | Spreadsheet package |
| C. | Communication S/W Package |
| D. | DBMS package |
| Answer» C. Communication S/W Package | |
| 583. |
Which of the following is not true about Find and Replace in Excel |
| A. | You can search for bold and replace with italics |
| B. | You can decide whether to look for the whole word or not |
| C. | You can search in formula too |
| D. | You can search by rows or columns or sheets |
| Answer» E. | |
| 584. |
MS Excel provides the default value for step in Fill Series dialog box |
| A. | 0 |
| B. | 1 |
| C. | 5 |
| D. | 10 |
| Answer» C. 5 | |
| 585. |
Which of the cell pointer indicates you that you can make selection? |
| A. | Doctor’s symbol (Big Plus) |
| B. | small thin plus icon |
| C. | Mouse Pointer with anchor at the tip |
| D. | None of above |
| Answer» B. small thin plus icon | |
| 586. |
Which of the following Excel screen components can NOT be turned on or off? |
| A. | Formula Bar |
| B. | Status Bar |
| C. | Tool Bar |
| D. | None of above |
| Answer» E. | |
| 587. |
You can merge the main document with data source in Excel. In mail merge operation, Word is usually |
| A. | server |
| B. | source |
| C. | client |
| D. | none |
| Answer» D. none | |
| 588. |
Which tool you will use to join some cells and place the content at the middle of joined cell? |
| A. | From Format Cells dialog box click on Merge Cells check box |
| B. | From Format Cells dialog box select the Centered alignment |
| C. | From Format Cells dialog box choose Merge and Center check box |
| D. | Click on Merge and Center tool on formatting toolbar |
| Answer» E. | |
| 589. |
You can check the conditions against __________ when applying conditional formatting |
| A. | Cell value |
| B. | Formula |
| C. | Both of above |
| D. | None of above |
| Answer» D. None of above | |
| 590. |
The Delete key of keyboard is assigned to which command in Excel? |
| A. | Edit >> Clear >> Contents |
| B. | Edit >> Clear >> All |
| C. | Edit >> Delete |
| D. | All of above |
| Answer» B. Edit >> Clear >> All | |
| 591. |
Which of the following series type is not valid for Fill Series dialog box? |
| A. | Linear |
| B. | Growth |
| C. | Autofill |
| D. | Time |
| Answer» E. | |
| 592. |
You can convert existing excel worksheet data an charts to an HTML document by using |
| A. | FTP wizard |
| B. | Internet assistant wizard |
| C. | Intranet wizard |
| D. | Import wizard |
| Answer» C. Intranet wizard | |
| 593. |
How do you display current date only in MS Excel? |
| A. | date () |
| B. | Today () |
| C. | now () |
| D. | time () |
| Answer» C. now () | |
| 594. |
Excel displays the current cell address in the ........ |
| A. | Formula bar |
| B. | Status Bar |
| C. | Name Box |
| D. | Title Bar |
| Answer» D. Title Bar | |
| 595. |
Status indicators are located on the |
| A. | Vertical scroll bar |
| B. | Horizontal scroll bar |
| C. | Formula bar |
| D. | Standard toolbar |
| Answer» D. Standard toolbar | |
| 596. |
When you link data maintained in an excel workbook to a word document |
| A. | The word document cannot be edit |
| B. | The word document contains a reference to the original source application |
| C. | The word document must contain a hyperlink |
| D. | The word document contains a copy of the actual data |
| Answer» C. The word document must contain a hyperlink | |
| 597. |
To activate the previous cell in a pre-selected range, press |
| A. | The Alt key |
| B. | The Tab key |
| C. | The Enter key |
| D. | None of the above |
| Answer» E. | |
| 598. |
Which of the following is a popular DOS based spreadsheet package? |
| A. | Word |
| B. | Smart cell |
| C. | Excel |
| D. | Lotus 1-2-3 |
| Answer» E. | |
| 599. |
The active cell: |
| A. | is defined by a bold border around the cell |
| B. | Receives the data the user enters |
| C. | It is the formula bar |
| D. | Only A and B |
| Answer» E. | |
| 600. |
What is represented by the small, black square in the lower-right corner of an active cell or range? |
| A. | Copy handle |
| B. | Fill handle |
| C. | Insert handle |
| D. | Border |
| Answer» C. Insert handle | |