ExcelTutorial

ExcelTutorial - Excel 2000 Tutorial Spreadsheet Basics...

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

View Full Document Right Arrow Icon
Excel 2000 Tutorial Spreadsheet Basics Screen elements Adding and renaming worksheets The standard toolbar - opening, closing, saving, and more. Modifying A Worksheet Moving through cells Adding worksheets, rows, and columns Resizing rows and columns Selecting cells Changing cell format Moving and copying cells Fill Down, Fill Right Autofill Paste Special Formulas and Functions Formulas Linking worksheets Relative, absolute, and mixed refere Basic functions Charts Chart Wizard Resizing a chart Moving a chart Spreadsheet basics Screen elements Excel allows you to create spreadsheets much like paper ledgers that can perform automatic calculations. Each Exce that can hold many worksheets . The worksheet is a grid of columns (designated by letters) and rows (designated by and numbers of the columns and rows (called labels ) are displayed in gray buttons across the top and left side of the intersection of a column and a row is called a cell . Each cell on the spreadsheet has a cell address that is the column number. For example, in the image below the cell address of the cell resulting from the intersection of column E and can contain either text, numbers, or mathematical formulas.
Background image of page 1

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

View Full DocumentRight Arrow Icon
Adding and Renaming Worksheets The worksheets in a workbook are accessible by clicking the worksheet tabs on the bottom of the screen. By default included in each workbook. To add a sheet, select Insert|Worksheet from the menu bar. To rename the worksheet t tab with the mouse and select Rename from the shortcut menu. Type the new name and press the ENTER key. The Standard Toolbar This toolbar is located just below the menu bar at the top of the screen and allows you to quickly access basic Excel Modifying a Worksheet Moving Through Cells
Background image of page 2
Use the mouse to select a cell you want to begin adding data to and use the arrow keys to move through the cells of of movements and corresponding key strokes: One cell up: up arrow key One cell down: down arrow key or ENTER One cell left: left arrow key One cell right: right arrow key or TAB Top of the worksheet (cell A1): CTRL+HOME End of the worksheet (last cell containing data): CTRL+END End of the row: CTRL+right arrow key End of the column: CTRL+down arrow key Any cell: File|Go To menu bar command Adding Worksheets, Rows, and Columns Worksheets - Add a worksheet to a workbook by selecting Insert|Worksheet from the menu bar. Row - To add a row to a worksheet, select Insert|Rows from the menu bar, or highlight the row by clicking on the r with the mouse, and choose Insert . Column - Add a column by selecting Insert|Columns from the menu bar, or highlight the column by click on the c with the mouse, and choose Insert . Resizing Rows and Columns
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 / 7

ExcelTutorial - Excel 2000 Tutorial Spreadsheet Basics...

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