cis 122l

agsbwuq1

AdvancedFunctions1.xlsx

Home >Computer Science homework help >cis 122l

OrderOfOperations

Arithmetic Order of Operations Examples

Order of Operations (PEMDAS):

(Excel follows the rules for order of operations and will calculate

Parentheses

each example correctly so you can check your answers.)

Exponents

Multiplication and division

Addition and subtraction

Calculate this:

In your head, figure the answer to the calculation, then type your answer in this column:

Then type the exact calculation shown in column B into this column so Excel can calculate the formula. Compare your answer in column D to this answer.

= 5 + 4 * 2

= 10 - 3 * 3

= 6 + 10 / 2

= 50 / 5 - 3 * 2

= 6 * ( 9 - 7 ) / ( 4 + 2 )

HG SPRING2019

Dollar Store

DOLLAR STORE
$1 for the first item, then $0.85 for each additional item
	Number of Items	Total Cost for the listed number of items
	2
	11
	317
	101
	27

Food Pantry

Food Pantry Credit
$25 per family plus $12 per child
	Adults	Children	Food Credit	Value Per Person
	2	3	$61.00
	1	1	$37.00
	2	2	$49.00
	1	5	$85.00
	Average of the Value Per Person:

Absolute

			Restocking Fee:	17%
The Credit Due is the Amount of Sale less the 17% Restocking Fee
Invoice #	Amount of Sale	Credit Due
10187	$317.41
10214	$333.42
10223	$333.30
10244	$297.53
10262	$295.19
10280	$317.07
10298	$326.19
10316	$161.13
10334	$64.04
10352	$208.58
10370	$176.25
10388	$78.40
10406	$113.75
10424	$91.17
10442	$253.45
10460	$336.18
10478	$265.10
10496	$231.31
10514	$240.12

TotalInterest

Total Interest
Period (years):	5
	Rate
Loan Amount	3.00%	3.25%	3.50%	3.75%	4.00%	4.25%	4.50%	4.75%	5.00%
$50,000.00
$75,000.00
$100,000.00
$125,000.00
$150,000.00
$175,000.00
$200,000.00
$225,000.00
$250,000.00
$275,000.00
$300,000.00
$325,000.00
$350,000.00
$375,000.00
$400,000.00
$425,000.00
$450,000.00
$475,000.00
$500,000.00

COUNTIF

