7 Apply number formatting as follows : 8.000
Format cells B26 : G29 , B34 : G37 , and B43 : G45 as Number as follows : ( 1,234.10 ). Negative numbers should not be displayed in red , 2 decimal places and Use 1000 Separator (,) should be checked .
Format cells B30 : H31 , H26 : H29 , B38 : H39 , H34 : H37 , B46 : H46 , and H43 : H45 as Accounting .
8 In cell B26 enter a formula to multiply the total number
5.000 of One Double rooms rented on Friday by the Standard Rate for a One Double room . To enter the formula , on the HOME tab , in the Editing group , click AutoSum , and then select the cell range B14 : B17 . Edit the formula to multiply the SUM () function by the Standard Rate for a One Double room .