Home G4 15 16 17 Paste 18 1 Names 2 Max 3 Alpha 4 Bravo 5 Charlie 6 7 8 9 10 11 12 13 14 19 20 Insert A. A Draw Page Layout Calibri (Body) BIU x ✓ fx B Midterm 100 88 94 58 92 V 83 75 75 67 82 97 78 39 81 78 77 16 Formulas Data Review A A A 22242HDGE 20 20 18 14 Assignment 1 Assignment 2 Assignment 3 Assignment 4 Assignment 5 Final 20 20 20 22 20 25 23 11 15 20 21 21 16 8 20 25 17 18 17 20 4 12 11 19 = = = = = € ∞ w w-POP8 20 21 10 25 19 24 23 15 24 1 25 3 View 3 5 12 8 16 6 20 Tell me 8 9 ab Wrap Text Merge & Center 8 13 24 1 17 23 15 5 6 General 14 15 13 25 22 5 $%9 4 12 11 19 19 24 23 15 24 1 H .00 100 79 85 88 95 100 90 83 85 92 96 86 82 89 84 92 -0000 V Cell Conditional Format Formatting as Table Styles I J SD IX V M Insert K Delete Each of the 5 assignments is graded out of 20 points and assignments are worth 35% on the final grade, the mid-term is worth 15% and final is worth 50% What formula would you enter in cell 14 to calculate final grade for Bravo and be able to copy for all students to calcuate their grades if all grades count. v Format L

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section: Chapter Questions
Problem 13PT
icon
Related questions
Question
Home
G4
6
7
1
2 Max
3 Alpha
4 Bravo
5
8
9
10
11
12
13
14
15
16
17
18
Paste
19
20
21
Insert Draw Page Layout
X
P
Names
A.
A
Charlie
V
Calibri (Body)
BIU✔
× ✓
fx
B
Midterm
100
88
16
94
58
92
83
75
75
67
82
97
78
39
81
78
77
Formulas Data Review
A A
Av
20
25
17
18
17
20
4
12
11
19
D
=== ==
C
E
F
G
Assignment 1 Assignment 2 Assignment 3 Assignment 4 Assignment 5 Final
20
20
20
20
20
22
8
20
18
14
AHHAHEEN
20
21
10
25
19
24
23
15
24
1
25
View
3
3
5
12
8
25
23
11
15
20
21
21
16
8
16
6
20
Tell me
8
9
Wrap Text
Merge & Center v
13
24
1
17
23
15
5
6
14
15
13
25
22
General
5
$ %
V
9
% 95.000
4
12
11
19
19
24
23
15
24
1
H
100
79
85
88
95
100
90
83
85
92
96
86
82
89
84
92
‒‒‒
I
Conditional Format. Cell
Formatting as Table Styles
V
J
4
MIX ✔
Insert Delete
K
Each of the 5 assignments is graded out of 20 points and assignments are worth 35% on the final grade, the mid-term is worth 15% and final is worth 50%
What formula would you enter in cell 14 to calculate final grade for Bravo and be able to copy for all students to calcuate their grades if all grades count.
Format
L
Transcribed Image Text:Home G4 6 7 1 2 Max 3 Alpha 4 Bravo 5 8 9 10 11 12 13 14 15 16 17 18 Paste 19 20 21 Insert Draw Page Layout X P Names A. A Charlie V Calibri (Body) BIU✔ × ✓ fx B Midterm 100 88 16 94 58 92 83 75 75 67 82 97 78 39 81 78 77 Formulas Data Review A A Av 20 25 17 18 17 20 4 12 11 19 D === == C E F G Assignment 1 Assignment 2 Assignment 3 Assignment 4 Assignment 5 Final 20 20 20 20 20 22 8 20 18 14 AHHAHEEN 20 21 10 25 19 24 23 15 24 1 25 View 3 3 5 12 8 25 23 11 15 20 21 21 16 8 16 6 20 Tell me 8 9 Wrap Text Merge & Center v 13 24 1 17 23 15 5 6 14 15 13 25 22 General 5 $ % V 9 % 95.000 4 12 11 19 19 24 23 15 24 1 H 100 79 85 88 95 100 90 83 85 92 96 86 82 89 84 92 ‒‒‒ I Conditional Format. Cell Formatting as Table Styles V J 4 MIX ✔ Insert Delete K Each of the 5 assignments is graded out of 20 points and assignments are worth 35% on the final grade, the mid-term is worth 15% and final is worth 50% What formula would you enter in cell 14 to calculate final grade for Bravo and be able to copy for all students to calcuate their grades if all grades count. Format L
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning