Group the two worksheets . Merge & Center the title in cell A1 across the range A1 :G 1 and apply the
Title cell style . Merge & Center the subtitle in cell A2 across the range A2 : G2 and apply the Heading 1
cell style . AutoFit Column A .

You will need to download the workbook included in this assignment. Nonetheless, I have provided some guidance on how to apply the merge & center command on Excel as well as the AutoFit command.

Step-by-step explanation

These are screenshots of what the data set would look like.

Click Home > Merge & Center

Book1 - Excel Millicent Sy Tan O X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do R Share Century Gothic 11 AA al Wrap Text General E. AY O Paste BIU~ Merge & Center $ ~ % " .00 Conditional Format as Cell Insert Delete Format Sort & Find & .00 7.0 Formatting ~ Table ~ Styles ~ Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing A1 X V fx Cell style BCDEF H J K L M N O P Q R S T Cell style ategory cell style ABC 3 abcde nnnn n XYZ ABC 4 abcde n n n n n XYZ ABC 5 abcde n n n n n XYZ ABC abcde n n n n n XYZ ABC abcde n n n n n XYZ ABC 8 abcde n n n n n XYZ ABC 9 abcde n n n n n XYZ ABC 10 abcde n n n n n XYZ ABC 11 abcde n n n n n XYZ ABC 12 abcde n n n n n XYZ ABC 13 abcde n n n n n XYZ ABC 14 abcde n n n n n XYZ ABC 15 abcde n n n n n XYZ ABC 16 abcde n n n n n XYZ ABC 17 18 19 20 21 Bulbs Trees (+)

Change the column width to automatically fit the contents (AutoFit)

1. Select the column or columns that you want to change.
2. On the Home tab, in the Cells group, click Format.
3. Under Cell Size, click AutoFit Column Width. Book1 - Excel Millicent Sy Tan O X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do R Share Century Gothic 11 AA ab Wrap Text General 2. AY O Paste BIU Merge & Center $ ~ % " .00 Conditional Format as Cell Insert Delete Format .00 7.0 Sort & Find & Formatting " Table ~ Styles ~ Filter ~ Select Clipboard Font Alignment Ly Number y Styles Cells Editing A3 X Y fic abcde A BCDEF G H J K L M N O P Q R S T Cell style Category cell style ABC W N abcde n n n n n XYZ ABC abcde nnnn XYZ ABC abcde nnnn XYZ ABC abcde r n n n n XYZ ABC abcde r n n n n XYZ ABC abcde nn n n n XYZ ABC abcde n n n n n XYZ ABC abcde n n n n n XYZ ABC abcde nn n n n XYZ ABC abcde r n n n n XYZ ABC abcde r n n n n XYZ ABC abcde nnn n XYZ ABC abcde Innnn XYZ ABC 16 abcde h n n n n XYZ ABC 17 18 19 20 21 Bulbs Trees (+)