The___category of excel functions returns true or false values |
Information |

Which of the following is a Math&Trig function? |
INT |

Which of the following is a statistical function? |
Average |

=Round(Average(A1:A100),2) is an example of a(n)___function. |
Logical |

After you describe a functions in the search for a function box in the Insert Function dialog box, click___… |
Next |

The numbers, text, or cell references used by the function to return a value are called….. |
Values |

In the following formula: =IF(A1="YES", "Done", "Restart"), what happens if A1=No? |
The formula returns the text NO |

The ___ function returns the maximum value in the range. |
Max |

One of the great advantages ___ 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. |
Cell |

Absolute references are marked with a ___ |
$ |

When you copy a formula that contains an absolute reference to a new location, the reference____. |
Is updated automatically |

Use___reference when you want different formulas to refer to the same cell. |
Relative |

____arguments may provide more control over the returned value. |
Absolute |

FUNCTION(argument1, argument2,….)is _______. |
The syntax of writing optional arguments |

If an optional argument is not included, excel assumes a(n)____value for it. |
default |

Excel functions are organized into____catagoreies. |
13 |

in "SUM(number1[, number2, number3,…]", number 1, number 2, and number 3 may be numbers or____. |
Cell Reference |

Which category of excel functions returns information about the format, location, or contents or worksheets cells? |
Description |

In the formula=INT(Average(A1:A100)), which would occur first? |
The average of the values in the range A1:A100 is calculated. |

Using the AutoFill Options button, the Fill Without Formatting option copies the___but not the formatting. |
Functions |

___reference 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. |
Matched |

=IF(G22="x", SUM(H22:J22),"") will display ___ if G22 is not equal to "x". |
False |

___functions find values in tables of data and insert them in another location in the worksheet such as cells or in formulas. |
Lookup |

If the Vlookup function connot find the lookup value, the ___error value is displayed in the cell. |
#Value |

One way to perform a ____is by changing one or more of the input values to see how they affect the calculated results. |
What-if analysis |

Since her monthly income is the same amount each month, she uses a(n)____ to identify the cell containing the income value. |
fixed reference |

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? |
F4 |

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 _______ . |
Exact |

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. |
#Value |

Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent. True or False |
True |

A ________ contains the actual values that are plotted on the chart |
Legend |

Category values are usually located in the ____ of the data source |
Either A or B |

The ____ is the only one of the following charts to compare relative values from different categories to the whole. |
Column |

The ____ dialog box provides options for moving charts between worksheets and chart sheets. |
Move Chart |

Placing a chart in a___displays only the chart and no worksheet cells. |
Chart Sheet |

Excel supports all of the following types of sparklines EXCEPT ____. |
true/false sparkline for help making decisions |

To resize an embedded chart,____. |
Select the chart and drag the corner sizing handle of the selection box |

To reposition the legend to the left-hand side of a chart, click the _________ button, point to Legend, click the right arrow icon, and click Left. |
Chart Elements |

A pie slice is a data marker that represents ____ from a data series. |
Only one value |

To move one slice of a pie chart away from the pie creates a(n)____ |
Perfect pie chart |

You already created a line chart, but now decide that you want to change this chart to a pie chart. To do this, you click ____ from the Type group in the Chart Tools Design tab. |
Change Chart Type |

The range of values or _______, of an axis is based on the values in the data source. |
Series |

To format an individual sparkline, select the sparkline you want to format, and then click the Ungroup button in the Group group on the SPARKLINE TOOLS ____ tab. |
Design |

___is the amount added to the principle of a loan by the lender. |
Interest |

The FV function stands for ___. |
formulated value |

the amount of money being loaned is know as the ____. |
Loan amount |

PMT(rate,nper,pv[,fv=0][,type=0]) the possible values for the type argument in the function above area. |
0 or null |

Since it’s important for Mya to keep percentages of her whole reviewer base in mind, she wants to represent data as parts of a whole. What chart type would you suggest to Mya? _____ |
Pie |

Sometimes Mya might want to see information on only specific slices. Rather than creating a new chart that includes only those selections, she can _____ an existing chart. |
Filter |

Mya needs to call attention to one category above all others. For this purpose, she should use a(n) ____. |
Exploded Pie Chart |

# Excel

### Share This

## Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price