Format data table

In this exercise you are going to format data inside a Calc spreadsheet. The goal is to create a spreadsheet like the image shown below. Of course you can style the spreadsheet with colors and font types you choose.

Instructions

Some formatting instructions are annotated to the solution guide image below.

1. Open the file cell-format-exercise-start.ods. You will work in this document.
2. Insert a column on the left and a row above all data. This will give more white space to the spreadsheet.
3. Format the numerical data in the table using the required format (currency, date, percent and number with decimals).
4. Format the first row. Increase font size, change font color, text align center, background color.
5. Apply background color to the even numbered data rows. To make non continuous selections hold down the CTRL key.
6. Resize column widths and row heights.
7. Apply left and right border.
8. Save your file and submit.