Purdue CS 235 Exam 1 with
complete solutions
What term refers to the necessity of following the rules when it
comes to using functions?
Function Logic
Syntax
Formula
Arguments
Syntax
What function computes the value in which on-half of the data is
above and one-half is below?
Mode
Median
Middle
Average
Median
Brainpower
Read More
What does Excel use to indicate optional arguments in a function?
Quote Marks
Square brackets
Curly brackets
Parenthesis
Square brackets
If a cell containing the formula =$B$14 is not copy and pasted, but
moved four columns over and four rows down, what would the
resultant cell reference become?
=$B$14
=$F$18
=F18
=B14
=$B$14
, The ROUND function requires how many arguments ?
1
2
3
4
2
What do you use to separate arguments in a function ?
Comma ( , )
Semi - colon ( ; )
Colon ( :)
Period ( . )
Comma ( , )
Which of the following is not a category of functions ?
Graphical
Financial
Statistical
Logical
Graphical
Which function would you use if you wanted to count the number of
values , but ignore cells that have text or are empty ?
COUNTVALUES
COUNT
COUNTBLANK
COUNTA
COUNT
Which of the following is not an argument in an IF function ?
value_if_equal
value_if_true
value_if_false
logical test
value_if_equal
Which Excel function changes the value to a desired number of
decimal places ?
Round
Truncate
Increase decimal
Decrease decimal
complete solutions
What term refers to the necessity of following the rules when it
comes to using functions?
Function Logic
Syntax
Formula
Arguments
Syntax
What function computes the value in which on-half of the data is
above and one-half is below?
Mode
Median
Middle
Average
Median
Brainpower
Read More
What does Excel use to indicate optional arguments in a function?
Quote Marks
Square brackets
Curly brackets
Parenthesis
Square brackets
If a cell containing the formula =$B$14 is not copy and pasted, but
moved four columns over and four rows down, what would the
resultant cell reference become?
=$B$14
=$F$18
=F18
=B14
=$B$14
, The ROUND function requires how many arguments ?
1
2
3
4
2
What do you use to separate arguments in a function ?
Comma ( , )
Semi - colon ( ; )
Colon ( :)
Period ( . )
Comma ( , )
Which of the following is not a category of functions ?
Graphical
Financial
Statistical
Logical
Graphical
Which function would you use if you wanted to count the number of
values , but ignore cells that have text or are empty ?
COUNTVALUES
COUNT
COUNTBLANK
COUNTA
COUNT
Which of the following is not an argument in an IF function ?
value_if_equal
value_if_true
value_if_false
logical test
value_if_equal
Which Excel function changes the value to a desired number of
decimal places ?
Round
Truncate
Increase decimal
Decrease decimal
