Why should you format data in Excel?
What will be an ideal response?
Data need formatting when there is additional context to add. For example, adding a $ sign to a number classifies the value as currency. Commas help the reader correctly grasp the magnitude of large numbers. A % sign indicates that the number represents a proportion. Color can indicate a classification, magnitude, or issue.
There are many reasons to format data. The best reason(s) to format data is to add information.
How might you format data for a person who is colorblind?
Add formatting that is not color-dependent but highlights the data in a different way. Bold, italic, parentheses, hyphens, hatched backgrounds, etc.
You might also like to view...
Write a script that inputs three integers from the user and displays the sum, average, product, smallest and largest of these numbers in an alert dialog.
What will be an ideal response?
Which of the following is a partially completed workbook to be used as a model for a fully completed document?
A) Macro B) Theme C) Sub Procedure D) Template
Which of the following components are contained in Normal view?
What will be an ideal response?
____ is the process of using people to get the information you want.
Social engineering Hacking Snarfing Phishing