In this project, you will be working on sales data for a shoe company. You will be completing steps covered under the Manage Data Cells and Ranges objective domain.

This project covers the following MOS Objectives:

Merge and unmerge cells $($EX$19-2\mathrm{.}2\mathrm{.}1)$

Apply cell styles $($EX$19-2\mathrm{.}2\mathrm{.}7)$

Format cells by using Format Painter $($EX$19-2\mathrm{.}2\mathrm{.}3)$

Apply number formats $($EX$19-2\mathrm{.}2\mathrm{.}5)$

Apply cell formats from the Format Cells dialog box $($EX$19-2\mathrm{.}2\mathrm{.}6)$

Modify cell alignment, orientation, and indentation $($EX$19-2\mathrm{.}2\mathrm{.}2)$

Fill cells by using Auto Fill $($EX$19-2\mathrm{.}1\mathrm{.}2)$

Insert sparklines $($EX$19-2\mathrm{.}4\mathrm{.}1)$

Define a named range $($EX$19-2\mathrm{.}3\mathrm{.}1)$

Name a table $($EX$19-2\mathrm{.}3\mathrm{.}2)$

Wrap text within cells $($EX$19-2\mathrm{.}2\mathrm{.}4)$

Paste data by using special paste options $($EX$19-2\mathrm{.}1\mathrm{.}1)$

Remove conditional formatting $($EX$19-2\mathrm{.}4\mathrm{.}3)$

Apply built$-$in conditional formatting $($EX$19-2\mathrm{.}4\mathrm{.}2)$

Insert and delete cells $($EX$19-2\mathrm{.}1\mathrm{.}4)$

Clear cell formatting $($EX$19-2\mathrm{.}2\mathrm{.}8)$

Insert and delete multiple columns or rows $($EX$19-2\mathrm{.}1\mathrm{.}3)$

Steps to complete this project:

Mark the steps as checked when you complete them.

Open the start file: EX$2019-$MOS$-$Ch$2.$ If the file opens in Protected View, click the Enable Editing button in the Message Bar at the top of the file so you can modify it$.$

The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it$.$

On the By Region worksheet, make the following formatting modifications:

a$.$ Merge and center the tile across cells A$1$:E$1.$

b$.$ Apply the Title style to the merged cells.

c$.$ Use format Painter to copy the formatting from cell A$3$ to cells A$4$:A$7.$

d$.$ Apply the Accounting number format to cells B$3$:E$8.$

e Decrease the decimal so the values are whole numbers with no cents $($e$.$g$.$ $$236,878.$