Correct Answer - Option 3 : F11
The correct answer is F11.
- An MS Excel worksheet contains rows 1,048,576 rows and 16,384 columns to store the text and numbers and merged into a single workbook knows as a File.
- Workbooks are the Excel files that one can open and share, while Excel worksheets are individual spreadsheets within them.
Function Key Shortcuts:
-
F11: Generates a bar graph from the values entered
-
F2: Edit Cells
-
F4: Anchor Cells
-
F7: Spell Check
-
F12: Save As
-
SHIFT + F2: Insert a Comment
-
SHIFT + F8: Add to Selection
-
SHIFT + F10: Right Click
-
CTRL + F3: Name a Cell
-
Windows Flag + D: Minimize Programs
Hence, we conclude that F11 generates a bar graph from the values entered.