Excel Shortcut | MCQs

Explanation

Ms. Excel is a Spreadsheet program

MS Excel is based on WINDOWS

shortcut key in  MS Excell:

which key is used for help in MS excel?

 F1

The Right answer is Ctrl + ;

***

Shift+Backspace

**

Which key is used to enter the current date in Excel?

 Ctrl+;

Which key is used for the GO TO tab in Ms. Excel?

 F5 

Which key is used for excel column highlight?

CTRL + space

What is the keyboard shortcut to insert a SUM formula in MS Excel?

 ALT + =

***

The delete key of the keyboard is assigned to which command in excel?

 Edit > Clear > Contents

****

The shortcut key to insert a new worksheet in Excel is _____.

 Shift + F11

****

in excel which key is used to format numbers in comma format?

 shift+1

*****

In Excel which shortcut key is used to go to the formula tab?

 Alt+M

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 keyboard shortcut to minimize an Excel worksheet is Ctrl+F9.

This shortcut also restores all workbook windows that are maximized. 

Here are some other Excel keyboard shortcuts:

Ctrl+F10: Maximizes or restores the selected workbook window

Ctrl+F7: Moves workbook windows that are not maximized

Ctrl+F8: Performs the size command for workbook windows that are not maximized

Ctrl+P: Opens the print dialog box

Ctrl+Z: Undoes the last action

Alt+Space: Displays the Control menu for the Main Excel window

Alt+F4: Closes Excel

F6/Shift+F6: Moves to the next or previous pane in a workbook that has been split

Ctrl+Tab/Ctrl+Shift +Tab: Moves to the next or previous workbook window

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