Microsoft Excel Questions

MCQ bookmark_border

111.

How do you delete a column?

A

Select the column heading you want to delete and select the Delete Row button on the standard toolbar

B

Select the column heading you want to delete and select Insert Delete from the menu

C

Select the row heading you want to delete and select Edit>Delete from the menu

D

Right click the column heading you want to delete and select delete from the shortcut menu

Correct Answer: D

Right click the column heading you want to delete and select delete from the shortcut menu in Excel 2003.
From 2007 and Higher version Home > Delete > Delete Sheet Columns.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

112.

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

Correct Answer: D

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

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

113.

When integrating word and excel, word is usually the

A

Server

B

Destination

C

Client

D

Both b and c

Correct Answer: D

When integrating ms-word and excel, word is usually the Destination and Client .

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

114.

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

A

Shorten the label

B

Increase the column width

C

Decrease the column width

D

Adjust the row height

Correct Answer: B

When a label is too long to fit within a worksheet cell, we must increase the column width.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

115.

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

A

Shorten the label

B

Increase the column width

C

Decrease the column width

D

Adjust the row height

Correct Answer: B

When a label is too long to fit within a worksheet cell, we must increase the column width.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

116.

Comments put in cells are called

A

Smart Tip

B

Cell Tip

C

Web Tip

D

Soft Tip

Correct Answer: B

Comments put in cells are called Cell Tip

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

117.

Which is used to perform what if analysis?

A

Solver

B

Goal seek

C

Scenario Manager

D

All of above

Correct Answer: D

Goal seek, Scenario Manager and Solver are used to perform what if analysis in Excel.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

118.

You can use the horizontal and vertical scroll bars to

A

Split a worksheet into two panes

B

View different rows and columns edit the contents of a cell

C

Edit the contents of a cell

D

View different worksheets

Correct Answer: B

You can use the horizontal and vertical scroll bars to view different rows and columns edit the contents of a cell.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

119.

Multiple calculations can be made in a single formula using

A

Standard formulas

B

Array formula

C

Complex formulas

D

Smart formula

Correct Answer: B

An array formula is a formula that can perform multiple calculations on one or more of the items in an array. We can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. For example, we can create an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. We can also place an array formula in a single cell and calculate a single amount. An array formula that includes multiple cells is called a multi-cell formula, and an array formula in a single cell is called a single-cell formula.

Check Answer report_problem Report forum Discussion

MCQ bookmark_border

120.

Multiple calculations can be made in a single formula using

A

Standard formulas

B

Array formula

C

Complex formulas

D

Smart formula

Correct Answer: B

An array formula is a formula that can perform multiple calculations on one or more of the items in an array. We can think of an array as a row of values, a column of values, or a combination of rows and columns of values. Array formulas can return either multiple results or a single result. For example, we can create an array formula in a range of cells and use the array formula to calculate a column or row of subtotals. We can also place an array formula in a single cell and calculate a single amount. An array formula that includes multiple cells is called a multi-cell formula, and an array formula in a single cell is called a single-cell formula.

Check Answer report_problem Report forum Discussion