Students	Gender	Ethnic	Pay Club Dues	Math	Language	Science	Writing	Grade	GPA	Grade	Count
1	Male	White	Yes	234	247	238	176	11	3.3	9
2	Male	White	No	240	241	243	187	12	2.8	10
3	Female	White	Yes	263	259	262	200	10	2.8	11
4	Male	White	Yes	243	244	239	213	9	3.4	12
5	Female	Black	Yes	248	242	244	196	9	2.9	Sum
6	Male	Hispanic	Yes	257	260	247	197	11	3.1
7	Male	White	No	239	252	245	212	12	2.8
8	Female	White	Yes	247	252	243	188	12	2.5	Gender	Count
9	Male	White	Yes	247	250	253	220	10	3.0	Female
10	Female	Black	No	235	245	238	191	11	3.1	Male
11	Female	White	No	248	247	248	223	10	3.3	Sum
12	Male	Hispanic	Yes	247	253	242	214	10	3.0
13	Male	White	No	239	241	246	196	9	2.8
14	Female	Black	Yes	246	248	236	190	9	2.9
15	Female	White	No	246	231	244	189	9	2.9
16	Male	White	Yes	263	240	238	188	11	3.1
17	Female	Hispanic	No	244	242	243	212	12	2.8
18	Male	Hispanic	Yes	247	250	264	215	10	2.6
19	Male	White	Yes	256	248	277	221	9	3.0
20	Male	White	No	238	250	244	189	9	3.1
21	Female	Hispanic	No	247	258	248	190	11	3.3
22	Male	White	Yes	246	252	244	215	12	3.0
23	Female	Hispanic	No	235	253	265	234	12	2.8
24	Female	Hispanic	No	247	249	254	211	10	3.3
25	Female	White	No	247	240	238	189	11	2.9
26	Female	White	Yes	239	248	248	198	10	3.1
27	Male	White	No	247	255	241	210	12	3.0
28	Female	White	Yes	248	241	268	214	12	3.1
29	Male	White	Yes	233	247	236	190	10	3.2
30	Female	White	Yes	238	249	244	191	11	3.0
31	Male	White	Yes	263	241	238	188	10	3.1
32	Male	White	No	243	242	241	213	10	2.9
33	Female	White	No	248	257	264	199	9	2.9
34	Male	White	Yes	257	244	239	211	11	3.1
35	Female	Black	No	239	244	246	197	12	2.8
36	Male	White	Yes	249	258	247	197	10	2.2
37	Male	White	No	247	252	243	212	9	3.0
38	Male	Black	Yes	235	251	238	214	9	3.1
39	Female	White	Yes	248	249	253	221	11	3.3
40	Female	Black	No	248	255	239	232	12	3.0
41	Male	Black	No	239	248	246	222	12	2.8
42	Female	White	No	247	254	241	214	10	2.9
43	Male	White	Yes	254	241	256	213	11	2.9
44	Male	White	No	264	248	235	189	10	3.1
45	Male	White	No	245	256	245	200	10	2.8
46	Female	Hispanic	No	246	240	238	196	9	2.5
47	Male	White	Yes	256	243	242	211	9	3.0
48	Female	Hispanic	No	240	258	264	215	9	3.1
49	Female	Hispanic	No	247	243	239	221	11	3.3
50	Male	White	No	247	242	245	200	11	2.9
51	Female	Hispanic	Yes	234	260	248	202	11	3.0
52	Male	Hispanic	No	239	251	245	215	10	2.8
53	Female	White	Yes	263	252	219	217	10	2.9
54	Male	Hispanic	Yes	244	250	252	213	9	2.9
55	Female	White	Yes	253	257	239	215	9	3.1
56	Male	White	Yes	258	248	247	197	9	2.8
57	Male	Hispanic	No	240	253	242	211	11	2.5
58	Female	White	No	247	241	241	213	12	3.0
59	Male	White	Yes	248	246	237	190	10	3.1
60	Female	Black	No	233	241	245	187	9	2.2
61	Male	Black	Yes	232	241	238	199	9	3.0
62	Male	White	No	248	241	242	214	11	3.4
63	Male	Black	Yes	238	258	262	210	12	3.4
64	Female	White	Yes	222	244	240	212	12	3.1
65	Female	Black	No	246	242	246	200	10	3.1
66	Male	Hispanic	No	222	260	247	199	11	2.8
67	Female	Black	No	233	253	243	210	10	2.5
68	Male	Hispanic	Yes	256	253	255	214	10	3.0
69	Male	White	No	226	260	252	222	9	3.1
70	Male	White	No	239	244	239	231	9	3.3
71	Female	Hispanic	No	248	248	248	222	9	3.0
72	Male	White	Yes	250	253	241	213	11	2.8
73	Female	Hispanic	No	234	240	246	197	12	2.9
74	Female	Hispanic	No	247	246	237	190	10	2.9
75	Female	White	No	246	246	243	200	9	3.1
76	Female	Hispanic	Yes	238	240	239	197	9	2.8
77	Male	White	No	246	242	242	210	11	2.7
78	Female	White	Yes	251	258	262	214	12	3.0
79	Male	Black	Yes	251	245	240	222	10	2.8
80	Female	Black	Yes	246	243	246	186	9	2.8
81	Male	White	Yes	262	258	247	200	9	3.0
82	Male	Hispanic	No	243	252	243	213	11	2.8
83	Female	Hispanic	No	247	253	241	214	12	3.2
84	Male	White	Yes	258	249	252	211	12	3.1
85	Female	Black	Yes	238	251	238	200	10	3.1
86	Male	White	No	248	247	247	197	11	2.8
87	Male	White	Yes	248	254	243	211	10	2.5
88	Male	White	No	235	240	237	213	10	3.0
89	Female	Hispanic	Yes	254	247	235	201	9	3.1
90	Female	White	No	248	245	244	199	9	3.3
91	Male	Hispanic	No	239	240	239	211	9	3.0
92	Female	White	Yes	246	242	243	214	11	2.8
93	Male	Black	Yes	250	258	264	195	12	3.0
94	Male	White	No	264	243	239	213	10	2.9
95	Female	Hispanic	No	247	259	247	199	9	2.8
96	Female	White	Yes	258	251	245	211	11	2.7
97	Male	Hispanic	No	239	251	259	214	12	3.2

