C268 Spreadsheets Practice Questions - Set 3 - 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 number of periods required to pay off a loan with $250 monthly payments and a total loan of $10,000?

a) =FV()

b) =PMT()

c) =NPER()

d) =PV()

Question 2: Which feature in Excel will allow you to freeze the first row of a worksheet while scrolling through the rest of the data?

a) Freeze Panes

b) Filter

c) Conditional Formatting

d) Trace Precedents

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

a) =DATE()

b) =NOW()

c) =TIME()

d) =TODAY()

Question 4: Which Excel function calculates the future value of regular monthly payments of $150 over 10 years with a 4% interest rate?

a) =NPER()

b) =FV()

c) =PMT()

d) =PV()

Question 5: A manager needs to determine how much sales have increased between two periods. Which formula will calculate the difference between sales in cells A1 and B1?

a) =A1+B1

b) =B1-A1

c) =A1-B1

d) =SUM(A1:B1)

Question 6: Which function calculates the correlation coefficient between two data arrays in Excel?

a) =CORREL()

b) =SUMIF()

c) =NPV()

d) =RATE()

Question 7: A doctor needs to display a filtered list of patients diagnosed with "Flu" from a dataset. What Excel feature should they use?

a) Data Validation

b) Conditional Formatting

c) Filter

d) PivotTable

Question 8: Which formula would return TRUE if sales in cell B2 are greater than or equal to $1,000?

a) =IF(B2>1000,TRUE,FALSE)

b) =IF(B2>=1000,TRUE,FALSE)

c) =B2=1000

d) =SUM(B2>=1000)

Question 9: Which Excel feature would you use to track changes made to a shared workbook by multiple users?

a) Conditional Formatting

b) Track Changes

c) Freeze Panes

d) Trace Dependents

Question 10: Which formula will correctly calculate the payment for a loan, where the rate is in C13, the number of months is in C12, and the loan amount is in C11?

a) =PMT(C13,C12,C11)

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

c) =FV(C13,C12,C11)

d) =PV(C13/12,C12,C11)

Question 11: Which formula will calculate the markup for an item in cell D4 if the cost is in cell C4 and the markup percentage is in A1?

a) =C4+A1

b) =C4*$A1

c) =C4+$A1

d) =C4-A1

Question 12: An accountant wants to restrict user input in cell B3 to whole numbers between 1 and 100. Which Excel feature should be used?

a) Data Validation

b) Conditional Formatting

c) Filter

d) Solver

Question 13: A manager tracks the correlation between employee hours and productivity. The correlation coefficient is calculated as 0.65. What does this suggest?

a) Weak correlation

b) Moderate correlation

c) Strong correlation

d) No correlation

Question 14: Which Excel function counts the number of sales transactions that exceed $500 in a dataset?

a) =COUNTIF()

b) =SUMIF()

c) =AVERAGEIF()

d) =IF()

Question 15: Which of the following is a valid use of a circular reference in an Excel spreadsheet model?

a) To remove redundant data

b) To prevent errors in formulas

c) To calculate interdependent values simultaneously

d) To find missing data

Question 16: A student wants to track the correlation between hours studied and exam grades in Excel. How should they set this up?

a) Use =SUMIF() on the two data arrays

b) Use =CORREL() to calculate the correlation

c) Use =IF() to compare study hours and grades

d) Use =COUNTIF() to count the correlation

Question 17: Which formula will calculate the total amount paid for a loan by multiplying the monthly payment in cell C15 by the loan term in cell C12?

a) =SUM(C15*C12)

b) =SUM(C15,C12)

c) =C15*C12

d) =IF(C15*C12)

Question 18: Which formula will calculate the interest for period 1 if the loan balance is in F19 and the interest rate is in C13?

a) =F19*C13/12

b) =F19+C13/12

c) =F19-C13/12

d) =SUM(F19*C13/12)

Question 19: An owner wants to know how many orders were placed for a product that sold at least 200 units. Which formula should they use?

a) =COUNTIF(B1:B10,">=200")

b) =SUMIF(B1:B10,">=200")

c) =IF(B1>=200)

d) =AVERAGEIF(B1:B10,">=200")

Question 20: Which feature in Excel helps visualize differences in values between categories on a chart?

a) Slicer

b) Legend

c) Data Validation

d) Conditional Formatting

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