Ask Copilot

Individual Assignment $1$ Instructions

INFO $10514\_61750-$ W$24$

The Individual Assignment $1$ is worth $(5\%).$

Perform these $6$ Actions that are worth up$-$to $10$ marks within $1$ hour.

Action $1$: Sorting $(1$ mark$)$

Copy the Wyoming Rural Real Estate Sales dataset to a new spreadsheet and rename the tab: Sort and IFs.

Colour the header row in yellow and bold it$.$

Select cell A$2$ and Freeze Panes.

Sort the records on type and sq$\_$ft $($descending: largest to smallest$).$

Be sure that the records appear sorted as expected $($or else sort again$).$

Action $2$: Basic IF $(1$ mark$)$

In the same Sort and IFs spreadsheet, cype Affordability in cell M$1.$ Colour that new column heading in light blue and bold it$.$

In cell M$2,$ create a Basic IF statement to determine if a listed house is expensive or manageable in terms of affordability. If the price is greater than $250000,$ then display Expensive or else display Manageable.

Drag the formula down to apply to all of the records in the dataset for the Affordability column.

View some records to ensure that the formula is working properly.

Syntax: $=IF($condition$,$ cell entry if condition is True, cell entry if condition is False$)$