BUS 2140 Intro to Spreadsheets Final Exam Review Q & A 2026 (Complete And Verified Study material) (22pages) LEARNEXAMS

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