Copy your answers to all tasks in a single word document. In this word document:
o You should have a cover page for the entire document and a table of content after the cover page.
o The written text will be single-spaced, in font size 12, and in Times New Roman or Arial font. Set the Top, Bottom, Left, and Right Margins to 1 inch.
o If you use any table or figure:
▪ Appropriately name each and refer to them by their names in the text.
▪ Use the same format for all figures for the entire document.
▪ Use the same format for all tables for the entire document.
Task 1. Formatting Data.
How many variables (columns) do we have in the data? How many observations do we have in the data? Take a screenshot and add it to the MS Word report.
Format data as a table. Take a screenshot and add it to the MS Word report.
Use “Conditional Format” for the column “Sale Price” to use a different color for prices
below $150,000. Take a screenshot and add it to the MS Word report.
Use “Conditional Format” for the column “Square Feet” to use a different color for sizes
more than 1,000 sqft. Take a screenshot and add it to the MS Word report.
Task 2. Sort and Filter.
Sort the data based on the “Year Built” variable (column). Take a screenshot and add it to
the MS Word report.
