Microsoft Excel Questions

MCQ bookmark_border

101.

Which of the following will not cut information?

A

Pressing Ctrl + C

B

Selecting Edit > Cut from the menu

C

Clicking the Cut button on the standard

D

Pressing Ctrl+X

Correct Answer: A

Pressing Ctrl+C when one or more cell is highlighted copies the cell's contents into the clipboard.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

102.

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

Correct Answer: D

When we press the spacebar, it selects the current cell for editing.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

103.

You can activate a cell by

A

Pressing the Tab key

B

Clicking the cell

C

Pressing an arrow key

D

All of the above

Correct Answer: D

A cell can be ready to activate by any of the method Pressing the Tab key or Clicking the cell or Pressing an arrow key.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

104.

Text formulas:

A

Replace cell references

B

Return ASCII values of characters

C

Concatenate and manipulate text

D

Show formula error value

Correct Answer: C

Concatenate and manipulate text

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

105.

Text formulas:

A

Replace cell references

B

Return ASCII values of characters

C

Concatenate and manipulate text

D

Show formula error value

Correct Answer: C

Concatenate and manipulate text

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

106.

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

A

Save workbook

B

Modifiy the worksheet

C

Enter text and data

D

Copy the worksheet

Correct Answer: D

Copy the worksheet is not a basic step in creating a worksheet.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

107.

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

Correct Answer: B

To select an entire column in MS-EXCEL, Click the column heading letter or press CTRL + Space Bar key.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

108.

How can you print three copies of a workbook?

A

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

B

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

C

Click the Print button on the standard toolbar to print the document then take it to Kinko

D

Press Ctrl+P+3

Correct Answer: B

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

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

109.

To create a formula, you first:

A

Select the cell you want to place the formula into

B

Type the equals sign (=) to tell Excel that you

C

Enter the formula using any input values and the appropriate mathematical operators that make up your formula

D

Choose the new command from the file menu

Correct Answer: B

A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

110.

To create a formula, you first:

A

Select the cell you want to place the formula into

B

Type the equals sign (=) to tell Excel that you

C

Enter the formula using any input values and the appropriate mathematical operators that make up your formula

D

Choose the new command from the file menu

Correct Answer: B

A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.

Check Answer report_problem Report forum Discussion