2.1. MS Excel

Try these first

1. 1.

   What is a spreadsheet?

   Hint

   Think about how data is arranged in Excel.

2. 2.

   What is the purpose of a chart in Excel?

   Hint

   What visual aids does Excel provide?

3. 3.

   What is the primary function of a pivot table?

   • Store data
   • Create reports
   • Summarize data

   Hint

   Think of how the tool processes large amounts of information.

4. 4.

   True or False: Macros can only be used in Excel.

   • True
   • False

   Hint

   Consider if other office applications might also have similar functions.

5. 5.

   You have sales data for the last five years. Create a pivot table and a corresponding chart to show the yearly growth trend.

   Hint

   Think about how to set up your rows and columns in the pivot table.

6. 6.

   Design a macro that formats a monthly report with specific headings, bolds certain key data, and adds a footer.

   Hint

   Consider what actions you take every month to format that report.