C268 Spreadsheets Practice Questions - Set 5 - 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 manager needs to know how many employees worked fewer than 40 hours in a week. Which formula will provide this information?

=SUMIF(A1:A10,"<40")

=COUNTIF(A1:A10,"<40")

=IF(A1<40)

=AVERAGEIF(A1:A10,"<40")

Question 2: Which Excel function would you use to return the day of the month from a date stored in cell A2?

=MONTH()

=DAY()

=YEAR()

=HOUR()

Question 3: A business owner wants to calculate the future value of monthly savings of $200 over 5 years with a 3% interest rate. Which function should they use?

=PMT()

=FV()

=NPV()

=PV()

Question 4: A manager wants to determine the total number of items sold that exceeded 100 units. Which formula should they use?

=SUMIF(A1:A10,">100")

=COUNTIF(A1:A10,">100")

=IF(A1>100)

=AVERAGEIF(A1:A10,">100")

Question 5: Which formula will calculate the difference between total sales in cells A1 and B1?

=SUM(A1,B1)

=B1-A1

=A1+B1

=IF(A1>B1)

Question 6: Which Excel function would calculate the number of periods required to pay off a loan with monthly payments of $300 and a 5% annual interest rate?

=NPER()

=PMT()

=FV()

=PV()

Question 7: A client wants to calculate the total value of sales for all products that sold more than 500 units. Which function should they use?

=COUNTIF()

=SUMIF()

=AVERAGEIF()

=IF()

Question 8: A student wants to calculate the number of days between two dates stored in cells A1 and A2. Which function will provide this result?

=DAY()

=DAYS()

=DATE()

=TODAY()

Question 9: Which Excel function will count the number of non-blank cells in a range?

=COUNT()

=COUNTA()

=COUNTIF()

=SUMIF()

Question 10: A doctor wants to count the number of patients diagnosed with "Flu" from a dataset. Which Excel feature will help achieve this?

Filter

Data Validation

Conditional Formatting

PivotTable

Question 11: Which Excel function will return the first 3 characters of a text string in cell A2?

=RIGHT(A2,3)

=MID(A2,3)

=LEFT(A2,3)

=TEXT(A2,3)

Question 12: Which formula will calculate the total loan payments made if the monthly payment is in C10 and the number of months is in C11?

=SUM(C10*C11)

=C10*C11

=IF(C10>C11)

=AVERAGE(C10*C11)

Question 13: Which Excel function would be used to calculate the number of months required to pay off a $12,000 loan with monthly payments of $500 and a 4% annual interest rate?

=NPER()

=PMT()

=FV()

=PV()

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

=A2/B2

=SUM(A2,B2)

=IF(A2>B2)

=COUNT(A2,B2)

Question 15: Which feature in Excel allows users to highlight cells based on specific conditions, such as highlighting sales over $5,000?

Conditional Formatting

Data Validation

Filter

Protect Sheet

Question 16: A company wants to summarize sales data for different regions in a report. Which Excel feature would allow them to filter the report by region?

Slicer

Conditional Formatting

Data Validation

Trace Dependents

Question 17: A manager tracks monthly sales in cells A1 through L1. Which formula will return the maximum sales value?

=SUM(A1:L1)

=COUNT(A1:L1)

=MAX(A1:L1)

=AVERAGE(A1:L1)

Question 18: A user needs to calculate the total number of unique entries in a dataset. Which Excel function will help?

=COUNT()

=COUNTA()

=COUNTIF()

=SUMIF()

Question 19: A sales manager needs to calculate the commission earned by a salesperson. The sales amount is in cell A5 and the commission rate is in cell B5. Which formula will calculate the total commission?

=A5*B5

=SUM(A5,B5)

=A5+B5

=IF(A5>B5)

Question 20: Which Excel feature allows users to restrict the type of data that can be entered into specific cells?

Data Validation

Conditional Formatting

Filter

Trace Precedents

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