Need Help with formating and the correct formulas

Excel Project #$150$ points Comprehensive Problem #$1,$ Chapter $2-4$: This assignment which is assigned through CengageNow, focuses on completing the accounting cycle. There are unlimited attempts as well as unlimited $$check my work$$ opportunities. Once this assignment is finalized in CengageNow, the Income Statement must be student$-$prepared as a single Microsoft Excel spreadsheet $($with the Excel tab labeled$).$ The content points are assigned based on the completion of the CengageNOW problem. The Excel file is scored according to the appropriate grading rubric. Points are awarded only if both the CengageNOW problem and the Excel file have been completed; one without the other will result in a zero score awarded for this $50-$point assignment. The grading rubric is provided below