On This Page
This set of Excel Multiple Choice Questions & Answers (MCQs) focuses on Excel Set 2
Q1 | What will be the answer of =DAYS360(“1-Feb-2020”, “1-Mar-2020”)?
- 28
- 29
- 30
- 31
Q2 | What will be the answer of =DATEVALUE(“1-Feb-1900”)?
- 1
- 32
- 30
- one
Q3 | What will be the answer of =TIMEVALUE(“12:00 PM”)?
- 12.00
- 12
- 0.5
- 0.25
Q4 | What will be the answer of =MONTH(32)?
- 2
- 3
- 8
- 9
Q5 | What will be the answer of =DAY(32)?
- 1
- 2
- 3
- 4
Q6 | What will be the answer of =YEAR(32)?
- 1932
- 2032
- 1990
- 1900
Q7 | If cell B1 contains text MUMBAI then what will be the answer of =LOWER(B1)?
- mumbai
- mumbai
- b1
- b
Q8 | What will be the answer of =MID(“COMMERCE”,3,2)?
- omm
- mme
- mm
- er
Q9 | Excel formula cannot start with ____
- +
- -
- *
- 0
Q10 | Which of the following is an invalid arithmetic operator?
- +
- -
-
- ^
Q11 | If cell A1 contains a number 100, then what will be the answer of =IF(A1< 200, A1+10, A1-10)?
- 90
- 110
- 190
- 210
Q12 | When we want to hide the records which are not satisfying a given condition, then we use________ command.
- sort
- filter
- goal seek
- solver
Q13 | We can add constraints while using __________ command.
- goal seek
- solver
- scenario manager
- data table
Q14 | By default extension for template file is _______
- .temp
- .xltx
- .tem
- . xlsx
Q15 | Excel macros can be edited using _______ editor.
- visual basic
- excel
- c
- java
Q16 | To make data interesting, attractive and easy to read and evaluate, we use ______
- graphs
- filter
- scenario
- solver
Q17 | _____ graph allows only one range of values.
- bar
- line
- column
- pie
Q18 | Gridlines are not allowed for ___ type of graphs.
- bar
- line
- column
- pie
Q19 | With Numeric Filters ______ operation is not allowed.
- top 10
- above average
- greater than
- begins with
Q20 | With Text Filters _____ operation is not allowed.
- begins with
- ends with
- above average
- contains
Q21 | Which of the following function is invalid.
- sumif( )
- avgif( )
- countif( )
- if( )