The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | Jul 2017 |
| Last Sign in: | 304 Weeks Ago, 1 Day Ago |
| Questions Answered: | 15833 |
| Tutorials Posted: | 15827 |
MBA,PHD, Juris Doctor
Strayer,Devery,Harvard University
Mar-1995 - Mar-2002
Manager Planning
WalMart
Mar-2001 - Feb-2009
Review and understand the example. (Note: Always start a function with an = as the first character.)                                                                                                                    Â
2Â Â Â Â Â Â Â Â Â Â Â Â Â Enter a column of 5 numbers, in cells B27 to B31Â (Pick any numbers you wish.)Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
3             In cell B33, enter a formula to add the individual 5 cells one at a time.                                   Â
4Â Â Â Â Â Â Â Â Â Â Â Â Â In cell B34, enter a formula to calculate the SUM using the SUM function of cell range B27 through B31Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
5Â Â Â Â Â Â Â Â Â Â Â Â Â In cell B35, enter a formula to calculate the average, but adding the 5 cells and dividing by 5.
6Â Â Â Â Â Â Â Â Â Â Â Â Â In cell B36, enter a formula to calculate the AVERAGE using the AVERAGE function of cell range B27 through B31Â Â Â Â
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly