Top 50+ Solved Excel MCQ Questions Answer
Q. If cell B1 contains text MUMBAI then what will be the answer of =LOWER(B1)?
a. mumbai
b. mumbai
c. b1
d. b
Q. What will be the answer of =PROPER(“verus d’sa”)?
a. verus d’sa
b. verus d’sa
c. verus d’sa
d. verus d’sa
Q. If cell A1 contains a number 100, then what will be the answer of =IF(A1< 200, A1+10, A1-10)?
a. 90
b. 110
c. 190
d. 210
Q. When we want to hide the records which are not satisfying a given condition, then we use________ command.
a. sort
b. filter
c. goal seek
d. solver
Q. We can add constraints while using __________ command.
a. goal seek
b. solver
c. scenario manager
d. data table
Q. To make data interesting, attractive and easy to read and evaluate, we use ______
a. graphs
b. filter
c. scenario
d. solver
Q. With Numeric Filters ______ operation is not allowed.
a. top 10
b. above average
c. greater than
d. begins with
Q. With Text Filters _____ operation is not allowed.
a. begins with
b. ends with
c. above average
d. contains