In Excel, which chart type is used to show the proportion of parts to a whole? MCQ with Answer and Explanation

In Excel, which chart type is used to show the proportion of parts to a whole?

A. Bar Chart

B. Pie Chart

C. Line Chart

D. Area Chart

Answer: Option B

Solution (By JKExamLibrary)

Pie charts are used to display parts of a whole as percentages. Bar and column compare categories, line shows trends, area similar to line with filled area.

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error

Which field property in MS Access ensures that a user cannot leave a specific field blank when entering a new database record?

A. Validation Rule

B. Indexed

C. Input Mask

D. Required

View Answer & Solution Discuss

Correct Answer: Option D

Explanation:
Setting the 'Required' property to 'Yes' forces the user to enter data into that specific field before saving the record.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

Which file format is used for a macro-enabled Word document?

A. .dotm

B. .docx

C. .docm

D. .doc

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
.docm is macro-enabled document. .docx without macros, .dotm macro-enabled template.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In Access, what is the purpose of the 'Validation Rule' property?

A. To set a default value

B. To format the field display

C. To restrict the values that can be entered in a field

D. To define a relationship

View Answer & Solution Discuss

Correct Answer: Option C

Explanation:
Validation Rule limits the data that can be entered, e.g., >0. Default Value sets initial value, Format controls display, Relationship links tables.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs