Which of the following is not a valid data type in excel
Number
Character
Label
Date/time
Answer : B
Free Online Test
View More Related Question
1) What is the correct way to refer the cell A10 on sheet3 from sheet1?
2) Which of the following is not true regarding Conditional Formatting?
You can add more than one condition to check
You can set condition to look for Bold and apply Italics on them
You can apply Font, border and pattern formats that meets the specified conditions
You can delete any condition from Conditional Formatting dialog box if it is not requried
View Answer
3) By default Excel provides 3 worksheets. You need only two of them, how will you delete the third one?
Right click on Sheet Tab of third sheet and choose Delete from the context menu
Click on Sheet 3 and from Edit menu choose Delete
Both of above
None of above
View Answer
4) The Autosum feature
extends a sequential series of data
automatically adds range of cell values
applies a boarder around the selected cells
none of the above
View Answer
5) A numeric value can be treated as label value if ...... precedes it.
