Last Column

Last Row

A spreadsheet program, designed to create, organized, and analyzed data

The intersection or rows and columns

The sheet you're working in a workbook

A rectangular object on a worksheet or chart.

Wrong type of data

Can't find the name of the function

There's a problem with one of the numbers

Divide on a blank cell

You're reference is invalid

Can't display your formula in the cell

Parts of Excel

Are text entries consisting of any combination of letters and number

Group of Incremental number, dates, or periods

Use a constant value to increase and decrease value

Multiplied by the preceding number by the step value

Freezes all the rows above the active cell and all the columns to the left of the active cell

Show the relationship between sets of data in picture form

Visual Presentation of a worksheet data

Found in the analysis of the layout tab

Used to see progressed and direction

Used to clearly see the items in the chart

used to calculate values

letter, symbol, numbers

Number that you enter into a cell

Set of predefined rules

Named operation that returns the value

summarize all the values

Table direction is horizontal or across

Table direction is vertical or down

Summarizes large amounts of data

used to get particular result

Range of cells that display results

What-if projection using multiple variables

Calculate required to pay off a loan

sequence of commands and actions

Organizer collection of information arranged in a row and column format

Used to display your database

Average the values in the specified values

count the cells

add values

extract single field

estimate the Standard deviation

File that holds all the worksheets

Most commonly used buttons

Add tables, graphics, charts, hyperlink, textbox and wordArt.

Setup margins, paper orientation, and other page settings.

Contains mathematical instructions Helps you build smart formula.

Get information from an outside source

Visible only if you have loaded a workbook.

Replaces the File Menu available in earlier versions of MS office and contains the same basic commands to open, save, and print.

Customizable toolbar that contains a set of commands that’s independent of the tab that is currently displayed.

Display the program name and the workbook name you’re working it.

Display the commands that are most relevant for each of the task areas in the app.

Displays the Excel Help window

Shows the selected cell, drawing object or chart item.

Display the content of the active cell.

Data is entered when you begin typing.

Column reference letter

Row reference number

Shows the sheet name.

Help you to scroll through your worksheet using the mouse.

Display information about a selected command or an operated in progress.

File that holds all the worksheets

Series values using horizontal bars.

Series values as points on a line.

Use two values axes gridlines to plot pairs of data points in a line showing the correlation between two series.

Plots data series as cumulative lines.

Plot data series in rings.

Series value using a separate value axis for each category.

Series as lines of a grid.

Compares sets of three values like a scatter chart

Requires four series of values in the order.

Named operation that returns the value Built-in formulas that perform special and advanced calculations. Called Function Name

Find the largest numbers

Finds the smallest number