MO-210 · Topic 4 Formulas and Functions Mission Lab

1 · Build

2 · Calculate

3 · Reference

4 · Audit

Multiple Response

=D5*E5=SUM(H5:J5)4500

Formula Response

Formula Classification

Invoice Review

F2

fx

Quantity=D2 · Unit Price=E2 · Discount=F2

Formula Response

Best Path Response

Formula Response

Multiple Response

Formula Response

Single Response

SUMIFSSUMIFCOUNTIFS

Single Response

C5 and D5$C$5 and $D$5

Formula Response

Multiple Response

A1 = relative$A$1 = absolute$A1 or A$1 = mixed$A$1 = mixed

Formula Response

Single Response

Multiple Path Response

Formulas → Formula Auditing → Show FormulasCtrl + `

Audit Simulation

C5

→

G5

←

D5

Trace PrecedentsTrace DependentsWatch Window

Multiple Response

#DIV/0! = division by zero#REF! = invalid cell reference#NAME? = unrecognized function or name#VALUE! = worksheet is protected

Single Response

1. Evaluate SUM(H5:J5)

2. Subtract the subtotal from G5

3. Inspect the final result

Open Simulation · Level 4

Certification Checkpoint

Project 4 · Municipal Payroll Audit10:00

0%

Microsoft Office Specialist Preparation Series

Certificate of Completion

This certifies that

has successfully completed

MO-210 · Topic 04

Perform Operations with Formulas and Functions

Completed a practical Microsoft Excel workplace mission involving formula creation, common functions, relative and absolute references, payroll calculations, error interpretation, and professional formula auditing.

Skills Demonstrated

Formula Construction · Common Functions · IF and Conditional Functions · Relative/Absolute References · Error Analysis · Formula Auditing

Mission Score: —Checkpoint Score: —Practice Activities: —Estimated Learning Time: 35 minutesCompletion Date:

Juan CarballoMicrosoft Office Specialist Master Instructor