Microsoft Excel Basic MCQs (Long Quiz) (Part 2)

This is the quiz about basics of Microsoft Office Excel. Students and new learner's can test their knowledge.

1. Which of the following methods cannot be used to enter data in a cell

Pressing the Esc key
Clicking on the formula bar

2. Which of the following will not cut information?

Pressing Ctrl + C
Pressing Ctrl+X

3. Which of the following is not a way to complete a cell entry?

Clicking the Enter button on the Formula bar
Pressing spacebar

4. Text formulas:

Concatenate and manipulate text
Show formula error value

5. Which of the following is not a basic step in creating a worksheet?

Copy the worksheet
Modifiy the worksheet

6. How do you select an entire column?

Select Edit > Select > Column from the menu
Click the column heading letter

7. How can you print three copies of a workbook?

Select File>Properties form the menu and type 3 in the Copies to print text box.
Select File >Print from the menu and type 3 in the Number of copies text box.

8. To create a formula, you first:

Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that you’re about to enter a formula

9. To center worksheet titles across a range of cells, you must

Select the cells containing the title text plus the range over which the title text is to be centered
Widen the columns

10. How do you delete a column?

Select Insert > Find from the menu
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button

11. When integrating word and excel, word is usually the

Destination & Client

12. When a label is too long to fit within a worksheet cell, you typically must

Increase the column width
Decrease the column width

13. The name box

Shows the location of the previously active cell
Appears to the left of the formula bar

14. Comments put in cells are called

Smart tip
Cell tip

15. You can use the horizontal and vertical scroll bars to

Split a worksheet into two panes
View different rows and columns edit the contents of a cell

16. Multiple calculations can be made in a single formula using

array formula
complex formulas

17. Which button do you click to add up a series of numbers?

The autosum button
The Formula button

18. To copy formatting from one area in a worksheet and apply it to another area you would use:

There is no way to copy and apply formatting in Excel – You have to do it manually
The Format Painter button on the standard toolbar

19. In a worksheet you can select


20. When you link data maintained in an excel workbook to a word document

The word document cannot be edit
The word document contains a reference to the original source application

21. Which area in an excel window allows entering values and formulas

Menu bar
Formula bar

22. To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the

Unfreeze panes command on the window menu
Freeze panes command on the window menu

23. To edit in an embedded excel worksheet object in a word document

Use the excel menu bar and toolbars inside the word application
Edit the hyperlink

24. To create a formula, you can use:

Values or cell references although not both at the same time
Value and cell references

25. Status indicators are located on the

Horizontal scroll bar
Formula bar

26. Which of the following is the oldest spreadsheet package?

Lotus 1-2-3