Multiple Choice Questions

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.
  • type january in cell A1 and then drag the fill handle
  • math and trig button in the function library group
  • select the range A10:L10, click the quick analysis button, click TOTALS, then click median
  • absolute reference
The numbers, text, or cell references used by the function to return a value are called ____.
  • arguments
  • cell references
  • formulas
  • average
Which of the following is not a date function? __
  • AND
  • median
  • INT
  • MAX
______ functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas.
  • look up
  • COUNT
  • absolute
  • logical
FUNCTION(argument1, argument2, ...) is ___
  • the average of the values A1:A100 is calculated
  • the formula returns the text "restart"
  • content in formats
  • the general syntax of all functions
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 ______.
  • does not change
  • what if analysis
  • goal seek
  • auto fill options button
Ellen wants to find out what her median monthly spending is. The monthly totals for her spending appear in the range A10:LWhich of the following is NOT a way to enter the MEDIAN function into her database?
  • math and trig button in the function library group
  • goal seek
  • select the range A10:L10, click the quick analysis button, click TOTALS, then click median
  • absolute reference
The Insert Function dialog box has a(n) ____ option.
  • forwarder inputs
  • data preview
  • apps
  • search
The ____ category of Excel functions retrieves data from multidimensional databases involving online analytical processing
  • Cube
  • absolute
  • COUNT
  • false
The ____ function returns the maximum value in the range
  • AVERAGE
  • MEDIAN
  • COUNT
  • MAX
Which of the following is not an Excel function category? ___
  • math & trig
  • text
  • algebra
  • average
In the formula =INT(AVERAGE(A1:A100)), which would occur first? ___
  • the same number of left and right parentheses
  • type january in cell A1 and then drag the fill handle
  • default
  • the average of the values A1:A100 is calculated
Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?
  • MAX
  • AVERAGE
  • COUNT
  • INT
Referring to the figure above, which number refers difference between the scheduled andattended workouts
  • five
  • four
  • three
  • two
If the VLOOKUP function cannot find the lookup value, the _________ error value is displayed in the cell.
  • #name?
  • #ref!
  • #n/a
  • absolute
Referring to the figure above, which number represents the COUNT function?
  • two
  • three
  • one
  • four
Ellen opens Excel 2013 and enters her monthly income for one year beginning with January. To create a series of months, she can ____.
  • auto fill options button
  • type january in cell A1 and then drag the fill handle
  • what if analysis
  • the formula returns the text "restart"
=IF(G22= "x ", SUM(H22:J22), " ") with display ______ if G22 is not equal to "x".
  • a blank cell
  • dashes
  • cell references
  • the result of the sum
The Insert Function button is in the ____ group.
  • user-defined function
  • function library
  • search
  • object
Referring to the figure above, the last entry shown in Column K is 644.There is a black "plus sign" on the lower right edge of the cell that is the
  • copy handle
  • auto fill options button
  • fill handle
  • scroll bar
After you describe a function in the Search for a function box in the Insert Function dialog box, click ____.
  • Go
  • F4
  • <<
  • four
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
  • absolute
  • #ref!
  • #N/A
  • #name?
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.
  • absolute reference
  • mixed reference
  • absolute
  • mixed
____ 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.
  • mixed
  • count
  • absolute
  • relative
Which of the following is a Statistical function?
  • max
  • count
  • average
  • median
Which of the following is not a comparison operator? __
  • AND
  • <<
  • average
  • MAX
The ____ category of Excel functions returns (true-false) values
  • median
  • absolute
  • optional
  • logical
=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function
  • Nested
  • Absolute
  • Relative
  • Average
In "SUM(number1 [, number2, number3, ...])", number 1, number 2, and number 3 may be numbers or ____.
  • operators
  • arguments
  • symbols
  • cell references
Referring to the figure above, the last entry shown in Column K is 644.There is an icon in the cell underneath the 644.7953813 which is the ____.
  • relative cell reference
  • auto fill options button
  • fill handle
  • argument
Using AutoFill, what would be the extended series of the initial entry Jan?
  • true or false
  • february, march, april
  • the formula returns the text "restart"
  • does not change
In the following formula: =IF(A1="YES", "DONE", "RESTART"), what happens if A1= "NO"?
  • february, march, april
  • A does not equal B
  • the formula returns the text "restart"
  • true or false
In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____.
  • the average of the values A1:A100 is calculated
  • A does not equal B
  • true or false
  • does not change
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 ______.
  • algebra
  • search
  • goal seek
  • track change
If an optional argument is not included, Excel assumes a(n) ____ value for it.
  • search
  • default
  • content
  • false
____ arguments may provide more control over the returned value.
  • arguments
  • absolute
  • relative
  • optional
Using the AutoFill Options button, the Fill Without Formatting option copies the ____ but not the formatting.
  • image
  • idea
  • content
  • text
0 h : 0 m : 1 s

Multiple Choice Questions
Answered Not Answered Not Visited Correct : 0 Incorrect : 0