TAMU ISTM 210 EXAMINATION SET 2026
SOLVED QUESTIONS GRADED A+
● 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
● Function Wizard. 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
SOLVED QUESTIONS GRADED A+
● 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
● Function Wizard. 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
