Shelly Cashman Word 2019 | Module 8 SAM Project 1b | Ashby Public Library

Поділитися
Вставка
  • Опубліковано 6 жов 2024
  • Shelly Cashman Word 2019 | Module 8: SAM Project 1b #shellycashman #Module8 #samproject1b
    If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,
    Whatsapp Contact Link:
    wa.me/message/...
    Whatsapp Contact Number:
    +91 8114420233
    Email ID:
    excelprojectshelp@gmail.com
    Project Steps:
    1. As a volunteer for the Friends of the Ashby Public Library, you are collaborating on a memo to Madeleine Frazier, the director of the organization. The memo summarizes statistics about the library in the past year. The director and another volunteer have reviewed the memo and made revisions using Word's Track Changes feature. Incorporate changes from Madeleine Frazier and the other volunteer, Kento Maki, as follows: a. Combine the revisions from the document Support_WD19_8b_MF.docx. b. Show the changes in the original document. c. Turn off Track Changes when you are finished.
    Combine two documents.
    2. Resolve the tracked changes in the document as follows: a. Accept the first tracked change from Madeleine Frazier, which inserts the organization name and removes the placeholder text. b. Accept the next tracked change, which is from Kento Maki and deletes "library's" to remove repetitive text. c. Reject the next tracked change, which inserts "Ashby Public", because the name of the library has already been introduced. d. Accept the remaining changes in the document because they improve or correct the writing.
    Accept a change.
    Accept a change.
    Reject a change.
    Accept a change.
    3. In the pie chart, use Patron Visits as the chart title.
    Enter a chart title.
    4. Embed data from an Excel workbook to include a table Kento created as follows: a. Open the workbook Support_WD19_8b_Circulation.xlsx. b. Copy the data in cells A1:F6. c. On page 2, use Paste Special to embed the worksheet data as a Microsoft Excel Worksheet Object in the blank paragraph in the "Circulation by Branch" section. d. Close Support_WD19_8b_Circulation.xlsx.
    Embed a worksheet from Excel.
    5. Insert a chart to comply with the request Madeleine Frazier inserted below the "Library Cards" table as follows: a. Select the text "[Insert a chart comparing the data in the table]" below the "Library Cards" table, and then insert a Clustered Column chart. b. Copy the table in the "Library Cards" section and then paste it in the chart spreadsheet window. (Hint: If prompted, click OK to continue.) c. Remove the Total data series from the chart, and then close the chart spreadsheet window. d. Delete the "Chart Title" placeholder object, since the placement of the chart makes the title unnecessary.
    Insert a chart.
    Copy and paste data into a chart.
    Remove a data series.
    In the Clustered Column chart, the Total data series should be removed.
    Delete a chart title.
    6. Format the chart to improve its appearance as follows: a. Apply Style 14 to the chart to display wider data columns. b. Change the colors to Monochromatic Palette 5 to coordinate with the rest of the document. c. Add a Red, Accent 5 border to clearly separate the chart from the table.
    Change the chart style.
    Change the chart colors.
    Change the color of a chart border.
    7. Link a chart from an Excel workbook to compare patron attitudes toward library technology as follows: a. Open the workbook Support_WD19_8b_Technology.xlsx. b. Copy the "Attitude Toward Library Technology" doughnut chart, and then paste it as a link using the destination theme in the blank paragraph at the end of the document. c. Close Support_WD19_8b_Technology.xlsx.
    Insert a chart from Excel as a link.
    8. Change the chart type of the "Attitude Toward Library Technology" chart to a Pie chart to match the "Patron Visits" chart.
    Change the chart type.
    shelly cashman excel 2019 | module 1: sam project 1b,#shelly cashman excel 2019 | module 1: sam project 1b,new perspectives excel 2019 module 1 sam project 1a,new perspectives word 2019 | module 10: sam project 1a,new perspectives excel 2019 | module 10: sam project 1b,new perspectives excel 2019 | module 1: end of module project 2,shelly cashman excel 2019 | module 5: sam project 1a,new perspectives excel 2019 | module 2: sam project 1a

КОМЕНТАРІ •