Have an account?
Skip to Content
18 questions
Show Answers
See Preview
- Multiple ChoicePlease save your changes before editing any questions.
The function CONCATENATE extracts part of the string.
True
False
- Multiple ChoicePlease save your changes before editing any questions.
The name of the cell that belongs to the second column and to the third row is called B3.
True.
False
- Multiple ChoicePlease save your changes before editing any questions.
The AND function returns true only if the two arguments is true.
True
False
- Multiple ChoicePlease save your changes before editing any questions.
Each column has a number (1, 2, …) on the top. These
numbers are the names of the columns.
True
False
- Multiple ChoicePlease save your changes before editing any questions.
When you use the dollar sign in front of a number, the row remains the same and the column changes.
True
False
- Multiple ChoicePlease save your changes before editing any questions.
#REF! We get this type of error when a reference is invalid.
True
False
- Multiple ChoicePlease save your changes before editing any questions.
#DIV/0! We get this type of error when a formula has invalid numeric data for the type of operation you are trying to calculate.
True
False
- Multiple ChoicePlease save your changes before editing any questions.
The AutoFill tool copies the formula but not the formatting of the cell.
True
False
- Multiple ChoicePlease save your changes before editing any questions.
When you use the dollar sign in front of a letter, the column changes when it is copied, but the row remains the same.
True
False
- Multiple ChoicePlease save your changes before editing any questions.
The only way to add text to a cell is to double click it and then start typing.
True
False
- Multiple ChoicePlease save your changes before editing any questions.
When you type number inside the cell
It is aligned to the left.
It is aligned in the centre.
It is aligned to the right.
- Multiple ChoicePlease save your changes before editing any questions.
When you type text inside a cell
It is aligned to the right.
It is aligned in the centre.
It is aligned to the left.
- Multiple ChoicePlease save your changes before editing any questions.
When you draw chart in Excel and you made a change in the data.
The chart will automatically change.
You will re-insert the chart again.
Draw the chart again.
- Multiple ChoicePlease save your changes before editing any questions.
When you insert a chart into your Excel sheet
You cannot change the title of x-axis.
You can change only the title of x-axis
You can change the title of both x- axis and y-axis.
- Multiple ChoicePlease save your changes before editing any questions.
In order to make a cell as an active cell
Right click on it.
Left click on it.
Click on it.
- Multiple ChoicePlease save your changes before editing any questions.
The pie chart is used to
Display trends over a period of time.
Make comparison between two or more categories.
Show a part of the whole.
- Multiple ChoicePlease save your changes before editing any questions.
The MAX function is used to get the sum of cells.
True
False
- Multiple ChoicePlease save your changes before editing any questions.
When you use the dollar sign in front of a number, the row remains the same and the column changes.
True
False