If you want to keep the column constant but allow the row to change, how would you write the cell reference for A1?
a) $A$1
b) A$1
c) $A1
d) A1
Which type of cell reference is used by default in Excel formulas?
a) Absolute reference
b) Relative reference
c) Mixed reference
d) Dynamic reference
If the formula =B$2+C$3 is copied from cell A1 to B2, what will be the new formula?
a) =C$2+D$3
b) =B$2+C$3
c) =B$3+C$4
d) =C$3+D$4
Which Excel feature allows you to arrange data in ascending or descending order?
a) Filter
b) Sort
c) PivotTable
d) Data Validation
What is the primary use of the Filter feature in Excel?
a) To arrange data in a specific order
b) To hide rows that do not meet certain criteria
c) To create charts
d) To perform calculations
How do you access the Sort and Filter options in Excel?
a) File tab
b) Home tab
c) Data tab
d) Insert tab
Which option would you use to sort data by more than one column in Excel?
a) Filter
b) Custom Sort
c) Quick Sort
d) Sort Ascending
When you apply a filter in Excel, what happens to the rows that do not meet the criteria?
a) They are deleted
b) They are hidden
c) They are moved to a new sheet
d) They are highlighted
Which button is used to clear all filters applied to a dataset in Excel?
a) Clear All
b) Reset
c) Filter Off
d) Clear Filter
How can you sort a column in Excel from highest to lowest values?
a) Sort A to Z
b) Sort Z to A
c) Custom Sort
d) Filter
What does the “Sort by Color” feature in Excel allow you to do?
a) Sort cells based on their fill color
b) Sort cells based on their font color
c) Both a and b
d) Neither a nor b
Which of the following is true about the Filter feature in Excel?
a) It can only be applied to numeric data
b) It can filter data based on multiple criteria
c) It permanently deletes filtered data
d) It cannot be used with text data
If you want to quickly sort a column of dates from oldest to newest, which option should you use?
a) Sort Z to A
b) Sort A to Z
c) Sort Oldest to Newest
d) Sort Newest to Oldest
Which formula would you use to add the values in cells A1 and A2?
A) =A1+A2
B) =SUM(A1,A2)
C) =ADD(A1,A2)
D) Both A and B
How can you subtract the value in cell B2 from the value in cell B1?
A) =SUBTRACT(B1,B2)
B) =B1-B2
C) =DIFFERENCE(B1,B2)
D) =B2-B1
Which formula is correct for multiplying the values in cells C1 and C2?
A) =C1C2
B) =MULTIPLY(C1,C2)
C) =PRODUCT(C1,C2)
D) =C1+C2
To divide the value in cell D1 by the value in cell D2, which formula should you use?
A) =D1/D2
B) =DIVIDE(D1,D2)
C) =QUOTIENT(D1,D2)
D) =D2/D1
What is the result of the formula =SUM(A1:A3) – B1 if A1=10, A2=20, A3=30, and B1=15?
A) 45
B) 65
C) 55
D) 35
If you want to add the values in cells E1 through E5 and then subtract the value in cell F1, which formula would you use?
A) =SUM(E1:E5)-F1
B) =SUM(E1:F1)
C) =SUM(E1:E5,F1)
D) =SUM(E1:E5)-SUM(F1)
Which formula correctly multiplies the sum of cells G1 and G2 by the value in cell G3?
A) =SUM(G1,G2)G3
B) =(G1+G2)G3
C) =MULTIPLY(SUM(G1:G2),G3)
D) Both A and B
To find the average of values in cells H1, H2, and H3 and then divide by the value in cell H4, which formula should you use?
A) =AVERAGE(H1:H3)/H4
B) =SUM(H1:H3)/3/H4
C) =SUM(H1,H2,H3)/3/H4
D) Both A and C
How would you write a formula to add the values in cells I1 and I2, multiply the result by the value in I3, and then divide by the value in I4?
A) =(I1+I2)I3/I4
B) =SUM(I1:I2)I3/I4
C) =PRODUCT(I1+I2,I3)/I4
D) Both A and B
What does the formula =SUM(J1:J5)*K1/L1 do?
A) Adds the values in J1 to J5, multiplies by the value in K1, then divides by the value in L1
B) Multiplies the values in J1 to J5, adds the value in K1, then divides by L1
C) Divides the sum of J1 to J5 by K1 and then multiplies by L1
D) Multiplies the sum of J1 to J5 by L1 and then divides by K1
Common functions (SUM, AVERAGE, MIN, MAX, COUNT) – Excel MCQs
Which function in Excel is used to add a range of cells?
a) AVERAGE
b) SUM
c) COUNT
d) MIN