Function
What function do you use to get the Sum of an average?
=SUM(range)
What type of chart would you use to average student grades?
Pivot Table
Stacked bar chart
Column chart
Histogram
Excel can be used to keep track of individual spending.
True or False
True
What function is used to calculate the average?
Average- =AVERAGE(number1, number2, …)
What type of chart would you use to complete inventory?
Inventory Control Chart
Bar Chart
Line Chart
Excel is a detailed program software that will assist in keeping companies accountable for their financial portfolio. True or False
True
What function is used to count the number of cells to meet a criteria?
COUNTIF =COUNTIF(B5:B17, ”<60”).
What type of chart would you use to forecast financial data?
Line Chart
Column Chart
Anybody can do excel. True or False
True
What function finds the highest number in a range>
Max MAX(number1, [number2], ...)
What type of chart would you use for personal budgeting use?
Line Chart
Pie Chart
Pivot Chart
Bar Chart
The purpose of excel is for pictures and graphs. True or False
False
What function returns a column number to a given cell of reference?
Column COLUMN(D10)
What is the purpose of using excel?
To assist in organizing data and provide financial picture or outlook on business to assist in meeting needs.
Why do individuals use excel?
To help them stay organized.