Excel displays the current cell address in the ……….
Formula bar
Status Bar
Name Box
Title Bar
What will be the output if you format the cell containing 5436.8 as ‘#,##0.00
5,430.00
5,436.80
5,436.8
6.8
What does COUNTA () function do?
counts cells having alphabets
counts empty cells
counts cells having number
counts non-empty cells
Which Chart can be created in Excel?
Area
Line
Pie
All of the above
How do you display current date and time in MS Excel?
date ()
Today ()
now ()
time ()
What is the short cut key to highlight the entire column?
Ctrl+C
Ctrl+Enter
Ctrl+Page Up
Ctrl+Space Bar
How do you wrap the text in a cell?
Format, cells, font
Format, cells, protection
format, cells, number
Format, cells, alignment
In the formula, which symbol specifies the fixed columns or rows?
$
*
%
&
No comments:
Post a Comment