Microsoft Excel Quiz: Test Your GK!

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Kritika Joshi
K
Kritika Joshi
Community Contributor
Quizzes Created: 2 | Total Attempts: 88,309
| Attempts: 2,598
SettingsSettings
Please wait...
  • 1/9 Questions

    Ctrl+B key makes the shortcut for making font in selected cell bold.

    • True
    • False
Please wait...
About This 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.

Microsoft Excel Quiz: Test Your GK! - Quiz

Quiz Preview

  • 2. 
     Is icon on standard toolbar for the following purpose. - ProProfs

     Is icon on standard toolbar for the following purpose.

    • Chart

    • Formatting

    • 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:

  • 3. 
    This button represents: - ProProfs

    This button represents:

    • The AutoCorrect button

    • The AutoFormat button

    • The AutoSum button

    • The conditional format button

    • None of the above

    Correct Answer
    A. 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:

  • 4. 
     Is icon on standard toolbar for the following purpose. - ProProfs

     Is icon on standard toolbar for the following purpose.

    • Copy

    • Paste

    • Painter

    • Format Painter

    Correct Answer
    A. 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:

  • 5. 
    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.

    • Ctrl+Shift+P

    • Ctrl+K

    • Ctrl+Shift+C

    • Ctrl+Shift+F

    Correct Answer
    A. 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:

  • 6. 
    What will be the result from this vlookup() function? - ProProfs

    What will be the result from this vlookup() function?

    • Company

    • Rebate

    • Bookshelf Library

    • 0.01

    • NA

    Correct Answer
    A. 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:

  • 7. 

    Freeze Panes is an option available in which of the following menu.

    • Tools

    • Data

    • Windows

    • Help

    Correct Answer
    A. 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:

  • 8. 

    What is the shortcut key to open a cell format window?

    • Ctrl+1

    • Ctrl+F

    • Ctrl+4

    • 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:

  • 9. 

    Can I change the color of the worksheet tabs in my workbook? If yes, what is the shortcut key?

    • No

    • Yes, Alt+O+H+T

    • Yes, Ctrl+O+H+T

    • Yes, Shift+O+H+T

    • Yes, Shift+O+H+M

    Correct Answer
    A. 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:

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • May 09, 2010
    Quiz Created by
    Kritika Joshi
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.