Spreadsheets Introduction-Know the definition and be able to recognize them in Excel for the test!

Worksheet

one spreadsheet computer file- this is where you enter information or work in.

Workbook

This is the file that contains one or more worksheets.

Electronic Spreadsheet

An application you use to perform numeric calculations and to analyze and present numeric data.

Tabs

Click to access tools and commands related to the name of the tab.

View Buttons

Click to display the worksheet in Normal, Page Layout, or Page Break View.

Ribbon

Contains the commands and tools grouped by category on different tabs.

Formula Bar

Displays the contents of the active cell and is used to create or edit text or values. It may be expanded or contracted by clicking the double arrows at the right edge of the bar.

Title bar

Displays the current worksheet and application names.

Active Cell

Highlighted with a thick border; stores information that is entered while it is active. (The selected cell being typed in)

Worksheet Tabs

Identify the active worksheet in the workbook.

Cell Name

Is referred to by the column letter then by row number.

Rows

Rows run horizontally in a worksheet. Each row has a heading (a number) running up or down the left side of the worksheet.

Columns

Run vertically in a worksheet. Each row has a heading (letter/s) running from left to right across the worksheet.

Name Box

The box above the worksheet that displays the active cell address.

Cell

The intersection of a column and a row. This is where the information is keyed and can contain text, numbers, formulas, or a combination of all three.

Scroll Bars

Used to move horizontally or vertically within a worksheet.