Question 1

Number of changing cells for a Goal Seek is limited to ______

Accepted Answer

A) 16 
B) 32 
C) 1 
D) 2 
A) 16 
B) 32 
C) 1 
D) 2

Question 2

To find number of characters in a string we use _____

Accepted Answer

A) count( ) 
B) len( ) 
C) length( ) 
D) sum( ) 
A) count( ) 
B) len( ) 
C) length( ) 
D) sum( )

Question 3

To count number of cells that contains numbers, we use _____.

Accepted Answer

A) count( ) 
B) counta( ) 
C) sum( ) 
D) countif( ) 
A) count( ) 
B) counta( ) 
C) sum( ) 
D) countif( )

Question 4

Answer of =DAYS360("1-Jan-2020", "31-Dec-2020") will be ________

Accepted Answer

A) 365 
B) 366 
C) 360 
D) 364 
A) 365 
B) 366 
C) 360 
D) 364

Question 5

Answer of =YEAR("15-Aug-20") will be

Accepted Answer

A) 20 
B) 2020 
C) 1920 
D) 2200 
A) 20 
B) 2020 
C) 1920 
D) 2200

Number of changing cells for a Goal Seek is limited to ______

To find number of characters in a string we use _____