Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

14. If cell D145 below has the formula =COUNTIF(D148:D153,D144), the result will be: >200 Hurdle # of Sales Greater Than>200 150 151 $312.00 $295.00 $294.99

image text in transcribed
14. If cell D145 below has the formula =COUNTIF(D148:D153,D144), the result will be: >200 Hurdle # of Sales Greater Than>200 150 151 $312.00 $295.00 $294.99 $675.00 $452.00 $195.00 a. #N/A b. 1 C 2 d. 5 e. $2,028.99 15. If cell D145 below has the formula =SUMIE(D148:D153,0144), the result will be: 145 Hurdle # of Sales Greater Than>4 146 150 $1.00 $2.00 $3.00 $4.00 $5.00 $6.00 153 a. #N/A b. O c. 2 d. 10 e. 11

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

Accounting Information System

Authors: James A. Hall

7th Edition

978-1439078570, 1439078572

More Books

Students also viewed these Accounting questions