Excel Shortcuts | MCQs

Explanation

F11 Creates a chart of the data in the current range in a separate Chart sheet.

Some important shortcuts used in MS Excel

•F1 Opens Excel Help

•F2 Edit contents of an excel

•F3 Paste Named Range or Named List

•F4 Toggles between cell references - Absolute, Relative, and Mixed Reference

•F5 Displays the "Go To" dialog box

•F6 Switch between the panes of an Excel workbook if you have a split window

•F7 Opens the "Spelling" option in Excel using which you can check the spellings in your workbook

•F8 Enables and disables the "Extend Mode" selection in Excel.

•F9 Recalculates the output of all formulas in your Excel workbook.

• F10 Displays the keyboard shortcut for the Excel ribbon also known as Excel tips

• F12 Opens the "Save As" dialog box like the "Alt + F2" keys

Explanation

The Enter key was originally the "Return key" on a typewriter,

which caused the carriage to return to the beginning of the next line on the paper.

Explanation

Go to command in Ms Excel is located in find

On the Home ribbon under “Find and Select” choose “Go To”

Explanation

The F11 key is a function key found at the top of almost all computer keyboards.

The key is used to Enter and exit fullscreen mode in all modern Internet browsers.

As mentioned below, F11 also has other uses depending on the computer and program.

Explanation

An “F2” shortcut key can put the cell into editing mode.

Explanation

 press Ctrl ( Control key ) + A together if we want to select all the cells in the document .

This feature is different in MS Word where we need to press Ctrl + A in order to select the entire document .

Explanation

• In Microsoft Excel, press CTRL + apostrophe (“) to copy the above cells contents into the current cell.
• 
  
• 
  
  

Explanation

Excel allowed you to create a chart by selecting the data and pressing the F11 key

Alt+F1. The chart is added to the worksheet and is listed in the Selection pane.

**

ND16-1-2023