0
0
Excelspreadsheet~10 mins

Consolidating data from multiple sheets in Excel - Interactive Code Practice

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Practice - 5 Tasks
Answer the questions below
1fill in blank
easy

Complete the formula to sum values from Sheet1 cell A1.

Excel
=SUM([1]!A1)
Drag options to blanks, or click blank then click option'
AData
BSheet2
CSheet1
DSummary
Attempts:
3 left
💡 Hint
Common Mistakes
Using the wrong sheet name.
Forgetting the exclamation mark after the sheet name.
2fill in blank
medium

Complete the formula to sum the range A1:A5 from Sheet2.

Excel
=SUM([1]!A1:A5)
Drag options to blanks, or click blank then click option'
ASummary
BSheet3
CData
DSheet2
Attempts:
3 left
💡 Hint
Common Mistakes
Referencing the wrong sheet.
Using incorrect range syntax.
3fill in blank
hard

Fix the error in the formula to sum cell B2 from Sheet3.

Excel
=SUM([1]B2)
Drag options to blanks, or click blank then click option'
ASheet3!
B'Sheet3'B2
CSheet3!$
DSheet3
Attempts:
3 left
💡 Hint
Common Mistakes
Omitting the exclamation mark.
Adding extra characters like '$' incorrectly.
4fill in blank
hard

Fill both blanks to create a formula that sums cells A1 to A3 from Sheet1 and Sheet2.

Excel
=SUM([1]!A1:A3, [2]!A1:A3)
Drag options to blanks, or click blank then click option'
ASheet1
BSummary
CSheet2
DData
Attempts:
3 left
💡 Hint
Common Mistakes
Using incorrect sheet names.
Forgetting the exclamation mark after sheet names.
5fill in blank
hard

Fill all three blanks to create a formula that sums cell B1 from Sheet1, Sheet2, and Sheet3.

Excel
=SUM([1]!B1, [2]!B1, [3]!B1)
Drag options to blanks, or click blank then click option'
ASheet2
BSheet3
CSheet1
DSummary
Attempts:
3 left
💡 Hint
Common Mistakes
Mixing up sheet names order.
Omitting exclamation marks.