Excel 1 Appendix

Excel 1 Appendix - This document contains instruction for...

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

View Full Document Right Arrow Icon
This document contains instruction for several skills that are not included in SimNet but may be helpful for Spreadsheet 1 Project. This document should be read as part of the Excel 1 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 1 lab. Right- click Excel 1 Appendix Sample File and select Save Link/Target As then pick a location on your computer . After Excel 1 Appendix Sample File.xlsx has been copied to your computer, open it in Excel. E1.0 How Can I Move Around Within a Sheet? Moving around within a worksheet is a relatively simple task. To move one cell at a time, simply select the arrow key that represents the direction you want to move. You can also move up and down by a screen-full of rows using the Page Up and Page Down keys. Excel offers another method of moving several cells at once. Excel can differentiate between cells that are empty and cells that contain something. The control key (labeled CTRL) can be used with the arrow keys to move by blocks of empty cells or blocks of occupied cells. When you use the control key with an arrow key, Excel first looks to see what kind of cell the cursor begins in. If you start in an occupied cell, Excel moves the cursor to the last occupied cell in that direction. If you begin at an empty cell, Excel moves the cursor to the first occupied cell in that direction. In the Excel 1 Appendix Sample File, position your cursor in cell A1 . Hold down the CTRL key and press the down arrow key . Your cursor moves to cell A10. Now select CTRL and the right arrow key . Your cursor moves to cell C10. Now select CTRL and up arrow . Your cursor moves to cell C7. All these moves took you from the first occupied cell to the last occupied cell in the desired direction. This time when you press CTRL and up arrow , Excel skips the empty cells and moves your cursor to C1, the first Page 1 of 18
Background image of page 1

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

View Full DocumentRight Arrow Icon
occupied cell. If you press CTRL and down arrow from any cell in the range C1 through C6, the destination will be the same: the first occupied cell – C7. Page 2 of 18
Background image of page 2
E1.1 How Do I Change the Cell Background Color? The interior color of a cell is also known as the background or fill color. By default, no color is applied; this appears white on your screen. You can change this default to a color, gradient or pattern. To change the color of the cell’s interior, first select the desired cell or range of cells , then select the Fill Color button from the Font group of the Home ribbon. Note that the Fill Color button has two parts. The Fill Color (or bucket) icon will fill the cell with the most recently applied color. In the figure below, the most recently applied color is yellow. The arrow to the right of the Fill Color icon will display the current theme, standard and
Background image of page 3

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

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 18

Excel 1 Appendix - This document contains instruction for...

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

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