How Much Do You Know About Excel?
12 Questions
| Total Attempts: 546
(312).jpg "How Much Do You Know About Excel?")
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?
Microsoft Excel has given a lot of people sleepless nights trying to figure it out, and some give up on it ultimately. Do you want to test your basic knowledge on an excel sheet? Play this excel practice quiz and prove yourself....
Questions: 10 | Attempts: 62207 | Last updated: May 30, 2021
-
Sample QuestionLabels are aligned at the ________ edge of the cell.
Microsoft excel quiz: test on functions! Microsoft Excel is considered to be one of the most diverse Microsoft office tools as it not only allows calculations but can also allow processing of different sets of data. Are you...
Questions: 10 | Attempts: 59827 | Last updated: Nov 19, 2020
-
Sample QuestionAn Excel Workbook is a collection of …….
Do you want to become familiar with Microsoft Excel? Do you think you can pass this quiz? Microsoft Excel helps to organize information in an easy to navigate way. It does complicated math problems so that you don’t have...
Questions: 10 | Attempts: 44527 | Last updated: Feb 12, 2021
-
Sample QuestionWhich language is used to create macros in Excel?
Back to top