Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For quick access, place your faverites here on the favorites bar. 5 8 minutes remaining O ? table [ [ ing O ? ,

For quick access, place your faverites here on the favorites bar.
58 minutes remaining
O?
\table[[ing O?,,,],[4,Shipped,Total Revenue,Transit KM],[5,78100,204,346,300,33070],[6,60900,194,647,000,45130],[7,45400,174,823,800,14840],[8,77300,229,304,800,30740],[9,50400,245,027,700,39750],[10,50200,204,694,500,34010],[11,54800,210,460,100,33880],[12,66800,148,113,900,36700],[13,60100,237,597,000,39110],[14,72500,223,950,600,45870],[15,48700,106,501,200,36130],[16,48800,159,203,600,46030],[17,54200,183,326,000,43460],[18,,,],[19,,,],[20,,,],[21,,,]]
What is the correct function to use to determine how many times the quantity shipped was greater than 50,000?
= Count|F(FB:B17,>50000)
= CountIF(B5:B17,">50000")
CountIF(B5:B17,"(:>50,000''}
= CountIF(B5:B17,(:50000}
CountiF(B5:B17,">50000")
Last saved 12:06;00 PM
Questions Filter (14)
Search
image text in transcribed

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

Step: 3

blur-text-image

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

Databases Illuminated

Authors: Catherine M. Ricardo, Susan D. Urban, Karen C. Davis

4th Edition

1284231585, 978-1284231588

More Books

Students also viewed these Databases questions

Question

Why is physical location critical for a distribution business?

Answered: 1 week ago