CIS 105 Excel UPDATED ACTUAL
Questions and CORRECT Answers
What does it mean if there are ##### instead of values or results from a formula? - CORRECT
ANSWER - The cell isn't wide enough and you must increase the column width
A workbook is defined as..? - CORRECT ANSWER - A file containing related worksheets
What does the formula bar display? - CORRECT ANSWER - The formula or contents of
an active cell
What does the sheet tab display? - CORRECT ANSWER - The name of a worksheet
within a workbook
What does the name box do? - CORRECT ANSWER - Identifies the address of the current
cell
Why should you use cell references in formulas - CORRECT ANSWER - To change the
input values without changing the formulas
What does a mixed cell reference contain? - CORRECT ANSWER - Both an absolute and
a relative cell reference
What is a function? - CORRECT ANSWER - A predefined formula that performs a
calculation
What does the COUNTA function do? - CORRECT ANSWER - Tallies the number of
cells in a range that are not empty
Questions and CORRECT Answers
What does it mean if there are ##### instead of values or results from a formula? - CORRECT
ANSWER - The cell isn't wide enough and you must increase the column width
A workbook is defined as..? - CORRECT ANSWER - A file containing related worksheets
What does the formula bar display? - CORRECT ANSWER - The formula or contents of
an active cell
What does the sheet tab display? - CORRECT ANSWER - The name of a worksheet
within a workbook
What does the name box do? - CORRECT ANSWER - Identifies the address of the current
cell
Why should you use cell references in formulas - CORRECT ANSWER - To change the
input values without changing the formulas
What does a mixed cell reference contain? - CORRECT ANSWER - Both an absolute and
a relative cell reference
What is a function? - CORRECT ANSWER - A predefined formula that performs a
calculation
What does the COUNTA function do? - CORRECT ANSWER - Tallies the number of
cells in a range that are not empty