MS. Frazer's Technology Excel 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 Sfrazer3
S
Sfrazer3
Community Contributor
Quizzes Created: 1 | Total Attempts: 747
Questions: 6 | Attempts: 747

SettingsSettingsSettings
MS. Frazers Technology Excel Quiz - Quiz

This is a quiz covering the basics of using Microsoft Excel.


Questions and Answers
  • 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 D
    Explanation
    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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 21, 2008
    Quiz Created by
    Sfrazer3
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.