Working with Formula, Microsoft Excel

Working with Formula

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: 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: In the formula, which symbol specifies the fixed columns or rows?
A
$

B
*

C
%

D
;

Note: Not available
1. Report
Question: Which of following is Not one of Excel’s what-if function?
A
Goal seek

B
Solver

C
Scenario manager

D
Auto Outline

Note: Not available
1. Report
Question: You can check the conditions against __________ when applying conditional formatting
A
Cell value

B
Formula

C
Both of above

D
None of above

Note: Not available
1. Report

First Prev 1 2 Next Last

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: 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: In the formula, which symbol specifies the fixed columns or rows?

Question: Which of following is Not one of Excel’s what-if function?

Question: You can check the conditions against __________ when applying conditional formatting