Cell Range The SUM function appears as SUMA1A3 The A1A3 in the parenthesis is

# Cell range the sum function appears as suma1a3 the

This preview shows page 8 - 12 out of 14 pages.

Cell Range The SUM function appears as SUM(A1:A3) . The A1:A3 in the parenthesis is called a cell range . It is shorthand for " from A1 to A3" Data The rectangles you see are called cells . A cell is the fundamental element of a worksheet. This is where the action takes place. Every cell has an address that is determined by the letter of the column and the number of the row that the cell is in. Addresses are written in the form A2 , B16 . Click on a cell on your screen. Notice the black box and the darker gray shading on the column and row labels. The black box identifies the active cell , or the one that will receive whatever you type. A cell can contain text, numbers or formulas. Let's enter something into cell A1 : 1. Click on the A1 cell (The cell at the very top left of the spreadsheet). 2. Notice the black rectangle around the A1 cell. The A and the 1 are highlighted. 3. Type Hello World and press Enter . 4. The active cell is now A2 . (The words “Hello World” are in A1.)
5. When you type something in a cell and press Enter , or Tab, or click the left mouse button or use one of the arrow keys, whatever you typed is entered into that cell. Enter Data Into More Than One Spreadsheet At The Same Time Method 1: Use Control Key 1. While holding down the Ctrl (Control) key, click on the numbered tab Sheet1 , then click on Sheet2 , then click on Sheet3 . Release the Ctrl key. (All 3 numbered tabs now have a white background. The numbered tab of the current (opened) sheet will have the word Sheet in bold) 2. In cell A1 type the word test then press Enter . (The word test will be entered in cell A1 on all 3 of the spreadsheets) 3. To stop adding data into all three Sheets, hold down the Ctrl key then click on the Sheet tab for each of the sheets. Method 2: Use "Select All Sh eets" 4. Right-click on one of the numbered tabs, Sheet1 , Sheet2 , etc. The Menu below appears. 2. Click Select All Sh eets . (There is no indication that anything happened.) 3. In cell A2, type the word test2 then press Enter . (The word, test2, will be entered in cell A2 on all the spreadsheets) 4. To stop adding data into the Sheets, hold down the Ctrl key then click on the Sheet tab for each of the sheets. Delete Data 1. Click on A1 again. 2. Press the Delete key. (The “Delete Contents” window appears.)
3. Check the Delete a ll box and click OK. (Note the delete options in the “Delete Contents” window.) Delete Data From More Than One Spreadsheet At The Same Time Method 1: Use Control Key 1. While holding down the Ctrl (Control) key, click on the numbered tabs. Sheet1 , then click on Sheet2 , then click on Sheet3 . Release the Ctrl key. (All 3 numbered tabs now have a white background. The numbered tab on the current sheet will have the word Sheet in bold) 2. Click on A2 . 3. Press the Delete key. (The “Delete Contents” window appears.)
4. Check the Delete a ll box and click OK. (The word, test, is no longer on the sheets.) Method 2: Use "Select All Sh eets" 1. Right-click on one of the numbered tabs, Sheet1 , Sheet2 , etc. (The Menu below appears.) 2. Click Select All Sh eets . (There is no indication that anything happened.) 3. Click on A2 .

#### You've reached the end of your free preview.

Want to read all 14 pages?

• Summer '19
• Control key, Shift key, Computer keys, Control-Alt-Delete

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern