Microsoft Excel Quiz: Test Your GK!
Microsoft Excel has the fundamental features of all spreadsheets. The grid of cells is in numbered rows, and the columns are letter named. It also displays data as line graphs, histograms, and charts, with a three- dimensional graphical display. If you want to learn more about Microsoft Excel, this is the quiz for you.
- 1.What is the shortcut key to open a cell format window?
- A.
Ctrl+1
- B.
Ctrl+F
- C.
Ctrl+4
- D.
Ctrl+Shift+Enter
- 2.Ctrl+B key makes the shortcut for making font in selected cell bold.
- A.
True
- B.
False
- 3.
![Is icon on standard toolbar for the following purpose. - ProProfs]( "Is icon on standard toolbar for the following purpose.")
Is icon on standard toolbar for the following purpose.- A.
Copy
- B.
Paste
- C.
Painter
- D.
Format Painter
- 4.
![Is icon on standard toolbar for the following purpose. - ProProfs]( "Is icon on standard toolbar for the following purpose.")
Is icon on standard toolbar for the following purpose.- A.
Chart
- B.
Formatting
- C.
Conditional Formatting
- 5.Freeze Panes is an option available in which of the following menu.
- A.
Tools
- B.
Data
- C.
Windows
- D.
Help
- 6.
![Following is a shortcut to select font option from the Formatting toolbar. - ProProfs]( "Following is a shortcut to select font option from the Formatting toolbar.")
Following is a shortcut to select font option from the Formatting toolbar.- A.
Ctrl+Shift+P
- B.
Ctrl+K
- C.
Ctrl+Shift+C
- D.
Ctrl+Shift+F
- 7.Can I change the color of the worksheet tabs in my workbook? If yes, what is the shortcut key?
- A.
No
- B.
Yes, Alt+O+H+T
- C.
Yes, Ctrl+O+H+T
- D.
Yes, Shift+O+H+T
- E.
Yes, Shift+O+H+M
- 8.
![This button represents: - ProProfs]( "This button represents:")
This button represents:- A.
The AutoCorrect button
- B.
The AutoFormat button
- C.
The AutoSum button
- D.
The conditional format button
- E.
None of the above
- 9.
![What will be the result from this vlookup() function?
- ProProfs]( "What will be the result from this vlookup() function?")
What will be the result from this vlookup() function?- A.
Company
- B.
Rebate
- C.
Bookshelf Library
- D.
0.01
- E.
NA
Questions: 20 | Attempts: 100541 | Last updated: Jul 27, 2021
-
Sample QuestionA fast way to add up this column of numbers is to click on the cell below the numbers and then:
Questions: 10 | Attempts: 61338 | Last updated: May 30, 2021
-
Sample QuestionLabels are aligned at the ________ edge of the cell.
Questions: 10 | Attempts: 59571 | Last updated: Nov 19, 2020
-
Sample QuestionAn Excel Workbook is a collection of …….
Back to top