Homework answers / question archive / New Perspectives Excel 2016 Module 2: Textbook Project Patricia Sanders 1

New Perspectives Excel 2016 Module 2: Textbook Project Patricia Sanders 1

MS Excel

Share With

---

New Perspectives Excel 2016 Module 2: Textbook Project

Patricia Sanders

1.Formatting Cell Text

To format the company name.

To change the font color of the company name and description.

2. Working with Fill Colors and Backgrounds

To change the fill and font colors in the Documentation worksheet.

To add a background image to the Documentation sheet.

3. Using Functions and Formulas to Calculate Sales Data

To calculate Morning Bean's sales and profit/loss.

To calculate the per-store statistics.

To calculate the net and percent changes.

To calculate different subtotals of the gross sales.

4. Formatting Numbers

To format the gross sales in the Accounting format.

To decrease the number of decimal places displayed in the gross sales.

To apply the Comma style to the sales statistics.

To format the percent change values as percentages.

To format the date in the Long Date format.

5. Formatting Worksheet Cells

To left-align the date and center the column titles.

To indent the expense categories.

To add borders to the sales statistics data.

To format the monthly sales table.

To merge the state name cells.

To rotate the state names.

6. Exploring the Format Cells Dialog Box

To use the Format Cells dialog box to format the column titles.

To format the row titles.

7. Calculating Averages

To calculate the average monthly sales for each store.

To add a double border to the state results.

8. Applying Cell Styles

To apply cell styles to the Sales Report worksheet.

9. Copying and Pasting Formats

To use the Format Painter to copy and paste a format.

10. Finding and Replacing Text and Formats

To find and replace the street title abbreviations.

To find and replace the street title abbreviations.

To find and replace the street title abbreviations.

To find and replace the street title abbreviations.

To replace white text with blue text.

11. Non-graded - Working with Themes

12. Highlighting Data with Conditional Formats

To highlight negative values in red.

To use a Top/Bottom Rule to highlight stores with the highest average sales.

To create a conditional formatting legend.

13. Formatting a Worksheet for Printing

To set the print area of the Sales Report worksheet.

To remove the automatic page breaks and insert manual page breaks.

To set the print titles.

To set up the page header.

To create the page footer.

To set the left margin.