Lesson 10: What Can I Do with a Spreadsheet?

F5

Displays the GoTo dialog box to enter any cell address.

View Tab and Group

Window Zoom Show/Hide Workbook Views Macros

spreadsheet program

is a computer APPLICATION, such as Microsoft Excel, that you use to build and manipulate electronic spreadsheets. The spreadsheet has become a much more powerful tool since the first spreadsheet program, VisiCalc, was introduced in 1979.

worksheet

is a single spreadsheet consisting of a GRID OF COLUMNS AND ROWS that often contain descriptive labels, numeric values, formulas, functions, and graphics. worksheet = Spreadsheet

Ledger

to track expenses and other quantitative data

Header/Footer Button Summary Code Entered

&(SOMETHING)

Change Worksheet Tab Color

1. Right-click the Sheet1 tab. 2. Select Tab Color. 3. You select Theme Colors, Standard Colors, No Color, or More Colors.

Columns

A to Z, continue from AA to AZ, and then from BA to BZ until the last of the 18,278 columns is reached.

vertical and horizontal scroll bars.

At the bottom and right of the document window

You can select a cell border from (2)

Borders in the Font group on the Home tab or you can use the Border tab in the Format Cells dialog box

Insert Description

Brings together all insert functions in one area. Includes ability to create graphs and add tables. Contains powerful picture functions. Headers and footers are inserted here.

spreadsheet

COMPUTERIZED equivalent of a LEDGER. contains rows and columns of data

Clear Cell Contents

Clear arrow in the Editing group on the Home tab.

Merge and Center

Click Merge & Center in the Alignment group on the Home tab.

Home Tab and Group

Clipboard Font Alignment Number Style Cells Editing

Page Layout Description

Contains all functions associated with page appearance, setup, and printing. Allows for many custom views.

Review Description

Contains all reviewing tools in Excel, including such things as spelling, the use of comments, and sharing and protection

View Description

Contains basic and advanced view settings. Some of these options also appear below the horizontal and vertical scroll bars.

for deleting rows and columns

Delete pull-down arrow in the Cells group

Tab

Each tab is made up of several GROUPS so that you can see all of its functions without opening menus. The contents of each tab are shown on the REFERENCE PAGE. This defines the tabs, the groups they contain, and their general function. You will refer to this page frequently.

Range

Every command in Excel applies to a rectangular group of cells

AutoFill

Excel operation that enables you to copy the content of a cell or a range of cells by dragging the FILL HANDLE (a small black square appearing in the bottom right corner of a cell) over an adjacent cell or range of cells.

You can add a shade to a cell from

Fill Color in the Font group on the Home tab or you can use the Fill tab in the Format Cells dialog box

Header/Footer Button Summary

Format Text, Insert Page #, Insert Number of Pages, Insert Date, Insert Time, Insert File Path, Insert File Name, Insert Sheet Name, Insert Picture, Format Picture

Formulas Tab and Group

Function Library Defined Names Formula Auditing Calculation

Data Tab and Group

Get External Data Connections Sort & Filter Data Tools Outline

Ctrl+Home

Moves active cell to cell A1.

Ctrl+End

Moves to the rightmost, lowermost active corner of the worksheet.

when the cell is not wide enough to display the complete number...

