IM-2

Q1. Which chart type is used to show trends over time and categories?

A. Area Chart

B. Bar Chart

C. Doughnut Chart

D. Hierarchy Chart

Q2. Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?

A. Styling

B. Conditional Formatting

C. Compare Formatting

D. Special Formatting

Q3. Which function is used to find the sum of complex numbers in MS Excel?

A. SUM()

B. ADD()

C. CSUM()

D. IMSUM()

Q4. Which option displays the total number of cells, formulas, charts, tables, sheets, etc in a Workbook?

A. Workbook Statistics

B. Statistics

C. Excel Statistics

D. Workbook Analysis

Q5. Which area in an excel window allows entering values and formulas

A. Title bar

B. Menu bar

C. Formula bar

D. Standard toolbar

Q6. In Excel how many characters can be typed in a single cell?

A. 256

B. 1024

C. 32,000

D. 65,535

Q7. The most common subtotal used Subtotals command is the __ function, which causes Excel to display a sum each time the control field change.

A. ADD

B. SUM

C. TOTAL

D. LIST

Q8. A constant is another name for this type of data:

A. number

B. equation

C. formula

D. description

Q9. To select the entire column, press

A. Tab + C

B. Tab + E

C. Alt + Space

D. Ctrl + Space

Q10. In A3 cell edit = A1 + A2 refers to

A. Addition of A1 and A3 will display in A2

B. Addition of A1 and A2 will display in A3

C. Addition of A1 and A2 will not display in A3

D. Addition of A2 and A3 will display in A1