You have a sales report where cells with sales below $500 are colored red, and cells with sales above $1000 are colored green. What does this color formatting most likely communicate?
Think about what the colors red and green usually represent in reports.
Red usually signals a warning or low value, while green signals good or high value. Here, red marks sales below $500 and green marks sales above $1000.
Cell A1 contains the number 1234.567. The cell is formatted as currency with 2 decimal places. What is the displayed value?
Currency formatting rounds to 2 decimal places and adds a dollar sign.
Currency format adds a dollar sign, uses commas for thousands, and rounds to 2 decimals, so 1234.567 becomes $1,234.57.
You want to display the date in cell B2 as 'March 15, 2024'. Which function will correctly format the date this way in Google Sheets?
Check the correct format codes for day and year in Google Sheets.
In Google Sheets, 'd' is day without leading zero, 'yyyy' is 4-digit year, and 'MMMM' is full month name. So "MMMM d, yyyy" gives 'March 15, 2024'.
In a budget sheet, expense categories are in normal font, totals are bold, and notes are italic. What does this formatting communicate?
Think about how bold and italic are usually used to highlight or differentiate text.
Bold is often used to highlight important summary numbers like totals. Italic is used for additional info like notes. Normal font is for regular data like categories.
Why does consistent use of formatting (colors, fonts, number formats) help when sharing spreadsheets with others?
Think about how formatting guides readers to interpret data correctly.
Consistent formatting acts like signs or labels. It helps users quickly see what data means and reduces confusion or errors.