Microsoft Excel Spreadsheet! Short 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 PCDAC
P
PCDAC
Community Contributor
Quizzes Created: 11 | Total Attempts: 7,054
Questions: 5 | Attempts: 151

SettingsSettingsSettings
Microsoft Excel Spreadsheet! Short Trivia Quiz - Quiz

.


Questions and Answers
  • 1. 

    CREATE THE FOLLOWING DATA TABLE WITH THE CORRECT OPERATOR FUNCTIONS IN COLUMN F FOR EACH ROW WITH NUMBERS. MAKE SURE YOU USE THE MERGE CELL FUNCTION TO CREATE THE TABLE NAME:   You Should Consider Using Columns C, D, E, F AND Rows 1 and 2 To Create The Table Name ALSO CREATE AN EXPLODED PIE IN 3-D CHART USING THE DATA FROM THE TABLE ABOVE

  • 2. 

    WHAT IS A CHART?

    • A.

      Also known as a graph, it is a visual way to display and compare data

    • B.

      a way of arranging data in a particular order

    • C.

      A calculation that describes the relationship between cells

    Correct Answer
    A. Also known as a grapH, it is a visual way to display and compare data
    Explanation
    A chart, also known as a graph, is a visual representation that allows for the display and comparison of data. It provides a visual way to present information in a clear and organized manner, making it easier to interpret and understand patterns, trends, and relationships within the data. Charts are commonly used in various fields such as business, finance, and statistics to present data in a visually appealing and informative way.

    Rate this question:

  • 3. 

    WHAT IS A WORKSHEET?

    • A.

      A symbol that represents a specific action

    • B.

      A table of data that is organized into rows and columns

    • C.

      Refers to the change a formula makes when it is moved or copied to other cells with different data

    Correct Answer
    B. A table of data that is organized into rows and columns
    Explanation
    A worksheet is a table of data that is organized into rows and columns. It is commonly used in spreadsheet software to input, calculate, and analyze data. Worksheets allow users to arrange and manipulate data in a structured format, making it easier to understand and work with large amounts of information. They provide a visual representation of data, with each cell in the table containing a specific value or formula. Users can perform various operations on the data, such as sorting, filtering, and performing calculations, to derive meaningful insights and make informed decisions.

    Rate this question:

  • 4. 

    IF YOU WANT TO CHANGE WHAT DISPLAYS IN YOUR CHART YOU MUST

    • A.

      Type the word 'change'

    • B.

      Switch from row data to column data and vice versa

    • C.

      Click on the redo button

    Correct Answer
    B. Switch from row data to column data and vice versa
    Explanation
    To change what displays in your chart, you need to switch between row data and column data. This means that you can toggle between displaying the data in rows or columns in order to change the chart's appearance and representation. By doing so, you can manipulate the chart to show different perspectives and insights based on the data organization.

    Rate this question:

  • 5. 

    YOU CAN CHANGE THE POSITION OF A CHART BY

    • A.

      Moving it to the other side of the page

    • B.

      Flipping it around

    • C.

      Clicking on an unused area of the chart and dragging

    Correct Answer
    C. Clicking on an unused area of the chart and dragging
    Explanation
    To change the position of a chart, you can click on an unused area of the chart and drag it to a different location on the page. This action allows you to move the chart to a desired position.

    Rate this question:

Quiz Review Timeline +

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
  • Oct 24, 2011
    Quiz Created by
    PCDAC
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.