Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The Individual Assignment 1 is worth ( 5 % ) . Perform these 6 Actions that are worth up - to 1 0 marks within
The Individual Assignment is worth
Perform these Actions that are worth upto marks within hour.
Action : Sorting 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 and Freeze Panes.
Sort the records on type and sqft descending: largest to smallest
Be sure that the records appear sorted as expected or else sort again
Action : Basic If mark
In the same Sort and IFs spreadsheet, type Affordability in cell M Colour that new column heading in light blue and bold it
In cell M 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 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: IFcondition cell entry if condition is True, cell entry if condition is False
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started