Excel Set 1

Bachelor of Commerce (B Com),

MCQ on Computer Softwares

Practice Mode Next
On This Page

This set of Excel Multiple Choice Questions & Answers (MCQs) focuses on Excel Set 1

Q1 | 15-August-2020 was Saturday. Answer of =WEEKDAY(“15-August-2020”) will be_____
  • saturday
  • sat
  • 7
  • 6
Answer: 7
Q2 | 15-August-2020 was Saturday. Answer of =MONTH(“15-August-2020”) will be ________
  • august
  • aug
  • 8
  • 7
Answer: 8
Q3 | 15-August-2020 was Saturday. Answer of =YEAR(“15-August-2020”) will be ________
  • 2020
  • 1920
  • 20
  • 2200
Answer: 2020
Q4 | Answer of =DAYS360(“1-Jan-2020”, “31-Dec-2020”) will be ________
  • 365
  • 366
  • 360
  • 364
Answer: 360
Q5 | Answer of =YEAR(“15-Aug-20”) will be
  • 20
  • 2020
  • 1920
  • 2200
Answer: 2020
Q6 | Answer of =TIMEVALUE(“6:00 PM”) will be ________
  • 6:00
  • 6:00 am
  • 18:00
  • 0.75
Answer: 0.75
Q7 | TODAY( ) returns current ______
  • date
  • time
  • day
  • date & time
Answer: date
Q8 | Answer of =DAYS360(“31-Dec-2020”, “1-Jan-2020”) will be ________
  • 365
  • 366
  • 360
  • -360
Answer: -360
Q9 | To convert uppercase alphabets to lowercase we use _____
  • lcase( )
  • lower( )
  • upper( )
  • ucase( )
Answer: lower( )
Q10 | To find number of characters in a string we use _____
  • count( )
  • len( )
  • length( )
  • sum( )
Answer: len( )
Q11 | To search a value in the first row of a given range, we use _______.
  • vllokup( )
  • hlookup( )
  • search( )
  • locate( )
Answer: hlookup( )
Q12 | To count non blank cells, we use _____.
  • count( )
  • counta( )
  • countblank( )
  • countnonblank( )
Answer: counta( )
Q13 | To count number of cells that contains numbers, we use _____.
  • count( )
  • counta( )
  • sum( )
  • countif( )
Answer: count( )
Q14 | Which of the following is not a valid chart type in Excel.
  • line
  • bar
  • pie
  • graph
Answer: graph
Q15 | Axis Title is not allowed in this type of graphs.
  • line
  • bar
  • column
  • pie
Answer: pie
Q16 | Select odd man out from the following graph types.
  • line
  • bar
  • column
  • pie
Answer: pie
Q17 | Charts are available under _______ Ribbon/Menu.
  • home
  • insert
  • data
  • view
Answer: insert
Q18 | Goal Seek Option is available under ____ Ribbon/Menu.
  • home
  • insert
  • data
  • view
Answer: data
Q19 | Number of changing cells for a Scenario is limited to ____
  • 16
  • 32
  • 1
  • 2
Answer: 32
Q20 | Number of changing cells for a Goal Seek is limited to ______
  • 16
  • 32
  • 1
  • 2
Answer: 1
Q21 | Solver Option is available under ____ Ribbon/Menu.
  • developer
  • data
  • insert
  • home
Answer: data
Q22 | Record Macro option is available under ____ Ribbon/Menu.
  • developer
  • data
  • insert
  • home
Answer: developer
Q23 | Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2)?
  • a2
  • a
  • co
  • c
Answer: c
Q24 | Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(“A2”)?
  • a2
  • a
  • co
  • c
Answer: a
Q25 | Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2, 3)?
  • a2
  • er
  • co
  • com
Answer: com
Next