download Mastguru Android App

Question Detail

Which function in excel counts the numbers of characters in a cell ?

  • LENGHT
  • LGT
  • LT
  • LEN

Answer: Option D

Similar Questions :

1. When creating a vertical page break ?

  • The active cell must be in row 1
  • The active cell must be A1
  • The active cell must be in row 10
  • The active cell must be in column A

Answer: Option A

2. Which of the following is not a valid Zoom percentage in Excel ?

  • 10
  • 100
  • 300
  • 500

Answer: Option D

3. Except which of the following function, a formula with a logical function shows the word "TRUE" or "FALSE" as a result ?

  • NOT
  • OR
  • IF
  • AND

Answer: Option C

4. What term refers to a specific set of values saved with the workbook ?

  • Range
  • File set
  • Data set
  • Scenario

Answer: Option D

5. To join some cells and place the content at the middle of joined cell, which tool you will use?

  • From Format Cells dialog box choose Merge and Center check box
  • Click on Merge and Center tool on formatting toolbar
  • From Format Cells dialog box select the Centered alignment
  • From Format Cells dialog box click on Merge Cells check box

Answer: Option B

Read more from - MS Excel Questions Answers
Post a comment

    Mastguru Youtube Channel

    Videos @mastguru

    Free useful videos - Subscribe Mastguru
     

    Get Free Current Affairs and Govt Jobs Alerts in your mailbox

    To Appreciate Our Effort, Please Like Us

    Quantitative Aptitude
    English Aptitude
    Reasoning Aptitude
    Computer Awareness
    General Knowledge
    Current Affairs
    IT Officer Aptitude
    Programming Aptitude
    Latest Govt Jobs