MS Excel

Objective Q&A


1. On an excel sheet the active cell in indicated by?

A) A dotted border

B) A dark wide borderü

C)A blinking border

D) By italic text

2. The default style for new data keyed in a new workbook is?

A) Comma

B) Normalü

C) Currency

D) Percent

3. A value used in a formula that does not change is called a?

A) Constantü

B) Cell address

C) Variable

D) Static

4. what term describes a background that appears as a grainy, non-smooth surface?

A) Pattern

B) Gradientü

C) Texture

D) Velvet

5. You can convert existing Excel worksheet data and charts to HTML document by using the?

A) Internet Assistant Wizardü

B) Intranet Wizard

C) Import Wizard

D) Export Wizard

6. Macros can be executed from the which of the following menu?

A) Format

B) Home

C) Insert

D) Toolsü

7. You can check the conditions against ____ when applying conditional formatting?

A) Cell Value

B) Formula

C) Both of aboveü

D) None of above

8. How is data organized in a spreadsheet?

A) Rows and columnsü

B) Layers and planes

C) Lines and spaces

D) Height and width

9.  How do you change column width to fit the contents?

A) Single-click the boundary to the left to the column heading.

B) Double click the boundary to the right of the column heading.ü

C) Press Alt and single click anywhere in the column.

D) All of above.

10. Which function is used for creating a data table?

A) Sum

B) Tableü

C) Add

D) Count