![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 02.04.2021 20:00 babygirl123468
Use the SUBTOTAL function to complete the following:
In cell H7, insert a formula that counts the number of cells in the Category field that are not empty.
In cell H8, insert a formula that sums the cells in the Units field.
In cell H9, insert a formula that sums the cells in the Subtotal field.
In cell H10, insert a formula that averages the cells in the Retail_Price field.
_PriceStaffStaff_CategoryHotel_Gues tTrans_Type
Receptionist Card
Transaction count
Units sold
Subtotal sum
Retail average
_PriceStaffStaff_CategoryHotel_Gues tTrans_TypeSubtotal
5/1/20181Sph - Hair WrapClothing17.95KendraMassage TherapistYescash$ 17.95
5/1/20182Sandalwood Massage OilMassage Oil19.95$ 39.90
5/1/20182Vanilla Bean Massage OilMassage Oil19.95KellyReceptionistNocheck$ 39.90
5/1/20182Water - rejuvenating, flavored, 12 oz bottleFood4.19PatMassage TherapistNocard$ 8.38
5/1/20182Geranium Rose Bath CrystalsSkincare6.99KendraMassage Therapist
![ansver](/tpl/images/cats/User.png)
Answers: 1
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 05:00
Which best explains why a digital leader would join a society specializing in technology
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 20:30
What is the biggest difference between section breaks and regular page breaks
Answers: 1
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 21:40
language consists of basic components, and they are called a. 3; mental images, concepts, and speech b. 2; language acquisition and linguistic relativity c. 3; heuristics, algorithms, and analogies d. 4; phonemes, morphemes, syntax, and semantics e. 2; words and grammar
Answers: 3
You know the right answer?
Use the SUBTOTAL function to complete the following:
In cell H7, insert a formula that counts the n...
Questions
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/informatica.png)
Computers and Technology, 25.01.2020 04:31
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/es.png)
![question](/tpl/images/cats/obshestvoznanie.png)
![question](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/biologiya.png)
![question](/tpl/images/cats/obshestvoznanie.png)
![question](/tpl/images/cats/health.png)
![question](/tpl/images/cats/fizika.png)
![question](/tpl/images/cats/obshestvoznanie.png)
![question](/tpl/images/cats/fizika.png)
![question](/tpl/images/cats/obshestvoznanie.png)
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/mat.png)