Sub Topic: Excel

• A. Column
• B. Value
• C. Cell
• D. Address

Correct Answer:

## 2 .  What type of chart is useful for comparing values over categories ?

• A. Pie Chart
• B. Line Chart
• C. Column Chart
• D. Dot Graph

Correct Answer:

• A. NUM
• B. COUNT
• C. CHKNUM
• D. SUM

Correct Answer:

• A. Sorting
• B. Pivot
• C. Formula
• D. Filtering

Correct Answer:

## 5 .  Statistical calculations and preparation of tables and graphs can be done using

• A. Adobe Photoshop
• B. Excel
• C. Power Point
• D. Notepad

Correct Answer:

## 6 .  What type of chart will you use to compare performance of two employees in the year 2016 ?

• A. Column Chart
• B. Line Chart
• C. Pie Chart
• D. Dot Chart

Correct Answer:

• A. SUM
• B. AVG
• C. MAX
• D. MIN

Correct Answer:

## 8 .  Functions in MS Excel must begin with ___

• A. An () sign
• B. An Equal Sign
• C. A Plus Sign
• D. A > Sign

Correct Answer:

• A. SUM
• B. COUNT
• C. IF
• D. AVERAGE

Correct Answer:

## 10 .  In Excel, Columns are labelled as ___

• A. A, B, C, etc
• B. 1,2,3 etc
• C. A1, A2, etc.
• D. \$A\$1, \$A\$2, etc.

Correct Answer:

Topics