Insert a Custom Footer with the File name in the left section and then save your workbook. On the Seattle Inventory worksheet, in cell B5, enter a function that will display the average retail price. In cell B6, enter a function that will display the median retail price. In cell B7, enter a function that will calculate the lowest retail price. In cell

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
Assignment Instructions
Insert a Custom Footer with the File name in the left section
and then save your workbook.
On the Seattle Inventory worksheet, in cell B5, enter a function
that will display the average retail price. In cell B6, enter a
function that will display the median retail price. In cell B7,
enter a function that will calculate the lowest retail price. In cell
B8, enter a function that will calculate the highest retail price.
Format the range B5:B8 with Accounting Number Format.
10
On the Seattle Inventory worksheet, in cell G14 , enter an IF
function to determine the items to be ordered. If the Quantity in
Stock is less than 50, then the cell should display Order. If not,
then the cell should display OK Copy the function down
through cell G19.
11
10
12
Format the range A13 G19 as a table with headers and then
apply Table Style Medium 5. (NOTE: Depending on the version
of Excel installed on your system, the style name may display
8.
9,
Transcribed Image Text:Assignment Instructions Insert a Custom Footer with the File name in the left section and then save your workbook. On the Seattle Inventory worksheet, in cell B5, enter a function that will display the average retail price. In cell B6, enter a function that will display the median retail price. In cell B7, enter a function that will calculate the lowest retail price. In cell B8, enter a function that will calculate the highest retail price. Format the range B5:B8 with Accounting Number Format. 10 On the Seattle Inventory worksheet, in cell G14 , enter an IF function to determine the items to be ordered. If the Quantity in Stock is less than 50, then the cell should display Order. If not, then the cell should display OK Copy the function down through cell G19. 11 10 12 Format the range A13 G19 as a table with headers and then apply Table Style Medium 5. (NOTE: Depending on the version of Excel installed on your system, the style name may display 8. 9,
Cipboard
Font
Alignment
Number
Styles
G
H
Seattle Facility: Inventory Status of Apparel
As of December 31, 2016
Total Items in Stock
271
Average Price
Median Price
Lowest Price
Highest Price
Ski Products
Ski Quantity in Stock
Quantity in Stock
Item
Item Name
Retail Price
Category
Sport
Stock Level
32
115689 Deluxe Biking Shorts
69.52 Pants
Biking
78
114568 Vented Explorer
34.78 Hats
Hiking
28
456897 Wicked Heavy Socks
9.35 Socks and Gloves
Skiing
58
465899 Gripper Gloves
25.55 Socks and Gloves
Sking
57
465888 Airflow Hat
2.99 Hats
Hiking
18
165332 Mini Crew Socks
6.45 Socks and Gloves
Fitness
Net Sales by State
Net Sales
Seattle Inventory
Denver Inventory
Inventory Summary
Sales Reps
Type here to search
Transcribed Image Text:Cipboard Font Alignment Number Styles G H Seattle Facility: Inventory Status of Apparel As of December 31, 2016 Total Items in Stock 271 Average Price Median Price Lowest Price Highest Price Ski Products Ski Quantity in Stock Quantity in Stock Item Item Name Retail Price Category Sport Stock Level 32 115689 Deluxe Biking Shorts 69.52 Pants Biking 78 114568 Vented Explorer 34.78 Hats Hiking 28 456897 Wicked Heavy Socks 9.35 Socks and Gloves Skiing 58 465899 Gripper Gloves 25.55 Socks and Gloves Sking 57 465888 Airflow Hat 2.99 Hats Hiking 18 165332 Mini Crew Socks 6.45 Socks and Gloves Fitness Net Sales by State Net Sales Seattle Inventory Denver Inventory Inventory Summary Sales Reps Type here to search
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY