ISTM 210 Exam 2 Excel (Phinney)
2025/2026 Exam Questions and Answers
| A+ Score Assured
Phinney's Fav formula - 🧠 ANSWER ✔✔CONCATENATE
CONCATENATE function - 🧠 ANSWER ✔✔CONCATENATE
(text1,[text2],...) - combines blocks of text
SEARCH function - 🧠 ANSWER ✔✔NOT case sensitive
COUNT function - 🧠 ANSWER ✔✔A function that determines how many
cells in a range contain a number.
Workbook - 🧠 ANSWER ✔✔excel file that stores all information,
calculations, and analyses.
Worksheet - 🧠 ANSWER ✔✔A computerized spreadsheet in Excel.
Cells - 🧠 ANSWER ✔✔store individual pieces of data/collections
, Cell Address - 🧠 ANSWER ✔✔The name of the cell is determined by the
name of the row and the column intersecting, such as A8.
Fill Feature - 🧠 ANSWER ✔✔allows you to automatically populate cells in a
worksheet by copying the contents of one cell to other contiguous cells
Freeze Panes - 🧠 ANSWER ✔✔allows user to lock rows and columns so
they don't disappear.
Format Painter - 🧠 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.
AVG - 🧠 ANSWER ✔✔average, calculates the simple average of a set of
numbers
Absolute Reference - 🧠 ANSWER ✔✔cell reference that remains constant
when a formula is pasted into a new cell. C$1, $C$1, $C1
Relative reference - 🧠 ANSWER ✔✔changes when reference is copied and
pasted into other cells
SUM function - 🧠 ANSWER ✔✔calculates the total of values contained in
two or more cells
2025/2026 Exam Questions and Answers
| A+ Score Assured
Phinney's Fav formula - 🧠 ANSWER ✔✔CONCATENATE
CONCATENATE function - 🧠 ANSWER ✔✔CONCATENATE
(text1,[text2],...) - combines blocks of text
SEARCH function - 🧠 ANSWER ✔✔NOT case sensitive
COUNT function - 🧠 ANSWER ✔✔A function that determines how many
cells in a range contain a number.
Workbook - 🧠 ANSWER ✔✔excel file that stores all information,
calculations, and analyses.
Worksheet - 🧠 ANSWER ✔✔A computerized spreadsheet in Excel.
Cells - 🧠 ANSWER ✔✔store individual pieces of data/collections
, Cell Address - 🧠 ANSWER ✔✔The name of the cell is determined by the
name of the row and the column intersecting, such as A8.
Fill Feature - 🧠 ANSWER ✔✔allows you to automatically populate cells in a
worksheet by copying the contents of one cell to other contiguous cells
Freeze Panes - 🧠 ANSWER ✔✔allows user to lock rows and columns so
they don't disappear.
Format Painter - 🧠 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.
AVG - 🧠 ANSWER ✔✔average, calculates the simple average of a set of
numbers
Absolute Reference - 🧠 ANSWER ✔✔cell reference that remains constant
when a formula is pasted into a new cell. C$1, $C$1, $C1
Relative reference - 🧠 ANSWER ✔✔changes when reference is copied and
pasted into other cells
SUM function - 🧠 ANSWER ✔✔calculates the total of values contained in
two or more cells
