Microsoft Excel Vocabulary And Functions! Trivia Quiz

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 Dbone
D
Dbone
Community Contributor
Quizzes Created: 1 | Total Attempts: 823
| Attempts: 826
SettingsSettings
Please wait...
  • 1/10 Questions

    Name of boxes (cells) in a spreadsheet

    • Graph
    • Cell address
    • Address
    • Worksheet 
Please wait...
About This Quiz

Microsoft Excel is a spreadsheet application produced by Microsoft that allows users to organize and calculate data with formulas. It's used for performing the basic calculation, graphing tools, creating pivot tables and macros. This quiz has been created to test your knowledge and skills about spreadsheet vocabulary, functions and formulas. So, let's try out the quiz. All the best!

Microsoft Excel Vocabulary And Functions! Trivia Quiz - Quiz

Quiz Preview

  • 2. 

    The vertical divisions of a spreadsheet

    • Cell

    • Row

    • Column

    Correct Answer
    A. Column
    Explanation
    The vertical divisions of a spreadsheet are called columns. Columns are used to organize and categorize data in a spreadsheet. Each column is identified by a letter at the top of the column, such as A, B, C, etc. Columns are used to input and manipulate data vertically in a spreadsheet, making it easier to analyze and calculate information.

    Rate this question:

  • 3. 

    What tool is used to split the window into different parts of the same worksheet?

    • The title bar

    • The scroll bar 

    • The toolbar

    • The split box

    Correct Answer
    A. The split box
    Explanation
    There are times when you need to compare values that are far away from each other. That's why it's an advantage to be able to split the screen in two vertically and/or horizontally and place the values close to each other on the screen. The split boxes help you do that easily.

    Rate this question:

  • 4. 

    A tab that identifies a worksheet

    • Sheet tab

    • Sheet

    • Formula

    • Active cell

    Correct Answer
    A. Sheet tab
    Explanation
    The correct answer is "Sheet tab" because a sheet tab is a visual representation of a worksheet in a spreadsheet software. It allows users to easily navigate between different worksheets within a workbook. By clicking on a sheet tab, users can quickly access and view the content of a specific worksheet.

    Rate this question:

  • 5. 

    What function offers you the possibility to view different results depending on the entered condition?

    • =If()

    • =Sum()

    • =SumIf()

    • =TrueFalse()

    Correct Answer
    A. =If()
    Explanation
    The correct answer is =If(). The IF function allows you to view different results based on a condition that is entered. It evaluates whether a condition is true or false and returns a specific value or performs a specific action accordingly. This function is commonly used in Excel to perform logical tests and make decisions based on the results.

    Rate this question:

  • 6. 

    Saved workbook or worksheet

    • Document

    • File

    • Grid

    • Graph

    Correct Answer
    A. File
    Explanation
    The term "file" is used to refer to a saved workbook or worksheet in a computer system. It is a common way to store and organize data in a digital format. The other options, such as document, grid, and graph, do not specifically indicate the saved format of a workbook or worksheet. Therefore, "file" is the most appropriate and correct answer in this context.

    Rate this question:

  • 7. 

    What key is used to select multiple ranges of cells?

    • Shift

    • CTRL

    •  Alt

    • AltCar or AltGr

    Correct Answer
    A. CTRL
    Explanation
    This key does allow you to select multiple ranges of cells so that youu can apply some options to them or use them for a chart.

    Rate this question:

  • 8. 

    A cell formula that stays the same when copied

    • Absolute reference

    • Relative reference

    • Active cell

    • Formula

    Correct Answer
    A. Absolute reference
    Explanation
    An absolute reference in a cell formula is a reference that does not change when the formula is copied to other cells. It always refers to the same cell or range of cells, regardless of where it is copied. This is useful when you want to keep a specific cell or range constant in a formula, such as when calculating a percentage based on a fixed value.

    Rate this question:

  • 9. 

    What tool helps you to optimize the results of a model?

    • Scenario manager 

    • Solver

    •  Target value 

    • None of the above

    Correct Answer
    A. Solver
    Explanation
    Solver is there to help you optimize your model to achieve it's greatest possible value.

    Rate this question:

  • 10. 

    What function is used to make sure that all conditions are true before showing a TRUE answer?

    • =AND()

    • =OR()

    • =Vlookup()

    • =If()

    Correct Answer
    A. =AND()
    Explanation
    This function is used when you want to make sure that many conditions are fulfilled before showing a #TRUE# result.

    Rate this question:

Quiz Review Timeline (Updated): Aug 20, 2024 +

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

  • Current Version
  • Aug 20, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 10, 2008
    Quiz Created by
    Dbone
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.