download Mastguru Android App

Question Detail

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

  • LENGHT
  • LGT
  • LT
  • LEN
Similar Questions :

1. The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is ?

  • C1:10H
  • C1:H10
  • C1:H-10
  • C1:H:10

2. 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

3. What function displays row data in a column or column data in a row ?

  • Transpose
  • Index
  • Rows
  • Hyperlinks

4. The accounting style shows negative numbers in ?

  • Bold
  • Italics
  • Parentheses
  • Quotes

5. What is shortcut to enter current date in cell in excel ?

  • Ctrl + ;
  • Alt + ;
  • Shift + &
  • Ctrl + $
Read more from - MS Excel Questions Answers
Post a comment