MANAGE WORKBOOK DATA

GETTING STARTED

$-$ Open the file IL$\_$EX$19\_6$a$\_$FirstLastName$\_1.$xIsx, available for download from the SAM website.

$-$ Save the file as IL$\_$EX$19\_6$a$\_$FirstLastName$\_2.$xlsx by changing the $"1"$ to a $"2".$

$-$ If you do not see the $.$xlsx file extension in the Save As dialog box, do not type it$.$ The program will add the file extension for you automatically.

$-$ To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:

$-$ Support$\_$EX$19\_6$a$\_$Q$3.$xlsx

$-$ With the file IL$\_$EX$19\_6$a$\_$FirstLastName$\_2.$xlsx still open, ensure that your first and last name is displayed in cell B$6$ of the Documentation sheet.

$-$ If cell B$6$ does not display your name, delete the file and download a new copy from the SAM website.

TR PROJECT STEPS

$1.$ Kendra Liang is a senior producer at MusicBot, an online source for all types of music. Kendra is using an Excel workbook to analyze sales for the first year of the online service. She asks you to update the workbook and make the data more secure and easier to understand.

Go to the Quarter $1$ worksheet and then unprotect the worksheet so you can update it$.$

$2.$ Kendra wants to focus on the Quarter $1$ revenue from CDs and vinyl sales, which are the lowest category of sales.

Create a custom view as follows:

a$.$ Hide rows $3$:$20$ to display only the CDs and Vinyl category of sales.

b$.$ Select cell G$1$ and then create a custom view using CDs$\_$Vinyl as the name.

$3.$ Display the Quarter $1$ worksheet using the custom view Q$1\_$All$\_$Categories, which Kendra already created, to redisplay all of the data.

$4.$ Kendra hid the Quarter $3$ worksheet because she still needs to verify the sales figures. However, she wants to change an unnecessary setting in the worksheet. Update the worksheet as follows:

a$.$ Unhide the Quarter $3$ worksheet so you can edit it$.$

b$.$ Unfreeze the first column because the worksheet is not wide enough to require horizontal scrolling.

$5.$ The company recently changed its name from MusicBot Online to MusicBot. Kendra asks you to change the name on all worksheets.

Group the Quarter $1,$ Quarter $2,$ Quarter $3,$ Quarter $4,$ and Current Month worksheets, and then change the company name to MusicBot in merged cell A$1.$