Biology
Chemistry
Computer
English
Geography
Hindi
History & Civics
Physics
Science
Displaying 5 out
of 19
questions & answers.
Q1.
Fill in the blanks with correct words.
| Formula | Enter | Same | Mixed | Concatenation |
- The button on the Formula bar works as ______ key.
- $B7 is an example of _______ referencing.
- Joining two strings is called _________.
- Formula can be entered on the ________ bar on the cell.
- The Multiplication (*) and division (/) arithmetic operators have the _______ order of evaluation.
S A
M P L E
S
A M P L E
www.bigslate.com
Answer:
S A M P L E
- Enter
- Mixed
- Concatenation
- Formula
- Same
Q2.
Write T for the true statement and F for False one. Correct the false statement(s).
- By default, Excel creates a relative cell reference in a formula.
- The Cancel button present near the Formula bar works as the Enter key.
- The error '#####' appears if the formula contains an invalid operation.
- All cells in rows 5 through 9 are referred as 5.9.
- In the order of evaluation the addition operator (+) has higher precedence than the exponent operator (^).
S A
M P L E
S
A M P L E
www.bigslate.com
Answer:
S A M P L E
answer not shownQ3.
What is the difference between the three types of cell referencing?
S A
M P L E
S
A M P L E
www.bigslate.com
Answer:
S A M P L E
answer not shownQ4.
How will you refer to the cell in column B and row 2?
S A
M P L E
S
A M P L E
www.bigslate.com
Answer:
S A M P L E
By using the cell reference B2
Q5.
What do you mean by concatenation?
S A
M P L E
S
A M P L E
www.bigslate.com
Answer:
S A M P L E
Joining of strings is called concatenation. The ampersand (&) character is used to concatenate strings.
