C268 Spreadsheets Practice Questions - Set 1 - Part 3

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

Question 41: Which formula calculates whether sales met the goal of $800 in cell B2?

a) =IF(B2=800,"Goal Met","Goal Not Met")

b) =IF(B2<800,"Did Not Meet Goal","Met Goal")

c) =IF(B2>=800,"Met Goal","Did Not Meet Goal")

d) =IF(B2>800,"Goal Met","Goal Not Met")

Question 42: A person wants to pay off a loan in five years by making $200 monthly payments. Which function will calculate the maximum annual interest rate?

a) =NPER()

b) =PV()

c) =RATE()

d) =FV()

Question 43: A data validation rule needs to restrict user inputs to numbers from a specific list. Which setting should be selected?

a) Decimal

b) Whole number

c) List

d) Text

Question 44: A person wants to buy a laptop with a maximum budget of $40 per month for 18 months. Which formula will help determine if the laptop priced at $700 is affordable?

a) =700/18<=40

b) =40/18>=700

c) =IF(700/18<=40,"Affordable","Not Affordable")

d) =IF(700>40,True,False)

Question 45: Which feature in Excel should you use to combine multiple rows or columns into one line of text?

a) CONCAT

b) RIGHT

c) LEFT

d) MID

Question 46: Which Excel function helps calculate the total operating expenses for a product by summing salaries, commissions, and fixed costs?

a) =SUMIF()

b) =COUNT()

c) =SUM()

d) =IF()

Question 47: An employee has been paid $250 per month for 36 months at an interest rate of 4.99%. Which function provides the present value of these payments?

a) =PV()

b) =FV()

c) =NPV()

d) =RATE()

Question 48: An Excel model needs to calculate the difference between the total amount paid over a loan period and the original loan amount. Which formula should be used?

a) =G12-C11

b) =SUM(G12-ABS(C11))

c) =G12-ABS(C11)

d) =IF(G12>=C11)

Question 49: A doctor’s assistant tracks patient diagnoses and wants to filter for patients diagnosed with the flu. What Excel feature should they use?

a) Filter

b) Conditional Formatting

c) Trace Precedents

d) SUMIF

Question 50: Which formula will provide the total number of products sold that have a quantity greater than or equal to 500 in a dataset?

a) =COUNTIF(C1:C6,">=500")

b) =SUMIF(C1:C6,">=500")

c) =IF(C1>=500)

d) =AVERAGEIF(C1:C6,">=500")

Struggling With Exams?

Less Time Studying, More Time Living – Finish Your Degree Faster! Pay-After-you-Pass

Get Exam Support