referenced in Module 2. This assignment is a continuation on Functions. Importan
ID: 352125 • Letter: R
Question
referenced in Module 2. This assignment is a continuation on Functions.
Important Note: If we have reviewed previous formatting/skills and it is used in the
recreation excel document, you are to add the formatting/skill. For Example, if I show grid
lines on the recreation excel document but do not mention them in the specifications, you are
to put grid lines in the assignment. This includes all formatting/skills that I have covered
(bold, italicized, centering, shading, borders, etc..). The assignments are used to build your
skills in excel. These skills are common skills that are used in business applications and should
be easily identifiable.
If you are unfamiliar with the icons located on the format bar, please ask reference.
Use Assignment 3 recreate document to complete this assignment.
Specifications:
1. In cell C15 use a statistical function to find the minimum of the values in column C.
2. In cell D15 use a statistical function to find the maximum of the values in column D.
3. Why are there ##### signs in the columns. Can you fix this? How? Type your answer
on row 22. Then fix the issue.
4. In cell E15 use a statistical function to find the average of the values in column E.
5. In cell F15 use a Math & Trig function to find the Sum if it meets the following
conditions in column F. Sum the values over $3000 in Column F using a sumif function.
6. In cell G15 use a statistical function to find count the number of values in column G
7. Change the name of "Sheet 1" to Functions
8. Save the file as an excel worksheet as "your last name"_assign3
9. Submit the saved file in the drop box located in module 2. The assignment is due on
MIS2UM assignment 3 -runctions-1 [Read-Only] Excel saima sultana Insert Pnge l ynut Fnrmalas Dat- Rrvirw View Add ins Hrip Team &Tell; me what you want to do AutoSum-A Fe Copy B 1 u-l 2-.2_a. Merge &Conter; . $ % , Cnnditinnal Fomat as Neutral Insert Delrtr Fommat Scort & Find & Check Cell eari Selet 41 Format Pairte Cipboard lignment Ed.ng B15 X Y | | fstudents-I will not put the answers to the functions 0 Summing Count the Find thewith Average conditions Minimum Maximum items 2 First Last 3 John Smith 4 Sam Smithers 8. /34.98 |$ 8,134.98 | ###MF#, $ 8,/34.98 | S 8, /34.98 5,430.98 | ## ##IS 5,430.98 5 Ashley Johns 5,430.98 ,430.98 Rvan Gardner 8 | lom |Garndershipis 6,439.64 |$ 6,439.64 | ###MWMWS 6,439.64 | S 6,439.64 Mike House 1,248. /8|$ 1,248. /8 | # #NWMWS 1,248. /8 | S 1,248/8 11 Julia Table 12 Dave Shelve 13 14 15 16 17 18 19 20 21 6.432.37 $ 6432.37 students not put the answers to the functions r submitted assignment 3 should have the values expected in row 15 and 22 23 24 75Explanation / Answer
1. In cell C15 use a statistical function to find the minimum of the values in column C.
Ans: =MIN(C3:C12)
2. In cell D15 use a statistical function to find the maximum of the values in column D
Ans: =MAX(D3:D12)
3.
3. Why are there ##### signs in the columns. Can you fix this? How? Type your answer
on row 22. Then fix the issue.
Ans: The size of the column needs to be adjusted here because the value present has numbers more than what the column at present can accomodate, therefore it is displaying #####. Go the column and double click ok teh right extreme of the column, the size will be appropriate for the value.
4. In cell E15 use a statistical function to find the average of the values in column E.
Ans: =AVERAGE(C1:C4)
5. In cell F15 use a Math & Trig function to find the Sum if it meets the following
conditions in column F. Sum the values over $3000 in Column F using a sumif function.
Ans: =SUMIF(F3:F12,">3000")
6. In cell G15 use a statistical function to find count the number of values in column G
Ans: =COUNT(G3:G12)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.