What type of chart in MS Excel displays data points connected by line intervals to illustrate long-term trends over continuous intervals? MCQ with Answer and Explanation

Question
What type of chart in MS Excel displays data points connected by line intervals to illustrate long-term trends over continuous intervals?
A. Radar Chart
B. Line Chart
C. Bar Chart
D. Pie Chart
Answer: Option B
Solution (By JKSSB Mock Tests)
Line charts map out changes over time, tracking continuous shifts in numerical values across defined chronological periods.
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
What is the function of the keyboard shortcut Ctrl + Shift + L when working with an active data grid range in MS Excel?
A. Aligns cell contents to the left edge
B. Toggles AutoFilter drop-down arrows on or off
C. Inserts a bulleted list inside a cell text string
D. Locks the selected cell ranges
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + Shift + L is the native keyboard shortcut to instantly apply or remove the dynamic AutoFilter toggle sorting keys on the active data range headers.
This question belongs to: Computer Microsoft Office
Question #2
In Excel, which function is used to calculate the sum of a range with criteria?
A. SUMIFS
B. SUMPRODUCT
C. SUMIF
D. All of the above
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
SUMIF, SUMIFS, and SUMPRODUCT can all perform conditional sums (SUMPRODUCT can do multiple criteria). So all are valid.
This question belongs to: Computer Microsoft Office
Question #3
In Access, which query type is used to display data from multiple tables based on a common field?
A. Select Query
B. Action Query
C. Crosstab Query
D. Parameter Query
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Select queries can join multiple tables to display data. Action queries modify data, Parameter queries prompt for criteria, Crosstab summarizes data.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Memory and Storage Devices 438 Computer Networking 325 Computer Abbreviations 369 Database Management System (DBMS) 278 CPU (Central Processing Unit) 327
Explore Subjects
Maths 5575 Geography GK 6121 Economy GK 2220 History GK 3374 Accountancy and Statistics 3179
Practice Mix
The 'Deccani' style of painting developed in:
He ___ be very upset; he's not talking to anyone.
Which cloud type appears as thin, feathery streaks?
Two numbers are in the ratio 4:8 and their sum is 512. Find the numbers.
By the time you return, I ________ the house.