BIS155 SBS_Lab1_Step3b

BIS155 SBS_Lab1_Step3b - Step by Step Instructions Step 3b...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Step by Step Instructions Step 3b Format Spreadsheet A. Separate the Header information and the summary information from the data. Insert rows between Row 4 and 5 and between Rows 14 and 15. Select the row below where you wish to insert a row. From the Home Tab, Cells group, click the Insert command and select Insert Sheet Rows. B. Move the data in cells C17:D18 to cells A18:B19. Select the cells you wish to move. Hover your cursor over the selected cells until the cursor becomes a Move pointer: Drag the cells to A18. Notice that the formulas will not change when you move the cells. C. Hide columns D through M. Select Columns D through M. From the Home Tab, select the Format menu, Cells Group, Visibility Command, Hide & Unhide. Select Hide Columns.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
D. Merge and Center the data in rows 1 and 2. Select columns A through P. From the Home Tab, Alignment Group, select Merge & Center: E. Select all text and change the Font to Arial. F.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 8

BIS155 SBS_Lab1_Step3b - Step by Step Instructions Step 3b...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online