1-InClassExample_Excel - Class notes: Basics Each cell (the...

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

View Full Document Right Arrow Icon
Class notes: Basics Each cell can hold "one thing" To select a single cell you could do either 1 or 2 below: 1. Point a using the mouse, and click on it. A darker border appears around the selected cell. To select a range of cells you could do either 1 or 2 below. To copy the contents of a cell, you could do it in any of the following ways. Each cell (the area where a column and a row intersects) has a name. The name is the column and row designation for that cell i.e. A1 or D25. The name of the cell that is selected is shown in the Name Box on the editing tool bar. You can enter a number, a label (aphanumeric characters, or a formula in a cell. You can also enter a macro (a programmed sequence of events) in a cell, but we will not be covering any programming in K501. A group of cells that are selected together is called a range. A range of cells make up a rectangle. A range may be only in a column or a row or a combination. The range in Excel is always expressed as the top left cell, then a colon, and then the bottom right cell. Examples: A1:A20 would contain all the cells in the A column from row 1 through row 20. A1:M1 would contain all the cells in the columns A, B, C, D, E, F, G, H, I, J, K, L, & M and in row 1. A1:E20 would include all the cells in columns A through E and rows 1 through 20. NOTE: There are always several ways to use any feature in Excel. You goal should be to use the way that allows you to work most efficiently i.e. quickly! Many students who have grown up using the PC to surf and are therefore overly mouse dependent - slow ! Many times you can use the keyboard - especially if you are inputting data more efficiently if you use the keys on the keyboard instead of the mouse. Note most, but not all the things that you can do with the mouse, you can do with the keyboard. 2. Use the arrow keys on the right side of the keyboard to move the cursor to the cell. A darker border appears around the selected cell. Note: These are the arrow keys between the alphanumeric keys and the number pad. It is best to leave the NumLock on when using Excel as the number pad on the right side of the is generally the quickest way to enter numbers and the basic mathematical operators. Note: When a range is selected there is a darker border around all the cells and there is a small black box in the bottom right hand corner of the border around the range. This small black box is often referred to as a " handle ". 1. Point at the first cell with the mouse and click on it to select it. While pointing at the first cell (top left cell) in the range, hold down the left mouse button and drag the cursor to the last cell (the bottom right cell) in the range and then release the mouse button. 2. Using the arrow keys, select the first cell (the top left cell) of the range. Hold down the shift key and
Background image of page 1

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

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

This note was uploaded on 09/15/2008 for the course BUS K201 taught by Professor Zandi during the Fall '08 term at Indiana University South Bend.

Page1 / 21

1-InClassExample_Excel - Class notes: Basics Each cell (the...

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

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