Case EX 9-1 Andrea is preparing a spreadsheet showing her earnings and spendings for the last year. Andrea wants to display the months in the format 2014-March. She needs to ____.
A) use one of Excel's existing number formats
B) create a custom number format
C) create a new theme
D) apply an existing theme

Question

Quizplus · Accepted Answer

To display the months in the format 2014-March, Andrea needs to create a custom number format. This can be done by selecting the cells containing the months, right-clicking, and choosing "Format Cells". In the Format Cells dialog box, she can select "Custom" and enter the format code as "yyyy-mmmm".

Case EX 9-1 Andrea Is Preparing a Spreadsheet Showing Her