Most commonly used buttons

Compares sets of three values like a scatter chart

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

summarize all the values

Parts of Excel

Used to see progressed and direction

Named operation that returns the value

The intersection or rows and columns

Formula for multiple values using one input cell.

Used to clearly see the items in the chart

Data is entered when you begin typing.

Series values using horizontal bars.

Calculate required to pay off a loan

Finds the smallest number

letter, symbol, numbers

Average

Series value using a separate value axis for each category.

Used to display your database

Plots data series as cumulative lines.

Set of predefined rules

sequence of commands and actions

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

Divide on a blank cell

Formula for multiple values using two input cells

Summarizes large amounts of data

Last Column

Setup margins, paper orientation, and other page settings.

Found in the analysis of the layout tab

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

Shows the sheet name.

Count the number of cells that contain the number from the arguments

Find the largest numbers

Average the values in the specified values

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

Last Row

What-if projection using multiple variables

estimate the Standard deviation

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

Can't find the name of the function

Help you to scroll through your worksheet using the mouse.

used to calculate values

Built-in formula you use ti perform database calculations based on a specified field and criteria

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

add values

Series values as points on a line.

extract single field

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

A rectangular object on a worksheet or chart.

Series as lines of a grid.

Plot data series in rings.

Used to perform operations in excel based on some criteria supplied by a user.

Shows the selected cell, drawing object or chart item.

Table direction is horizontal or across

Contains mathematical instructions Helps you build smart formula.

Stores all scenarios created within the workbook.

Get information from an outside source

Organizer collection of information arranged in a row and column format

Workbook that contains more than one worksheet

Worksheet contain the cell pointer

Wrong type of data

File that holds all the worksheets

Are text entries consisting of any combination of letters and number

Show the relationship between sets of data in picture form

Number that you enter into a cell

Table direction is vertical or down

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

used to get particular result

Requires four series of values in the order.

Can't display your formula in the cell

The sheet you're working in a workbook

Display the content of the active cell.

Column reference letter

There's a problem with one of the numbers

Group of Incremental number, dates, or periods

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

Use a constant value to increase and decrease value

Displays the Excel Help window

You're reference is invalid

Multiplied by the preceding number by the step value