Filetype Excel XLSX | Posted on 17 Aug 2022 | 3 years ago
Authentication
digital resources
319x Filetype XLSX File size 0.04 MB Source: ag.tennessee.edu
Sheet 1: Helpful Videos
| Creating Basic Formula | |||||||||||||||||||
| A | B | C | D | A | B | C | D | A | B | C | D | ||||||||
| 15 | 10 | 10 | 20 | 25 | 45 | 58 | 79 | 56 | 25 | 86 | 156 | ||||||||
| Add Cell A4 and C4 | Add A4,C4, Add D4 | Add Cell Aand C | Add A,C, Add D | Add Cell Aand C | Add A,C, Add D | ||||||||||||||
| 25 | =A4+C4 | 45 | =A4+C4+D4 | 83 | 162 | 142 | 298 | ||||||||||||
| D4 minus B4 | Add A4 and D4, then divide the Total by C4 | D minus B | Add A and D, then divide the Total by C | D minus B | Add A and D, then divide the Total by C | ||||||||||||||
| 10 | =D4-B4 | 3.5 | =(A4+D4)/C4 | 34 | 1.79310344827586 | 131 | 2.46511627906977 | ||||||||||||
| Multiply B4 x A4 | Multiply B4 times D4, Then add A4 | Multiply B x A | Multiply B times D, Then add A | Multiply B x A | Multiply B times D, Then add A | ||||||||||||||
| 150 | =B4*A4 | 215 | =(B4*D4)+A4 | 1125 | 3580 | 1400 | 3956 | ||||||||||||
| Divide D4 by C4 | Divide D by C | Divide D by C | |||||||||||||||||
| 2 | =D4/C4 | 1.36206896551724 | 1.81395348837209 |
| Using Functions | Using Functions | Using Functions | ||||||||||||
| Date | Daily Sales | Date | Daily Sales | Date | Daily Sales | |||||||||
| 1-Oct | $254.00 | 1-Oct | $584.00 | 1-Oct | $365.00 | |||||||||
| 2-Oct | $658.00 | 2-Oct | $658.00 | 2-Oct | $856.00 | |||||||||
| 3-Oct | $576.00 | 3-Oct | $576.00 | 3-Oct | $576.00 | |||||||||
| 4-Oct | $854.00 | 4-Oct | $259.00 | 4-Oct | $854.00 | |||||||||
| 5-Oct | $958.00 | 5-Oct | $958.00 | 5-Oct | $487.00 | |||||||||
| 6-Oct | $685.00 | 6-Oct | $685.00 | 6-Oct | $685.00 | |||||||||
| 7-Oct | $547.00 | 7-Oct | $478.00 | 7-Oct | $568.00 | |||||||||
| Total | $4,532.00 | =sum(B3:B9) | Total | $4,198.00 | Total | $4,391.00 | ||||||||
| Average | $647.43 | =AVERAGE(B3:B9) | Average | $599.71 | Average | $627.29 | ||||||||
| Max | $958.00 | =MAX(B3:B9) | Max | $958.00 | Max | $856.00 | ||||||||
| Min | $254.00 | =MIN(B3:B9) | Min | $259.00 | Min | $365.00 | ||||||||
| Count | 7 | =COUNT(B3:B9) | Count | 7 | Count | 7 |
no reviews yet
Please Login to review.
