part 1
- Open the following excel file: excel2016_cellbasics.xlsx
download - Select cell D6 and type hlee.
- Clear the contents in row 14.
- Delete column G.
- Using either cut and paste or drag and drop, move the contents of row 18 to row 14.
- Use the fill handle to put an X in cells F9:F17.part 2
- Open this excel file: excel2016_modifyingcells.xlsx download
- Autofit Column Width for the entire workbook.
- Modify the row height for rows 3 to 14 to 22.5 (30 pixels).
- Delete row 10.
- Insert a column to the left of column C. Type SECONDARY CONTACT in cell C2.
- Make sure cell C2 is still selected and choose Wrap Text.
- Merge and Center cells A1:F1.
- Hide the Billing Address and Phone columns
- part 3
- Open the following excel file: excel2016_formattingcells.xlsx download
- Click the Challenge worksheet tab in the bottom-left of the workbook.
- Change the cell style in cells A2:H2 to Accent 3.
- Change the font size of row 1 to 36 and the font size for the rest of the rows to 18.
- Bold and underline the text in row 2.
- Change the font of row 1 to a font of your choice.
- Change the font of the rest of the rows to a different font of your choice.
- Change the font color of row 1 to a color of your choice.
- Select all of the text in the worksheet, and change the horizontal alignment to center align and the vertical alignment to middle align.part 4
- Open the following excel file: excel2016_numberformats.xlsx download
- In cell D2, type today’s date and press Enter.
- Click cell D2 and verify that it is using a Date number format. Try changing it to a different date format (for example, Long Date).
- In cell D2, use the Format Cells dialog box to choose the 14-Mar-12 date format.
- Change the sales tax rate in cell D8 to the Percentage format.
- Apply the Currency format to all of column B.
- In cell D8, use the Increase Decimal or Decrease Decimal command to change the number of decimal places to one. It should now display 7.5%.
- part 5
- Open the following excel file: excel2016_multiplesheets.xlsx download
- Insert a new worksheet, and rename it Q1 Summary.
- Move the Expenses Summary worksheet to the far right, then move the Q1 Summary worksheet so that it is between March and April.
- Create a copy of the Expenses Summary worksheet by right-clicking the tab. Do not just copy and paste the content of the worksheet into a new worksheet.
- Change the color of the January tab to blue and the color of the February tab to red.
- Group the worksheets September, October, and November.
0 comments