SUMIF

Students	Gender	Ethnic	Pay Club Dues	Math	Language	Science	Writing	Grade	Club Dues	Grade	Sum of Club Dues
1	Female	White	Yes	234	247	238	176	11	$40	9
2	Male	White	Yes	240	241	243	187	12	$61	10
3	Female	White	Yes	263	259	262	200	10	$17	11
4	Male	White	Yes	243	244	239	213	9	$16	12
5	Female	Black	Yes	248	242	244	196	9	$87	Total
6	Male	Hispanic	Yes	257	260	247	197	11	$46
7	Male	White	Yes	239	252	245	212	12	$86
8	Female	White	Yes	247	252	243	188	12	$50	Gender	Sum of Club Dues
9	Male	White	Yes	247	250	253	220	10	$52	Female
10	Female	Black	Yes	235	245	238	191	11	$33	Male
11	Male	White	Yes	248	247	248	223	10	$28	Total
12	Male	Hispanic	Yes	247	253	242	214	10	$88
13	Male	White	No	239	241	246	196	9
14	Female	Black	Yes	246	248	236	190	9	$29
15	Female	White	No	246	231	244	189	9
16	Male	White	Yes	263	240	238	188	11	$45
17	Female	Hispanic	Yes	244	242	243	212	12	$21
18	Male	Hispanic	Yes	247	250	264	215	10	$85
19	Male	White	Yes	256	248	277	221	9	$71
20	Male	White	Yes	238	250	244	189	9	$17
21	Female	Hispanic	Yes	247	258	248	190	11	$18
22	Male	White	Yes	246	252	244	215	12	$30
23	Female	Hispanic	Yes	235	253	265	234	12	$25
24	Female	Hispanic	Yes	247	249	254	211	10	$81
25	Female	White	No	247	240	238	189	11
26	Female	White	Yes	239	248	248	198	10	$59
27	Male	White	No	247	255	241	210	12
28	Female	White	Yes	248	241	268	214	12	$54
29	Male	White	Yes	233	247	236	190	10	$47
30	Female	White	Yes	238	249	244	191	11	$73
31	Male	White	Yes	263	241	238	188	10	$20
32	Male	White	Yes	243	242	241	213	10	$75
33	Female	White	Yes	248	257	264	199	9	$89
34	Male	White	Yes	257	244	239	211	11	$51
35	Female	Black	Yes	239	244	246	197	12	$41
36	Male	White	Yes	249	258	247	197	10	$62
37	Male	White	Yes	247	252	243	212	9	$57
38	Male	Black	Yes	235	251	238	214	9	$49
39	Female	White	Yes	248	249	253	221	11	$53
40	Female	Black	Yes	248	255	239	232	12	$88
41	Male	Black	Yes	239	248	246	222	12	$59
42	Female	White	No	247	254	241	214	10
43	Male	White	Yes	254	241	256	213	11	$86
44	Male	White	Yes	264	248	235	189	10	$13
45	Male	White	Yes	245	256	245	200	10	$72
46	Female	Hispanic	No	246	240	238	196	9
47	Male	White	Yes	256	243	242	211	9	$65
48	Female	Hispanic	Yes	240	258	264	215	9	$77
49	Female	Hispanic	Yes	247	243	239	221	11	$15
50	Male	White	Yes	247	242	245	200	11	$32
51	Female	Hispanic	Yes	234	260	248	202	11	$41
52	Male	Hispanic	Yes	239	251	245	215	10	$49
53	Female	White	Yes	263	252	219	217	10	$55
54	Male	Hispanic	Yes	244	250	252	213	9	$66
55	Female	White	Yes	253	257	239	215	9	$66
56	Male	White	Yes	258	248	247	197	9	$18
57	Male	Hispanic	Yes	240	253	242	211	11	$37
58	Female	White	Yes	247	241	241	213	12	$32
59	Male	White	Yes	248	246	237	190	10	$54
60	Female	Black	No	233	241	245	187	9
61	Male	Black	Yes	232	241	238	199	9	$68
62	Male	White	Yes	248	241	242	214	11	$46
63	Male	Black	Yes	238	258	262	210	12	$49
64	Female	White	Yes	222	244	240	212	12	$86
65	Female	Black	Yes	246	242	246	200	10	$61
66	Male	Hispanic	Yes	222	260	247	199	11	$22
67	Female	Black	Yes	233	253	243	210	10	$28
68	Male	Hispanic	Yes	256	253	255	214	10	$30
69	Male	White	Yes	226	260	252	222	9	$25
70	Male	White	Yes	239	244	239	231	9	$86
71	Female	Hispanic	No	248	248	248	222	9
72	Male	White	Yes	250	253	241	213	11	$24
73	Female	Hispanic	Yes	234	240	246	197	12	$63
74	Female	Hispanic	Yes	247	246	237	190	10	$53
75	Female	White	No	246	246	243	200	9
76	Female	Hispanic	Yes	238	240	239	197	9	$73
77	Male	White	Yes	246	242	242	210	11	$69
78	Female	White	Yes	251	258	262	214	12	$31
79	Male	Black	Yes	251	245	240	222	10	$68
80	Female	Black	Yes	246	243	246	186	9	$65
81	Male	White	Yes	262	258	247	200	9	$77
82	Male	Hispanic	Yes	243	252	243	213	11	$74
83	Female	Hispanic	Yes	247	253	241	214	12	$78
84	Male	White	Yes	258	249	252	211	12	$30
85	Female	Black	Yes	238	251	238	200	10	$41
86	Male	White	Yes	248	247	247	197	11	$45
87	Male	White	Yes	248	254	243	211	10	$85
88	Male	White	Yes	235	240	237	213	10	$73
89	Female	Hispanic	Yes	254	247	235	201	9	$73
90	Female	White	Yes	248	245	244	199	9	$47
91	Male	Hispanic	Yes	239	240	239	211	9	$29
92	Female	White	Yes	246	242	243	214	11	$81
93	Male	Black	Yes	250	258	264	195	12	$81
94	Male	White	Yes	264	243	239	213	10	$40
95	Female	Hispanic	Yes	247	259	247	199	9	$41
96	Male	White	Yes	258	251	245	211	11	$19
97	Female	Hispanic	No	239	251	259	214	12

