C268 Spreadsheets Practice Questions - Set 5 - Part 2

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

Question 21: A business owner wants to track monthly sales performance for multiple products. Which Excel feature allows them to summarize the data in a report?

PivotTable

Conditional Formatting

Data Validation

Solver

Question 22: Which formula will return the current date and time in Excel?

=TODAY()

=DATE()

=NOW()

=TIME()

Question 23: A company wants to calculate the total interest paid over the course of a loan. Which function should they use?

=SUM()

=COUNTIF()

=IF()

=SUMIF()

Question 24: Which formula will count the number of times the word "Completed" appears in a range of cells from A1 to A10?

=COUNTIF(A1:A10,"Completed")

=SUMIF(A1:A10,"Completed")

=AVERAGEIF(A1:A10,"Completed")

=IF(A1="Completed")

Question 25: A team wants to track the number of projects completed on time. Which Excel feature will allow them to filter the data by project status?

Filter

Conditional Formatting

Data Validation

Slicer

Question 26: Which Excel formula will display "Passed" if a student’s score in cell A2 is greater than or equal to 70 and "Failed" otherwise?

=IF(A2>=70,"Passed","Failed")

=IF(A2<70,"Passed","Failed")

=IF(A2>70,"Failed","Passed")

=A2>=70

Question 27: A store wants to calculate the total sales for products that sold more than 300 units. Which formula should they use?

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

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

=IF(A1>300)

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

Question 28: A manager needs to calculate the number of employees who worked more than 40 hours in a week. Which function will provide this information?

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

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

=IF(A1>40)

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

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

=SUM(A1:A12)

=AVERAGE(A1:A12)

=COUNT(A1:A12)

=MAX(A1:A12)

Question 30: Which formula will calculate the total interest paid on a loan if the monthly interest payments are in cells D1 through D12?

=SUM(D1:D12)

=COUNT(D1:D12)

=IF(D1:D12>0)

=AVERAGE(D1:D12)

Question 31: Which function calculates the total value of sales based on a specific condition, such as sales greater than $1,000?

=SUMIF()

=COUNTIF()

=AVERAGEIF()

=IF()

Question 32: A client wants to calculate the number of months required to pay off a $15,000 loan with monthly payments of $500 and an interest rate of 5%. Which function should they use?

=NPER()

=PV()

=PMT()

=FV()

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

=SUM(A1:L1)

=COUNT(A1:L1)

=MIN(A1:L1)

=MAX(A1:L1)

Question 34: A business owner tracks the number of customers who visit their store each month. Which formula will calculate the average number of customers per month?

=SUM(A1:A12)

=AVERAGE(A1:A12)

=COUNT(A1:A12)

=MAX(A1:A12)

Question 35: A financial analyst needs to calculate the present value of a series of monthly payments. Which Excel function will provide this information?

=FV()

=NPV()

=PMT()

=PV()

Question 36: Which formula will calculate the total loan amount if the monthly payment is in cell C5 and the number of months is in cell C6?

=SUM(C5*C6)

=C5*C6

=IF(C5>C6)

=AVERAGE(C5*C6)

Question 37: A team wants to calculate the total number of hours worked on a project. Which Excel function should they use?

a) =SUM()

b) =COUNT()

c) =AVERAGE()

d) =IF()

Question 38: Which feature in Excel allows users to visualize data differences in a chart by adding labels to indicate what each color represents?

a) Legend

b) Data Validation

c) Slicer

d) Conditional Formatting

Question 39: A student wants to calculate the average test score for students who scored above 80. Which function will help achieve this?

a) =AVERAGEIF(A1:A10,">80")

b) =SUMIF(A1:A10,">80")

c) =COUNTIF(A1:A10,">80")

d) =IF(A1>80)

Question 40: A user wants to extract the last 5 characters from a text string in cell A1. Which function should they use?

a) =LEFT(A1,5)

b) =MID(A1,5)

c) =RIGHT(A1,5)

d) =TEXT(A1,5)

Don't Want to Study?

Save Time on Studies, Spend More with Family & Friends! Pay-After-you-Pass

Get Exam Support