Study Guides

Unit Summary

In this unit pupils will explore how to use spreadsheets to store and manipulate data. They will use common functions and extract data to create visual representations using charts. Pupils will use spreadsheets to track and calculate income, make predictions, and answer "what if…?" questions.

Lesson Summary

You will learn to use lookup and IF functions to retrieve data efficiently.

Key Notes

• The VLOOKUP function is used to retrieve data from another sheet based on a matching value.
• Lookup and reference functions can be useful for working with sets of data efficiently.
• Data can be stored in a database, which is an organised collection of data.
• The IF function checks a condition and returns different outcomes depending on whether the condition is True or False.
• The IF function is used to give user feedback in a spreadsheet.

Vocabulary To Learn

• database: an organised collection of data
• function: a predefined formula that performs a calculation
• LOOKUP: a function that looks for a value in one column and finds matching information from the same row in another column
• IF: a function in a spreadsheet that checks if something is True or False

Common Mistakes To Avoid

• The IF function can only return the words True or False to the user.

3 Quick Questions (With Answers)

More Lessons In This Unit

• Data validation in a spreadsheet model Study Guide
• Formatting in a spreadsheet model Study Guide
• Formulas in a spreadsheet model Study Guide
• Improving a spreadsheet model Study Guide
• Spreadsheet modelling Study Guide
• Spreadsheet project I Study Guide
• Spreadsheet project II Study Guide
• Visualising data using charts in a spreadsheet Study Guide