InstructionsExam EnvironmentExam Interface and ControlsThe exam panel provides access to the project task(s).

To achieve the look where the dollar symbol is left-aligned and the decimal points are perfectly aligned vertically, you need to apply theAccountingnumber format. This is a standard requirement for professional financial statements.

Step 1: Select the Data Range

Ensure you are on theQtr 1worksheet.

Using your mouse, click and drag to select the range fromB10 to E14. This range covers all the monthly revenue data for the various locations.

Step 2: Open the Number Format Options

You can do this quickly using the Ribbon or with more precision via the Format Cells dialog:

Go to theHometab on the Ribbon.

In theNumbergroup, click the smallDialog Box Launcher(the tiny arrow in the bottom-right corner of the group). Alternatively, you can pressCtrl + 1on your keyboard.

Step 3: Configure Accounting Format

Once theFormat Cellsdialog box appears:

SelectAccountingfrom theCategorylist on the left.

Set theDecimal placesto2.

In theSymboldropdown menu, ensure$ English (United States)is selected.

ClickOK.

Key Difference: Accounting vs. Currency

Accounting Format:Aligns the$ symbol to the far leftof the cell and thedecimal points verticallyin a column, making it easier to read large lists of numbers.

Currency Format:Places the$ symbol immediately to the leftof the number, which does not allow for uniform vertical alignment of the symbols.