BASIC EXCEL EXAM QUESTIONS AND
ANSWERS
Which is the part of the Excel screen where you can find all the commands or buttons,
depending on the tab you selected before? - Correct Answers -Ribbon
What is represented by the small, black square in the lower-right corner of an active cell
or range? - Correct Answers -Fill handle
Which of the following is one way to change column width to fit the contents? - Correct
Answers -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: - Correct Answers -
Click Wrap Text
To add a new row, click a cell in the row immediately above where you want the new
row, right click, select insert and press enter. - Correct Answers -False
Which is not the function of "Edit, Clear" command? - Correct Answers -Delete cells
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? - Correct Answers -=AVERAGE(A1:A5)
You can complete the entry of a cell formula that contains cell references by pressing
_______. - Correct Answers -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? - Correct Answers -Sum
A fast way to add up this column of numbers is to click in the cell below the numbers
and then: - Correct Answers -Click the AutoSum button on the Standard toolbar, then
press ENTER.
Which menu option can be used to split windows into two? - Correct Answers -View ->
Split
q
###### in a cell means: - Correct Answers -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
ANSWERS
Which is the part of the Excel screen where you can find all the commands or buttons,
depending on the tab you selected before? - Correct Answers -Ribbon
What is represented by the small, black square in the lower-right corner of an active cell
or range? - Correct Answers -Fill handle
Which of the following is one way to change column width to fit the contents? - Correct
Answers -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: - Correct Answers -
Click Wrap Text
To add a new row, click a cell in the row immediately above where you want the new
row, right click, select insert and press enter. - Correct Answers -False
Which is not the function of "Edit, Clear" command? - Correct Answers -Delete cells
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? - Correct Answers -=AVERAGE(A1:A5)
You can complete the entry of a cell formula that contains cell references by pressing
_______. - Correct Answers -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? - Correct Answers -Sum
A fast way to add up this column of numbers is to click in the cell below the numbers
and then: - Correct Answers -Click the AutoSum button on the Standard toolbar, then
press ENTER.
Which menu option can be used to split windows into two? - Correct Answers -View ->
Split
q
###### in a cell means: - Correct Answers -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
