SBS_LAB_1_Step2a

SBS_LAB_1_Step2a - Double click on the lower right hand...

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

View Full Document Right Arrow Icon
LAB 1, STEP 2a Calculate Profit Per Item A. Click in Cell C5 to enter the formula. B. Type an equal sign (=) to indicate to Excel that the cell will contain a calculated value. C. The profit margin for this sale is 50%. Click cell B5, enter the multiplication sign (*) and then 50%. D. Validate the formula mathematically (desk check). Since 50% of 15 is 7.5, you know that the formula is correct.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Double click on the lower right hand corner of Cell C5 to auto fill this formula to all of the rest of the items in the list. E. Format the cells in this column as currency by clicking the Number Group Dialog Box Launcher: In the Format Cells dialog box, select Currency with 2 decimals: Click OK to apply this cell format to the column. Your spreadsheet will now look like this:...
View Full Document

This note was uploaded on 03/24/2011 for the course BIS 155 taught by Professor Willox during the Spring '99 term at ITT Tech San Dimas.

Page1 / 3

SBS_LAB_1_Step2a - Double click on the lower right hand...

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