Steps to complete This Project Mark the steps as checked when you complete them 1 Open the workbook EX 2 0 2 1 GuidedProject 1 3 xlsx start file If the workbook opens in Protected View, clickEnable Editing in the security bar 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 Open the workbook WearEver 0 1 xlsx downloaded from the Resources link If the workbook opens in Protected View, click Enable Editing in the security bar 3 Zoom out and unfreeze panes a Click the Zoom Out button in the Status bar five times to return to a 1 0 0 zoom size b Click the Unfreeze Panes button View tab, Window group c Click the Switch Windows button View tab, Window group d Confirm that WearEver 0 1 and your name EX 2 0 2 1 GuidedProject 1 3 are both open e Display the WearEver 0 1 workbook 4 Copy a worksheet to another workbook a Right click the Sheet 1 tab in WearEver 0 1 and choose Move or Copy b Click the To book drop down list and select your name EX 2 0 2 1 GuidedProject 1 3 c Select the Create a copy box ( Figure 1 1 0 1 ) Figure 1 1 0 1 Select the destination workbook for the copied sheet d Click OK The copied sheet inserts as Sheet 1 ( 2 ) in your name EX 2 0 2 1 GuidedProject 1 3 and is active e Click the Switch Windows button View tab,Window group and choose WearEver 0 1 f Close the workbook without saving g Verify that you are working in your name EX 2 0 2 1 GuidedProject 1 3 5 Rename and delete sheets a Double click the Sheet 1 ( 2 ) tab b Type Inventory and press Enter c Right click the Sheet 1 tab and choose Delete 6 Fill a label series and delete a column a Click cell A 4 b Type WEA 0 0 1 and press Enter c Select A 4 and double click its Fill Handle d Right click the column J heading and choose Delete 7 Use the Fill Handle to copy a formula a Click H 4 The formula displays in the Formula bar The formula multiplies the quantity by the cost to calculate the value of the current stock ( Figure 1 1 0 2 ) Figure 1 1 0 2 Formula to be copied b Double click the Fill pointer for cell H 4 The formula is copied down the column ( Press Enter to complete the function if you didn t double click fast enough ) 8 Merge across and set word wrap a Select cells A 1 I 2 b Click the Merge Center button arrow Home tab, Alignment group ( Figure 1 1 0 3 ) Figure 1 1 0 3 Use Merge Across to combine cells without centering the data c Select Merge Across The cells in each row are merged and the labels are left aligned d Select cell F 3 and click the Expand Formula Bar arrow at the right edge of the Formula bar ( Figure 1 1 0 4 ) The label has a line break after the word or , but the row is not tall enough to display two lines Figure 1 1 0 4 Label that was typed with a line break e Click the Wrap Text button Home tab, Alignment group The row height adjusts to display the label on two lines f Collapse the Formula bar 9 Change alignment and format data a Select cells A 4 C 3 9 and click the Increase Indent button Home tab, Alignment group once This moves the label away from the border for easier reading b Select cells F 4 F 3 9 and click the Center button Home tab, Alignment group c Select cells G 4 I 3 9 d Click the Number Format drop down list Home tab, Number group and choose Currency e Select cells A 1 A 2 and click the Font Size arrow Home tab, Font group f Choose 2 0 as the new size g Select cells A 3 I 3 and click the Bold button Home tab, Font group h Click the Format button Home tab, Cells group and choose Row Height i Type 3 5 and press Enter 1 0 Display and calculate total inventory value a Click cell G 4 0 b Type Current Inventory Value at Cost and press Enter c Select cell G 4 0 and click the Bold button Home tab, Font group d Click the Align Right button Home tab, Alignment group e Select cell H 4 0 and double click the AutoSum button Home tab, Editing group f AutoFit column H to display the value 1 1 Add borders and set row height a Select cells A 3 I 4 0 b Click the Borders drop down arrow Home tab, Font group and select All Borders c Select cells A 4 I 4 0 d Click the Format button Home tab, Cells group and choose Row Height e Type 2 0 and press Enter f Press fn control Left Arrow 1 2 Use Page Layout view to insert a footer a Click the Page Layout view button in the Status bar b Click the center header section The Header Footer tab displays c Click the Go to Footer button Header Footer tab, Navigation group d Click the right section e Click the File Name button in the Header Footer Elements group The code is File f Click a worksheet cell to see the file name g Switch to Normal view and press fn control Left Arrow 1 3 Change page setup options a Click File on the Excel menu bar and choose Print b Click the Next Page button two or three times to see how the worksheet spreads across printed pages The number of pages depends on

Question

