50 terms

Kaylee_DutroTEACHER

Spreadsheet

A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns.

Row

Horizontal line of cells

Cell

A box that holds data

Column

A vertical line of cells

Cell Address

The column and the row number of a cell, e.g. C13; F27;

Formula Bar

the cell that one enters numbers, a formula or text

: (the colon)

Symbol used to designate a range (2 or more cells that are adjacent to each other) For Example: B3:B37 means b3,b4, b5,...to b37

, (the comma)

Symbol used to designate the use of cells that are NON-ADJACENT in a formula or function

=SUM(A12+A13)

Adding two cells

Sort

Putting data in a certain order

Filter

Temporarily displays only certain data that meets a condition that you specify

Max

the largest number

Average

the sum of all numbers divided by the amount of numbers

Min

The lowest number

######

column is not wide enough to display contents

#name?

error in your formula

#div/0!

Need numbers in ur cells, cannot divide by zero

AutoFill

Completes previously typed words when you begin to repeat the typing

Column Chart

Displays vertical bars going across the chart, with the values axis being displayed on the left side of the chart.

Pie Chart

Displays a circle is divided into sectors which shows a percentage of a whole.

Bar Chart

Displays horizontal bars going down the chart with the values axis on the bottom of the chart.

Doughnut Chart

Like a pie chart, it displays data as parts of a whole, but with a hole. This allows you to display multiple series of a chart within each other, like the picture.

Line Chart

Displays information as a series of data points called 'markers' connected by straight line segments.

Scatter Chart

Displays data points for two variables on a coordinate plane.

Active Cell

The selected cell in Excel, marked by a thick border

Count

Calculates how many numbers are in the selected group

Function

Pre-defined calculations that are available

Formula

A custom calculation created by the user

Columns are marked...

... by letters

Rows are marked...

... by numbers

$

Marks an absolute (as opposed to relative) cell in a formula

The button used to highlight the entire spreadsheet

(See picture)

Series

A row or column of data that is being used in a chart

An INCORRECT Excel function example

Function Example: sum(A3:A7)=

A CORRECT Excel function example:

Function example: =sum(A3:A7)

Category Axis

The horizontal or x-axis of a chart

Value Axis

The vertical or y-axis of a chart

` (grave accent)

The key used to toggle your formulas to show the math instead of the result

Lookup Function

Retrieves values from a table of data that match a specified condition.

Conditional Formatting

Formatting that is applied to a cell when a specified condition is met.

IF functions

Performs a logical test and return one value for a TRUE result, and another for a FALSE result. For example, to "pass" scores above 70: =IF(A1>70,"Pass","Fail").

Cell Orientation

Changing the direction of text within a cell

Wrap Text

Moves long text within a cell onto multiple lines to prevent overlap

Merge & Center

Joins selected cells into one larger cell and centers the contents

=Sheet2!B2 - what does this do?

Grabs B2 on Sheet 2 and inserts it into another sheet

What can you do with comma separated values (CSV)?

You can automatically split them into rows or columns

Named range

A human-friendly name given to a cell or range of cells so you can refer to it often. Could be used as an alternative to having to do an absolute cell reference.

The Transpose feature

Will quickly switch data from a column to a row or vice versa.

The Subtotals feature

Allows you to perform a function on preliminary groups of data before calculating a grand total

Scale to Fit

Reduces the size of a worksheet so it will better fit on a printed page