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.- A.
Copy
- B.
Paste
- C.
Painter
- D.
Format Painter
- 4.
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.
- 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:
- 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?
- A.
Company
- B.
Rebate
- C.
Bookshelf Library
- D.
0.01
- E.
NA
Questions: 10 | Attempts: 70895 | Last updated: Mar 22, 2022
-
Sample QuestionLabels are aligned at the ________ edge of the cell.
Questions: 10 | Attempts: 62218 | Last updated: Mar 22, 2022
-
Sample QuestionAn Excel Workbook is a collection of …….
Questions: 10 | Attempts: 45730 | Last updated: Mar 22, 2022
-
Sample QuestionWhich language is used to create macros in Excel?
Back to top