BASIC EXCEL QUESTIONS

How to navigate a specific cell quickly?

• Right click on the column, choose insert new column on the menu

• Use the cell name box next to formula bar

• Click in a cell and start typing

• Use the formula bar

How to go back to the first cell quickly?

• Control + Home

• Control + A

• Control + End

• Control + Shift + Down Arrow

Where is the formula bar located?

• Beside the Quick Access Toolbar

• Under the cell name box

• Above the file tab

• Below the ribbons of Microsoft Excel

How to do data entry inside Microsoft Excel?

• Click in a cell and start typing

• Click on the column, choose data entry

• Start typing on the cell name box

• Control + F

What is the other way to do data entry?

• Use the cell name box

• Control + F

• Use the formula bar

• Control + End

What should you do if you want to insert a new column into your workbook?

• Right click on the column, choose insert new column on the menu

• Left click on the column, choose insert new column on the menu

• Control + A

• Control + F

What keyboard shortcut will help you in selecting the entire sheet and all the data that’s on it?

• Control + Home

• Control + FD

• Control + Shift + Down Arrow

• Control + A

What keyboard shortcut will help you in selecting everything in that column to the last cell where something was typed?

• Control + End

• Control + Shift + Down Arrow

• ALT + N + C

• Control + Home

What keyboard shortcut will take you to the last point where someone typed inside your sheet that you’re on?

• ALT and S

• Control + Shift + Down Arrow

• Control + End

• ALT + A + B

What is the shortcut key for the AutoSum?

• ALT and =

• Control and =

• ALT + H + I + S

• ALT + H + V + S