Microsoft Excel Assignment (Very easy follow the directions)

Anonymous
timer Asked: Mar 3rd, 2019
account_balance_wallet $15

Question Description

Very easy follow the directions excel assignment.

Unformatted Attachment Preview

USING MICROSOFT EXCEL 2016 Guided Project 1-3 Guided Project 1 -3 In this project, you edit a worksheet for Wear-Ever Shoes that tracks their product inventory. You change the zoom size, reset the panes, and format data. You copy an existing formula to calculate the value of the current stock and insert a column for new data. After adjusting print options, you set a print area for a specific product line. Skills Covered in This Project • • • • • • Step 1: Download start file Open and save a workbook. Change zoom size and remove a split. Freeze panes. Format labels and values. Use the Fill Handle to copy a formula and fill a series. Check spelling. • Apply a workbook theme, cell styles, and • • • • • font attributes. Merge and center labels. Insert a column and adjust column widths and row heights. Adjust alignment, indents, and borders. Rename the sheet tab. Use Page Layout view to insert a footer. 1. Open the WearEverShoes-01.xlsx start file. If the workbook opens in Protected View, click the Enable Editing button so you can modify it. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it. 2. Remove a split and freeze panes. a. Click the Split button [View )< ,I f. E31 tab, Window group]. The split A B C D F G H is removed. 1 Wear-Ever Shoes b. Click cell A4 to freeze the 2 Current Stock 3 Product ID Product Co lo r Size Quantity Men's or\ Cost Value column titles at this position. 16 WE013 Comfy Walking Shoes Taupe 7.5 2W 47.5 c. Click the Freeze Panes 17 WE014 Comfy Walking Shoes Brown 8 3W 47.5 La2y Flip-Flops 18 WE015 6 4W 7.5 Pink button [View tab, Window 19 WE016 Lazy Flip-Flops Pink 7 ow 7.5 group]. La2y Flip-Flops 2W 7.5 20 WE017 Pink 8 La2y Flip-Flops d. Choose Freeze Panes. There 21 WE018 Whit e 6 3W 7.5 La,y Flip-Flops White 7 lW 7 .5 22 WE019 is a solid border between La2y Flip-Flops 23 WE020 White 8 2W 7.5 rows 3 and 4 to mark the La2y Flip-Flops Brown 8 2M 7.5 24 WE021 La2y Flip-Flops 25 WE022 Brown 9 4M 7.5 pane. 26 WE023 Lazy Flip-Flops Brow n 10 2M 7 .5 e. Scroll to row 31 and click cell La2y Flip-Flops 27 WE024 Brown 11 2M 7.5 28 WE025 Seriously Tall Boots Black 6 ow 42.5 E31. The column titles are 29 WE026 Seriously Tall Boots Black 6.5 ow 42.5 frozen. 30 WE027 Seriously Tall Boots Black 7 1W 42.5 . Seriously Tall Boots Black 42.5 K j wE028 7.51 3j w f. Type 3 and press Enter (Figure 1-91). 1-91 Panes frozen at cell A4 g. Press Ctrl+Home. The insertion point returns to cell A4. 3. Change zoom size and unfreeze the pane. a. Click the 100% button [View tab, Zoom group]. b. Click the Freeze Panes button [View tab, Window group]. c. Choose Unfreeze Panes. d. Click cell A1. Excel 2016 Chapter 1 Creating and Editing Workbooks Last Updated: 11/27/17 Page 1 USING MICROSOFT EXCEL 2016 Guided Project 1-3 4. Check spelling in the worksheet. a. Select B4:B11. Click the Spelling button [Review tab, Proofing group]. The first occurrence of “Hikin” is found as misspelled. b. Select Hiking in the Suggestions list. c. Click Change All to correct all occurrences of the misspelled word (Figure 1-92). d. Click OK. JI) v l!El ,pt! ,g Sm.rt ramml"'f'lt ~',,id< P es a, a, l~dUI~ , ii;;i~ Prolul Prol~ct Sh~,e '""Sh,,t W i WE004 WE005 WE006 WE007 WE008 WE009 v~tu I U VVCV I I WE0 12 WE0 13 WE0 14 WE0 15 WE0 16 WE0 17 VVtv l i:l WE0 19 WE020 WE02 1 WE022 WE023 WE024 VVCV.C'-' vvcv.cc WE027 WE028 WE029 WE030 WE03 1 WE032 VVt::U,>,> WE034 WE035 WE036 Disc? No No Yes No No Yes No No Ye s No No Yes No No Yes No No Yes No No Yes No No Yes NO NO Yes No No Yes No No Yes No No Yes Product Ru gged Hiking Boots Ru gg e d Hiking Boots lnoe s L.omty VVa lKIng :>noe s Comfy Wa lking Shoes Comfy Wa lking Shoes Comfy Wa lking Shoes La zy Fri p-Flops La zy Fri p-Flops La zy Fri p-Flops La zy t-ll p-t-lops Lazy Fri p-Flops Lazy Fri p-Flops La zy Fri p-Flops Lazy Fri p-Flops Lazy Fri p-Flops La zy Fri p-Flops :>e nousIy 10 11 ~oo rs :>e nously I O U ~OO TS Se riously Ta ll Boo ts Se riously Ta ll Boo ts Se riously Ta II Boo ts Se riously Ta ll Boo ts G lid e Running Shoes G lid e Running Shoes G lid e lhoes G lid e Running Shoes G lid e Runn ing Shoes G lid e Running Shoes Color Brown Brown ~lack Blac k Black Black Brown Brown Brown ~ la cK Navy Black Ta upe Brown Pin k Pink Pin k vvn rre Wh rte Wh rte Brow n Brow n Brown Brown ~la CK ~laCK Black Black Black Black Wh rte Wh rte vvn rte Black Black Black Size 8 10 Qua ntity 5 3 'U , 6 10.5 7. 5 8 9 8.5 8.5 4 Men 's or Women's Cost $ 46.50 $ 46.50 $ 46.:,U $ 46.50 $ 53.50 $ 53.50 $ 53.50 $ 53.50 $ 47.50 ;t, 41 .~ $ 41 .~ $ 47 .50 47 .50 47 .50 7.50 7.50 ~ $ 7.50 $ / .:,U 7.50 7.50 7.50 ~ 7.50 ~ $ 7.50 $ 7.50 ;i, 4L.~ ;i, 4L.~ $ 42.50 $ 42.50 $ 42.50 $ 42.50 $ 48.00 Value $ 232.50 $ 139.50 $ Ln.UU $ 186.00 $ 2 14.00 $ 107.00 $ 160.50 $ 107 .00 $ 190 .00 ;i, 41 .~ $ l 'iU.UU $ 47 .50 95.00 142.50 30.00 $ 48.00 $ M $ 46.W $ M M M $ 48.00 $ 48.00 $ 48.00 $ $ M M M M 2 3 2 w w w w 4 4 M 't I M / _::, 8 7.5 8 6 7 8 4 vv l 2 3 4 0 2 6 7 8 8 9 10 11 ;; l 2 2 4 2 2 0 u 6.:C, u 7 7.5 8 8.5 8 9 l 3 2 l 6 6 6 2 3 l IU 8 9 10 w w w w w w w w w M M M M vv vv w w w w M M $ 15.00 $ zz.w $ $ 7.50 15.00 15.00 30.00 15.00 15.00 ;i, $ $ $ $ $ $ $ Reta il Reorder 90 N y 90 ;,u N 90 N 98 N y 98 98 N y 98 65 N o" r o:i 65 65 65 14 14 14 N y N N y 14 N 14 14 14 14 14 14 N OU 42.50 127.50 85.00 42.50 288.00 288.00 LOO.OU 96.00 144.00 48.00 y N y y N y y r O'U T 80 80 80 80 y y y y 75 75 N N le N 75 75 75 N N y 1-97 Excel 1-3 completed Excel 2016 Chapter 1 Creating and Editing Workbooks Last Updated: 11/27/17 Page 5 Wear-Ever Shoes Current Stock Product ID Product WE001 Rugged Hikin Boots WE002 Rugged Hikin Boots WE003 Rugged Hikin Boots WE004 Rugged Hikin Boots WE005 Rugged Hikin Boots WE006 Rugged Hikin Boots WE007 Rugged Hikin Boots WE008 Rugged Hikin Boots WE009 Comfy Walking Shoes WE010 Comfy Walking Shoes WE011 Comfy Walking Shoes WE012 Comfy Walking Shoes WE013 Comfy Walking Shoes WE014 Comfy Walking Shoes WE015 Lazy Flip-Flops WE016 Lazy Flip-Flops WE017 Lazy Flip-Flops WE018 Lazy Flip-Flops WE019 Lazy Flip-Flops WE020 Lazy Flip-Flops WE021 Lazy Flip-Flops WE022 Lazy Flip-Flops WE023 Lazy Flip-Flops WE024 Lazy Flip-Flops WE025 Seriously Tall Boots WE026 Seriously Tall Boots WE027 Seriously Tall Boots WE028 Seriously Tall Boots WE029 Seriously Tall Boots WE030 Seriously Tall Boots WE031 Glide Running Shoes WE032 Glide Running Shoes WE033 Glide Running Shoes WE034 Glide Running Shoes WE035 Glide Running Shoes WE036 Glide Running Shoes Color Brown Brown Black Black Black Black Brown Brown Brown Black Navy Black Taupe Brown Pink Pink Pink White White White Brown Brown Brown Brown Black Black Black Black Black Black White White White Black Black Black Size Quantity 8 10 9.5 10.5 7.5 8 9 8.5 8.5 9 7.5 8 7.5 8 6 7 8 6 7 8 8 9 10 11 6 6.5 7 7.5 8 8.5 8 9 10 8 9 10 5 3 6 4 4 2 3 2 4 1 4 1 2 3 4 0 2 3 1 2 2 4 2 2 0 0 1 0 2 1 6 6 6 2 3 1 Men's or Women's Cost Value M 46.5 232.5 M 46.5 M 46.5 M 46.5 W 53.5 W 53.5 W 53.5 W 53.5 M 47.5 M 47.5 W 47.5 W 47.5 W 47.5 W 47.5 W 7.5 W 7.5 W 7.5 W 7.5 W 7.5 W 7.5 M 7.5 M 7.5 M 7.5 M 7.5 W 42.5 W 42.5 W 42.5 W 42.5 W 42.5 W 42.5 M 48 M 48 M 48 M 48 M 48 M 48 Retail 90 90 90 90 98 98 98 98 65 65 65 65 65 65 14 14 14 14 14 14 14 14 14 14 80 80 80 80 80 80 75 75 75 75 75 75 Reorder N Y N N N Y N Y N Y N Y N Y N N Y N N Y Y N Y Y Y Y Y Y Y Y N N N N N Y ...
Purchase answer to see full attachment

Tutor Answer

ProgrammerOctavia
School: Purdue University

Hello buddy...

flag Report DMCA
Review

Anonymous
Good stuff. Would use again.

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors