t. Use relative and mixed cell references correctly. Copy the formula for the Sunday column to complete the entire range of weekdays C11:G14. What is the correct formula?

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Group the four weekly worksheets. Enter a formula in cell C11 to calculate Sunday’s Orchestra Front revenue, which is based on the number of seats sold and the price per seat. Use relative and mixed cell references correctly. Copy the formula for the Sunday column to complete the entire range of weekdays C11:G14.

What is the correct formula?

AutoSave
Eberle exploring_e09_grader_a1_Theater - Read-Only - Excel
P Search
ff
Colette Moriarty CM
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
Acrobat
A Share
P Comments
Σ
- 11 - A A"
a Wrap Text
Calibri
General
Paste
$ - % 9 58 8
Insert Delete Format
Ideas
BIU -
=EE EE E Merge & Center -
Conditional Format as
Cell
Sort & Find &
.00
Formatting - Table Styles v
Filter v Select
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
Ideas
A1
fe
Home
B
D
F
G
H
K
L
M
N
P
1 Home
Number of Seats Sold per Day
Saturday
Saturday
Evening
2 Seating
3 Orchestra Front
Available
Sunday Wednesday
Friday
Matinee
Weekly Totals
86
86
84
86
86
86
428
4 Box Seats
5 Mezzanine Level 1
6 Balcony Level 1
16
16
12
15
16
16
75
64
50
54
64
64
64
296
46
32
42
44
46
46
210
7 Totals
184
192
209
212
212
1,009
8
9
Revenue per Day
10 Seating
11 Orchestra Front
12 Box Seats
Seat Price Sunday
Wednesday Friday
Saturday Ma Saturday Eve Weekly Totals
168
250
13 Mezzanine Level 1
14 Balcony Level 1
15 Totals
155
$
95
16
17
18
19
20
21
Documentation
Week 1
Week 2
Week 3
Week 4
October
+)
Circular References
围
100%
4:11 PM
10/20/2020
国,
圍,
關,
出
Transcribed Image Text:AutoSave Eberle exploring_e09_grader_a1_Theater - Read-Only - Excel P Search ff Colette Moriarty CM File Home Insert Page Layout Formulas Data Review View Help Acrobat A Share P Comments Σ - 11 - A A" a Wrap Text Calibri General Paste $ - % 9 58 8 Insert Delete Format Ideas BIU - =EE EE E Merge & Center - Conditional Format as Cell Sort & Find & .00 Formatting - Table Styles v Filter v Select Clipboard Font Alignment Number Styles Cells Editing Ideas A1 fe Home B D F G H K L M N P 1 Home Number of Seats Sold per Day Saturday Saturday Evening 2 Seating 3 Orchestra Front Available Sunday Wednesday Friday Matinee Weekly Totals 86 86 84 86 86 86 428 4 Box Seats 5 Mezzanine Level 1 6 Balcony Level 1 16 16 12 15 16 16 75 64 50 54 64 64 64 296 46 32 42 44 46 46 210 7 Totals 184 192 209 212 212 1,009 8 9 Revenue per Day 10 Seating 11 Orchestra Front 12 Box Seats Seat Price Sunday Wednesday Friday Saturday Ma Saturday Eve Weekly Totals 168 250 13 Mezzanine Level 1 14 Balcony Level 1 15 Totals 155 $ 95 16 17 18 19 20 21 Documentation Week 1 Week 2 Week 3 Week 4 October +) Circular References 围 100% 4:11 PM 10/20/2020 国, 圍, 關, 出
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Table
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education