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
Correct Answer
Wrong Answer
2. Which of the following will not cut information?
Pressing Ctrl + C
Pressing Ctrl+X
Correct Answer
Wrong Answer
3. Which of the following is not a way to complete a cell entry?
Clicking the Enter button on the Formula bar
Pressing spacebar
Correct Answer
Wrong Answer
4. Text formulas:
Concatenate and manipulate text
Show formula error value
Correct Answer
Wrong Answer
5. Which of the following is not a basic step in creating a worksheet?
Copy the worksheet
Modifiy the worksheet
Correct Answer
Wrong Answer
6. How do you select an entire column?
Select Edit > Select > Column from the menu
Click the column heading letter
Correct Answer
Wrong Answer
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.
Correct Answer
Wrong Answer
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
Correct Answer
Wrong Answer
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
Correct Answer
Wrong Answer
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
Correct Answer
Wrong Answer
11. When integrating word and excel, word is usually the
Destination & Client
Server
Correct Answer
Wrong Answer
12. When a label is too long to fit within a worksheet cell, you typically must
Increase the column width
Decrease the column width
Correct Answer
Wrong Answer
13. The name box
Shows the location of the previously active cell
Appears to the left of the formula bar
Correct Answer
Wrong Answer
14. Comments put in cells are called
Smart tip
Cell tip
Correct Answer
Wrong Answer
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
Correct Answer
Wrong Answer
16. Multiple calculations can be made in a single formula using
array formula
complex formulas
Correct Answer
Wrong Answer
17. Which button do you click to add up a series of numbers?
The autosum button
The Formula button
Correct Answer
Wrong Answer
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
Correct Answer
Wrong Answer
19. In a worksheet you can select
Rows
Columns
Correct Answer
Wrong Answer
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
Correct Answer
Wrong Answer
21. Which area in an excel window allows entering values and formulas
Menu bar
Formula bar
Correct Answer
Wrong Answer
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
Correct Answer
Wrong Answer
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
Correct Answer
Wrong Answer
24. To create a formula, you can use:
Values or cell references although not both at the same time
Value and cell references
Correct Answer
Wrong Answer
25. Status indicators are located on the
Horizontal scroll bar
Formula bar
Correct Answer
Wrong Answer
26. Which of the following is the oldest spreadsheet package?
VisiCalc
Lotus 1-2-3
Correct Answer
Wrong Answer
