{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel 2 Appendix

# Excel 2 Appendix - Use This document contains instruction...

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

Use This document contains instruction for several skills that are not included in SimNet but may be helpful for Spreadsheet 2 Project. This document should be read as part of the Excel 2 Lab. First, download the sample file that goes with this appendix by following the Course Assignments and Labs links on the course website. Then select Excel 2 lab. Right- click Excel 2 Appendix Sample File and select Save Link/Target As then pick a location on your computer . After Excel 2 Appendix Sample File.xlsx has been copied to your computer, open it in Excel. E2.1 How Can I Select Several Cells that are Not Next to Each Other? To select a single cell, you simply place your cursor on the cell and click the left mouse button. To select a group of cells that are next to each other: 1. Select the first cell by placing your cursor on the cell, but this time, click and hold the left mouse button. Then drag the cursor to the last cell. 2. Alternatively, you can select the first cell, hold down the shift key, then select the last cell. Give this a try by selecting cells A1, B1, C1, D1 and E1 in an empty worksheet. You can select multiple cells even if they are not next to each other. To do so, use the CTRL (or Control) key in place of the shift key. Select the first cell, hold down the CTRL key, then select all remaining cells. Try selecting cells A2, C2 and E2 in an empty worksheet. Page 1 of 14

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

View Full Document
You can combine the two methods to select multiple, non-contiguous ranges. For example, select A1-E1 and A3-E3 by: 1. Click on cell A1 and hold down the left mouse button. 2. Drag the mouse to cell E1. 3. Hold down the CTRL key. 4. Click on cell A3. 5. Drag the mouse to cell E3. 6. Release the CTRL key and the left mouse button. E2.2 What Do Those Green Triangles Mean and How Do I Get Rid of Them? Before we discuss the green triangles, let’s take a look at the sample file. This is the same file used for the Excel 1 Appendix with a few additions. 1. Columns D, E and F have been added along with totals rows 6, 12 and 13. 2. Recall that we had unlocked the course title, credit hours and grade cells and turned protection on. Protection has been turned off in this file, but the cells remain unlocked. 3. I had to insert a new row to make room for the Fall Totals row (row 6). When you insert a new row, by default, the new row is assigned the same formatting choices as the row above. Therefore, row 6 has cells A6, B6 and C6 unlocked because those three cells were unlocked for row 15.
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 14

Excel 2 Appendix - Use This document contains instruction...

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

View Full Document
Ask a homework question - tutors are online