C268 Spreadsheets Practice Questions - Set 2 - 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 spreadsheet tracks loan payments. Which formula would you use to calculate the number of monthly payments required to pay off a loan of $10,000 at $200 per month over five years?

a) =RATE()

b) =NPER()

c) =PMT()

d) =FV()

Question 22: Which function will provide the total interest paid over the course of a loan, based on a list of monthly interest payments?

a) =COUNT()

b) =IF()

c) =SUM()

d) =MAX()

Question 23: A sales manager wants to know which formulas reference a specific cell, such as B2. Which tool should they use?

a) Trace Precedents

b) Trace Dependents

c) Filter

d) PivotTable

Question 24: Which formula would be used to find the average sales for the days when sales exceeded $10,000?

a) =SUMIF(B1:B7,">10000")

b) =AVERAGEIF(B1:B7,">10000")

c) =COUNTIF(B1:B7,">10000")

d) =IF(B1>10000)

Question 25: Which formula will calculate the salary expenses based on the number of employees and their individual salaries?

a) =COUNT(A1:A5)

b) =SUMIF(A1:A5)

c) =SUM(A1:A5*B1:B5)

d) =SUM(A1:A5*B1)

Question 26: An analyst needs to determine how much more food sales were generated at concerts compared to other events. Which formula should they use?

a) =SUM(Food_Concert)-SUM(Food_Other)

b) =COUNTIF(Food_Concert)

c) =SUM(Food_Concert+Food_Other)

d) =SUMIF(Food_Concert,">0")

Question 27: Which formula should be used to calculate the total sales for the 4th quarter of the year, with monthly sales in cells B2, B3, and B4?

a) =SUM(B2+B3+B4)

b) =+B2+B3+B4

c) =SUM(B2,B3,B4)

d) All of the above

Question 28: An employee tracks the correlation between the number of hours worked and job performance. The correlation coefficient is 0.5. What does this suggest?

a) No correlation

b) Weak correlation

c) Moderate correlation

d) Strong correlation

Question 29: A business tracks sales for multiple products. Which formula will return the minimum sales for a given range?

a) =SUM()

b) =MIN()

c) =AVERAGE()

d) =COUNTIF()

Question 30: An Excel model uses multiple inputs that change frequently. Which feature is useful for evaluating different scenarios within the model?

a) Solver

b) Goal Seek

c) Scenario Manager

d) Data Validation

Question 31: A client wants to borrow $10,000 with monthly payments of $250. Which function will calculate the maximum annual interest rate that satisfies this payment schedule?

a) =NPER()

b) =RATE()

c) =FV()

d) =PMT()

Question 32: A table contains data for sales reps and their total sales. Which formula will sum the sales for a specific rep, such as Rep B?

a) =SUMIF(A1:A5,"Rep B",B1:B5)

b) =SUMIF(B1:B5,A1:A5,"Rep B")

c) =COUNTIF(A1:A5,"Rep B")

d) =AVERAGEIF(A1:A5,"Rep B",B1:B5)

Question 33: A bank offers several loan interest rate options. Which Excel tool would allow a user to compare the total monthly payments across all options?

a) Solver

b) Scenario Manager

c) Trace Precedents

d) Trace Dependents

Question 34: Which formula will display "Y" for sales greater than or equal to $3,000 and "N" for sales below $3,000?

a) =IF(B2>=3000,"Y","N")

b) =IF(B2<3000,"Y","N")

c) =IF(B2<3000,"Y","N")

d) =IF(B2=3000,"Y","N")

Question 35: A doctor wants to know how many patients have been diagnosed with a specific illness. Which function will filter the list of patients by diagnosis?

a) =SUMIF()

b) Filter

c) Trace Dependents

d) Data Validation

Question 36: Which feature of Excel should be used to track the percentage of sales attributed to each product in a pie chart?

a) Data Labels

b) Data Validation

c) Conditional Formatting

d) Solver

Question 37: A student wants to align all text to the left in an Excel worksheet. Which group on the Home Tab should they use?

a) Font

b) Number

c) Alignment

d) Styles

Question 38: Which two options are available in Solver’s parameter dialog window for optimization analysis?

a) MAX and Value Of

b) MIN and MAX

c) Count and Sum

d) Value Of and MIN

Question 39: An Excel model includes formulas that reference other worksheets. What tool can be used to verify the cells referenced in these formulas?

a) Data Validation

b) Trace Precedents

c) Trace Dependents

d) Filter

Question 40: A table contains a list of sales for multiple products. Which formula will return the average sales for products that sold more than 100 units?

a) =COUNTIF()

b) =SUMIF()

c) =AVERAGEIF()

d) =IF()

Don't Want to Study?

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

Get Exam Support