Microsoft Excel Quiz: Test Your GK!

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Kritika Joshi

Kritika Joshi

Community Contributor

Quizzes Created: 2 | Total Attempts: 84,482

Questions: 9 | Attempts: 2,592 | Updated: Mar 21, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

Microsoft Excel Quiz: Test Your GK! - Quiz

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.

Questions and Answers

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
Correct Answer
A. Ctrl+1

Explanation
The shortcut key Ctrl+1 is used to open a cell format window in Microsoft Excel. This shortcut allows users to quickly access the Format Cells dialog box, where they can modify the formatting of selected cells. By pressing Ctrl+1, users can easily change the number format, font, alignment, border, fill, and other formatting options for the selected cells. This shortcut helps to save time and streamline the formatting process in Excel.

Rate this question:

1
0
2.

Ctrl+B key makes the shortcut for making font in selected cell bold.
- A.
  
  True
- B.
  
  False
Correct Answer
A. True

Explanation
Pressing the Ctrl+B key combination is a shortcut for making the font in the selected cell bold. This means that when you have a cell selected in a spreadsheet or a text document, pressing Ctrl+B will apply the bold formatting to the text in that cell.

Rate this question:

1
0
3.

Is icon on standard toolbar for the following purpose.
- A.
  
  Copy
- B.
  
  Paste
- C.
  
  Painter
- D.
  
  Format Painter
Correct Answer
D. Format Painter

Explanation
The correct answer is Format Painter. The Format Painter icon on the standard toolbar is used to copy the formatting of a selected object or text and apply it to another object or text. It allows for quick and consistent formatting across different parts of a document or presentation.

Rate this question:
4.

Is icon on standard toolbar for the following purpose.
- A.
  
  Chart
- B.
  
  Formatting
- C.
  
  Conditional Formatting
Correct Answer
A. Chart

Explanation
The correct answer is "Chart." The icon on the standard toolbar is used for creating and inserting charts into a document or spreadsheet. This allows users to visually represent data in the form of graphs or charts, making it easier to analyze and understand the information presented. It provides a visual representation of data trends, patterns, and comparisons, making it an essential tool for data analysis and presentation.

Rate this question:
5.

Freeze Panes is an option available in which of the following menu.
- A.
  
  Tools
- B.
  
  Data
- C.
  
  Windows
- D.
  
  Help
Correct Answer
C. Windows

Explanation
The Freeze Panes option is available in the Windows menu. This option allows users to freeze specific rows or columns in a spreadsheet so that they remain visible while scrolling through the rest of the data. By selecting the Freeze Panes option, users can improve the visibility and organization of their data by keeping important information in view at all times.

Rate this question:
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
Correct Answer
D. Ctrl+Shift+F

Explanation
The correct answer is Ctrl+Shift+F. This keyboard shortcut is a shortcut to select the font option from the Formatting toolbar. By pressing Ctrl+Shift+F, users can quickly access and modify the font settings of their text without having to navigate through the toolbar manually.

Rate this question:
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
Correct Answer
B. Yes, Alt+O+H+T

Explanation
Yes, the color of the worksheet tabs in a workbook can be changed. The shortcut key to change the color of the worksheet tabs is Alt+O+H+T.

Rate this question:
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
Correct Answer
C. The AutoSum button

Explanation
The given correct answer is the AutoSum button. The AutoSum button is used to quickly calculate the sum of a range of numbers in a spreadsheet or a table. It automatically selects the range of numbers that are adjacent to it and inserts the SUM function to calculate the total. This button is commonly used in spreadsheet applications like Microsoft Excel to simplify the process of summing up data.

Rate this question:

1
0
9.

What will be the result from this vlookup() function?
- A.
  
  Company
- B.
  
  Rebate
- C.
  
  Bookshelf Library
- D.
  
  0.01
- E.
  
  NA
Correct Answer
E. NA

Explanation
The result from this vlookup() function will be "NA". This is because the function is searching for the value "Bookshelf Library" in the "Company" column and returning the corresponding value from the "Rebate" column. Since "Bookshelf Library" is found in the "Company" column, the function will return the value "NA" from the "Rebate" column.

Rate this question:

1
0