## The formula "=T(value) " is used to check whether a value is a)Text (b) number (c) line chart (d) true

This question was asked in written examination for Assistant Computer Operator Examination of 2017 conducted by Public Service Commission.

The question is asked from Spreadsheet Calculation portion of the syllabus and MS Excel is the prescribed application.It aims to test the candidate's knowledge about various functions available in Excel. The excel function t() is somewhat rarely used function and many made mistake in this question.

Continue reading for the correct answer and explanation by Suresh Khanal for this question.

**Show Your Love! Share this page!**

Question:

**The formula "=T(value)" is used to check whether a value is...**

Options:

a)Text

b) number

c) line chart

d) true

Correct Answer:

**Correct Answer: a)Text**

Explanation:

The excel function T(value) returns the text referred to by value. You do not generally need to use the T function in a formula because Microsoft Excel automatically converts values as necessary. This function is provided for compatibility with other spreadsheet programs.

If value is text or it refers to text, T function returns value. If value does not refer to text, T function returns "" (empty text). [Source]

Related to:

excel te, how to do a t test in excel, t test excel 2016, excel t test function, excel t test p value, one sample t test excel, t test two sample assuming unequal variances, t function statistics

Other Related Questions:

[…] attribute of a table cannot hold multiple values is the property ofRead More The formula “=T(value)” is used to check whether a value is…Read More Which command will be used to display a file within the specified directory of […]