C268 Spreadsheets Practice Questions - Set 4 - Part 1

Test your knowledge of Spreadsheets concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 1: A spreadsheet contains sales data for different months. Which formula will return the minimum monthly sales?

a) =SUM()

b) =COUNTIF()

c) =MIN()

d) =AVERAGE()

Question 2: Which formula will correctly calculate the monthly interest for a loan if the loan balance is in F10 and the annual interest rate is in C5?

a) =F10*C5

b) =F10+C5/12

c) =F10*C5/12

d) =SUM(F10*C5)

Question 3: A student wants to calculate the average exam score for students who scored above 75. Which formula should they use?

a) =AVERAGE()

b) =SUMIF()

c) =AVERAGEIF()

d) =COUNTIF()

Question 4: A business owner wants to display only the sales data for the "Manufacturing" industry from a large table. Which Excel feature should they use?

a) Data Validation

b) Filter

c) Conditional Formatting

d) Slicer

Question 5: Which Excel function would calculate the payment required for a $10,000 loan over five years with monthly payments of $200?

a) =FV()

b) =NPER()

c) =PMT()

d) =PV()

Question 6: Which Excel function calculates the total number of periods required to pay off a loan if the loan amount is in C10 and monthly payments are in C11?

a) =PMT()

b) =NPER()

c) =FV()

d) =PV()

Question 7: Which formula would calculate the monthly sales tax for each month, based on a 7% tax rate stored in cell B2 and total monthly sales in cells A1 through L1?

a) =SUM(A1:L1)

b) =SUM(A1:L1)*B2

c) =A1+B2

d) =IF(A1>0)

Question 8: A table contains data for employees and their total work hours. Which function will count the number of employees who worked more than 40 hours?

a) =COUNTIF(B1:B10,">40")

b) =SUMIF(B1:B10,">40")

c) =AVERAGEIF(B1:B10,">40")

d) =IF(B1>40)

Question 9: A manager needs to calculate the total sales for products that sold more than 500 units. Which formula will accomplish this?

a) =COUNTIF(B1:B10,">500")

b) =SUMIF(B1:B10,">500")

c) =AVERAGEIF(B1:B10,">500")

d) =IF(B1>500)

Question 10: Which Excel function will return the last 5 digits from a text string in cell A2?

a) =LEFT(A2,5)

b) =MID(A2,5)

c) =RIGHT(A2,5)

d) =TEXT(A2,5)

Question 11: A business owner tracks monthly revenue in columns A through L. Which formula will calculate the total revenue for the year?

a) =SUM(A1:A12)

b) =SUM(A1:L1)

c) =AVERAGE(A1:L1)

d) =COUNT(A1:L1)

Question 12: Which Excel function counts the number of entries in a dataset that are greater than or equal to 100?

a) =SUMIF()

b) =COUNTIF()

c) =IF()

d) =AVERAGEIF()

Question 13: A doctor wants to count the number of patients diagnosed with "Allergy" in a dataset. Which function should they use?

a) =SUMIF()

b) =COUNTIF()

c) =IF()

d) =AVERAGEIF()

Question 14: A client wants to calculate the total interest paid over the course of a loan. Which formula should they use?

a) =SUM(D1:D12)

b) =COUNTIF(D1:D12)

c) =SUMIF(D1:D12)

d) =SUM(D1:D12)+D13

Question 15: A manager needs to identify the highest sales amount for the year. Which formula will return the maximum value from a list of sales data?

a) =SUM()

b) =MAX()

c) =MIN()

d) =AVERAGE()

Question 16: A doctor wants to track how many patients have been diagnosed with "Flu" over the last 12 months. Which feature should they use to filter the data?

a) Data Validation

b) Filter

c) Conditional Formatting

d) Trace Dependents

Question 17: A sales team tracks the total number of units sold each month. Which formula will calculate the average number of units sold per month?

a) =SUM(A1:A12)

b) =AVERAGE(A1:A12)

c) =COUNT(A1:A12)

d) =MAX(A1:A12)

Question 18: A student wants to calculate the percentage of total points they scored in a course. Which formula will return the correct percentage if their score is in cell A2 and the total points possible is in B2?

a) =A2/B2

b) =SUM(A2,B2)

c) =IF(A2>B2)

d) =COUNT(A2,B2)

Question 19: Which Excel function returns the number of days between two dates?

a) =DAY()

b) =DAYS()

c) =DATE()

d) =TODAY()

Question 20: A manager wants to calculate the gross profit for a product, which is the sales amount minus the cost of goods sold (COGS). Which formula will calculate this if sales are in C15 and COGS are in C16?

a) =SUM(C15,C16)

b) =C15-C16

c) =IF(C15>C16)

d) =COUNT(C15,C16)

Need Guaranteed Results?

Don't want to study? Our exam support service guarantees you'll pass your OA on the first attempt. Pay only after you pass!

Get Exam Support