9. In cell C14, create a formula using the COUNTA function to count the number of components in the Bizzy Caz clothing set (the range B20:F20). Copy the formula from cell C14 to fill the range C15:C17 without formatting to count the number of components for the rest of the clothing sets.
9. In cell C14, create a formula using the COUNTA function to count the number of components in the Bizzy Caz clothing set (the range B20:F20). Copy the formula from cell C14 to fill the range C15:C17 without formatting to count the number of components for the rest of the clothing sets.
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
Question
I need help
![1
2
K11
3
MAGN
File
7
Default
60
11
12
13
14
15
16
AutoSave Off 19 NP_EX16_3b_Raven MarieJones_1 ✓
H Keep
17
18
19
20
21
22
23
24
25
26
27
Home Insert Page Layout Formulas Data Review View Automate Help
New Perspectives Excel 2016 | Module 3: SAM Project 1b
You've Got Style
4 PERFORMING CALCULATIONS WITH FORMULAS AND FUNCTIONS
Ready
Exit New Options
Sheet View
X✓ fx
Normal Page Break Page Custom
Preview Layout Views
Workbook Views
Documentation
B
Circular References: M6
8
9
s sheet. If your name does not appear in cell B6, please download a new copy of the
file from the SAM website.
10
#NAME?
Product Lookup Orders
Accessibility: Investigate
Navigation
+
✔Ruler
0
Gridlines Headings
Search
с
Show
0
Formula Bar
D
0
E
Zoom 100% Zoom to
Selection
0
F
Zoom
0
G
0
New Arrange Freeze
Window All Panes
H
A
0
I
0
J
Split
Hide
Unhide
0
K
View Side by Side
[DI Synchronous Scrolling
Reset Window Position
Window
0
L
0
Marie Jones
M
B
N
MJ
Switch
Windows
E
O
Comments
I
Macros
Macros
0
0
0
0
P
o o o o o
0
+
Ō
Share
Q
X
100%](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fde0a9949-9fd7-4731-897b-5ba0b9f65d7c%2Fe910d85b-6bf5-439e-96e5-2077a522cdcb%2Fw6oga4n_processed.png&w=3840&q=75)
Transcribed Image Text:1
2
K11
3
MAGN
File
7
Default
60
11
12
13
14
15
16
AutoSave Off 19 NP_EX16_3b_Raven MarieJones_1 ✓
H Keep
17
18
19
20
21
22
23
24
25
26
27
Home Insert Page Layout Formulas Data Review View Automate Help
New Perspectives Excel 2016 | Module 3: SAM Project 1b
You've Got Style
4 PERFORMING CALCULATIONS WITH FORMULAS AND FUNCTIONS
Ready
Exit New Options
Sheet View
X✓ fx
Normal Page Break Page Custom
Preview Layout Views
Workbook Views
Documentation
B
Circular References: M6
8
9
s sheet. If your name does not appear in cell B6, please download a new copy of the
file from the SAM website.
10
#NAME?
Product Lookup Orders
Accessibility: Investigate
Navigation
+
✔Ruler
0
Gridlines Headings
Search
с
Show
0
Formula Bar
D
0
E
Zoom 100% Zoom to
Selection
0
F
Zoom
0
G
0
New Arrange Freeze
Window All Panes
H
A
0
I
0
J
Split
Hide
Unhide
0
K
View Side by Side
[DI Synchronous Scrolling
Reset Window Position
Window
0
L
0
Marie Jones
M
B
N
MJ
Switch
Windows
E
O
Comments
I
Macros
Macros
0
0
0
0
P
o o o o o
0
+
Ō
Share
Q
X
100%
![AutoSave Off 19 Instructions_NP_EX16_3b • Saved to this PC ✓
File Home Insert Draw Design Layout
Show All ✔
Page 2 of 4
1052 words
N Text Predictions: On
References
Accessibility: Investigate
Mailings
9.
Review View
10.
Search
In cell C14, create a formula using the COUNTA function to count the number
of components in the Bizzy Caz clothing set (the range B20:F20). Copy the
formula from cell C14 to fill the range C15:C17 without formatting to count the
number of components for the rest of the clothing sets.
The data section called Product Information Lookup uses a mix of user input
cells, output cells, and calculated cells to display various information for a
single clothing set. Format the section as follows:
Apply the Input cell style to cell 15.
Apply the Output cell style to the range 16:18.
Apply the Calculation cell style to cell 19.
11. In cell 16, create a formula using the VLOOKUP function to display the number
of items in the selected clothing set. Use the clothing set listed in cell 15 as the
lookup value, the range A14:D17 as the table array, column number 2 as the
column index number, and FALSE as the range lookup value. Use absolute
references for cell 15 and the range A14:D17.
a.
b.
Help
C.
12. In cell 19, create a formula without using a function that first adds the selected
boxed set's net weight (cell 18) to the packing weight (cell F5), and then
divides the value by 16 to show the shipping weight in pounds.
13. The delivery service used by the company charges a higher rate for packages
weighing over 40 lbs.
In cell I10, create a formula that uses the IF function to determine if a
packaged clothing set is overweight by checking if the shipping weight (cell 19)
is greater than 40. If this condition is true, the cell should display Yes, and if it
is false, the cell should display No. (Hint: Use "Yes" for the value if true, and
"No" for the value if false.)
14. The company can make more profit by keeping shipping costs to a minimum.
Felicia has been put in charge of the packaging redesign project, and she needs
Focus
Marie Jones MJ
Comments
80
e
Editing ✓
+
Ō X
Share ✔
100%](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fde0a9949-9fd7-4731-897b-5ba0b9f65d7c%2Fe910d85b-6bf5-439e-96e5-2077a522cdcb%2Fsma8s3p_processed.png&w=3840&q=75)
Transcribed Image Text:AutoSave Off 19 Instructions_NP_EX16_3b • Saved to this PC ✓
File Home Insert Draw Design Layout
Show All ✔
Page 2 of 4
1052 words
N Text Predictions: On
References
Accessibility: Investigate
Mailings
9.
Review View
10.
Search
In cell C14, create a formula using the COUNTA function to count the number
of components in the Bizzy Caz clothing set (the range B20:F20). Copy the
formula from cell C14 to fill the range C15:C17 without formatting to count the
number of components for the rest of the clothing sets.
The data section called Product Information Lookup uses a mix of user input
cells, output cells, and calculated cells to display various information for a
single clothing set. Format the section as follows:
Apply the Input cell style to cell 15.
Apply the Output cell style to the range 16:18.
Apply the Calculation cell style to cell 19.
11. In cell 16, create a formula using the VLOOKUP function to display the number
of items in the selected clothing set. Use the clothing set listed in cell 15 as the
lookup value, the range A14:D17 as the table array, column number 2 as the
column index number, and FALSE as the range lookup value. Use absolute
references for cell 15 and the range A14:D17.
a.
b.
Help
C.
12. In cell 19, create a formula without using a function that first adds the selected
boxed set's net weight (cell 18) to the packing weight (cell F5), and then
divides the value by 16 to show the shipping weight in pounds.
13. The delivery service used by the company charges a higher rate for packages
weighing over 40 lbs.
In cell I10, create a formula that uses the IF function to determine if a
packaged clothing set is overweight by checking if the shipping weight (cell 19)
is greater than 40. If this condition is true, the cell should display Yes, and if it
is false, the cell should display No. (Hint: Use "Yes" for the value if true, and
"No" for the value if false.)
14. The company can make more profit by keeping shipping costs to a minimum.
Felicia has been put in charge of the packaging redesign project, and she needs
Focus
Marie Jones MJ
Comments
80
e
Editing ✓
+
Ō X
Share ✔
100%
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
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)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education