IntermediateConstructionEXCEL+20 XP

Adjusted Totals: Add 2

Scenario

You are a data professional working with construction data. Prepare a reliable result from site_jobs for a review.

Question

Add all values in C2:C5, then add an adjustment of 2.

Intermediate · COUNTIF & SUMIF — question 16 of 20

Finish all 20 to earn a certificate

Choose your workbook

Sheet1

Excel worksheet · Sheet1

site_jobs

E2
A
B
C
D
E
F
1
2
3
4
5
6
Sheet1
excel editor
Type your code here ↓
✍️ Tap here to type
attempts: 0
▶ Output terminal
$ Press “Check my answer” — results appear here.

Your next steps

Each item turns green when your answer includes it.

3 left
  • Uses the required formula
  • Uses the requested value
  • Reads the workbook column