Column 1
a verticle group of cells in a worksheet
Column
The intersection column letter and row number form the...
Cell reference or cell address
___________________is an equation that performs mathematical calculations on values in your worksheet.
Formula
A unique letter identifies each column
Column heading
The small square in the lower right corner of a selected cell
fille handle
You can pull out _(__________________)_ one or more slices of a pie chart to emphasize a specific slice or slices.
explode
Two or more cells on a worksheet that are adjacent
range
________________function checks whether one or more conditions - logical tests -- are met, and then returns a value correspoinding to the first TRUE condition,
IFS function
A _________________displays trends over time.
line chart
Filtering controls with buttons that enable you to drill down through large amounts of a data.
Slicers
Mathematical rules and or PEMDAS are called
Order of Operations
What type of chart displays trends over time?
Line
A text funtion that extracts a series of characters from a text string given the location of the beginning character.
MID
a database function that counts the number of occurrences of a specified condition in a databse is:
DCOUNT
to make a letter a shortcut key, precede the letter with:
Ctrl
Information in a database is organized in a format of horizontal rows and vertical columns called a:
Table
The values that an Excel function uses to perform calculations or operations are called:
Arguments
A logical function that returns TRUE in any of the condtions are true.
OR function
Examples of variable expenses in a restaurant are:
food and wages
The abbreviation for number of time periods in various Excel functions.
Nper
An Excel function that looks up values that are displayed vertically in a column is the:
VLOOKUP function
To organize data in a particular order is to:
sort
Buttons on a PivotChart with an arrow to choose a filter, and thus change the data that is displayed in the chart are:
Field Buttons
One possible source of data for a PivotTable is a(n):
Access database file
Slicers are used to:
filter data