Microsoft Excel 2021365 - Beginner to Advanced - Exercise 05 -apply number formats and apply formatting to cells

This video tutorial covers applying various number formats in Excel, including short date, accounting, and percentage formats. It demonstrates using formulas to calculate sales tax and totals, and shows how to enhance data presentation by formatting titles, headings, and borders. The tutorial provides a step-by-step guide to applying these formats, ensuring a structured and visually appealing worksheet.

Which format should be applied to column AI to display dates in a concise manner?

• Long Date

• Custom Date

• General

• Short Date

What format is recommended for column C to ensure financial data is displayed correctly?

• Text

• Percentage

• Currency

• Accounting

To make the worksheet more visually appealing, what background color should be applied to the column headings?

• Light Blue

• Light Gray

• Light Yellow

• Light Green

What is the correct line color for the borders around the data?

• Dark Blue

• Dark Red

• Dark Green

• Dark Gray

When applying percentage format to a cell, what should be done to ensure it displays as 15%?

• Increase decimal places

• Decrease decimal places

• Change to currency format

• Apply bold formatting