C268 Spreadsheets Practice Questions - Set 2 - 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: Which Excel function calculates the monthly payment for a loan based on constant payments and a constant interest rate?

a) =PV()

b) =PMT()

c) =RATE()

d) =NPV()

Question 2: Which formula will correctly calculate the difference between the total amount paid over a loan and the original loan amount?

a) =G12-C11

b) =G12-ABS(C11)

c) =SUM(G12,C11)

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

Question 3: Which function will provide the present value of an investment when given the interest rate, number of periods, and payment?

a) =FV()

b) =NPER()

c) =PV()

d) =RATE()

Question 4: Which two tools are found in the Review tab of Excel and can be used for protecting and managing changes in a worksheet?

a) Protect Sheet and Freeze Panes

b) Track Changes and Sort

c) Track Changes and Protect Sheet

d) Conditional Formatting and Protect Workbook

Question 5: A student is calculating the correlation between study hours and exam scores using Excel. Which function should they use?

a) =CORREL()

b) =SUMIF()

c) =COUNTIF()

d) =IF()

Question 6: Which Excel feature will allow you to display the number $3.10 in a cell?

a) Select the cell and format it as Currency, then enter 3.1

b) Select the cell and enter 310

c) Use the AutoSum function

d) Use the Text to Columns feature

Question 7: Which of the following functions will count the total number of employees in a table who worked more than 40 hours?

a) =COUNTIF()

b) =IF()

c) =SUMIF()

d) =AVERAGEIF()

Question 8: Which formula will calculate the principal amount for the first period in an amortization schedule?

a) =PMT(D20,F20)

b) =C20-D20

c) =C20/D20

d) =SUM(C20+D20)

Question 9: Which Excel function allows you to automatically populate the "Hourly Wage" column by looking up the employee name in a reference table?

a) =HLOOKUP()

b) =VLOOKUP()

c) =INDEX()

d) =MATCH()

Question 10: Which formula correctly calculates the payment for a loan, assuming the rate is in cell C13, the term is in C12, and the loan amount is in C11?

a) =PMT(C13,C12,C11)

b) =PMT(C13/12,C12,C11)

c) =RATE(C12,C13,C11)

d) =FV(C13,C12,C11)

Question 11: A manager wants to determine how much money a customer will have after saving $100 per month for two years at a 5% interest rate. Which function should they use?

a) =NPV()

b) =FV()

c) =RATE()

d) =PV()

Question 12: A doctor tracks patient diagnoses in a report and wants to filter the data to show only patients diagnosed with a specific illness. What tool should they use?

a) Filter

b) Data Validation

c) Conditional Formatting

d) PivotTable

Question 13: Which Excel formula will calculate the interest amount for the first period of a loan if the balance in period 0 is in cell F19 and the loan interest rate is in cell C13?

a) =F19*C13/12

b) =F19+C13/12

c) =F19/C13/12

d) =F19*C13

Question 14: A grocery store wants to track how many products sold at least 500 units. Which function will accomplish this?

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

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

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

d) =IF(C1>=500)

Question 15: An analyst is calculating the sales forecast for each product if expected attendance is 18,000 people. Which function should they use?

a) =CORREL()

b) =FORECAST()

c) =SUM()

d) =VLOOKUP()

Question 16: Which function will count the number of responses in a survey that contain an age, where non-responses are marked with an "N"?

a) =COUNTA()

b) =COUNTIF()

c) =COUNT()

d) =SUM()

Question 17: A restaurant tracks daily sales. Which formula will return the total sales for days that exceeded $10,000?

a) =COUNTIF(A1:A7,">10000")

b) =SUMIF(A1:A7,">10000")

c) =AVERAGEIF(A1:A7,">10000")

d) =IF(A1>10000)

Question 18: Which Excel feature should you use to prevent users from entering invalid data in a specific cell?

a) Conditional Formatting

b) Data Validation

c) Sort

d) Freeze Panes

Question 19: Which formula will return the text "On Track" if the number of appointments in cell B2 is greater than or equal to 10 and "Off Track" if it is less than 10?

a) =IF(B2>=10,"On Track","Off Track")

b) =IF(B2<10,"On Track","Off Track")

c) =IF(B2>10,"Off Track","On Track")

d) =IF(B2<=10,"On Track","Off Track")

Question 20: Which Excel function is used to calculate the total amount of sales, where the quantity in each row is greater than zero?

a) =COUNTIF()

b) =SUMIF()

c) =IF()

d) =AVERAGEIF()

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