NEW
Font size
S
M
L
XL
WorksheetsMS Excel
Total questions: 63
Worksheet time: 21mins
Name
Class
Date
1.
Which of the following is NOT a type of cell reference in Excel?
a)
Relative Reference
b)
Absolute Reference
c)
Fixed Reference
d)
Mixed Reference
2.
What happens when you copy a formula with a relative reference?
a)
The reference remains unchanged
b)
The reference adjusts based on its new location
c)
It converts to an absolute reference
d)
It removes all references
3.
What symbol is used to indicate an absolute reference in Excel?
a)
#
b)
$
c)
@
d)
&
4.
If a formula in A1 is =B1+C1 and is copied to D1, what will the new formula be?
a)
="=B1+C1"
b)
="=D1+E1"
c)
="=B2+C2"
d)
="=E1+F1"
5.
A mixed reference means:
a)
Both row and column are absolute
b)
One is absolute, the other is relative
c)
Both row and column are relative
d)
The reference is invalid
6.
If you enter =$A$1+B1 and copy it down, how does it change?
a)
It remains =$A$1+B1
b)
It changes to =$A$1+B2
c)
It changes to =$A$2+B2
d)
It remains unchanged for all cells
7.
How do you quickly toggle through reference types (absolute, relative, mixed)?
a)
Press F4
b)
Press Ctrl + A
c)
Press Alt + R
d)
Right-click the formula
8.
What is a circular reference in Excel?
a)
A reference that loops back to itself
b)
A reference to another worksheet
c)
A reference error
d)
A reference that Excel automatically corrects
9.
What does the caret (^) symbol represent in an Excel formula?
a)
Multiplication
b)
Division
c)
Exponentiation
d)
Modulus
10.
What is the result of =10/2*5 in Excel?
a)
25
b)
20
c)
50
d)
5
11.
Which of the following operators is used for concatenating text?
a)
+
b)
&
c)
*
d)
#
12.
What does =A1>B1 return?
a)
The greater value
b)
TRUE or FALSE
c)
An error
d)
An error message
13.
What is a built-in function in Excel?
a)
A function predefined in Excel
b)
A function the user creates manually
c)
A VBA function
d)
A function used in macros
14.
What does the SUM() function do?
a)
Subtracts values
b)
Multiplies values
c)
Adds values
d)
Counts cells
15.
Which function counts numeric values in a range?
a)
COUNT()
b)
COUNTA()
c)
COUNTIF()
d)
SUM()
16.
The IF() function:
a)
Checks a condition and returns different values
b)
Sorts data
c)
Finds the highest number
d)
Creates a new sheet
17.
What function finds the largest number in a range?
a)
MIN()
b)
MAX()
c)
AVERAGE()
d)
COUNT()
18.
Which function returns today’s date?
a)
DATE()
b)
NOW()
c)
TODAY()
d)
TIME()
19.
What does =LEFT("Excel",2) return?
a)
Ex
b)
xc
c)
cel
d)
lE
20.
What function rounds a number down?
a)
ROUND()
b)
ROUNDDOWN()
c)
CEILING()
d)
FLOOR()
21.
Which function converts text to uppercase?
a)
LOWER()
b)
PROPER()
c)
UPPER()
d)
TITLE()
22.
What does =MOD(10,3) return?
a)
1
b)
3
c)
0
d)
2
23.
What does =LEN("Excel") return?
a)
5
b)
6
c)
7
d)
4
24.
What function retrieves the current system time?
a)
TODAY()
b)
NOW()
c)
TIME()
d)
CLOCK()
25.
What is the default separator in Excel formulas?
a)
Comma (,)
b)
Semicolon (;)
c)
Pipe (|)
d)
Colon (:)
26.
What function finds the first occurrence of a character in text?
a)
SEARCH()
b)
FIND()
c)
MATCH()
d)
LOOKUP()
27.
What does =ROUND(4.567,2) return?
a)
4.57
b)
4.56
c)
4.6
d)
4.5
28.
Which function joins two or more text strings?
a)
CONCAT()
b)
TEXTJOIN()
c)
CONCATENATE()
d)
All of the above
29.
What does =RAND() return?
a)
A random number between 1 and 100
b)
A random number between 0 and 1
c)
A random number between -1 and 1
d)
A random number between -100 and 100
30.
What does =TEXT(1234,"$#,###.00") return?
a)
$1,234.00
b)
1,234.00
c)
$1234
d)
1234
31.
What is the result of =5+2*3-4/2?
a)
9
b)
10
c)
8
d)
5
32.
What does =4^2+6/3 evaluate to?
a)
18
b)
16
c)
20
d)
15
33.
What is the result of =(8+2)*3^2/6?
a)
15
b)
20
c)
25
d)
45
34.
What is the result of =2+3&4?
a)
24
b)
34
c)
54
d)
Error
35.
Which operator has the highest precedence in Excel formulas?
a)
Parentheses ()
b)
Exponentiation (^)
c)
Multiplication (*)
d)
Addition (+)
36.
What will =10 + 5 * 2 return in Excel?
a)
30
b)
20
c)
15
d)
50
37.
How can you change the order of operations in an Excel formula?
a)
Use parentheses ()
b)
Use commas ,
c)
Use & operator
d)
None of the above
38.
What is the result of =(10 + 5) * 2?
a)
20
b)
30
c)
50
d)
50
39.
What is the correct order of operator precedence in Excel?
a)
+, -, *, /, ^
b)
^, *, /, +, -
c)
*, /, ^, +, -
d)
+, /, ^, *, -
40.
Which of the following is NOT an arithmetic operator in Excel?
a)
+
b)
-
c)
&
d)
*
41.
What does the caret (^) symbol represent in an Excel formula?
a)
Multiplication
b)
Division
c)
Exponentiation
d)
Modulus
42.
Which of the following is the modulus operator in Excel?
a)
%
b)
MOD() function
c)
/
d)
#
43.
What does the & operator do in an Excel formula?
a)
Adds two numbers
b)
Concatenates text
c)
Performs division
d)
Converts numbers to text
44.
Which of the following is a comparison operator in Excel?
a)
<
b)
+
c)
&
d)
%
45.
What does the expression =A1=B1 return?
a)
The sum of A1 and B1
b)
TRUE if A1 equals B1, otherwise FALSE
c)
The difference between A1 and B1
d)
An error message
46.
What does the <> operator mean in Excel?
a)
Equal to
b)
Not equal to
c)
Greater than
d)
Less than
47.
What is the purpose of the colon (:) operator in Excel?
a)
Denotes a range of cells
b)
Multiplies two values
c)
Finds the sum of two values
d)
Concatenates text
48.
Which of these is a reference operator?
a)
:
b)
,
c)
(space)
d)
All of the above
49.
What does the , (comma) operator do in Excel formulas?
a)
Separates function arguments
b)
Acts as a multiplication operator
c)
Combines two values
d)
Represents a logical OR
50.
Which operator has the highest precedence in Excel formulas?
a)
Addition (+)
b)
Parentheses ()
c)
Exponentiation (^)
d)
Multiplication (*)
51.
What will =10 + 5 * 2 return in Excel?
a)
30
b)
20
c)
15
d)
50
52.
How can you change the order of operations in an Excel formula?
a)
Use parentheses ()
b)
Use commas ,
c)
Use & operator
d)
None of the above
53.
What is the result of =(10 + 5) * 2?
a)
20
b)
30
c)
15
d)
50
54.
Which of the following operators is evaluated first according to Excel’s precedence rules?
a)
+ (Addition)
b)
^ (Exponentiation)
c)
* (Multiplication)
d)
& (Concatenation)
55.
If a formula contains multiple operators with the same precedence, how does Excel evaluate them?
a)
Right to left
b)
Left to right
c)
Based on cell order
d)
Randomly
56.
Which of the following operations is performed last in Excel?
a)
Multiplication
b)
Addition
c)
Exponentiation
d)
Comparison
57.
What is the result of =100 / 5 * 2?
a)
40
b)
50
c)
10
d)
20
58.
What is the correct order of operator precedence in Excel?
a)
+, -, *, /, ^
b)
^, *, /, +, -
c)
*, /, ^, +, -
d)
+, /, ^, *, -
59.
What does =3+5*2^3 return?
a)
64
b)
43
c)
18
d)
256
60.
What is the result of =5+2*3-4/2?
a)
9
b)
10
c)
8
d)
5
61.
What does =4^2+6/3 evaluate to?
a)
18
b)
16
c)
20
d)
15
62.
What is the result of =(8+2)*3^2/6?
a)
45
b)
30
c)
25
d)
15
63.
What is the result of =3+2&4?
a)
24
b)
54
c)
5
d)
Error
Reset
