Microsoft Excel

Microsoft Excel

Question: How do you display current date only in MS Excel?
A
Date ()

B
Today ()

C
Now ()

D
Time ()

Note: Not available
1. Report
Question: How do you wrap the text in a cell?
A
Format cells font

B
Format cells protection

C
Format cells number

D
Format cells alignment

Note: Not available
1. Report
Question: What does COUNTA () function do?
A
Counts cells having alphabets

B
Counts empty cells

C
Counts cells having number

D
Counts non-empty cells

Note: Not available
1. Report
Question: Which one is not a Function in MS Excel?
A
SUM

B
AVG

C
MAX

D
MIN

Note: Average is exist in excel
1. Report
Question: What function displays row data in a column or column data in a row?
A
Hyperlink

B
Index

C
Transpose

Note: Not available
1. Report
Question: Which function do you use to choose rows randomly?
A
RAND

B
RANDBETWEEN

C
AGGREGATE

D
SUBTOTAL

Note: Not available
1. Report
Question: To hold row and column titles in place so that they do not scroll away from view when scrolling an Excel work sheet, we make use of–
A
Unfreeze panes command

B
Freeze panes command

C
Hold titles command

D
Split command

Note: Not available
1. Report
Question: Which Function display current date only in MS Excel?
A
Date ()

B
=Today ()

C
Now ()

D
Time ()

Note: Write "=Today()" and press Enter
1. Report
Question: What is the short cut key to highlight the entire column?
A
Ctrl + C

B
Ctrl + Enter

C
Ctrl + Page Up

D
Ctrl + Space Bar

Note: Not available
1. Report
Question: In the formula, which symbol specifies the fixed columns or rows?
A
$

B
*

C
%

D
;

Note: Not available
1. Report

First Prev 3 4 5 6 7 Next Last

Question: How do you display current date only in MS Excel?

Question: How do you wrap the text in a cell?

Question: What does COUNTA () function do?

Question: Which one is not a Function in MS Excel?

Question: What function displays row data in a column or column data in a row?

Question: Which function do you use to choose rows randomly?

Question: To hold row and column titles in place so that they do not scroll away from view when scrolling an Excel work sheet, we make use of–

Question: Which Function display current date only in MS Excel?

Question: What is the short cut key to highlight the entire column?

Question: In the formula, which symbol specifies the fixed columns or rows?