AVERAGEIF

Students	Gender	Ethnic	Pay Club Dues	Math	Language	Science	Writing	Grade	GPA	Grade	Average GPA
1	Female	White	Yes	234	247	238	176	11	3.3	9
2	Male	White	No	240	241	243	187	12	2.8	10
3	Female	White	Yes	263	259	262	200	10	2.8	11
4	Male	White	Yes	243	244	239	213	9	3.4	12
5	Female	Black	Yes	248	242	244	196	9	2.9
6	Male	Hispanic	Yes	257	260	247	197	11	3.1
7	Male	White	No	239	252	245	212	12	2.8
8	Female	White	Yes	247	252	243	188	12	2.5	Pay Club Dues	Average GPA
9	Male	White	Yes	247	250	253	220	10	3.0	Yes
10	Female	Black	No	235	245	238	191	11	3.1	No
11	Male	White	No	248	247	248	223	10	3.3
12	Male	Hispanic	Yes	247	253	242	214	10	3.0
13	Male	White	No	239	241	246	196	9	2.8
14	Female	Black	Yes	246	248	236	190	9	2.9
15	Female	White	No	246	231	244	189	9	2.9
16	Male	White	Yes	263	240	238	188	11	3.1
17	Female	Hispanic	No	244	242	243	212	12	2.8
18	Male	Hispanic	Yes	247	250	264	215	10	2.6
19	Male	White	Yes	256	248	277	221	9	3.0
20	Male	White	No	238	250	244	189	9	3.1
21	Female	Hispanic	No	247	258	248	190	11	3.3
22	Male	White	Yes	246	252	244	215	12	3.0
23	Female	Hispanic	No	235	253	265	234	12	2.8
24	Female	Hispanic	No	247	249	254	211	10	3.3
25	Female	White	No	247	240	238	189	11	2.9
26	Female	White	Yes	239	248	248	198	10	3.1
27	Male	White	No	247	255	241	210	12	3.0
28	Female	White	Yes	248	241	268	214	12	3.1
29	Male	White	Yes	233	247	236	190	10	3.2
30	Female	White	Yes	238	249	244	191	11	3.0
31	Male	White	Yes	263	241	238	188	10	3.1
32	Male	White	No	243	242	241	213	10	2.9
33	Female	White	No	248	257	264	199	9	2.9
34	Male	White	Yes	257	244	239	211	11	3.1
35	Female	Black	No	239	244	246	197	12	2.8
36	Male	White	Yes	249	258	247	197	10	2.2
37	Male	White	No	247	252	243	212	9	3.0
38	Male	Black	Yes	235	251	238	214	9	3.1
39	Female	White	Yes	248	249	253	221	11	3.3
40	Female	Black	No	248	255	239	232	12	3.0
41	Male	Black	No	239	248	246	222	12	2.8
42	Female	White	No	247	254	241	214	10	2.9
43	Male	White	Yes	254	241	256	213	11	2.9
44	Male	White	No	264	248	235	189	10	3.1
45	Male	White	No	245	256	245	200	10	2.8
46	Female	Hispanic	No	246	240	238	196	9	2.5
47	Male	White	Yes	256	243	242	211	9	3.0
48	Female	Hispanic	No	240	258	264	215	9	3.1
49	Female	Hispanic	No	247	243	239	221	11	3.3
50	Male	White	No	247	242	245	200	11	2.9
51	Female	Hispanic	Yes	234	260	248	202	11	3.0
52	Male	Hispanic	No	239	251	245	215	10	2.8
53	Female	White	Yes	263	252	219	217	10	2.9
54	Male	Hispanic	Yes	244	250	252	213	9	2.9
55	Female	White	Yes	253	257	239	215	9	3.1
56	Male	White	Yes	258	248	247	197	9	2.8
57	Male	Hispanic	No	240	253	242	211	11	2.5
58	Female	White	No	247	241	241	213	12	3.0
59	Male	White	Yes	248	246	237	190	10	3.1
60	Female	Black	No	233	241	245	187	9	2.2
61	Male	Black	Yes	232	241	238	199	9	3.0
62	Male	White	No	248	241	242	214	11	3.4
63	Male	Black	Yes	238	258	262	210	12	3.4
64	Female	White	Yes	222	244	240	212	12	3.1
65	Female	Black	No	246	242	246	200	10	3.1
66	Male	Hispanic	No	222	260	247	199	11	2.8
67	Female	Black	No	233	253	243	210	10	2.5
68	Male	Hispanic	Yes	256	253	255	214	10	3.0
69	Male	White	No	226	260	252	222	9	3.1
70	Male	White	No	239	244	239	231	9	3.3
71	Female	Hispanic	No	248	248	248	222	9	3.0
72	Male	White	Yes	250	253	241	213	11	2.8
73	Female	Hispanic	No	234	240	246	197	12	2.9
74	Female	Hispanic	No	247	246	237	190	10	2.9
75	Female	White	No	246	246	243	200	9	3.1
76	Female	Hispanic	Yes	238	240	239	197	9	2.8
77	Male	White	No	246	242	242	210	11	2.7
78	Female	White	Yes	251	258	262	214	12	3.0
79	Male	Black	Yes	251	245	240	222	10	2.8
80	Female	Black	Yes	246	243	246	186	9	2.8
81	Male	White	Yes	262	258	247	200	9	3.0
82	Male	Hispanic	No	243	252	243	213	11	2.8
83	Female	Hispanic	No	247	253	241	214	12	3.2
84	Male	White	Yes	258	249	252	211	12	3.1
85	Female	Black	Yes	238	251	238	200	10	3.1
86	Male	White	No	248	247	247	197	11	2.8
87	Male	White	Yes	248	254	243	211	10	2.5
88	Male	White	No	235	240	237	213	10	3.0
89	Female	Hispanic	Yes	254	247	235	201	9	3.1
90	Female	White	No	248	245	244	199	9	3.3
91	Male	Hispanic	No	239	240	239	211	9	3.0
92	Female	White	Yes	246	242	243	214	11	2.8
93	Male	Black	Yes	250	258	264	195	12	3.0
94	Male	White	No	264	243	239	213	10	2.9
95	Female	Hispanic	No	247	259	247	199	9	2.8
96	Male	White	Yes	258	251	245	211	11	2.7
97	Female	Hispanic	No	239	251	259	214	12	3.2