Question 1

What chart type would you use to compare values across categories?

Options :

A : Area chart

B : Column chart

C : Histogram

D : Scatter chart

Answer: B

Question 2

What is the benefit of using tables in Excel?

Options :

A : They allow you to add animations and transitions to data.

B : They allow you to sort, filter, and analyze data easily.

C : They allow you to convert data into charts easily.

D : They allow you to create complex formulas and macros.

Answer: B

Question 3

Which of the following formatting options is not available in the Format Cells dialog box in Excel?

Options :

A : Border

B : Alignment

C : Fill

D : Font

Answer: C

Question 4

Which Excel function can be used to remove spaces from the beginning and end of a text string?

Options :

A : LEFT

B : RIGHT

C : CLEAN

D : TRIM

Answer: D

Question 5

What chart type would you use to show how individual parts contribute to the whole?

Options :

A : Line chart

B : Radar chart

C : Bubble chart

D : Pie chart

Answer: D