EXCEL CRASH CERTIFICATION
EVALUATION FULLY UPDATED TEST
PAPER SOLUTIONS ALREADY PASSED
●● What is represented by the small, black square in the lower-right
corner of an active cell or range?
Answer: Fill handle
●● Which of the following is one way to change column width to fit the
contents?
Answer: Double-click the boundary to the right of the column heading.
●● If you have columns that are truncating your content (not showing all
the content), but you cannot increase the width of the worksheet and be
able to print on one page, a solution for making the text visible without
losing data would be to:
Answer: Click Wrap Text
●● If cells are: A1=90, A2=85, A3=80, A4=75, and A5=75. What will be
your formula if you are going to get the average?
Answer: =AVERAGE(A1:A5)
, ●● You can complete the entry of a cell formula that contains cell
references by pressing _______.
Answer: Enter key
●● Which formula can add the all the numeric values in a range of cells,
ignoring those which are not numeric, and place the result in a different
cell?
Answer: Sum
●● A fast way to add up this column of numbers is to click in the cell
below the numbers and then:
Answer: Click the AutoSum button on the Standard toolbar, then press
ENTER.
●● Which menu option can be used to split windows into two?
Answer: View -> Split
q
●● ###### in a cell means:
Answer: The cell is not wide enough.
●● If you want to paste a formula result, but not the underlying formula,
to another cell, you would copy the cell with the formula, then place the
insertion point in the cell you want to copy to. What next?
EVALUATION FULLY UPDATED TEST
PAPER SOLUTIONS ALREADY PASSED
●● What is represented by the small, black square in the lower-right
corner of an active cell or range?
Answer: Fill handle
●● Which of the following is one way to change column width to fit the
contents?
Answer: Double-click the boundary to the right of the column heading.
●● If you have columns that are truncating your content (not showing all
the content), but you cannot increase the width of the worksheet and be
able to print on one page, a solution for making the text visible without
losing data would be to:
Answer: Click Wrap Text
●● If cells are: A1=90, A2=85, A3=80, A4=75, and A5=75. What will be
your formula if you are going to get the average?
Answer: =AVERAGE(A1:A5)
, ●● You can complete the entry of a cell formula that contains cell
references by pressing _______.
Answer: Enter key
●● Which formula can add the all the numeric values in a range of cells,
ignoring those which are not numeric, and place the result in a different
cell?
Answer: Sum
●● A fast way to add up this column of numbers is to click in the cell
below the numbers and then:
Answer: Click the AutoSum button on the Standard toolbar, then press
ENTER.
●● Which menu option can be used to split windows into two?
Answer: View -> Split
q
●● ###### in a cell means:
Answer: The cell is not wide enough.
●● If you want to paste a formula result, but not the underlying formula,
to another cell, you would copy the cell with the formula, then place the
insertion point in the cell you want to copy to. What next?
