Microsoft Excel Vocabulary And Functions! Trivia Quiz

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 Dbone
D
Dbone
Community Contributor
Quizzes Created: 1 | Total Attempts: 800
Questions: 10 | Attempts: 800

SettingsSettingsSettings
Excel Quizzes & Trivia

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!


Questions and Answers
  • 1. 

    A cell formula that stays the same when copied

    • A.

      Absolute reference

    • B.

      Relative reference

    • C.

      Active cell

    • D.

      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:

  • 2. 

    Saved workbook or worksheet

    • A.

      Document

    • B.

      File

    • C.

      Grid

    • D.

      Graph

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

  • 3. 

    The vertical divisions of a spreadsheet

    • A.

      Cell

    • B.

      Row

    • C.

      Column

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

  • 4. 

    A tab that identifies a worksheet

    • A.

      Sheet tab

    • B.

      Sheet

    • C.

      Formula

    • D.

      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. 

    Name of boxes (cells) in a spreadsheet

    • A.

      Graph

    • B.

      Cell address

    • C.

      Address

    • D.

      Worksheet 

    Correct Answer
    B. Cell address
    Explanation
    The term "cell address" refers to the specific location of a cell in a spreadsheet. It is a combination of the column letter and row number that uniquely identifies a cell. This address is used to reference and access the data or formula contained within that cell.

    Rate this question:

  • 6. 

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

    • A.

      The title bar

    • B.

      The scroll bar 

    • C.

      The toolbar

    • D.

      The split box

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

  • 7. 

    What key is used to select multiple ranges of cells?

    • A.

      Shift

    • B.

      CTRL

    • C.

       Alt

    • D.

      AltCar or AltGr

    Correct Answer
    B. 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. 

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

    • A.

      Scenario manager 

    • B.

      Solver

    • C.

       Target value 

    • D.

      None of the above

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

    Rate this question:

  • 9. 

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

    • A.

      =If()

    • B.

      =Sum()

    • C.

      =SumIf()

    • D.

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

  • 10. 

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

    • A.

      =AND()

    • B.

      =OR()

    • C.

      =Vlookup()

    • D.

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

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.