Quiz - Stat Modeller

Created by

Stat Modeller

Basic to Advanced Excel

Welcome to the Quiz based on the "Excel Training".

There will be 10 MCQ type questions. This quiz will be automatically submitted after 15 minutes. There is no negative marking.

All the Best!!!
Team Stat Modeller

1 / 10

1. What does =IF(AND(B2>=1000,C2="Pharma"),"Eligible","Not Eligible") require for a row to return 'Eligible'?

A) Either quantity >= 1000 or category is Pharma

B) Category is Pharma only

C) Quantity >= 1000 only

D) Both quantity >= 1000 and category is Pharma

2 / 10

2. Which Excel feature automatically changes a cell's fill color or font based on its value, without altering the underlying data?

A) Conditional Formatting

B) Text to Columns

C) Freeze Panes

D) Data Validation

3 / 10

3. Which single function directly returns the highest sales value achieved by any distributor in a range, without specifying a rank?

A) COUNT

B) AVERAGE

C) SUM

D) MAX

4 / 10

4. What does =SMALL(C2:C30,3) return?

A) The third-highest value in the range

B) The third-lowest value in the range

C) The lowest value in the range

D) The 3 lowest values added together

5 / 10

5. What does the formula =COUNTIF(A2:A50,"<>") return?

A) The number of non-blank cells in A2:A50

B) The number of cells containing text only

C) An error, since <> is invalid in COUNTIF

D) The number of blank cells in A2:A50

6 / 10

6. Which Conditional Formatting option displays a colored bar inside each cell, with its length proportional to the cell's value relative to others in the range?

A) Data Bars

B) Icon Sets

C) Highlight Cells Rules

D) Color Scales

7 / 10

7. In =INDEX(C2:C50,MATCH(A2,B2:B50,0)), what does the final 0 inside MATCH tell Excel to do?

A) Find the closest match above the value

B) Find an exact match

C) Find the closest match below the value

D) Ignore case sensitivity

8 / 10

8. In the reference A$1, which part is fixed and which can change when the formula is copied to other cells?

A) Column is fixed, row can change

B) Both can change

C) Row is fixed, column can change

D) Both are fixed

9 / 10

9. A distributor's Actual Sales are in B2 and Target is in C2. Which formula in D2 correctly returns 'Achieved' when Actual Sales meet or exceed Target, and 'Not Achieved' otherwise?

A) =IF(C2>=B2,"Achieved","Not Achieved")

B) =IF(B2>=C2,"Achieved","Not Achieved")

C) =IF(B2=C2,"Achieved","Not Achieved")

D) =IF(B2>C2,"Not Achieved","Achieved")

10 / 10

10. After the underlying source data of a PivotTable has changed (new rows added, values updated), what must you do for the PivotTable to reflect those changes?

A) Refresh the PivotTable

B) Recalculate the workbook with F9

C) Nothing - it updates automatically

D) Reformat the PivotTable style

Your score is