Numbers appear as a series of pound signs (######)

comments

On the Review tab, in the Comments group, click New Comment

Review Tab and Group

Proofing Comments Changes

Insert Tab and Group

Tables Illustrations Charts Links Text

Office Menu

The Office menu displays when you click the OFFICE BUTTON in the upper left of the Excel window and contains the following commands, all of which open dialog boxes: NEW, OPEN, SAVE, SAVE AS. SHARE, PRINT AND CLOSE. A list of recently used workbooks and an extensive Excel Options section displays.

Ribbon

The Ribbon is made of tabs, groups, and commands

Formulas Description

The area that contains the mathematical backbone of Excel. Includes basic areas (Function Library) as well as more advanced (Formula Auditing).

Home Description

The basic Excel tab. Contains basic editing functions such as cut and paste along with most formatting actions. As with all groups, pull-down areas are available and do increase functionality. Your Tabs may display differently depending on your screen resolution.

Data Description

The heart of the database portions of Excel. While not a true relational database, it has much power and includes GOAL SEEK and SCENARIO MANAGER.

cell

The intersection of a column and row

Name Box

The name box is another name for the CELL REFERENCE of the cell currently used in the worksheet. The name box appears to the left of the formula bar and displays the active cell's address (D4) or a name it has been assigned.

Ctrl+~

The quickest way to display cell formulas

Worksheet Tab Color

The sheet tabs are blue in color by default. The active worksheet tab is white.

Page Layout Tab and Group

Themes Page Setup Scale to Fit Sheet Options Arrange

Page Setup dialog box

This dialog box contains four tabs. Page, Margins, Header.Footer, Sheet tabs in the dialog box.

Alt+Enter

To insert a line break, where you want to start the next line of text within the cell.

AutoComplete

To turn the feature on (or off), click the Office Button, click Excel Options, and click the Edit tab. Check (clear) the box to enable (disable) the AutoComplete feature.

A workbook

a collection of related worksheets contained within a single file. equivalent of the three-ring binder.

fill handle

a small black square appearing in the bottom right corner of a cell

AutoFit

adjust the height and width of cells. AutoFit commands available in Format in the Cells group on the Home tab. Height Width

Sheet Tabs

are located at the BOTTOM LEFT of the Excel window and tell the user what sheets of a workbook are available. Three sheet tabs, INITIALLY named Sheet1, Sheet2, and Sheet3, are included when you open a new workbook in Excel.

Formula Bar

below the Ribbon and above the workbook screen and shows the active cell's contents. The formula bar displays the contents of cells; you can enter or edit cell contents here or directly in the active cell.

you can remove the formatting

by using the options with Clear in the Editing group on the Home tab

If you want to insert clip art

click Clip Art in the Illustrations group on the Insert tab to open the Clip Art task pane

To insert a row

click the Insert down arrow in the Cells group on the Home tab.

The title bar

contains the name of the application (Excel) and the name of the workbook you are using.

Cut

in the Clipboard group on the Home tab.

Alignment taB

in the Format Cells dialog box and the Alignment group on the Home tab

Excel window

includes items that are similar to other Office applications and items that are unique to the Excel application

The active cell

is the cell you are working in, the cell where information or data will be input.

Select All Button

is the square at the intersection of the rows and column headings and you can use it to select all elements of the worksheet.

Status Bar

located at the bottom of the Excel window. operation in progress. For example, it displays CAPS when Caps Lock is active and the default setting is On.

Rows

numeric headings ranging from 1 to 1,048,576

Format Cells dialog box and commands

on the Home tab control the formatting for numbers, alignment, fonts, borders, colors, and patterns.

merge and center cells

option centers an entry across a range of selected cells.

Excel performs mathematical calculations left to right in this order:

parentheses, exponentiation, multiplication or division, and finally addition or subtraction.

To insert a column

select Insert Sheet Columns

To change the row height of many rows at one time...

select the multiple rows and right-click to show the shortcut menu. Select Row Height and enter a number in the Row Height dialog box

Page Setup

the Page tab.

To widen a column

the border between column headings to change the column width.

active cell

the cell you are working in, the cell where information or data will be input

cell reference appears in...

the name box, its contents in the formula bar, and it is surrounded by a dark black box.

formula

to recognize a formula it must always start with an equal sign (=).

move operation

transfers the content of a cell or cell range from one location in the worksheet to another, with the cells where the move originated becoming empty

cell reference

unique, intersection of a column and row designated by a column letter and a row number.

Edit Cell Contents

you select the cell, press the F2 key, and then make the edit.