1. What function would you use to calculate the total revenue over a
quarter if each month's revenue is listed in a separate cell?
A) SUM
B) AVERAGE
C) COUNT
D) MAX
Answer: A) SUM
Rationale: The SUM function adds all the numbers in a range of cells,
providing the total amount, which is necessary for calculating total
revenue.
2. To find the highest expense recorded in a range of cells, which function
is most appropriate?
A) SUM
B) AVERAGE
C) COUNT
D) MAX
Answer: D) MAX
Rationale: The MAX function identifies the largest number in a set of
values, which is useful for pinpointing the highest expense.
3. If you want to determine how many times a particular value appears
within a dataset, which function will you use?
A) SUM
B) AVERAGE
C) COUNTIF
D) MIN
Answer: C) COUNTIF
Rationale: COUNTIF counts the number of cells that meet a specified
criterion, such as the occurrence of a specific value.
4. When creating a pie chart in a spreadsheet, what does each 'slice'
represent?
A) A range of cells
B) A numerical value or category from a dataset
C) The sum of all values in the chart
D) A formula
Answer: B) A numerical value or category from a dataset
Category | exam bundles |
Comments | 0 |
Rating | |
Sales | 0 |