Question

Using the Internet, conduct a thorough search for more information on formatting in Excel. Choose two topics (explain and also include a use for each) from the following:

Section 2.1

• Change fonts, font style, and font color
• Add fill colors and a background image
• Create formulas to calculate sales data
• Format numbers as currency and percentages
• Format dates and times
• Align, indent, and rotate cell contents
• Merge a group of cells

Section 2.2

• Use the AVERAGE function
• Apply cell styles
• Copy and paste formats with the Format Painter
• Find and replace text and formatting
• Change workbook themes

Answer 1