50 terms

# Excel

#### Terms in this set (...)

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
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)
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?
#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
STUDY GUIDE

#### Flickr Creative Commons Images

Some images used in this set are licensed under the Creative Commons through Flickr.com.
Click to see the original works with their full license.