In MS Excel, what is the default keyboard shortcut used to insert a brand-new, empty chart sheet based on the currently highlighted data cells? MCQ with Answer and Explanation
In MS Excel, what is the default keyboard shortcut used to insert a brand-new, empty chart sheet based on the currently highlighted data cells?
A. F4
B. F11
C. F2
D. Alt + F1
Answer: Option B
Solution (By JKSSB Mock Tests)
Pressing F11 creates a new, dedicated Chart Sheet containing a chart generated from the selected cell range. Alt + F1 inserts the chart on the current worksheet.
Explanation:
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.
No comments yet. Be the first to start the discussion!