MCQ Test - MS Excel Advanced

1. Which symbol normally begins an Excel formula?

A. #

B. =

C. @

D. &

2. Which function adds numbers in a range?

A. COUNT

B. MAX

C. SUM

D. MIN

3. Which function calculates the arithmetic mean?

A. AVERAGE

B. SUM

C. COUNTIF

D. ROUNDUP

4. Which function returns one value for TRUE and another for FALSE?

A. SUM

B. COUNT

C. MAX

D. IF

5. Which is an absolute cell reference?

A. A1

B. A$1

C. $A$1

D. $A1

6. What does conditional formatting do?

A. Deletes duplicate worksheets automatically

B. Formats cells when specified conditions are met

C. Creates a new workbook

D. Changes the computer operating system

7. What is the main purpose of data validation?

A. To control the data entered into cells

B. To increase monitor brightness

C. To delete formulas

D. To print charts automatically

8. Which Excel feature summarizes and analyzes datasets?

A. WordArt

B. Page Layout

C. Spell Check

D. PivotTable

9. Which function counts cells meeting a condition?

A. SUMIF

B. COUNTIF

C. AVERAGE

D. CONCAT

10. Which function adds values that meet a condition?

A. COUNT

B. MAX

C. SUMIF

D. LEFT

11. What does VLOOKUP search in by default?

A. The first column of the specified table array

B. The last worksheet only

C. The chart title

D. The workbook filename

12. What does XLOOKUP return?

A. Only a chart

B. Only a worksheet name

C. A corresponding value from a return range

D. A printed page

13. What is the purpose of sorting?

A. To hide every row permanently

B. To arrange data in a chosen order

C. To delete all formulas

D. To protect the workbook with a password automatically

14. What does filtering do?

A. Changes all numbers into text

B. Deletes all unmatched records

C. Creates a PivotTable automatically

D. Displays records that meet specified criteria

15. What does Freeze Panes do?

A. Keeps selected rows or columns visible while scrolling

B. Locks the computer keyboard

C. Deletes hidden rows

D. Removes cell formatting

16. What is an Excel macro used for?

A. Changing the monitor resolution

B. Creating a physical storage device

C. Automating repetitive tasks

D. Replacing the operating system

17. Which chart is commonly used to compare values across categories?

A. Pie chart only

B. Column chart

C. Stock ticker only

D. Surface map only

18. What is the purpose of worksheet protection?

A. To guarantee that no one can ever access the file

B. To remove every formula

C. To prevent the workbook from opening

D. To restrict specified editing actions

19. Which function returns the largest value in a range?

A. MAX

B. MIN

C. COUNT

D. AVERAGE

20. Which function returns the smallest value in a range?

A. SUM

B. MAX

C. MIN

D. IF

📝 MCQ Test

Chapter 6 - MS Excel Advanced