ISTM 210 Exam 2 Study Questions and Answers
(2026/2027) | Exam-Focused Revision Pack |
A+
• CONCATENATE function -✓✓CONCATENATE (text1,[text2],...) - combines
blocks of text
• SEARCH function -✓✓NOT case sensitive
• COUNT function -✓✓A function that determines how many cells in a range
contain a number.
• Workbook -✓✓excel file that stores all information, calculations, and analyses.
• Worksheet -✓✓A computerized spreadsheet in Excel.
• Cells -✓✓store individual pieces of data/collections
• Cell Address -✓✓The name of the cell is determined by the name of the row and
the column intersecting, such as A8.
• Fill Feature -✓✓allows you to automatically populate cells in a worksheet by
copying the contents of one cell to other contiguous cells
• Freeze Panes -✓✓allows user to lock rows and columns so they don't disappear.
• Format Painter -✓✓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 -✓✓average, calculates the simple average of a set of numbers
• Absolute Reference -✓✓cell reference that remains constant when a formula is
pasted into a new cell. C$1, $C$1, $C1
, • Relative reference -✓✓changes when reference is copied and pasted into other
cells
• SUM function -✓✓calculates the total of values contained in two or more cells
• Function Wizard -✓✓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
• COUNT -✓✓counts the number of cells in a range of cells that contain numbers
• MAX -✓✓returns the largest value in a set of values
• MIN -✓✓returns the smallest value in a set of values
• COUNTA -✓✓counts the number of cells in a range that are NOT blank
• RATE -✓✓calculates interest rate earned for an investment given the number of
payments made as part of the investment, payment amount, and current value.
• EFFECT -✓✓calculates effective annual percentage rate for an interest rate
given the number of periods per year that interest is charged.
• NPER -✓✓calculates the number of payments that will be made to pay off a loan
given the interest rate, payment amount, and original loan amount.
• PMT -✓✓Function that calculates the periodic payment for an installment loan.
• PV -✓✓calculates the current value (accounting for compounding interest) of an
investment given the interest rate, number of payments to be made, and the amount
of the payment.
• FV -✓✓calculates the future value of an investment given the interest rate,
number of payments to be made, and the amount of the payment.
• Trace Precedents -✓✓allows you to see which cells are referenced in a particular
formula or function
(2026/2027) | Exam-Focused Revision Pack |
A+
• CONCATENATE function -✓✓CONCATENATE (text1,[text2],...) - combines
blocks of text
• SEARCH function -✓✓NOT case sensitive
• COUNT function -✓✓A function that determines how many cells in a range
contain a number.
• Workbook -✓✓excel file that stores all information, calculations, and analyses.
• Worksheet -✓✓A computerized spreadsheet in Excel.
• Cells -✓✓store individual pieces of data/collections
• Cell Address -✓✓The name of the cell is determined by the name of the row and
the column intersecting, such as A8.
• Fill Feature -✓✓allows you to automatically populate cells in a worksheet by
copying the contents of one cell to other contiguous cells
• Freeze Panes -✓✓allows user to lock rows and columns so they don't disappear.
• Format Painter -✓✓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 -✓✓average, calculates the simple average of a set of numbers
• Absolute Reference -✓✓cell reference that remains constant when a formula is
pasted into a new cell. C$1, $C$1, $C1
, • Relative reference -✓✓changes when reference is copied and pasted into other
cells
• SUM function -✓✓calculates the total of values contained in two or more cells
• Function Wizard -✓✓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
• COUNT -✓✓counts the number of cells in a range of cells that contain numbers
• MAX -✓✓returns the largest value in a set of values
• MIN -✓✓returns the smallest value in a set of values
• COUNTA -✓✓counts the number of cells in a range that are NOT blank
• RATE -✓✓calculates interest rate earned for an investment given the number of
payments made as part of the investment, payment amount, and current value.
• EFFECT -✓✓calculates effective annual percentage rate for an interest rate
given the number of periods per year that interest is charged.
• NPER -✓✓calculates the number of payments that will be made to pay off a loan
given the interest rate, payment amount, and original loan amount.
• PMT -✓✓Function that calculates the periodic payment for an installment loan.
• PV -✓✓calculates the current value (accounting for compounding interest) of an
investment given the interest rate, number of payments to be made, and the amount
of the payment.
• FV -✓✓calculates the future value of an investment given the interest rate,
number of payments to be made, and the amount of the payment.
• Trace Precedents -✓✓allows you to see which cells are referenced in a particular
formula or function
