The questions use the sample orders: country in column E, status in column K and revenue in column J, rows 2 to 31. The names work the same in Excel, Google Sheets and LibreOffice.
Spreadsheet functions for business data
Match seven common spreadsheet functions to what they do, then choose the formula that answers each question about an order list.
Exercise15 minBachelor +2CC BY 4.0
2 tasks · 15 min
What you will learn
- Choose the right function for a calculation
- Read a COUNTIF and a SUMIFS formula
Use it with a class
- 1. Copy the class link and share it with your class.
- 2. Learners finish the exercise and get a result code.
- 3. Paste the codes into Class results to see everyone at once.
Reuse this material
CC BY 4.0You may copy, adapt and share it, also commercially, as long as you credit ManyPI and link back.
"Spreadsheet functions for business data" by ManyPI (https://manypi.com/edu/spreadsheet-functions-exercise), licensed under CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/)