And this part please ?

I TF paint quality). 9. In an adjacent column, determine if (TRUE or FALSE) this is a low-priced room. A low-priced ate a row below the data that totals the costs of each item (primer, first coat, and so on) and then 11. Because larger jobs have certain economies of scale in setup and cleanup, a discount is given based room is one that is estimated to cost less than $300. 10. Cre a grand total of all items for all rooms. on these estimated values to jobs based on their total size. Just below the grand total, determine the total discounted price of the job based on the following: . If the total cost of the painting job is less than $800, then there is no discount. If the total cost of the painting job is at least $800 but less than $2,000, then a 5% discount will be given (discount is calculated based on the grand total cost for all items and all rooms). If the total cost of the painting job is at least $2,000 but less than $5,000, then a 10% discount will be given. If the total cost of the painting job is $5,000 or more, then a 15% discount will be given. 12. Format your worksheets so that they are easy to read and information is clearly identifiable. High light the result of Step 10 in yellow. Submitting the Project To submit the project, simply upload the Excel files on Moodle. There will be a specific link for this project I TF paint quality). 9. In an adjacent column, determine if (TRUE or FALSE) this is a low-priced room. A low-priced ate a row below the data that totals the costs of each item (primer, first coat, and so on) and then 11. Because larger jobs have certain economies of scale in setup and cleanup, a discount is given based room is one that is estimated to cost less than $300. 10. Cre a grand total of all items for all rooms. on these estimated values to jobs based on their total size. Just below the grand total, determine the total discounted price of the job based on the following: . If the total cost of the painting job is less than $800, then there is no discount. If the total cost of the painting job is at least $800 but less than $2,000, then a 5% discount will be given (discount is calculated based on the grand total cost for all items and all rooms). If the total cost of the painting job is at least $2,000 but less than $5,000, then a 10% discount will be given. If the total cost of the painting job is $5,000 or more, then a 15% discount will be given. 12. Format your worksheets so that they are easy to read and information is clearly identifiable. High light the result of Step 10 in yellow. Submitting the Project To submit the project, simply upload the Excel files on Moodle. There will be a specific link for this project