Steps to complete This Project Mark the steps as checked when you complete them  1   Open the workbook EX 2 0 2 1   GuidedProject   1   3   xlsx start file  If the workbook opens in Protected View, clickEnable Editing in the security bar  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   Open the workbook WearEver   0 1   xlsx downloaded from the Resources link  If the workbook opens in Protected View, click Enable Editing in the security bar  3   Zoom out and unfreeze panes  a   Click the Zoom Out button in the Status bar five times to return to a 1 0 0   zoom size  b   Click the Unfreeze Panes button   View tab, Window group     c   Click the Switch Windows button   View tab, Window group     d   Confirm that WearEver   0 1 and   your name     EX 2 0 2 1   GuidedProject   1   3 are both open  e   Display the WearEver   0 1 workbook  4   Copy a worksheet to another workbook  a   Right   click the Sheet 1 tab in WearEver   0 1 and choose Move or Copy  b   Click the To book drop   down list and select   your name     EX 2 0 2 1   GuidedProject   1   3   c   Select the Create a copy box ( Figure 1   1 0 1 )   Figure 1   1 0 1 Select the destination workbook for the copied sheet d   Click OK   The copied sheet inserts as Sheet 1 ( 2 ) in   your name     EX 2 0 2 1   GuidedProject   1   3 and is active  e   Click the Switch Windows button   View tab,Window group   and choose WearEver   0 1   f   Close the workbook without saving  g   Verify that you are working in   your name     EX 2 0 2 1   GuidedProject   1   3   5   Rename and delete sheets  a   Double   click the Sheet 1 ( 2 ) tab  b   Type Inventory and press Enter  c   Right   click the Sheet 1 tab and choose Delete  6   Fill a label series and delete a column  a   Click cell A 4   b   Type WEA 0 0 1 and press Enter  c   Select A 4 and double   click its Fill Handle  d   Right   click the column J heading and choose Delete  7   Use the Fill Handle to copy a formula  a   Click H 4   The formula displays in the Formula bar  The formula multiplies the quantity by the cost to calculate the value of the current stock ( Figure 1   1 0 2 )   Figure 1   1 0 2 Formula to be copied b   Double   click the Fill pointer for cell H 4   The formula is copied down the column   ( Press Enter to complete the function if you didn t double   click fast enough   ) 8   Merge across and set word wrap  a   Select cells A 1  I 2   b   Click the Merge   Center button arrow   Home tab, Alignment group   ( Figure 1   1 0 3 )   Figure 1   1 0 3 Use Merge Across to combine cells without centering the data c   Select Merge Across  The cells in each row are merged and the labels are left   aligned  d   Select cell F 3 and click the Expand Formula Bar arrow at the right edge of the Formula bar ( Figure 1   1 0 4 )   The label has a line break after the word or , but the row is not tall enough to display two lines  Figure 1   1 0 4 Label that was typed with a line break e   Click the Wrap Text button   Home tab, Alignment group     The row height adjusts to display the label on two lines  f   Collapse the Formula bar  9   Change alignment and format data  a   Select cells A 4  C 3 9 and click the Increase Indent button   Home tab, Alignment group   once  This moves the label away from the border for easier reading  b   Select cells F 4  F 3 9 and click the Center button   Home tab, Alignment group     c   Select cells G 4  I 3 9   d   Click the Number Format drop   down list   Home tab, Number group   and choose Currency  e   Select cells A 1  A 2 and click the Font Size arrow   Home tab, Font group     f   Choose 2 0 as the new size  g   Select cells A 3  I 3 and click the Bold button   Home tab, Font group     h   Click the Format button   Home tab, Cells group   and choose Row Height  i   Type 3 5 and press Enter  1 0   Display and calculate total inventory value  a   Click cell G 4 0   b   Type Current Inventory Value at Cost and press Enter  c   Select cell G 4 0 and click the Bold button   Home tab, Font group     d   Click the Align Right button   Home tab, Alignment group     e   Select cell H 4 0 and double   click the AutoSum button   Home tab, Editing group     f   AutoFit column H to display the value  1 1   Add borders and set row height  a   Select cells A 3  I 4 0   b   Click the Borders drop   down arrow   Home tab, Font group   and select All Borders   c   Select cells A 4  I 4 0   d   Click the Format button   Home tab, Cells group   and choose Row Height  e   Type 2 0 and press Enter  f   Press fn   control   Left Arrow  1 2   Use Page Layout view to insert a footer  a   Click the Page Layout view button in the Status bar  b   Click the center header section  The Header   Footer tab displays  c   Click the Go to Footer button   Header   Footer tab, Navigation group     d   Click the right section  e   Click the File Name button in the Header   Footer Elements group  The code is     File     f   Click a worksheet cell to see the file name  g   Switch to Normal view and press fn   control   Left Arrow  1 3   Change page setup options  a   Click File on the Excel menu bar and choose Print  b   Click the Next Page button two or three times to see how the worksheet spreads across printed pages  The number of pages depends on

Accepted Answer

The Answer is in the image, click to view ...

Question

Steps to complete This Project Mark the steps as checked when you complete them. 1 . Open the workbook EX 2 0 2 1 -

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

MySQL/PHP Database Applications

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question