Excel

The___category of excel functions returns true or false values

Which of the following is a Math&Trig function?

Which of the following is a statistical function?

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

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

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

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

The ___ function returns the maximum value in the range.

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.

Absolute references are marked with a ___

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

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

____arguments may provide more control over the returned value.

FUNCTION(argument1, argument2,....)is _______.

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

Excel functions are organized into____catagoreies.

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

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

In the formula=INT(Average(A1:A100)), which would occur first?

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

___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.

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

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

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

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

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

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?

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

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.

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

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

Category values are usually located in the ____ of the data source

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

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

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

Excel supports all of the following types of sparklines EXCEPT ____.

To resize an embedded chart,____.

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.

A pie slice is a data marker that represents ____ from a data series.

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

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.

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

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.

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

The FV function stands for ___.

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

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

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

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.

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