C268 Spreadsheets Practice Questions - Set 2 - 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 function would calculate the maximum monthly sales for a range of data covering multiple months?

a) =MAX()

b) =SUM()

c) =MIN()

d) =IF()

Question 42: Which feature in Excel allows you to add an additional filter to a data field in a PivotTable?

a) Slicer

b) Data Labels

c) Trace Dependents

d) Data Validation

Question 43: Which formula will display "Good Job" if both the hours worked are less than the estimated hours and the quality is greater than 1?

a) =IF(E161,"Good Job")

b) =IF(AND(E161),"Good Job","")

c) =AND(E161,"Good Job")

d) =IF(E16

Question 44: An analyst uses the CORREL function and gets a coefficient of 0.274 between two variables. What type of relationship does this indicate?

a) No correlation

b) Weak correlation

c) Moderate correlation

d) Strong correlation

Question 45: An employee earns an outcome bonus if the difficulty of the job is greater than 3 or the quality of their work equals 3. Which formula will calculate the outcome bonus eligibility?

a) =AND(G16>3,H16=3)

b) =IF(AND(G16>3,H16=3),"Bonus Eligible","Not Eligible")

c) =OR(G16>3,H16=3)

d) =IF(G16>3,"Bonus","No Bonus")

Question 46: A company tracks sales data for different departments. Which Excel feature should be used to create a report showing gross pay by department?

a) Data Validation

b) PivotTable

c) Trace Precedents

d) Filter

Question 47: Which feature in Excel allows you to visualize the differences in data between categories in a chart?

a) Slicer

b) Legend

c) Data Validation

d) Solver

Question 48: An owner wants to display the monthly sales tax based on a rate of 7.5% of total sales. Which formula will calculate the sales tax if monthly sales are in cells A1 to L1?

a) =SUM(A1:L1)*B2

b) =SUM(A1:L1)+B2

c) =SUM(A1:L1-B2)

d) =AVERAGE(A1:L1)*B2

Question 49: A manager wants to calculate the percentage of total sales each product contributes to a company’s overall sales. Which chart type should be used?

a) Pie Chart

b) Line Chart

c) Column Chart

d) Bar Chart

Question 50: Which formula will calculate how many employees are eligible for a time bonus, based on whether they worked fewer hours than estimated and their work quality exceeded 1?

a) =COUNTIF(E16:C16,H16>1)

b) =AND(E161)

c) =IF(E16>C16,H16=1)

d) =SUMIF(E16,C16,H16>1)

Struggling With Exams?

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

Get Exam Support