SBS_LAB_1_Step2b

# SBS_LAB_1_Step2b - E Double click on the lower right hand...

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

LAB 1, STEP 2b Calculate Sales per Item A. Click in Cell N5 to enter the formula. B. Type an equal sign (=) to indicate to Excel that the cell will contain a calculated value. C. Total sales per item is the sum of all daily sales for this period. Use the Excel SUM function to provide a total for a range of cells. Type SUM and a beginning parentheses into cell N5. D. Click on cell D5 and drag the cursor to select all cells from D5 through M5: Release the cursor and hit the tab button. The calculation will appear. Validate that this is correct by manually adding all of the cells for this item. Click on cell N5 and the formula: =SUM(D5:M5) will display.

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: E. Double click on the lower right hand corner of Cell N5 to auto fill this formula to all of the rest of the items in the list. F. To make it easier to work with the later columns, you may wish to hide the cells in the daily columns, E through M. From the Home tab, select the Cells Group Æ Format command Æ Visibility options Æ Hide & Unhide option and then select Hide Columns: Your spreadsheet will now look like this: (You can later go back and Unhide the columns by selecting the column before and after the hidden cells. Select Home Æ Cells Æ Format Æ Visibility Æ Hide & Unhide Æ Unhide Columns.)...
View Full Document

{[ snackBarMessage ]}

### Page1 / 3

SBS_LAB_1_Step2b - E Double click on the lower right hand...

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

View Full Document
Ask a homework question - tutors are online