Format cells so a list is easy to read

Question 1 of 7

1. Number formats change:

   The stored value into a different number How the number looks on the sheet The file into a PDF The sheet tab name
2. To add a border, Microsoft's path is:

   Home tab, Font group, arrow next to Borders, then a style File > Print Data > Filter Formulas > AutoSum
3. Fill Color is found:

   Only under File > Options Only in Quick Analysis On the Data tab On the Home tab, in the Font group
4. A sensible format for Household amounts in CAD is:

   Time Percentage Currency (or Number with two decimal places) Scientific
5. If you apply Percentage to a cell that contains 5.49 (dollars):

   That is the recommended money format Excel will display it as a large percentage, which is not what a dollar amount means The file will not save The cell becomes a chart
6. After you apply Currency to 5.49, the formula bar still shows:

   The underlying value 5.49 A random date Nothing The word Groceries
7. Calm formatting for a header row is:

   A different neon colour in every header cell No headers at all Hiding the header row A pale fill and a clear border, plus labels that still make sense without colour