WorksheetsTI Quizz - Second Partial
Total questions: 23
Worksheet time: 16mins
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
What's the use of =DCOUNTA() ?
Counts nonblank cells in a database
Counts the cells that contain numbers in a database
Extracts from a database a single record that matches the specified criteria
Returns the maximum value from selected database entries
TRUE OR FALSE: =DGET() allows you to extract as many values as the user wants from a database.
TRUE
FALSE
Let's say I have in cell A1: 1 and in cel A2 0. If i apply the "OR" functions as in =OR(A1,A2), what value should I recieve?
TRUE
FALSE
Let's say I have in cell A1: 1 and in cel A2 1. If i apply the "AND" function as in =AND(A1,A2), what value should I recieve?
TRUE
FALSE
Let's say I have in cell A1: 1 and in cel A2 1. If i apply the "XOR" functions as in =XOR(A1,A2), what value should I recieve?
TRUE
FALSE
What happens if i have TRUE as my value but I apply the FALSE function.
My value converts to FALSE
My value stays as TRUE
Nothing happens
Returns the cosine value of the given (angle) in radians
=COS()
=ACOS()
Returns the inverse tangent of a given number in radians
=TAN()
=ATAN()
What does the functions =TRUNC() do?
Deletes the fractional part of a number to truncate it to an integrate
Rounds a number down to the nearest integer
=STEDV.M() does what?
Calculate the standard deviation from a sample.
Calculate the running standard deviation of the entire population.
Is =MAX() a statistical function?
TRUE
FALSE
What does =AVERAGE() (=PROMEDIO()) do?
Returns the average of the absolute deviations from the mean of the data points.
Returns the average of its arguments.
Returns the average of its arguments, including numbers, text and logical values.
If i apply =MAXA(VERDADERO,8,10,6,FALSO,9) what will be my result?
Verdadero
10
Falso
9
