Cell | 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

***

Which is the shortcut key to display active cells in Excell?

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

ND11-3-2023

Explanation

A cell reference or cell address is a combination of a column letter and a row number that identifies a cell on a worksheet. 

For example, C1 refers to the cell at the intersection of column C and row 4; D5 refers to the second cell in column D, and so on.

It is basically a cell's column number and row number.

Explanation

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

Explanation

MS-Excel comments are used to add a note or explain an action in a cell.

Explanation

When there is no data in in the adjacent cells, long text flows into adjacent cells on a worksheet.

Explanation

If we need to remove only the formatting done in a range, we must use From Edit menu choose Clear and then Formats.

Explanation

On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button.

--OR--

Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.

Explanation

A cell can be edited through Press the F2 key or Click the formula bar or Double click the cell.

Explanation

Doctor’s symbol (Big Plus) indicates we that we can make selection to cell.

Explanation

Mouse Pointer with anchor at the tip cell pointer indicate that you can move the content to other cell.