ISDS 1100 Chapter : ISDS EXCEL
15 Mar 2019
School
Department
Course
Professor
Document Summary
Enter text: enter the text with the cell as the active cell type and press tab, in the other cell enter the text and press tab. Enter retail price formula: click the cell and follow the instructions (=b5*(1+c5), press enter. Enter the sail price formula: click the cell number and type following the instructions (=d5-d5*e5, press ctrl+enter. Enter profit margin formula: follow the instructions on the questions (=(f5-b5)/f5, ctrl + enter. Copy formulas with auto-fill (copy the formula to calculate retain price from cell d5 to the range d6:d10: right click d5 and click copy, select d6:d10 and right click and click paste. Manage worksheets: renaming the sheet: double click on sheet 1 worksheet tab, type, press enter, change tab color: right click on the tab, point to tab color, click the color you want. Delete a row: click on row header, home tab: cells group click the delete arrow and click delete sheet rows.
