Excel probably considers the cell entry January 1, 2000 to be a
Home | Discussion ForumFree Online Test
Excel probably considers the cell entry January 1, 2000 to be a
Label
Value
Formula
Text string
Answer : B
Free Online Test
View More Related Question
1) You can set Page Border in Excel from
From Border tab in Format Cells dialog box
From Border tool in Formatting toolbar
From Line Style tool in Drawing toolbar
You can not set page border in Excel
View Answer
2) What does COUNTA () function do?
counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
View Answer
3) 3-D reference in a formula ?
Spans worksheets
Can not be modified
Only appears on summary worksheets
Limits the formatting options
View Answer
4) 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
5) You can use the format painter multiple times before you turn it off by
You can use the format painter button on ly one time when you click it
Double clicking the format painter button
Pressing the Ctrl key and clicking the format painter button
Pressing the Alt key and clicking the format painter button
View Answer
