Microsoft Excel

Microsoft Excel

Question: How to create series of cells in a row to column?
A
Format

B
Formula

C
Transpose

D
Paste

Note: Not available
1. Report
Question: “=a1*a15”is a ……………in MS Excel
A
Formula

B
Function

C
Both of above

D
None of above

Note: Not available
1. Report
Question: Which is use for calculate condition?
A
And

B
Product

C
Max

D
If

Note: Not available
1. Report
Question: Which of the following is an absolute cell reference?
A
!a!1

B
$A$1

C
Typing error

D
None of the above

Note: Not available
1. Report
Question: What is the function of COUNTIF?
A
Count the number of cells in a range that contain a numerical value

B
Count the number of cells in a range that are not empty

C
Counts the number of cells in a range without using criteria

D
Count the number of cells in a range that meet a given criterion

Note: Not available
1. Report
Question: If you want to enter same value in multiple cell at a time in MS Excel ,you should select range and type the data in active cell and press
A
Enter

B
Shift+Enter

C
Ctrl+Enter

D
Alt+Enter

Note: Not available
1. Report
Question: Each time you start the MS Excel program, by default, it displays a new blankworkbook containing _________ blank worksheets.
A
Two

B
Three

C
Four

D
Five

Note: Not available
1. Report
Question: Which of the following is not the correct error code in MS Excel ?
A
#VALUE!

B
#######

C
#REF!

D
#NAME?

Note: Not available
1. Report
Question: SUM (B3:B7) here B3 AND B7 are
A
Cell heading

B
Cell address

C
Row heading

D
Colum heading

Note: Not available
1. Report
Question: Which of the following is the correct example of relative columns and absolute row?
A
C4

B
C$4

C
SC$4

D
$C4

Note: Not available
1. Report

First Prev 2 3 4 5 6 Next Last

Question: How to create series of cells in a row to column?

Question: “=a1*a15”is a ……………in MS Excel

Question: Which is use for calculate condition?

Question: Which of the following is an absolute cell reference?

Question: What is the function of COUNTIF?

Question: If you want to enter same value in multiple cell at a time in MS Excel ,you should select range and type the data in active cell and press

Question: Each time you start the MS Excel program, by default, it displays a new blankworkbook containing _________ blank worksheets.

Question: Which of the following is not the correct error code in MS Excel ?

Question: SUM (B3:B7) here B3 AND B7 are

Question: Which of the following is the correct example of relative columns and absolute row?