Excel Office Pro Videos 5.5.1 & 5.5.2 (15 PTS)

What is the first step to format dates in Excel?

• Click the dollar sign ($) button

• Select all of the dates

• Type the date and press Enter

• Select the Phone Number format

What does Excel automatically format when you type in a date and press Enter?

• The date format to match the rest

• The phone number format

• The currency format

• The percentage format

What should you do if Excel changes phone numbers into pound signs (######)?

• Change the number format

• Widen the columns

• Use the Percentage format

• Click the dollar sign ($) button

Which button do you click to format money values in Excel?

• Percentage (%)

• Phone Number

• Dollar sign ($)

• Date

What is the first step to resolve the ###### error in Excel?

• Change the number format

• Widen the columns

• Use the Date format

• Click the dollar sign ($) button

What can Excel's number formatting tools help you with?

• Making data entry faster

• Making data easy to understand

• Increasing spreadsheet size

• Deleting unnecessary data

What does the document mention as a common issue with spreadsheets?

• Lack of color

• Difficulty in reading due to small cell size

• Too many formulas

• Excessive use of images

What is the result of clicking the Decrease Decimal button twice?

• Adds two decimal places

• Removes two decimal places

• Converts numbers to percentages

• Merges cells

What does the document suggest doing to explore number formatting options?

• Spend time exploring

• Ignore them

• Use default settings

• Delete unnecessary formats

What is the main topic of the section titled "Cell Formats"?

• Data entry

• Formatting tools

• Spreadsheet formulas

• Chart creation