FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need the formula for the following How many TVs were sold by Billy? What is the sales total using the store card? Excel. Store Card

Need the formula for the following How many TVs were sold by Billy? What is the sales total using the store card? Excel.

image text in transcribed

Store Card N Y Y N. N Transaction ID# Dept 103180 Cameras 391615 TV 424445 TV 321265 Computers 25795 Phones 447895 Appliances 337680 Music 316575 Music 480725 Appliances 541695 Computers 227465 Cameras 504175 Cameras 213395 TV 548730 TV 553350 Phones 440045 Music 437410 Phones 374170 Appliances Salesperson Micky Jiggy Billy Jiggy Billy Kimmy Kimmy Micky Jiggy Billy Jiggy Kimmy Micky Micky Jiggy Jiggy Kimmy Billy N N Amount 416.79 2145.89 679.36 912.99 45.56 231.67 38.99 43.78 128.99 . 499.99 255.67 . 667.23 455.8 1677.77 87.69 32.15 112.16 512.49 Y N N Y N N

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Theory Icdt 99 7th International Conference Jerusalem Israel January 10 12 1999 Proceedings Lncs 1540

Database Theory Icdt 99 7th International Conference Jerusalem Israel January 10 12 1999 Proceedings Lncs 1540

Authors: Catriel Beeri ,Peter Buneman

1st Edition

3540654526, 978-3540654520

More Books

Students also viewed these Databases questions

Question

★★★★★
In 2008, Doolan Company sold 10,000 unitsof inventory at twice their purchase price of $27.50 each. In 2009, Doolan had a gross prot of $200,000 and cost of goods sold of $225,000. Required: (a) What...

Answered: 1 week ago

Question

★★★★★
An investor has two bonds in his portfolio that have a face value of $1,000 and pay a 9% annual coupon. Bond L matures in 12 years, while Bond S matures in 1 year. What will the value of the Bond L...

Answered: 1 week ago

Question

★★★★★
What cultural influences need to be considered when choosing an effective leadership style?

Answered: 1 week ago

Question

★★★★★
Selected accounts from Keystone Furnitures adjusted trial balance as of August 31, 2014, the end of the fiscal year, follow. Required 1. Prepare a multistep income statement for Keystone. Store...

Answered: 1 week ago

Question

★★★★★
Need the formula for the following How many TVs were sold by Billy? What is the sales total using the store card? Excel. Store Card N Y Y N. N Transaction ID# Dept 103180 Cameras 391615 TV 424445 TV...

Answered: 1 week ago

Question

★★★★★
Assume that, in a TCP connection the initial sequence numbers chosen by the client and the server are 8 0 0 0 and 9 0 0 0 respectively. Clearly show values of sequence no . , acknowledgement no ....

Answered: 1 week ago

Question

★★★★★
Two desks are setup parallel (customer may choose any of these two desks). Each desk takes 26 minutes with each customer. What is the throughput of this parallel system? Provide your answer in...

Answered: 1 week ago

Question

★★★★★
Entrepreneur and firm founder Oscar Farinetti has said that Eataly's "informal style of communication shows how direct and approachable we are, just the way people like." A focus on customer...

Answered: 1 week ago

Question

★★★★★
Bank Organizer Printers Inc, produces luxury checkbooks with three checks and stubs per page. Each checkbook is designed for an individual customer and is ordered through the customers bank. The...

Answered: 1 week ago

Question

★★★★★
PA1 LO 10.1 Artisan Metalworks has a bottleneck in their production that occurs within the engraving department. Jamal Moore, the COO is considering hiring an extra worker, whose salary will be...

Answered: 1 week ago

Question

★★★★★
CASE STUDY Should Packing Be Postponed to the DC? Penang Electronics (PE) is a contract manufacturer that produces and packages private-label products for several retail chains, including Target,...

Answered: 1 week ago

Question

★★★★★
7-14 What kind of technology does your school or university library use? Does IT play a crucial role in managing operations? RFID (Radio-frequency Identification) can play a key role in library...

Answered: 1 week ago

Question

★★★★★
7-15 How is RFID technology helping the Allianze University College of Medical Sciences library to detect and prevent the theft of books? RFID (Radio-frequency Identification) can play a key role in...

Answered: 1 week ago

Question

★★★★★
7-11 This project will help develop your Internet skills in using Web search engines for business research. Use Google and Bing to obtain information about the Internet of Things. If you wish, try...

Answered: 1 week ago

Previous Question Next Question