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!
The formula "=T(value)" is used to check whether a value is...
c) line chart
Correct Answer: a)Text
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]
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: