chapter 1
Workbook
An Excel file that contains one or more worksheets.
formula
=C6+Y3 is a example of a___ cell entry.
cell
A ___ is formed at the intersection of a given column and row.
spreadsheet
A ___ refers to a category of computer software applications that can be extremely useful for analyzing numeric data.
conditional format
A format that changes the appearance of a cell based on a condition.
IF function
A function that uses a logical test to check whether a condition is met, and then returns one value if true and another value if false.
logical function
A group of functions that test for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false.
row
A horizontal group of cells in a worksheet.
row
A horizontally arranged group of cells is called a ___.
Sum function
A predefined formula that adds all the numbers in a selected range.
function
A predefined formula that performs calculations by using specific values in a particular order or structure.
CountIF function
A statistical function that counts the number of cells within a range that meet the given condition and which has two arguments—the range of cells to check and the criteria.
column
A vertical group of cells in a worksheet
column
A vertically arranged group of cells is called a ___.
1A
All of the following are examples of cell references, except ___.
autocomplete
An Excel feature which, after typing an = (equal sign) and the beginning letter or letters of a function name, displays a list of function names that match the typed letter(s).
Average function
An Excel function that adds a group of values and then divides the result by the number of values in the group.
max function
An Excel function that determines the largest value in a range.
min function
An Excel function that determines the smallest value in a range.
median function
An Excel function that finds the middle value that has as many values above it in the group as are below it.
formula
An equation that performs mathematical calculations on values in a worksheet.
Cell address
Another name for a cell reference.
value
Another name for a constant value.
spreadsheet
Another name for a worksheet.
logical test
Any value or expression that can be evaluated as being true or false.
cell content
Anything typed into a cell.
workbook
BUDGET.XLSX is the name of a ___.
text/label
C+Y3 is a example of a___ cell entry.
5th, 20th
Cell E20 is the intersection of the ___ column and ___ row.
letters
Columns are labeled with ___.
criteria
Conditions that you specify in a logical function.
number values
Constant values consisting of only numbers.
Statistical functions
Excel functions, such as AVERAGE, that are useful to analyze a group of measurements.
+
In an Excel formula, the symbol for addition is ______. *
/
In an Excel formula, the symbol for division is ______. Correct!
^
In an Excel formula, the symbol for exponentiation is ______.
*
In an Excel formula, the symbol for multiplication is ______.
-
In an Excel formula, the symbol for subtraction is ______.
column
Letters (A. B, C, etc.) are used as ___ designations in a worksheet.
row
Numbers (1. 2, 3, etc.) are used as ___ designations in a worksheet.
Constant value
Numbers, text, dates, or times of day that you type into a cell.
text/label
Quarter 1 is a example of a___ cell entry.
numbers
Rows are labeled with ___.
workbook
Spreadsheet applications, such as Microsoft Excel, produce a file called a ___.
comparison operator
Symbols that evaluate each value to determine if it is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria.
data
Text or numbers in a cell.
value
The date 12/31/2000 is a ______ cell entry.
value
The date December 31, 2000 is a example of a___ cell entry.
chart
The graphic representation of data in a worksheet.
cell
The intersection of a column and a row.
sheet tabs
The labels along the lower border of the Excel window that identify each worksheet.
value
The number 145,234 is a ______ cell entry. Correct! value
fill handle
The small black square in the lower right corner of a selected cell.
