A personal trainer stores how much weight each person can lift in several categories. Each week’s…


 A singular trainer stores how fur efficacy each individual can lift in various categories. Each week’s facts are stored in a detached worksheet within the selfsame workbook, and each worksheet has an selfsame erection. Assume cell F5 contains the efficacy the chief individual can bench squeeze. What power can identify that individual’s chief aggregate bench-pressed in all worksheets?

(a) =COUNT(Week 1,Week4:F5)

(b) =SUM(Week 1:Week4:F5)

(c) =MAX('Week 1:Week 4'!F5)

 (d) =MAX(Week1:Week4:’F5’)