Basic Computer Skills Review
Exam With Correct Solutions |
Graded A+
Which of the following symbols is used to convert a number to text? - Correct Answer-'
If ######## or 12.0E+3 displays in a cell, what should you do so the cell will display
the actual number? - Correct Answer-widen the column
If you want to copy data from one cell to another cell that is several rows down in a
worksheet, which method should you use? - Correct Answer-copy and paste
Which one is not a date AutoFill option? - Correct Answer-Fill Semiannually
If you apply borders or fill color to cells, removing the borders or fill color can be done
by selecting the cells and pressing the Delete key on your keyboard. - Correct Answer-
False
You can remove the formats only of cells using the Clear tool options of ________. -
Correct Answer-Clear Formats
Moving a worksheet to a new location in the workbook is easy. Simply click on the
worksheet tab and _______. - Correct Answer-drag
In the order of operations, what is calculated after multiplication and division? - Correct
Answer-addition and subtraction
When creating formulas in the Excel program, it's important to start the formula with
the _______. - Correct Answer-=
What symbol is used in absolute and mixed cell references? - Correct Answer-$
What is the name of the tool that contains the commonly used functions in the Excel
program? - Correct Answer-AutoSum
When setting up data in a worksheet to be sorted or filtered, it's important to leave no
_________ rows or columns in the data. - Correct Answer-blank
1|Page
Exam With Correct Solutions |
Graded A+
Which of the following symbols is used to convert a number to text? - Correct Answer-'
If ######## or 12.0E+3 displays in a cell, what should you do so the cell will display
the actual number? - Correct Answer-widen the column
If you want to copy data from one cell to another cell that is several rows down in a
worksheet, which method should you use? - Correct Answer-copy and paste
Which one is not a date AutoFill option? - Correct Answer-Fill Semiannually
If you apply borders or fill color to cells, removing the borders or fill color can be done
by selecting the cells and pressing the Delete key on your keyboard. - Correct Answer-
False
You can remove the formats only of cells using the Clear tool options of ________. -
Correct Answer-Clear Formats
Moving a worksheet to a new location in the workbook is easy. Simply click on the
worksheet tab and _______. - Correct Answer-drag
In the order of operations, what is calculated after multiplication and division? - Correct
Answer-addition and subtraction
When creating formulas in the Excel program, it's important to start the formula with
the _______. - Correct Answer-=
What symbol is used in absolute and mixed cell references? - Correct Answer-$
What is the name of the tool that contains the commonly used functions in the Excel
program? - Correct Answer-AutoSum
When setting up data in a worksheet to be sorted or filtered, it's important to leave no
_________ rows or columns in the data. - Correct Answer-blank
1|Page
