The spreadsheet above includes the names of various movie theaters in town. Each
ID: 3543445 • Letter: T
Question
The spreadsheet above includes the names of various movie theaters in town. Each theatre has multiple cinemas in which various movies are played. The types of movie (Drama, Comedy, etc.) playing in each cinema are listed on the left side. Note: If no movie is playing in a cinema, the type cell is empty.
The following ranges have been named:
a) What formula would you enter into F5 to count the total number of Comedy movies played at Galaxy? Your formula must be able to be filled down and right from F5 to H6 to correctly populate the table. The values shown in the summary table should be automatically updated if the types of movie showing in the cinemas change (e.g., C9 is changed to Comedy) or if the type of movie to be summarized change (e.g., F4 is changed to Western). Hint: You will find the INDIRECT function useful for answering this question.
b) Which formula would you enter in cell I5 to count the number of movies playing at Galaxy? Again your formula must be able to be filled down and be automatically updated if the types of movie showing in the cinemas change. Hint: You will find the COUNTA function useful for answering this question.
Cell/Range Name B4:C10 GALAXY B13:C15 FUN_HALL C4:C10 GALAXYtype C13:C15 FUN_HALLtypeExplanation / Answer
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.