CIS 105 MIDTERM EXAM 2026 UPDATE QUESTIONS
AND CORRECT VERIFIED ANSWERS ALREADY
GRADED A+ (BRAND NEW VISION)
Tab Stops - ANS-The custom tab positions when pressing the Tab Key in a document. The
default is every 1/2 inch. Displayed on the ruler.
Setting Tabs - ANS-(tab stop, alignment, dot leader)
cell - ANS-the intersection of column and row
formula - ANS-a combination of cell references, operators, values, and/or functions used to
perform a calculation
spreadsheet information - ANS-an electronic file that containsa grid of columns and rows
containing related data
Name box - ANS-identifies the address of the current cell
Formula Bar - ANS-displays the content in the active cell
Fill Handle - ANS-a small black square at the bottom-right corner of a cell
Pie Chart - ANS-shows each data point in proportion to the whole data series as a slice in a
circular pie
, column chart - ANS-displays data comparisons vertically in a chart
bar chart - ANS-compares values across categories using horiztontal bars
absolute cell referance - ANS-indicates a cell's specific location; does not change when the
formula is copied
relative cell referance - ANS-indicates a cell's relative location from the cell containing the
formula; changes when the formula is copied
=SUM - ANS-calculates the total of values contained in two or more cells
=Average - ANS-calculates the arithmetic mean or average of the values contained in two or
more cells
=Max - ANS-displays the highest value in a range
=Min - ANS-displays the lowest value in a range
=If - ANS-evaluates a condition and returns one value if the condition is true and another
value if the condition is false
=Vlookup - ANS-looks up a value in a vertical lookup table and returns a related result from
the lookup table
=PMT - ANS-calculates the periodic payment for a loan with a fixed interest rate and fixed
term
AND CORRECT VERIFIED ANSWERS ALREADY
GRADED A+ (BRAND NEW VISION)
Tab Stops - ANS-The custom tab positions when pressing the Tab Key in a document. The
default is every 1/2 inch. Displayed on the ruler.
Setting Tabs - ANS-(tab stop, alignment, dot leader)
cell - ANS-the intersection of column and row
formula - ANS-a combination of cell references, operators, values, and/or functions used to
perform a calculation
spreadsheet information - ANS-an electronic file that containsa grid of columns and rows
containing related data
Name box - ANS-identifies the address of the current cell
Formula Bar - ANS-displays the content in the active cell
Fill Handle - ANS-a small black square at the bottom-right corner of a cell
Pie Chart - ANS-shows each data point in proportion to the whole data series as a slice in a
circular pie
, column chart - ANS-displays data comparisons vertically in a chart
bar chart - ANS-compares values across categories using horiztontal bars
absolute cell referance - ANS-indicates a cell's specific location; does not change when the
formula is copied
relative cell referance - ANS-indicates a cell's relative location from the cell containing the
formula; changes when the formula is copied
=SUM - ANS-calculates the total of values contained in two or more cells
=Average - ANS-calculates the arithmetic mean or average of the values contained in two or
more cells
=Max - ANS-displays the highest value in a range
=Min - ANS-displays the lowest value in a range
=If - ANS-evaluates a condition and returns one value if the condition is true and another
value if the condition is false
=Vlookup - ANS-looks up a value in a vertical lookup table and returns a related result from
the lookup table
=PMT - ANS-calculates the periodic payment for a loan with a fixed interest rate and fixed
term
