CIS 150 3

9 September 2022
4.7 (114 reviews)
52 test answers

Unlock all answers in this set

Unlock answers (48)
question
Cube
answer
The ____ category of Excel functions retrieves data from multidimensional databases involving online analytical processing
question
logical
answer
The ____ category of Excel functions returns (true-false) values
question
average
answer
Which of the following is a Statistical function?
question
INT
answer
Which of the following is a Math & Trig function? ____
question
Nested
answer
=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function
question
Go
answer
After you describe a function in the Search for a function box in the Insert Function dialog box, click ____.
question
arguments
answer
The numbers, text, or cell references used by the function to return a value are called ____.
question
fill handle
answer
Referring to the figure above, the last entry shown in Column K is 644.7953813. There is a black "plus sign" on the lower right edge of the cell that is the
question
auto fill options button
answer
Referring to the figure above, the last entry shown in Column K is 644.7953813. There is an icon in the cell underneath the 644.7953813 which is the ____.
question
two
answer
Referring to the figure above, which number represents the COUNT function?
question
four
answer
Referring to the figure above, which number refers difference between the scheduled and attended workouts
question
<<
answer
Which of the following is not a comparison operator? __
question
the formula returns the text "restart"
answer
In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"?
question
AND
answer
Which of the following is not a date function? __
question
MAX
answer
The ____ function returns the maximum value in the range
question
relative
answer
One of the great advantages of ____ references is that you can quickly generate row and column totals without having to worry about revising the formulas as you copy them to new locations.
question
$
answer
Absolute references are marked with a ____.
question
does not change
answer
When you copy a formula that contains an absolute reference to a new location, the reference ____.
question
absolute
answer
Use ____ references when you want different formulas to refer to the same cell.
question
median
answer
Another name for the middle value is the ____ value.
question
optional
answer
____ arguments may provide more control over the returned value.
question
the general syntax of all functions
answer
FUNCTION(argument1, argument2, ...) is ___
question
default
answer
If an optional argument is not included, Excel assumes a(n) ____ value for it.
question
12
answer
Excel functions are organized into ____ categories.
question
algebra
answer
Which of the following is not an Excel function category? ___
question
COUNT
answer
Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?
question
cell references
answer
In "SUM(number1 [, number2, number3, ...])", number 1, number 2, and number 3 may be numbers or ____.
question
information
answer
Which category of Excel functions returns information about the format, location, or contents of worksheet cells? ____
question
the average of the values A1:A100 is calculated
answer
In the formula =INT(AVERAGE(A1:A100)), which would occur first? ___
question
the same number of left and right parentheses
answer
When you nest functions, you should have ____
question
function library
answer
The Insert Function button is in the ____ group.
question
search
answer
The Insert Function dialog box has a(n) ____ option.
question
content in formats
answer
The fill handle copies ____
question
content
answer
Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the formatting.
question
february, march, april
answer
Using AutoFill, what would be the extended series of the initial entry Jan?
question
true or false
answer
A logical function is a function that works with values that are either ____.
question
A does not equal B
answer
In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____.
question
mixed
answer
____ references are seldom used other than when creating tables of calculated values such as a multiplication table in which the values of the formula or function can be found in the initial rows and columns of the table.
question
a blank cell
answer
=IF(G22= "x ", SUM(H22:J22), " ") with display ______ if G22 is not equal to "x".
question
look up
answer
______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.
question
#n/a
answer
If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell.
question
what if analysis
answer
One way to perform a _________ is by changing one or more of the input values to see how they affect the calculated results.
question
type january in cell A1 and then drag the fill handle
answer
Ellen opens Excel 2013 and enters her monthly income for one year beginning with January. To create a series of months, she can ____.
question
absolute reference
answer
Ellen has entered all of her monthly expenses. She needs to create a formula that will deduct her monthly expenses from her monthly income. Since her monthly income is the same amount each month, she uses a(n)____ to identify the cell containing the income value.
question
math and trig button in the function library group
answer
Ellen's spending varies from month to month. She wants to calculate the total expenses for each month. She wants to see all of the arguments associated with the SUM function so she clicks the ____ then clicks SUM to open the Function Arguments dialog box.
question
select the range A10:L10, click the quick analysis button, click TOTALS, then click median
answer
Ellen wants to find out what her median monthly spending is. The monthly totals for her spending appear in the range A10:L10. Which of the following is NOT a way to enter the MEDIAN function into her database?
question
F4
answer
Ellen is expecting to get a 3% raise next year. She enters .03 in cell D2 so that she can predict her monthly income for the next year. What function key will make D2 an absolute reference?
question
look up function
answer
Susan designs a worksheet with the inventory number, description, quantity, unit cost, reorder point and value. To find values in tables of data, and insert them in another location in the worksheet such as cells or in formulas, she will use ________.
question
false
answer
Susan needs to use a lookup function to find an exact match of an inventory item, so she will set the range_lookup value to _______ .
question
#N/A
answer
Susan uses VLOOKUP to retrieve the return value from a vertical lookup table. When she enters the VLOOKUP function, specifying the lookup value and other criteria, the lookup value cannot be found. It displays ______ error value in the cell
question
what if analysis
answer
Susan wants to make some changes to the worksheet to explore the impact that changing input values has on the calculated values in the worksheet. She can use ______.
question
goal seek
answer
Susan wants to automate the trial-and-error process by allowing her to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal. She can use ______.