Spreadsheet

Task - Using Spreadsheet in an online shop

Situation: Online shop

Spreadsheet is a very powerful tool for handling data. In this task, you will try and make use of spreadsheet and other tools to handling orders in an online shop.

Order form

Design an online order form

Create an Google Form to collect order from their customers. Please refer to the form above.

2. Create information from the order

After sending out the information, you have to processing the information for different purposes. Read the document above for the details.

3. Use pivot table to create different summaries

Pivot table is a handy tool for creating summaries. Create the summaries required in the document above.

4. Create charts for presentation

Statistical charts can be created for presenting the information.

Spreadsheet functions

Watch the video tutorial of the spreadsheet function and try them out. You have to make a copy of the Google Sheet in order to test it out.

IF function

Spreadsheet functions IF.mp4

IF and Nested IF

Report abuse