TI Quizz - Second Partial

This type of functions are designed to perform simple operations on data that is in a “database-like structure”.

• Database Functions

• Logical Functions

• Trigonometry Functions

• Statistic Functions

This functions come from a branch of mathematics that studies the relationship between the sides and angles of a triangle.

• Databaste Functions

• Logical Functions

• Trigonometry Functions

• Statistics Functions

This type of functions are used in spreadsheets in Excel to test whether a situation is true or false, answer different equations or follow sequences.

• Database Functions

• Logical Functions

• Trigonometry Functions

• Statistics Functions

This type of functions are used when a mathematical process is required for a range of cells, such as summing the values in several cell locations.

• Database Functions

• Logical Functions

• Trigonometry Functions

• Statistics Functions

In what format does Excel work trigonometry functions?

• Degrees

• Radians

Can a value given in radians be transformed to degrees in excel?

• YES

• NO

Can a value given in degrees in Excel be transformed to radians?

• YES

• NO

What's the functions to find the product of a database?

(YOU CAN ADD OR NOT PARENTHESIS BUT DO NOT ADD ANYTHING INSIDE THEM)

(a)  

Are =DVAR() and =DVARP() the same function?

• YES

• NO

What's the use for =DVARP()

• Estimates variance based on a sample from selected database entries

• Calculates variance based on the entire population of selected database entries