onta ain viruses. Unless you need to edit, it's safer to stay in Protected View.Enable Editing 1. COMPLETE Real Estate Problem. In this part of the lab you will be using spreadsheets to solve problems requiring Relational Expressions and Boolean L ogic. A file named Realestate.xisx has been prepared for you with information on a specific Broker's sales in the nearby area. The spreadsheet lists the address of the property, city, number of bedrooms, asking price, and selling price. You will be asked to copy this file, fill in the remaining sections of the spreadsheet to ascertain if the property sold above asking price, if the property sold below 95% of the asking price etc. Copy the file Realestate xlsx from Carmen to your personal directory (Hint: Remember to save file first before attempting to open). Name the new file realestate1.xisx In the top section of the worksheet is a list of the property addresses, cities etc. You will be filling in columns F through J. In the bottom section there are summary questions which you will be asked to solve. r Determine if a property is sold for no less than the asking price -In cell F2, write a formula which can be copied down the column to cells F3:F8, to determine if the property sold for no less than the asking price -try using the following method of reasoning: .Do you want a Boolean value or an arithmetic value? Here it appears that the value we want is are either True or False. To obtain a Boolean (True/False) value you will need to use a Relational Expression and/or Boolean operator . If it's a Boolean value you require, consider this: Are you comparing just two things (more jellybeans than candy corn), or are you comparing a group of things (do all the candy items cost more than $1 or does at least one candy item cost less than $1)? If you are comparing more than two things you will require a Boolean operator or a operator in combination with relational operators. You will have a chance to Boolean practice with these in subsequent questions. In the simplest case, such as this one, you are trying to compare just two things- the selling price and the asking price. So you wouid use a relational operator alone onta ain viruses. Unless you need to edit, it's safer to stay in Protected View.Enable Editing 1. COMPLETE Real Estate Problem. In this part of the lab you will be using spreadsheets to solve problems requiring Relational Expressions and Boolean L ogic. A file named Realestate.xisx has been prepared for you with information on a specific Broker's sales in the nearby area. The spreadsheet lists the address of the property, city, number of bedrooms, asking price, and selling price. You will be asked to copy this file, fill in the remaining sections of the spreadsheet to ascertain if the property sold above asking price, if the property sold below 95% of the asking price etc. Copy the file Realestate xlsx from Carmen to your personal directory (Hint: Remember to save file first before attempting to open). Name the new file realestate1.xisx In the top section of the worksheet is a list of the property addresses, cities etc. You will be filling in columns F through J. In the bottom section there are summary questions which you will be asked to solve. r Determine if a property is sold for no less than the asking price -In cell F2, write a formula which can be copied down the column to cells F3:F8, to determine if the property sold for no less than the asking price -try using the following method of reasoning: .Do you want a Boolean value or an arithmetic value? Here it appears that the value we want is are either True or False. To obtain a Boolean (True/False) value you will need to use a Relational Expression and/or Boolean operator . If it's a Boolean value you require, consider this: Are you comparing just two things (more jellybeans than candy corn), or are you comparing a group of things (do all the candy items cost more than $1 or does at least one candy item cost less than $1)? If you are comparing more than two things you will require a Boolean operator or a operator in combination with relational operators. You will have a chance to Boolean practice with these in subsequent questions. In the simplest case, such as this one, you are trying to compare just two things- the selling price and the asking price. So you wouid use a relational operator alone
