Lab Activity

1. Use now(), today(), text() in worksheet1
2. Add a new sheet.
3. Using fill series do the following task.

4. Enter the following data in Excel

Perform the pivoting to summarize the above data, based on the total sales per month each salesperson performs.

5. Make this data in Excel and create charts

6. Create a hyperlink between two sheets.

sheet1 -> sheet2

sheet2 -> sheet1