Test Bank 11. What formatting option is applied? Quarterly Sales - Top Performers Q1 Afshan $41,500 Cammy Vincent Tomeka $47,750 $35,950 $52,800 Q2 $56,500 $52,000 $54,500 $56,250 Q3 $45,000 $48,700 $56,200 $54,000 Q4 $42,800 $40,250 $48,000 $50,750 TOTALS $185,800 $188,700 $194,650 $213,800 A. Theme B. Cell styles C. Pattern fills D. International Create Custom Number Formats 12. In what order are custom number formats created? A. Negative values, positive values, zero values, text B. Positive values, negative values, zero values, text C. Positive values, text, negative values, zero values D. Text, negative values, zero values, positive values 13. Which custom number format will display negative values with only a negative sign and a red font color? A. $#,## 0 ): [Red]-$#,##0 B. -$#,##0;[Red]:$#,##0_) C. $#,##0): [Red](-$#,##0) D. $#,##0): [Red]($#,##0) 14. Match each Custom Number Formatting description to its example. DESCRIPTIONS A. Digit placeholder, if required B. Digit placeholder always displayed C. May contain one digit; must contain two decimal places D. Must contain one digit plus two decimal places 15. How do you change date format for another country? A. Use the Date category on the Format Cells dialog box's Number tab. B. Apply the appropriate international theme to the worksheet. C. Edit the document properties to match that country's properties. D. Manually edit the date in all applicable cells. EXAMPLES 1. #.00 2. 0 3. 0.00 4. # Excel 2019 & 365 Page 3 of 4