Скачать или смотреть Excel Module 6 SAM 1b | Shelly Cashman 365/2021 | SC EX365 2021 6b | Roscoe’s Sports Blog

Contact Us
Whatsapp No : +994-401583314

#Shelly_Cashman_Excel_365/2021_Module_6_SAM_Project_1b
Shelly Cashman Excel 365/2021 | Module 6: SAM Project 1b
Roscoe’s Sports Blog
• Save the file SC_EX365_2021_6b_FirstLastName_1.xlsx as SC_EX365_2021_6b_FirstLastName_2.xlsx
o Edit the file name by changing “1” to “2”.
o If you do not see the .xlsx file extension, do not type it. The file extension will be added for you automatically.
• With the file SC_EX365_2021_6b_FirstLastName_2.xlsx open, ensure that your first and last name is displayed in cell B6 of the Documentation worksheet.
o If cell B6 does not display your name, delete the file and download a new copy.

PROJECT STEPS
1. Jack Roscoe started running a sports blog two years ago, and since then, it has provided a second income for him and his family. Jack is reviewing the recent articles written for the blog along with the payments to the authors and the income from ads. He asks for your help in using Excel tables to analyze the data.

Go to the August Articles worksheet, which lists the articles published in August 2024.

Create a table as follows so that Jack can summarize and filter the data and display articles with the highest payment amounts:
a. Format the August articles data (range A1:G26) as a table using Aqua, Table Style Medium 5.
b. Use AugArticles as the name of the table.
c. Filter the table using a custom AutoFilter to display projects with a Payment amount greater than or equal to $500.
2. Go to the Current Articles worksheet, which contains the CurrentArticles table listing articles that are scheduled for publication during the first 10 days in September. Jack received a proposal for a new article that he wants to publish on September 10.

Insert a row to the end of the CurrentArticles table for a new record containing the data shown in Table 1.
3. Sort the CurrentArticles table in descending order by payment amount so that Jack can quickly track the payments for each article.
4. Jack wants to list the published articles in a separate part of the worksheet.

Use an advanced filter as follows to list these articles in a new range:
a. In cell I18, type Yes as the value to filter on in the criteria range.
b. Create an advanced filter using the CurrentArticles table (range A1:I13) as the List range.
c. Use the range A17:I18 as the Criteria range.
d. Copy the results to another location, starting in the range A20:I20.
5. As a contrast, Jack also wants to list the projects that are not in development.

In the CurrentArticles table, display the filter arrows, and then filter the table to display the articles that have not been published yet. (Hint: If the Filter Button check box is not available, remove and then redisplay the header row.)
6. Go to the Proposed Articles worksheet, which lists articles that have been proposed for publication in September. Jack suspects the ProposedArticles table has a duplicate record. Identify the duplicate as follows:
a. Clear the filter from the ProposedArticles table to display all the records.
b. In the range A2:A16, create a Conditional Formatting Highlight Cells Rule that displays cells with duplicate values using Light Red Fill with Dark Red Text.