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

Which of the following functions in Excel is used to concatenate two or more text strings into a single string?

Options :

A : RIGHT

B : LEFT

C : MID

D : CONCATENATE

Answer: D

Question 3

Which chart type is most suitable for showing the relationships among different sets of values in a single chart?

Options :

A : Scatter chart

B : Line chart

C : Stacked bar chart

D : Radar chart

Answer: D

Question 4

Which chart type is best for comparing multiple data series?

Options :

A : Bar Chart

B : Scatter Chart

C : Pie Chart

D : Line Chart

Answer: A

Question 5

What is the purpose of the CountA function in Excel?

Options :

A : To count the number of cells in a range that contain blank values.

B : To count the number of cells in a range that contain error values.

C : To count the number of cells in a range that are not empty.

D : To count the number of cells in a range that contain numerical values.

Answer: C

Higher Test Marks with Free Online MO-211 Exam Practice