Sumif, Countif Functions Kindly following the instructions below and enter the appropriate formula in cell. Name Electronics SELLING PRICE Results Patricia King Laptop $ 6,665.00 Sum all Electronics that equals "Monitor" and enter in D8. Patricia King Monitor $ 5,000.00 Charles Monaghan Printer $ 7,300.00 Fred Jones Projector $ 6,500.00 In cell D11 count all electronics for Patricia King. John Paul Headset $ 5,248.00 Charlie Brown Laptop $ 6,000.00 Pink Panter Monitor $ 4,400.00 $ 4,400.00 ITEM CAR MODEL SELLING PRICE Results Retro Style Billet Grille Chevy $ 319.00 In cell D17 Sum all Car Models that equals "Dodge". Hood Vent Dodge $ 55.00 Rear Spoiler Mustang $ 220.00 Removable Roof Rack Chevy $ 63.00 Rear Hatch Accent Strip Chevy $ 25.00 Splash Guards Dodge $ 42.00 Roof Mount Bike Carrier Mustang $ 60.00 Use a formula in D23 to count all Chevy. ? Use a formula to sum the Selling Price in C24. Driver's name Item Number of Items Transport Destination John May TV $ 25.00 truck 4 Boston Peter White Washier $ 30.00 truck 3 NY Carl Anthony microwave $ 15.00 truck 3 Philadelphia Peter White TV $ 32.00 truck 4 NY Henry Price refrigerator $ 25.00 truck 3 Boston Mac Arthur Washier $ 15.00 truck 1 Baltimore Theresa Gaitor TV $ 30.00 truck 2 Philadelphia Ken Moore microwave $ 15.00 truck 1 Baltimore Use the table above to perform the following functions :- countif Total number of orders in Boston: number of microwaves orders: sumif Total sum of refrigerator items: sum of TV items: Product Supplier In Stock Results Sugar Apples Results Yam Banannas Ecudor 350 Sum all Products that equal to Sugar Apples" and enter in the Results 1 Column E48. Sugar Apples Barbados 200 Count all products that is from Jamaica and enter in Results 2 Column E49. Yam Jamaica 250 Sugar Apples Barbados 180 Banannas Ecudor 225 Sugar Apples Barbados 400 Yam Jamaica 380 Sugar Apples Barbados 175 Shape Color Amount Results Circle Red 10 1. Use a formula in D59 that will total all shapes that are green. Triangle Green 2 2. Use a formula in D60 that will total all the Triangles. Octogan Blue 7 Heptagpn Yellow 11 Hexagon Orange 8 Circle Red 5 Triangle Green 3 Total
Sumif, Countif Functions Kindly following the instructions below and enter the appropriate formula in cell. Name Electronics SELLING PRICE Results Patricia King Laptop $ 6,665.00 Sum all Electronics that equals "Monitor" and enter in D8. Patricia King Monitor $ 5,000.00 Charles Monaghan Printer $ 7,300.00 Fred Jones Projector $ 6,500.00 In cell D11 count all electronics for Patricia King. John Paul Headset $ 5,248.00 Charlie Brown Laptop $ 6,000.00 Pink Panter Monitor $ 4,400.00 $ 4,400.00 ITEM CAR MODEL SELLING PRICE Results Retro Style Billet Grille Chevy $ 319.00 In cell D17 Sum all Car Models that equals "Dodge". Hood Vent Dodge $ 55.00 Rear Spoiler Mustang $ 220.00 Removable Roof Rack Chevy $ 63.00 Rear Hatch Accent Strip Chevy $ 25.00 Splash Guards Dodge $ 42.00 Roof Mount Bike Carrier Mustang $ 60.00 Use a formula in D23 to count all Chevy. ? Use a formula to sum the Selling Price in C24. Driver's name Item Number of Items Transport Destination John May TV $ 25.00 truck 4 Boston Peter White Washier $ 30.00 truck 3 NY Carl Anthony microwave $ 15.00 truck 3 Philadelphia Peter White TV $ 32.00 truck 4 NY Henry Price refrigerator $ 25.00 truck 3 Boston Mac Arthur Washier $ 15.00 truck 1 Baltimore Theresa Gaitor TV $ 30.00 truck 2 Philadelphia Ken Moore microwave $ 15.00 truck 1 Baltimore Use the table above to perform the following functions :- countif Total number of orders in Boston: number of microwaves orders: sumif Total sum of refrigerator items: sum of TV items: Product Supplier In Stock Results Sugar Apples Results Yam Banannas Ecudor 350 Sum all Products that equal to Sugar Apples" and enter in the Results 1 Column E48. Sugar Apples Barbados 200 Count all products that is from Jamaica and enter in Results 2 Column E49. Yam Jamaica 250 Sugar Apples Barbados 180 Banannas Ecudor 225 Sugar Apples Barbados 400 Yam Jamaica 380 Sugar Apples Barbados 175 Shape Color Amount Results Circle Red 10 1. Use a formula in D59 that will total all shapes that are green. Triangle Green 2 2. Use a formula in D60 that will total all the Triangles. Octogan Blue 7 Heptagpn Yellow 11 Hexagon Orange 8 Circle Red 5 Triangle Green 3 Total
Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
Related questions
Concept explainers
Max Function
Statistical function is of many categories. One of them is a MAX function. The MAX function returns the largest value from the list of arguments passed to it. MAX function always ignores the empty cells when performing the calculation.
Power Function
A power function is a type of single-term function. Its definition states that it is a variable containing a base value raised to a constant value acting as an exponent. This variable may also have a coefficient. For instance, the area of a circle can be given as:
Question
Sumif, Countif Functions | ||||||||
Kindly following the instructions below and enter | ||||||||
the appropriate formula in cell. | ||||||||
Name | Electronics | SELLING PRICE |
Results | |||||
Patricia King | Laptop | $ 6,665.00 | Sum all Electronics that equals "Monitor" and enter in D8. | |||||
Patricia King | Monitor | $ 5,000.00 | ||||||
Charles Monaghan | Printer | $ 7,300.00 | ||||||
Fred Jones | Projector | $ 6,500.00 | In cell D11 count all electronics for Patricia King. | |||||
John Paul | Headset | $ 5,248.00 | ||||||
Charlie Brown | Laptop | $ 6,000.00 | ||||||
Pink Panter | Monitor | $ 4,400.00 | $ 4,400.00 | |||||
ITEM | CAR MODEL | SELLING PRICE |
Results | |||||
Retro Style Billet Grille | Chevy | $ 319.00 | In cell D17 Sum all Car Models that equals "Dodge". | |||||
Hood Vent | Dodge | $ 55.00 | ||||||
Rear Spoiler | Mustang | $ 220.00 | ||||||
Removable Roof Rack | Chevy | $ 63.00 | ||||||
Rear Hatch Accent Strip | Chevy | $ 25.00 | ||||||
Splash Guards | Dodge | $ 42.00 | ||||||
Roof Mount Bike Carrier | Mustang | $ 60.00 | Use a formula in D23 to count all Chevy. | |||||
? | Use a formula to sum the Selling Price in C24. | |||||||
Driver's name | Item | Number of Items | Transport | Destination | ||||
John May | TV | $ 25.00 | truck 4 | Boston | ||||
Peter White | Washier | $ 30.00 | truck 3 | NY | ||||
Carl Anthony | microwave | $ 15.00 | truck 3 | Philadelphia | ||||
Peter White | TV | $ 32.00 | truck 4 | NY | ||||
Henry Price | refrigerator | $ 25.00 | truck 3 | Boston | ||||
Mac Arthur | Washier | $ 15.00 | truck 1 | Baltimore | ||||
Theresa Gaitor | TV | $ 30.00 | truck 2 | Philadelphia | ||||
Ken Moore | microwave | $ 15.00 | truck 1 | Baltimore | ||||
Use the table above to perform the following functions :- | ||||||||
countif | Total | |||||||
number of orders in Boston: | ||||||||
number of microwaves orders: | ||||||||
sumif | Total | |||||||
sum of refrigerator items: | ||||||||
sum of TV items: | ||||||||
Product | Supplier | In Stock | Results Sugar Apples |
Results Yam |
||||
Banannas | Ecudor | 350 | Sum all Products that equal to Sugar Apples" and enter in the Results 1 Column E48. | |||||
Sugar Apples | Barbados | 200 | Count all products that is from Jamaica and enter in Results 2 Column E49. | |||||
Yam | Jamaica | 250 | ||||||
Sugar Apples | Barbados | 180 | ||||||
Banannas | Ecudor | 225 | ||||||
Sugar Apples | Barbados | 400 | ||||||
Yam | Jamaica | 380 | ||||||
Sugar Apples | Barbados | 175 | ||||||
Shape | Color | Amount | Results | |||||
Circle | Red | 10 | 1. Use a formula in D59 that will total all shapes that are green. | |||||
Triangle | Green | 2 | 2. Use a formula in D60 that will total all the Triangles. | |||||
Octogan | Blue | 7 | ||||||
Heptagpn | Yellow | 11 | ||||||
Hexagon | Orange | 8 | ||||||
Circle | Red | 5 | ||||||
Triangle | Green | 3 | ||||||
Total | ||||||||
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education