Data used in graphs/charts is called _______.

A visual representation of data is called a _______.

A tool that allows you to enter, calculate, manipulate (sort & filter) and analyze data in a series of rows and columns is called a _______.

A chart made of slices that compare proportions or percentages is called a _______.

A chart summarizing a set of categorical data in horizontal bars is called a _______.

A chart that shows comparison between items of data using vertical bars is called a _______.

A chart used to plot two ordered pairs is called a _______.

A chart that displays a series as a set of points connected by a line with all the area filled in below the line is called a _______.

A chart arranged in columns or rows, with data plotted along a line and used to show trends over time, is called a _______.

The intersection of a row or column or an individual rectangle in a spreadsheet is called a _______.

The name of the intersection of a row and column, charted with a letter (column) then a number (row), for example C4, is called a _______.

A money cell format, represented by $, is called a _______.

A feature that automatically formats cells based on data within the cell is called _______.

What is identified by numbers in a worksheet?

What is identified by letters in a worksheet?

What is a select group of cells in a workbook/table called?

What adds grid lines to the worksheet?

What is an equation that performs calculations (+-*/^) in a worksheet and all formulas begin with an (=) equal sign called?

All formulas must begin with what sign?

What is a pre-written formula that takes a value, performs an operation and returns a value called?

What automatically adds all numbers in a contiguous row?

What function adds all numbers in a range of cells?

What function is the arithmetic mean which is calculated by adding a group of numbers and then dividing by the count of those numbers?

What function displays the highest value in a range?

What function displays the lowest value in a range?

What function finds out how many times a particular text or number occurs?

What command is used to repeat data to adjacent or contiguous cells?

What automatically copies cell contents to consecutive or adjacent (touching) cells?

What keyboard shortcut is described as CTRL + click?

Command used to conceal data. Fill in the blank: ________

Sorting data alphabetically (A-Z) or lowest to highest numerically. Fill in the blank: ________

Able to view data differently based on a set criteria. Fill in the blank: ________

Re-order the data. Fill in the blank: ________

When copying, adjusts the cell addresses for each new position. Fill in the blank: ________

When copying, keeps the cell address constant (not changing) by using a $$. Example C$$ 5. Fill in the blank: ________

Combining selected cells into one cell. Fill in the blank: ________

Appear on left hand portion of cell. Fill in the blank: ________

Appear on right hand portion of cell. Fill in the blank: ________

Double click to resize a cell. Fill in the blank: ________

% data format. Fill in the blank: ________

Data format for date and time. Fill in the blank: ________

Displays cell contents; allows users to enter functions or formulas. Fill in the blank: ________

Identifies the information being displayed in the chart. Fill in the blank: ________

Fill in the blank: A ______ is a list that identifies patterns, symbols, or colors used in a chart.

Fill in the blank: The ______ is the base of the chart or graph that usually the data series heading or time frames.

Fill in the blank: The ______ is the vertical scale of a chart on which the values from each category is plotted, sometimes called the Y axis.

What type of chart is shown in the image?

What type of chart is shown in the image?

What type of chart is shown in the image?

What type of chart is shown in the image?

What type of chart is shown in the image?