To insert chart in MS Excel, which shortcut key used?

  • A. A) Alt+F1
  • B. B) F2
  • C. C) F3
  • D. D) F4
Correct Answer: A. A) Alt+F1
Alt+F1: This combination quickly creates a basic chart, typically a clustered column chart, based on the data you've currently selected. It's a convenient way to visualize your data without needing to navigate through menus.

While the other options have their uses in Excel, they aren't specifically designed for chart insertion:

B. F2: This key is used to edit the content of the active cell.

C. F3: This key can be used for various purposes depending on the context, such as pasting a named range or finding a specific cell reference.

D. F4: This key can be used to repeat the last action you performed, but it's not directly related to chart insertion.

So, if you want to quickly create a chart from your selected data in Excel, remember the handy shortcut Alt+F1!

If you think there is any confusion in the given MCQs, you can comment below.

Follow us on WhatsApp

docmcqs.com is Pakistan's No.1 online platform for preparing for all types of exams including PPSC, FPSC, KPSC, SPSC, Ministry of Defence, and for one-paper MCQs. This includes Pedagogy MCQs, general knowledge MCQs, current affairs MCQs, and much more.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top