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( )