C268 Spreadsheets Practice Questions - Set 1 - 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: Which Excel function returns the total number of children attending an event, where “N” is used to indicate no children?

a) =COUNT()

b) =COUNTA()

c) =SUM()

d) =IF()

Question 22: Which Excel function is used to display only the last 10 digits of an account number stored in cell A2?

a) =LEFT()

b) =RIGHT()

c) =MID()

d) =LEN()

Question 23: A salesperson tracks their appointments per month. Which formula will show if the goal of 10 appointments was met in January?

a) =IF(B2<10,"Did Not Meet Goal","Met Goal")

b) =IF(B2>=10,"Did Not Meet Goal","Met Goal")

c) =IF(B2=10,"Goal Met","Goal Not Met")

d) =IF(B2<10,"Goal Met","Goal Not Met")

Question 24: Which of the following functions would you use to find the commission dollars in cells E5 through E20 if the commission rate is stored in B2?

a) =SUMIF(E5:E20,B2)

b) =COUNTA(B2:E20)

c) =COUNTIF(B2:E20,B2)

d) =IF(E5:B2,B2)

Question 25: Which Excel formula will calculate the monthly interest rate on a loan, where F19 contains the loan balance and C13 contains the annual interest rate?

a) =F19*$C$13/12

b) =F19/$C$13*12

c) =F19*C13

d) =F19/C13/12

Question 26: An Excel model contains employee salaries. Which function will calculate the total salary paid annually?

a) =SUM()

b) =COUNT()

c) =MAX()

d) =MIN()

Question 27: Which formula will result in the sum of sales values in cells B2 through B4?

a) =+B2+B3+B4

b) =SUM(B2,B3,B4)

c) =SUM(B2:B4)

d) All of the above

Question 28: Which Excel function calculates the future value of monthly payments of $100 over two years with a 5% interest rate?

a) =FV()

b) =NPV()

c) =RATE()

d) =PV()

Question 29: Which chart type can be used to compare total sales over the last four years?

a) Pie Chart

b) Line Chart

c) Column Chart

d) Both b) and c)

Question 30: Which Excel feature can you use to track changes made by other users in a shared workbook?

a) Conditional Formatting

b) Track Changes

c) Data Validation

d) Freeze Panes

Question 31: An analyst wants to know the position of a specific character in a text string. Which Excel function should they use?

a) =LEN()

b) =SEARCH()

c) =LEFT()

d) =CONCAT()

Question 32: Which of the following is a feature of a PivotTable in Excel?

a) It can calculate totals but not averages

b) It allows data filtering but not sorting

c) It can analyze large datasets by summarizing information in multiple ways

d) It only supports two-dimensional data

Question 33: A manager wants to use Solver to maximize profit by changing the number of products produced, but wants to ensure that no more than the demand is met. What should the constraint be?

a) Produced <= Demand

b) Produced = Demand

c) Produced > Demand

d) Produced >= Demand

Question 34: Which function calculates the upper limit for a sales forecast if expected attendance is 18,000 people and a confidence interval has been set up?

a) =FORECAST()

b) =SUM()

c) =MAX()

d) =I16+J8

Question 35: In which situation would you use a circular reference in a spreadsheet model?

a) To prevent errors

b) To calculate two dependent values simultaneously

c) To check for broken formulas

d) To remove redundant data

Question 36: An owner wants to summarize all purchase data for Product A from four vendors using named ranges in separate tabs. Which formula should be used?

a) =MAX(V1PA,V2PA,V3PA,V4PA)

b) =SUM(V1PA+V2PA+V3PA+V4PA)

c) =AVERAGE(V1PA,V2PA,V3PA,V4PA)

d) =COUNTIF(V1PA,V2PA,V3PA,V4PA)

Question 37: A mechanic uses the CORREL function to find the correlation coefficient of 0.234 between teenage drivers and car repairs. What can be inferred about the reliability of the forecast based on this correlation?

a) Reliable

b) Somewhat Reliable

c) Unreliable

d) Highly Reliable

Question 38: Which feature of PivotTables allows you to add an additional filter to your data fields?

a) Slicer

b) Value Field

c) Data Label

d) Data Series

Question 39: Which feature of Excel is most useful for comparing investment returns at different points in time using a chart?

a) Line Chart

b) Stacked Column Chart

c) Pie Chart

d) Bar Chart

Question 40: Which formula will determine the total sales made by Person B in May, where the data is organized in cells A1 through A5 (names) and B1 through B5 (sales)?

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

b) =SUM(A1:B5)

c) =COUNTIF(A1:B5,"Person B")

d) =IF(B1>B5,B1,B5)

Don't Want to Study?

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

Get Exam Support