Fill This Form To Receive Instant Help
Fill This Form To Receive Instant Help
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.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.
Already member? Sign In
