Quiz on Excel (08/08/23)

Here are some Excel MCQ for you folks to practice and learn. :slight_smile:

Q1. Some of your data in Column C is displaying as hashtags (#) because the column is too narrow. How can you widen Column C just enough to show all the data?

Right-click column C, select Format Cells, and then select Best-Fit.
Right-click column C and select Best-Fit.
Double-click column C.
Double-click the vertical boundary between columns C and D.

Q2. If cell A3 contains the text THE DEATH OF CHIVALRY, what will the function =PROPER(A3) return?

the death of chivalry
The death of Chivalry
THE DEATH OF CHIVALRY
The Death Of Chivalry

Q3. Which format will display the value 27,500,000 as 27.5?

##,###,
###.0,
999.9,
###,###.0,

Q4. Which formula is NOT equivalent to all of the others?

=A3+A4+A5+A6
=SUM(A3:A6)
=SUM(A3,A6)
=SUM(A3,A4,A5,A6)

Q5. You want to be able to restrict values allowed in a cell and need to create a drop-down list of values from which users can choose. Which feature should you use?

Protect Worksheet
Conditional Formatting
Allow Users to Edit Ranges
Data Validation

1 Like

answers
1.d
2. d
3. b
4. c
5. d