Microsoft Excel Spreadsheet! Short Trivia Quiz
.
- 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 dataExplanation
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 columnsExplanation
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 versaExplanation
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 draggingExplanation
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:
-
.png "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")
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, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 24, 2011Quiz Created by
PCDAC
Back to top