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

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


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


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

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