In Excel, the chart type 'Combo' allows: MCQ with Answer and Explanation

Question

Share Report Error

In Excel, the chart type 'Combo' allows:

A. Creating a chart from multiple sheets

B. Grouping multiple charts together

C. Combining two different chart types in one chart (e.g., column and line)

D. Adding a secondary axis

Answer: Option C

Solution (By JKSSB Mock Tests)

Combo charts mix different chart types for different data series.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

In MS Word, the 'Format Painter' tool is found on which tab?

A. Design

B. Layout

C. Insert

D. Home

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Format Painter is located in the Clipboard group on the Home tab. It copies formatting from one selection and applies it to another.

This question belongs to: Computer Microsoft Office

Question #2

What does Ctrl + Shift + End do in MS Word?

A. Moves cursor to the end of the document

B. Deletes to the end of the line

C. Selects the last page

D. Selects from the cursor position to the end of the document

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Ctrl+Shift+End selects from the insertion point to the end of the document.

This question belongs to: Computer Microsoft Office

Question #3

In Excel, which function is used to calculate the average of a set of numbers but ignores zero values?

A. MEDIAN

B. AVERAGE

C. AVERAGEA

D. AVERAGEIF

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
AVERAGEIF can exclude zero by using criteria 0. AVERAGE includes zeros, AVERAGEA includes logicals, MEDIAN is middle value.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs