MS. Frazer's Technology Excel Quiz
This is a quiz covering the basics of using Microsoft Excel.
- 1.
Why is Excel a useful program?
- A.
Who knows? Ms. Frazer just told me to use it. I don't ask questions!
- B.
It helps keep data organized.
- C.
It can perform calculations.
- D.
It can easily create graphs and charts from data.
- E.
B, C and D
Correct Answer
E. B, C and DExplanation
Excel is a useful program because it helps keep data organized, performs calculations, and can easily create graphs and charts from data. This makes it a valuable tool for tasks such as data analysis, budgeting, and creating visual representations of information.Rate this question:
-
- 2.
True or False: Excel can calculate averages and sums.
- A.
True.
- B.
False.
Correct Answer
A. True.Explanation
Excel is a powerful spreadsheet program that can perform various calculations, including averages and sums. It has built-in functions such as AVERAGE and SUM that allow users to easily calculate the average or sum of a range of numbers. These functions save time and effort, making Excel a popular tool for data analysis and financial calculations. Therefore, the statement "Excel can calculate averages and sums" is true.Rate this question:
-
- 3.
How many different types of charts can you make in Excel?
- A.
One - Column Chart.
- B.
Two - Column Chart and Bar Graph.
- C.
Three - Column Chart, Bar Graph, Pie Chart.
- D.
Many!!
Correct Answer
D. Many!!Explanation
The correct answer is "Many!!" because Excel offers a wide range of chart types that users can create, including column charts, bar graphs, pie charts, line graphs, scatter plots, area charts, and more. The software provides various options for visualizing data, allowing users to choose the most suitable chart type based on their data and presentation needs. Therefore, the statement "Many!!" accurately reflects the versatility and flexibility of Excel in creating different types of charts.Rate this question:
-
- 4.
If you want to add a number of cells together, what is the formula you use?
- A.
=total(cells)
- B.
=sum(cells)
- C.
=add(cells)
- D.
=halloween(cells)
Correct Answer
B. =sum(cells)Explanation
The correct formula to add a number of cells together is =sum(cells). This formula calculates the sum of the values in the specified range of cells.Rate this question:
-
- 5.
How do you change the title of a chart?
- A.
What?! That can't be done!!
- B.
Concentrate really hard, and it will show up.
- C.
In the chart-making wizard.
Correct Answer
C. In the chart-making wizard.Explanation
To change the title of a chart, you can do it in the chart-making wizard. This implies that when creating a chart, there is a specific step or option within the chart-making wizard that allows you to modify the title. It suggests that the chart-making wizard provides a user-friendly interface or tool that enables users to customize the chart title according to their preferences or requirements.Rate this question:
-
- 6.
When might you use Excel in the future?
- A.
When organizing data in science.
- B.
When making graphs in math.
- C.
When trying to decide if you're late for carpool.
- D.
A and B.
Correct Answer
D. A and B.Explanation
In the future, you might use Excel when organizing data in science because Excel is a powerful tool that allows you to input and manipulate data easily. It provides various functions and formulas to perform calculations and analysis on the data. Additionally, you might use Excel when making graphs in math as it has built-in graphing capabilities that allow you to create visually appealing and informative graphs. Therefore, the correct answer is A and B.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, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 21, 2008Quiz Created by
Sfrazer3
Back to top