MS Excel MCQ for practice

Data Analysis
#1

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
2 Likes
#2

1.C
2.B
3.C
4.C
5.D
MS Excel

1 Like
#3

Q.1- d- Double -click the vertical boundary between Cand D.
Q.2 - d - The Death Of Chivalry
Q.3 - b - ###.0,
Q.4 - c - = SUM(A3,A6)
Q.5 - d - Data Validation
MS - Excel

1 Like
#4

Q1 Option d
Q2 Option d
Q3 Option b
Q4 Option c
Q5 Option d

#5
  1. Double-click the vertical boundary between columns C and D
  2. The Death Of Chivalry
  3. ###.0,
  4. =SUM(A3,A6)
  5. Data Validation
#6
  1. d
  2. d
  3. b
  4. c
  5. d
#7

@mvaishali729
1 - D
2 - D
3 - B
4 - C
5 - D