Final Exam Introduction : Final Exam

Pretest Introduction

Introduction

The Excel Environment

Working with Data: Basic Techniques

Increasing Spreadsheet Readability

Excel Formulas

Useful Excel Functions

Charts

Importing Data into Excel

The Art of Spreadsheet Modeling

Using Excel Solver

Three$-$Dimensional Formulas, the Table Feature and Circular References

Monte Carlo Simulation

Final Exam Introduction

Final Exam

Credits

$117$

$/118$

Close

Closed Captions

$19.$

The design for the new electric car had been approved by the board and production was underway, but the VP of Manufacturing was nervous about the rate of defective parts from subcontractors. He scheduled a meeting with a key supplier and wants to present evidence of how many months the Master Cylinder defects were greater than $20.$ What formula should be entered in cell C$28$ to get this information? Assume the three columns of the dataset have been named Subassembly$\_$Name, Month, and Defects.

$=$SUBTOTAL$($Subassembly$\_$Name,$A$28,$Defects$>20)$

$=$COUNTA$($Subassembly$\_$Name,Defects,$>20)$

$=$COUNTIF$($Subassembly$\_$Name,A$28,$Defects,$>20)$

$=$COUNTIFS$($Subassembly$\_$Name,A$28,$Defects,$>20)$

submitQuestion

$19$

$/58$