please help by turning in no later than 7:30 or i will not
heres the directions
HM 271 Lecture – Conditional Formatting Homework
Due date: Sep 29nd (Friday) 11:59pm
The excel file you worked on should be uploaded to Canvas, under “Assignment” menu. One submission by student. No corrupted files accepted.
Formatting (20 points)
- Format the tables (title, numbers, borders, cell styles etc.)
- Freeze panes so that the title row (top three rows 1, 2, and 3) and the column containing the
- last names (Column A) are always visible.
Using absolute / relative reference (30points)
The City collects a 2.0% Tourist Tax to pay for loan incurred when constructing a new convention center. Using an absolute/relative reference so as to be able to copy the formula without re-writing it:
- Compute column E: Total Rate = Room Rate × (1 + City Tax rate)
- Compute column F : Outstanding Balance = Total Rate × Guest nights
Using conditional formatting (50 points)
- Highlight the cells for the 10 lowest Outstanding Balance in column F.
- With a different color, highlight the rows where the Outstanding Balance Exceeds the Balance
- Limit in cell in cell K5.