Part 1 Stock Market Challenge

1
Stock Challenge Directions Part 1 Labeling
Categories and Format the Basic Setup

• Dont forget to continue to autosize you columns
  as you see text overlap or not fit in a cell. If
  you see symbols, it means the text is too
  wide to be seen and autosize will fix that as
  well.

• Change the tab name at the bottom of the sheet to
  Stocks. Right click on the tab name and give it a
  Tab Color

2

• In cell A1, type the text Todays Date
• Use ControlB to bold the text in A1 and raise
  the font size to 12
• Use the Borders dropdown on your toolbar and
  select the Thick Box Border to put around this
  cell.

3

• Select cells D1 and E1. On the Home tab,
  Alignment section, select Merge Center.
• In the merged cells, type the text Gift.
• Use ControlB to bold the text, raise the font to
  size 12.
• Use the Borders dropdown on your toolbar and
  select the Thick Box Border to put around these
  merged cells.

4

• Select cells F1 and G1. On the Home tab,
  Alignment section, select Merge Center.
• In the merged cells, put the number 10,000.
• Bold and raise the font size to 12.
• Use the Control1, the Number tab, and select
  Currency to format the amount. Make sure the
  sign is selected in the Symbol box.
• Use the Borders dropdown on your toolbar and
  select the Thick Box Border to put around these
  merged cells.

5

• Select cells B3, C3, D3, E3. On the Home tab,
  Alignment section, select Merge Center.
• In the merged cells, type the text Purchase
  Information
• Use ControlB to bold the text in the merged
  cells, raise the font size to 12.
• Use the Borders dropdown on your toolbar and
  select the Thick Box Border to put around these
  merged cells.

6

• Select cells F3, G3, H3, and I3. On the Home tab,
  Alignment section, select Merge Center.
• In the merged cells, type the text Current
  Information
• Use ControlB to bold the text in the merged
  cells, raise the font size to 12.
• Use the Borders dropdown on your toolbar and
  select the Thick Box Border to put around these
  cells.

7

• In cell A4, type the text Company
• In cell B4, type the text Date
• In cell C4, type the text Shares
• In cell D4, type the text Price
• In cell E4, type the text Cost

• In cell F4, type the text Price
• In cell G4, type the text Value
• In cell H4, type the text Gain/Loss
• In cell I4, type the text Days Held

Select the text in A4 trough I4 and bold it using
ControlB
8

• Select cells D5 through H11.
• Use Control1, Number tab, and select Currency.
• The Decimal places should read 2, Symbol should
  be a , and choose the red selection without
  parentheses for Negative numbers.

9

• Select cells A4 through I9.
• Use the border icon on the toolbar or Control1
  and the Border tab, All Borders to put borders
  around each of the cells in the range.

10

• In cell A11, type the text Total
• Bold and raise the font size of this text to 12.
• Select cells A11, E11, G11, and H11 (remember,
  using the control key lets you select
  non-contiguous cells).
• Use the Borders dropdown on your toolbar and
  select the Thick Box Border to put around these
  cells.

11
You should now have a document that looks like
the picture below If not, carefully go back and
find out what direction you missed.