How Much Do You Know About Excel?

12 Questions | By Felicyaa | Updated: Mar 17, 2022 | Attempts: 775

Questions

Settings

Create your own Quiz

How Much Do You Know About Excel? - Quiz

Excel Tips

Questions and Answers

1.

What series of keys do you use to see all of your forumlas in a worksheet at once?
- A.
  
  Ctrl+ a
- B.
  
  Shift+F3
- C.
  
  Alt+F8
- D.
  
  Ctrl+~
2.

What key Stroke(s) create an excel chart from selected data?
- A.
  
  F10
- B.
  
  F11
- C.
  
  Shift+F10
- D.
  
  Alt+C
3.

If you have a file with filtered data and just want to copy selected visible fields, what would you do before pasting?
- A.
  
  Ctrl+G, Special and Select Visible cells only
- B.
  
  F5, Special and Select Visible cells only
- C.
  
  A or B
- D.
  
  None of the above
4.

What is the shortcut to add current date in a cell?
- A.
  
  Ctrl +
- B.
  
  Ctrl + D
- C.
  
  Ctrl + :
- D.
  
  Ctrl + ;
5.

What function key will convert cell reference to absolute, if you are in the formula bar with the cell reference selected?
- A.
  
  F11
- B.
  
  F5
- C.
  
  F7
- D.
  
  F4
6.

What Function key will repeat the last step you did on the current area?
7.

If you have cells selected, it is possible to see the sum of the cells in the status bar.
- A.
  
  True
- B.
  
  False
8.

How do you copy the cell above without using copy paste or drag and drop?
- A.
  
  Ctrl + C + P
- B.
  
  Ctrl + '
- C.
  
  Alt + P
- D.
  
  None of the above
9.

How do you select the column of the cell you are in ?
- A.
  
  Alt + C
- B.
  
  Alt + R
- C.
  
  Ctrl + Spacebar
- D.
  
  Shift + S
10.

What 2 Keys do you to get a a second line in a cell?
11.

Ctrl + 0 Hides the selected column.
- A.
  
  True
- B.
  
  False
12.

What Feature in excel allows you to seperate data in one cell into multiple cells?