ISTM 210 Exam 2 Excel (phinney)
Questions & Answers (Grade A+)
Phinney's Fav formula -
correct answer ✅CONCATENATE
CONCATENATE function -
correct answer ✅CONCATENATE (text1,[text2],...) - combines
blocks of text
SEARCH function -
correct answer ✅NOT case sensitive
COUNT function -
correct answer ✅A function that determines how many cells in a
range contain a number.
Workbook -
correct answer ✅excel file that stores all information, calculations,
and analyses.
Worksheet -
correct answer ✅A computerized spreadsheet in Excel.
,ISTM 210 Exam 2 Excel (phinney)
Questions & Answers (Grade A+)
Cells -
correct answer ✅store individual pieces of data/collections
Cell Address -
correct answer ✅The name of the cell is determined by the name
of the row and the column intersecting, such as A8.
Fill Feature -
correct answer ✅allows you to automatically populate cells in a
worksheet by copying the contents of one cell to other contiguous
cells
Freeze Panes -
correct answer ✅allows user to lock rows and columns so they
don't disappear.
Format Painter -
correct answer ✅A feature that copies format attributes such as
colors, borders, and fill effects from an object, text, or cell in order
to apply the same formatting to another object, text, or cell.
, ISTM 210 Exam 2 Excel (phinney)
Questions & Answers (Grade A+)
AVG -
correct answer ✅average, calculates the simple average of a set of
numbers
Absolute Reference -
correct answer ✅cell reference that remains constant when a
formula is pasted into a new cell. C$1, $C$1, $C1
Relative reference -
correct answer ✅changes when reference is copied and pasted
into other cells
SUM function -
correct answer ✅calculates the total of values contained in two or
more cells
Function Wizard -
correct answer ✅1. allows you to enter or select the inputs for the
function
2. provides a description of the function and each argument
3. lists the function result based on the inputs you enter
Questions & Answers (Grade A+)
Phinney's Fav formula -
correct answer ✅CONCATENATE
CONCATENATE function -
correct answer ✅CONCATENATE (text1,[text2],...) - combines
blocks of text
SEARCH function -
correct answer ✅NOT case sensitive
COUNT function -
correct answer ✅A function that determines how many cells in a
range contain a number.
Workbook -
correct answer ✅excel file that stores all information, calculations,
and analyses.
Worksheet -
correct answer ✅A computerized spreadsheet in Excel.
,ISTM 210 Exam 2 Excel (phinney)
Questions & Answers (Grade A+)
Cells -
correct answer ✅store individual pieces of data/collections
Cell Address -
correct answer ✅The name of the cell is determined by the name
of the row and the column intersecting, such as A8.
Fill Feature -
correct answer ✅allows you to automatically populate cells in a
worksheet by copying the contents of one cell to other contiguous
cells
Freeze Panes -
correct answer ✅allows user to lock rows and columns so they
don't disappear.
Format Painter -
correct answer ✅A feature that copies format attributes such as
colors, borders, and fill effects from an object, text, or cell in order
to apply the same formatting to another object, text, or cell.
, ISTM 210 Exam 2 Excel (phinney)
Questions & Answers (Grade A+)
AVG -
correct answer ✅average, calculates the simple average of a set of
numbers
Absolute Reference -
correct answer ✅cell reference that remains constant when a
formula is pasted into a new cell. C$1, $C$1, $C1
Relative reference -
correct answer ✅changes when reference is copied and pasted
into other cells
SUM function -
correct answer ✅calculates the total of values contained in two or
more cells
Function Wizard -
correct answer ✅1. allows you to enter or select the inputs for the
function
2. provides a description of the function and each argument
3. lists the function result based on the inputs you enter
