excel
Absolute cell references are indicated by using what symbol in the cell address?
$
Which is the Excel operator for multiplication
*
) IF is an example of a ________ function
...
A value or expression that can be evaluated as true or false is called a:
...
Functions that test for a specific condition are called ________ functions.
...
If a column of data holds the letter grades for a class, the ________ function could be used to determine how many students had a grade of "A".
...
The COUNTIF function takes two arguments
...
The Excel operator for "greater than or equal" to is:
...
The Excel operator for "not equal to" is:
...
The ________ function counts the number of cells within a range that meet a certain criteria
...
The ________ function returns one value if a condition is met, and a different value if it is not.
...
Values are evaluated using ________ operators.
...
Which of the following is an example of a logical test?
...
All Excel formulas begin with which symbol?
=
Excel's ________ function adds all of its arguments then divides the sum by the number of arguments.
AVERAGE
The ________ inserts a thousand comma separator when appropriate, inserts a fixed U.S. dollar sign aligned at the left edge of the cell, applies two decimal places, and provides space for negative numbers to be displayed inside of parentheses
Accounting number Format
The values that an Excel function uses to perform operations are called
Arguments.
Use ________ to split data from two or more cells or to combine data from two cells.
Flashfill
The result of a formula displays in the active cell, and the ________ itself displays in the Formula Bar.
Formula
In the ________ you can enter a value or a formula or edit a value or formula in the active cell.
Formula Bar
Excel's ________ function finds the middle value in a range
MEDIAN
Excel's ________ function finds the middle value in a range.
MEDIAN
The Excel function ________ would be used to find the lowest score on a series of student test scores.
MIN
Which Excel function would be used to find the middle value of a list of test scores
Median
Excel's ________ command creates one cell from the selected cells and centers the contents within the new cell
Merge & Center
The ________ function adds all of the numbers in a range of cells.
SUM
The functions AVERAGE and MEDIAN are examples of ________ functions, which are useful when the user needs to analyze a group of measurements.
Statistical
Which Excel function would be used to calculate the total points a student earned on a series of tests?
Sum
Which is the Excel operator for exponentiation?
^
The ________, when outlined in black, indicates it is ready to accept data.
active cell
The values that an Excel function uses to perform operations are called:
argument
. Excel uses ________ to perform basic mathematical operations.
arithemetic operators
The ________ feature fills in the remaining characters of a word if what is typed matches an existing entry in the column
auto complete
________ generates and extends a series of values into adjacent cells based on the values of other cells.
auto fill
To widen a column to fit the cell content of the widest cell in the column, use
autofit
Labels that display along the bottom of a chart to identify the category of the data are called
category labels
A ________ is created when a row and a column intersect
cell
Anything you type into a cell is referred to as
cell content
________ are defined as sets of formatting characteristics, such as font, font size, font color, cell borders, and cell shading.
cell styles
To make data easier to understand, use a ________ instead of a table of numbers
chart
A data marker, such as a column, dot, or pie slice on a chart, represents a single
data point
Charted values that originate in a worksheet are called
data points
In an Excel chart, a ________ is made up of related data points
data series
The data you see in a cell is called the
displayed value
The small black square in the lower right corner of a selected cell is called the
fill handle
A predefined formula is called a
function
A prewritten formula known as a (n) ________ looks at one or more values, performs an operation, and returns a value.
function
A text value is also referred to as a
label
On an Excel chart, the ________ identifies the patterns or colors that are assigned to all the categories in the chart.
legend
) Excel's ________ function finds the largest value in a selected range of cells.
max
The ________ displays the name of the selected cell, table, chart, or object
name box
To center worksheet data horizontally and vertically on a page, use the ________ dialog box
page setup
Two or more cells that Excel treats as a single unit is called a
range
________ shrinks the width and height of the printed worksheet to fit a maximum number of pages.
scaling
A group of items that come one after another in succession is called
series
A ________ identifies a worksheet in a workbook
sheet tab
Tiny charts embedded in cells that show a visual trend alongside the data are called
spark lines
The Current cell mode, the page number, and the view and zoom button display on the
status bar
The Formula Bar displays the data known as the
underlying value
an excel document is called a
workbook
A ________ is formatted as a pattern of uniformly spaced horizontal rows and vertical columns.
worksheets
The individual pages of an Excel document are called
worksheets
