using named ranges and the IF function, enter a formula in cell F$6$ to calculate the standard cost. if the room type $($named range Room$)$ is private, use Days$*$PrivateCost$,$ otherwise use Days$*$Semicost$.$ If the formula does not automatically copy into the range F$7$:F$20,$ use the fill handle to copy the formula into the range