BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+ GRADED

BITM 215 EXAM QUESTIONS AND ANSWERS LATEST UPDATE A+
GRADED


Cell (Excel)
The intersection of a row and a column
cell reference
the column letter and row number that intersect at the cell's location
active cell
a selected worksheet cell that is ready for data entry
Name Box
Area in the formula bar that displays the cell address of the active cell
Range (Excel)
a set of one or more contiguous cells such as a cell, a row, a column, or a block of cells.
Formula
A calculation entered by the user for the data in the spreadsheet
Workbook
a collection of one or more related worksheets contained within a single file
text
combination of letters, numbers, symbols, and spaces
AutoComplete
searches for and automatically displays any other matching text
mathematical order of operations
PEMDAS
Parentheses, Exponent, Multiplication, Division, Addition, Subtraction
SUM function
adds all the numbers in a range of cells
Fill
give cells a background color or pattern
border
separate main or column headings, to emphasize totals, or to group data
Percent Style
The Percent Style formats a value as if it was multiplied by 100 and with a percent
symbol.
Time Number Format
A number formatted for time.
Fraction number format
A number formatted as a fraction.
Scientific number format
special number format
A number with editing characters, such as the parentheses and hyphen in a phone
number, hyphen in a Zip Code+4, and the hyphens in a Social Security number.
Custom number format