MS Excel MCQs

Question 1

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

Accepted Answer

Pressing the Esc key

Answer

Pressing an arrow key

Answer

Pressing the Tab key

Answer

Clicking on the formula bar

Question 2

Which of the following will not cut information?

Accepted Answer

Pressing Ctrl + C

Answer

Selecting Edit > Cut from the menu

Answer

Clicking the Cut button on the standard

Answer

Pressing Ctrl+X

Question 3

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

Accepted Answer

Pressing spacebar

Answer

Pressing enter

Answer

Pressing any arrow key on the keyboard

Answer

Clicking the Enter button on the Formula bar

Question 4

You can activate a cell by

Accepted Answer

All of the above

Answer

Pressing the Tab key

Answer

Clicking the cell

Answer

Pressing an arrow key

Question 5

Text formulas:

Accepted Answer

Concatenate and manipulate text

Answer

Replace cell references

Answer

Return ASCII values of characters

Answer

Show formula error value

Question 6

How do you insert a row?

Accepted Answer

Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

Answer

Select the row heading where you want to insert the new row and select Edit >Row from the menu

Answer

Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

Answer

All of the above

Question 7

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

Accepted Answer

Copy the worksheet

Answer

Save workbook

Answer

Modifiy the worksheet

Answer

Enter text and data

Question 8

How do you select an entire column?

Accepted Answer

Click the column heading letter

Answer

Select Edit > Select > Column from the menu

Answer

Hold down the shift key as you click anywhere in the column

Answer

Hold down the Ctrl key as you click anywhere in the column

Question 9

How can you print three copies of a workbook?

Accepted Answer

Select File > Print from the menu and type 3 in the Number of copies text box

Answer

Select File > Properties form the menu and type 3 in the Copies to print text box

Answer

Click the Print button on the standard toolbar to print the document then take it to Kinko’s and have 2 more copies made

Answer

Press Ctrl+P+3