MS Excel - 06

01. What does COUNTA () function do?

  • 1counts cells having alphabets
  • 2counts empty cells
  • 3counts cells having number
  • 4counts non-empty cells
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

02. How do you wrap the text in a cell?

  • 1Format, cells, font
  • 2Format, cells, protection
  • 3Format, cells, number
  • 4Format, cells, alignment
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

03. How do you display current date only in MS Excel?

  • 1date ()
  • 2Today ()
  • 3now ()
  • 4time ()
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

04. How do you display current date and time in MS Excel?

  • 1date ()
  • 2Today ()
  • 3now ()
  • 4time ()
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

05. Which Chart can be created in Excel?

  • 1Area
  • 2Line
  • 3Pie
  • 4All of the above
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

06. How do you rearrange the data in ascending or descending order?

  • 1Data, Sort
  • 2Data, Form
  • 3Data, Table
  • 4Data Subtotals
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

07. Microsoft Excel is a powerful ...........

  • 1Word processing package
  • 2Spreadsheet package
  • 3Communication S/W Package
  • 4DBMS package
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

08. Which is not the function of "Edit, Clear" command?

  • 1Delete contents
  • 2Delete notes
  • 3Delete cells
  • 4Delete formats
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

09. To return the remainder after a number is divided by a divisor in EXCEL we use the function?

  • 1ROUND ( )
  • 2FACT ( )
  • 3MOD ( )
  • 4DIV ( )
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

10. To select an entire column in MS-EXCEL, press?

  • 1CTRL + C
  • 2CTRL + Arrow key
  • 3CTRL + S
  • 4None of the above
Answer:- 1
Explanation:-

No explanation is given for this question Let's Discuss on Board

Page 1 Of 2
Test
Classes
E-Book