shelly cashman series microsoft office 365 & excel 2019 comprehensive

Change the font color of cell A2 to Blue, Accent 1, Darker 50%.Ĥ. Use buttons in the Font group on the Home tab on the ribbon to change the worksheet subtitle in cell A2 to 14-point font and then merge and center it across columns A through H. Change the worksheet tide in cell A1 to the Title cell style and then merge and center it across columns A through H.ģ. As you edit the values in the cells containing numeric data, watch the totals in row 8, the totals in column H, and the chart change.Ģ. Make the changes to the worksheet described in Table 1–7. You are to edit data, apply formatting to the worksheet, and move the chart to a new sheet tab.ġ.

The workbook you open contains sales data for Delton Discount. Open the workbook called SC_EX_1-1.xlsx (Figure l–99a), which is located in the Data Files. Please contact your instructor for information about accessing the Data Files. Note: To complete this assignment, you will be required to use the Data Files. Index.Reinforce the skills and apply the concepts you learned in this module. Managing Contacts and Personal Contact Information with Outlook. Creating Templates, Manipulating Data, and Adding Additional Enhancements to a Worksheet. Working with Multiple Worksheets and Workbooks. Financial Functions, Data Tables, and Amortization Schedules. Creating a Self-Running Presentation Containing Animation. Navigating Presentations Using Hyperlinks and Action Buttons. Collaborating on and Delivering a Presentation. Creating and Formatting Information Graphics. Creating a Newsletter with a Pull-Quote and Graphics. Generating Form Letters, Mailing Labels, and a Directory. Using a Template to Create a Resume and Sharing a Finished Document. Creating a Document with a Title Page, Lists, Tables, and a Watermark. Microsofts New Productivity Tools for School and Work.

Shelly cashman series microsoft office 365 & excel 2019 comprehensive