De 3 - just topic, no solution PDF

Preview

Summary

just topic, no solution...

Description

ĐỀ SỐ 3 Rental Rates.xlsx File/ Save As: “ID_Name.xlsx” và thực hành trên file vừa tạo. 1. Themes: Apply the theme to the workbook: Retrospect 2. Rename Worksheet: Rename an existing worksheet - Houseboats: Rename the tab “Sales Data” 3. Change tab Color: Change the color of a worksheet tab - Sale Data worksheet, Orange, Accent 2 4. Format Worksheet: Format worksheet in a workbook - Power Boats & PWCs: Tab color: Orange, Accent 2, Darker 25% 5. Append Data: Append data to the worksheet - Row 13 on the Toys & Accessories worksheet Import MoreToys.csv located in the Gmetrix Templates folder Comma delimited, Accept all other defaults 6. Delete: Delete a roư: Row 13 on the Toys & Accessories worksheet: Remove the row 7. Renumber: Resequence numbers in a cell range. - Row 13 through 22 on the Toys & Accessories worksheet: Use AutoFill; Replace the Item # (column A); Continue sequence 11 through 20 8. Fine and Replace: Replace data in workbook - RentalRates.xlsx: Replace all instances of “Jet Ski” with Personal Watercraft” Sales Data worksheet 9. Row height: Resize row height: Row 1: “105” 10. Image: Insert a photo: Cell A1 Houseboat.jpg located in the GMetrix Templates folder, Scale Height and Width 30% Format an image: Houseboat.jpg, add a Border: - Orange, Accent 2; 4 ½ pt. 11. Remove duplicate rows: Cell range A5:J15: Use columns Length and Houseboat as criteria 12. Sort data: Cell range A5:J15: Length: Smallest to Largest; Houseboat: A to Z 13. Merge and Center: Merge a range of cells and ceneter the data within - Cell range C3:F3 (5 Day Rental): Use Merge and Center - Cell range G3:J3 (7 Day Rental): Use Merge and Center 14. Copy data from one cell range to another: Cell range A4:B13, paste into cell range A18:B27 15. Move data from one cell range to another: Cell range G3:J13, paste into cell range C17:F27 16. Resize row height: Row 3 and 17: “55” 17. Cell Alignment: Rotate the orientation of the headers: 5 Day Rental and 7 Day Rental: Angle Clockwise 18. Table: Create table - Cell range A4:F13: Table Style Medium 2; Include Headers; Name the table “FiveDayTable” - Cell range A8:F27: Table Style Medium 2; Include Headers; Name the table “SevenDayTable” 19. Apply formatting to columns: Column A through F: Resize column A: “11” Resize column B: “29”: Resize column C through F: “11”; Wrap Text in rows 4 to 18 20. Format Cells: Apply formatting to selected cells. - Cell range C3:F3 and C17:F17: Fill Color: Orange, Accent 2, Font Color: White, Background 1 21. Modify table: Expand the table. - Row 14 and 15 (FiveDay Table) Expand row 13: Cell A14 insert the text, “Average”, Cell A15 insert the text, “Unavailable Summer” Cell Style: Accent 2 - Row 28 (SevenDay Table) Expand row 27: Cell A28 insert the text, “Average” Cell Style: Accent 2 22. AVERAGE Function: Use a function to display the average of each column. - Cell range C14:F14 and C28:F28: Use AVERAGE function, 0 decimal places 23. Define name range: Create a named range for a group of cells. - Cell range D5:D13: Name the range, “Seasonal” 24. Use Named Range: Use a Named Range in a function to count the number of empty records in a range of cells - Cell D15: Use COUNTBLANK function, count all the empty cells in the named range, “Seasonal”

Power Boats & PWCs Worksheet 25. Create tables: Cell range A2:D10, Table style Medium 3, include headers 26. Format Numbers: Change the number formatting for a selected cell range. - Column C and Column D: $ English (United States) 27. Rows and Columns: Manager the rows and columns on this worksheet. - Power Boats and PWCs worksheet: Add a new row between rows 1 and 2 Resize row 1 to “105”, resize column B, C and D to autofit to contents 28. Image: Insert a photo - Cell A1: PWCs.jpg located in the Gmetrix Templates folder, Height “1.68”, Width “4.9” - Format an image: PWC.jpg - Picture style: Soft Edge Oval Toys & Accessories Worksheet 29. Apply Cell Styles: Change the style of cells - Cell range A2:F2: Themed cell Style Accent 2 30. Conditional Formatting: Create a new formatting rule - Cell range E3:E22 Format all cells based on their values: Use the Icon set style, 3 Flags Display the Green Flag when the value is >=100 Display the Yelow Flag when the value is =50 31. Resize Columns: Change the width of the columns. - Columns A through F: Autofit 32. Hyperlinks: Insert a Hyperlinks. - Cell C21: Link to cell range A8:D10 in the Power Boats and PWCs Worksheet - Cell C22: Link to cell range A8:D10 in the Power Boats and PWCs Worksheet - Cell C15: Link to “http://www.uscgboating.org” 33. Hide rows: Make rows invisible to users. - Row 17 throght 19 Hide the rows 34. AVERAGEIF Function: Use a function to display the average daily rate of Wakeboard rentals. -Cell C25: Insert text “Average Daily Rate – Wakeboards” -Cell E25: Use AVERAGEIF function: - Range: Type (B), Criteria: WakeBoard, Average_Range: Daily (E) 35. Insert Symbols: Insert Symbol. - Cell B27: Insert the Clibri Dagger Symbol “t” (Unicode “2020”) Align Cell Data: Top Align, Align right 36. CONCATENATE Function: Join text from multiple cells. - Cell C27: Wrap Text, use CONCATENATE function - Text1: “Recommend either ” (include space) - Text2: Data in cell B9 on the Power Boats and PWCs worksheet - Text3: “ or “ (include spaces) - Text4: Data in cell B10 on the Power Boats and PWCs worksheet - Text5: “ or “ (include spaces) - Text6: Data in cell B11 on the Power Boats and PWCs worksheet - Text7: End with a period 37. Create Chart: Create a chart using data from a cell range - Cell range B3:D7: 2-D Pie Chart; Position the upper-left corner of chart in cell H2 Rename of Chart 1 to “Wakeboard Chart” 38. Format Chart: Add formatting to a chart - Chart: Apply Chart Style 7, Monochromatic Color 6, Quick Layout 1 - Chart Title: Change the chart title to “Wakeboards” - ALT TEXT: Add the Title, “Wakeboard Chart” 39. Define a cell range for printing: Cell range A2:F22: Set Print Area 40. Export: Export as a .pdf and do not open the file after publishing - Cell range A2:F22 Save file as “RentalRates.pdf” in the Gmetrix Templates folder. Do not open the file after publishing 41. Document properties: Add values to ducoment property fields - Subject field: Add the property, “2015 Rental Rates” Lưu ý: Học sinh xóa bài thực hành (không xóa đề) sau khi chấm bài....