BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED
Accounting Number Format
A number format that displays $ on the left side of a cell and formats values with
commas for the thousands separator and two decimals
Active Cell
The current cell in a worksheet. It is indicated by a dark green border onscreen
Alignment
Placement of data within cell boundaries
AutoComplete
A feature that searches for and automatically displays any other label in that column
that matches the letters you typed.
Border
A line that surrounds a cell or a range of cells to offset particular data from the rest of
the data in a worksheet
Cell
The intersection of a column and row in a worksheet
Cell Address
The unique identifier of a cell, starting with the column letter and then the row number.
Such as A9
Column Heading
The alphabetical letters above the columns in a worksheet
Column Width
The horizontal measurement of a column in a table or a worksheet. In excel, it is
measured by the number of characters or pixels
Comma Style
A number format that formats values with commas for the thousands separator and two
decimal places
Fill Color
The background color that displays behind the data in a cell
Fill Handle
A small square at the bottom-right corner of a cell used to copy cell contents to text or
number patters to adjacent cells
Formula Bar
An element in Excel that appears below the ribbon and tot he right of the insert function
command. It shows the contents of the active cell
Formula
A combo of cell references, operators, values, and/or functions used to perform a
calculation. A formula starts with an equal sign
Horizontal Alignment
The placement of of cell data between the left and the right cell margins in a worksheet
Indent
A format that positions cell contents to the right of the left cell margin to offset the data
Input Area
, A range of cells in a worksheet used to store and change the variables used in
calculations
Name Box
An identifier that displays the address or the range name of the current cell in an Excel
worksheet
Nonadjacent Range
A collection of multiple ranges that are not positioned in a contiguous cluster in an Excel
worksheet
Normal View
The default view of a worksheet that shows worksheet data but not margins, headers,
footers, or page breaks.
Number Formats
Predefined settings that control how values appear in cells
Order of Operations (order of precedence)
A set of rules that determines the sequence by which operations are calculated in an
expression
Output Area
The range of cells in an Excel worksheet that contain formulas dependent on the values
in the input area
Page Break Preview
The display that shows the worksheet data and page breaks within the worksheet.
Page Layout View
The display that shows the worksheet data, margins, headers, and footers
Paste Options button
An icon that displays in the bottom-right corner immediately after using the paste
command. It enables the user to apply different paster options
Perent Style
A number format that displays values as if they were multiplied by 100 and with the %
symbol
Pointing
The process of using the mouse pointer to select cells while building a formula. Also
known as semi-selection
Range
A group of adjacent or contiguous cells in an Excel worksheet
Row Heading
The numbers to the left side of rows in a worksheet
Row Height
The vertical measurement of the row in a worksheet
Semi-Selection
The process of using the mouse pointer to select cells while building a formula. Also
known as pointing
Sheet Tab
A visual element that shows the name of a worksheet contained in the workbook
Sheet Tab Navigation
Visual elements that help you navigate to the first, previous, next, or last sheet within a
workbook
GRADED
Accounting Number Format
A number format that displays $ on the left side of a cell and formats values with
commas for the thousands separator and two decimals
Active Cell
The current cell in a worksheet. It is indicated by a dark green border onscreen
Alignment
Placement of data within cell boundaries
AutoComplete
A feature that searches for and automatically displays any other label in that column
that matches the letters you typed.
Border
A line that surrounds a cell or a range of cells to offset particular data from the rest of
the data in a worksheet
Cell
The intersection of a column and row in a worksheet
Cell Address
The unique identifier of a cell, starting with the column letter and then the row number.
Such as A9
Column Heading
The alphabetical letters above the columns in a worksheet
Column Width
The horizontal measurement of a column in a table or a worksheet. In excel, it is
measured by the number of characters or pixels
Comma Style
A number format that formats values with commas for the thousands separator and two
decimal places
Fill Color
The background color that displays behind the data in a cell
Fill Handle
A small square at the bottom-right corner of a cell used to copy cell contents to text or
number patters to adjacent cells
Formula Bar
An element in Excel that appears below the ribbon and tot he right of the insert function
command. It shows the contents of the active cell
Formula
A combo of cell references, operators, values, and/or functions used to perform a
calculation. A formula starts with an equal sign
Horizontal Alignment
The placement of of cell data between the left and the right cell margins in a worksheet
Indent
A format that positions cell contents to the right of the left cell margin to offset the data
Input Area
, A range of cells in a worksheet used to store and change the variables used in
calculations
Name Box
An identifier that displays the address or the range name of the current cell in an Excel
worksheet
Nonadjacent Range
A collection of multiple ranges that are not positioned in a contiguous cluster in an Excel
worksheet
Normal View
The default view of a worksheet that shows worksheet data but not margins, headers,
footers, or page breaks.
Number Formats
Predefined settings that control how values appear in cells
Order of Operations (order of precedence)
A set of rules that determines the sequence by which operations are calculated in an
expression
Output Area
The range of cells in an Excel worksheet that contain formulas dependent on the values
in the input area
Page Break Preview
The display that shows the worksheet data and page breaks within the worksheet.
Page Layout View
The display that shows the worksheet data, margins, headers, and footers
Paste Options button
An icon that displays in the bottom-right corner immediately after using the paste
command. It enables the user to apply different paster options
Perent Style
A number format that displays values as if they were multiplied by 100 and with the %
symbol
Pointing
The process of using the mouse pointer to select cells while building a formula. Also
known as semi-selection
Range
A group of adjacent or contiguous cells in an Excel worksheet
Row Heading
The numbers to the left side of rows in a worksheet
Row Height
The vertical measurement of the row in a worksheet
Semi-Selection
The process of using the mouse pointer to select cells while building a formula. Also
known as pointing
Sheet Tab
A visual element that shows the name of a worksheet contained in the workbook
Sheet Tab Navigation
Visual elements that help you navigate to the first, previous, next, or last sheet within a
workbook
