You are expected to create a named range called LastFiveAvg that will average $5$ numbers starting with the cell to the left of the cell containing the formula $=$ LastFiveAvg, and going up another four cells. Assume you are working in Sheet$1.$ If $=$ LastFiveAvg is entered in C$8,$ what will the show for the reference of LastFiveAvg?

Cannot tell from information given

Average$($Sheet$1!$B$2$:B$6)$

Offset$($Sheet$1!$B$4$:B$8)$

Average$($Sheet$1$B$4$:B$9)$

Sheet$1($B$4$:B$8)$