In Excel, which chart type is used to show the relationship between two variables? MCQ with Answer and Explanation

In Excel, which chart type is used to show the relationship between two variables?
A. Pie Chart
B. Bar Chart
C. Line Chart
D. Scatter Chart
Answer: Option D
Solution (By JKSSB Mock Tests)
Scatter (or XY) charts show the relationship or correlation between two numeric variables. Line charts show trends, bar compare categories, pie proportions.

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1
In Excel, what is the result of the formula =LEFT(Microsoft,3)?
A. Soft
B. Micro
C. Microsoft
D. Mic

Correct Answer: Option D


Explanation:
LEFT extracts a specified number of characters from the left side of a text string. LEFT(Microsoft,3) returns Mic.

This question belongs to: Computer Microsoft Office
Question #2
In MS Word, 'Shrink One Page' command attempts to:
A. Delete the last page
B. Zoom out
C. Reduce the document by one page by adjusting font size and spacing
D. Print the document on one page

Correct Answer: Option C


Explanation:
Shrink One Page (Print Preview) reduces content to fit one less page.

This question belongs to: Computer Microsoft Office
Question #3
What is the maximum number of characters that can be stored in a 'Text' field in MS Access (Short Text)?
A. 256
B. 1 GB
C. 255
D. 64,000

Correct Answer: Option C


Explanation:
Short Text field in Access can store up to 255 characters. Long Text can store up to 65,535 characters.

This question belongs to: Computer Microsoft Office