Cmpsci Ex 2

Front 1

In order to generate correct subtotals, records must be ____.

Back 1

sorted

Front 2

Assume I plan to save $200 every month for the next 10 years. What function do you use to calculate the amount of money I will have in 10 years?

Back 2

FV

Front 3

What type of data do we put in the Values drop zone?

Back 3

Numeric

Front 4

A worksheet contains these columns in this sequence: business name, address, city, state, and donation amount. Data are sorted by state and then by city. What is the default "At change in" setting with the subtotal dialog box, and what would be a more appropriate setting?

Back 4

Default field = business name
Correct field = state

Front 5

You created an outline for a dataset. What does the + button indicate to the left of a row heading?

Back 5

Click it to expand the details of the category

Front 6

A worksheet contains a PIVOTTABLE placeholder and the PIVOTTABLE field list. Where do you drag the State field if you want a list of each state in the first column of the PivotTable?

Back 6

Row Labels Area

Front 7

You made changes to the original dataset in the PivotTable, what should you do now?

Back 7

Data Tab, Options Group, click "Refresh"

Front 8

You created a PivotTable to summarize salaries by department. What is the default summary statistic for Salaries in the PivotTable?

Back 8

SUM

Front 9

If you want to remove a former employee's name from the chart without deleting data, you should:

Back 9

Filter the employee's field in the pivotchart and deselt the employee's name check box

Front 10

Conditional formatting is:

Back 10

applies special formatting to highlight and emphasize cells that meet certain conditions.

Front 11

Use the ___ to insert subtotal rows at each designated field change in a sorted range of data

Back 11

Subtotal

Front 12

A ___ allows you to summarize, analyze, and explore large amounts of data

Back 12

PivotTable

Front 13

Regarding a PivotTable, to add a field that aggregates values, drop it in the ____ area

Back 13

Values

Front 14

A one-variable data table enables you to identify ___ variable(s) and ___ result(s)

Back 14

one, unlimited

Front 15

This function calculates a sum of values in a range only when related data meet a specific condition instead of calculating the sum of an entire range:

Back 15

SUMIF

Front 16

In the SUMIF function, what argument specifies the condition that imposes limitations on what values excel sums?

Back 16

Criteria

Front 17

This function calculates the average, or arithmetic mean, of all cells in a range that meet a specific condition:

Back 17

AVERAGEIF

Front 18

This function calculates the number of cells in a range that meet a specific condition you specify instead of calculating the count of an entire range:

Back 18

COUNTIF

Front 19

This function calculates the total value of cells in a range that meet multiple criteria:

Back 19

SUMIFS

Front 20

This function calculates the average value of cells in a range that meet multiple criteria:

Back 20

AVERAGEIFS

Front 21

This function counts the number of cells in a range that meet multiple criteria:

Back 21

COUNTIFS

Front 22

This function identifies the rank of a value but assigns an average rank when identical values exist:

Back 22

RANK.AVG

Front 23

This function displays a value's rank as a percentile of the range of data in the dataset:

Back 23

PERCENTRANK.INC

Front 24

This function accepts two or more logical tests and displays TRUE if all conditions are true or FALSE if all conditions are false.

Back 24

AND

Front 25

This function returns the position of a value in a list:

Back 25

MATCH

Front 26

This function returns a value or the reference to a value within a range:

Back 26

INDEX

Front 27

A ____ is a separate range of cells that specifies the conditions used to filter the table:

Back 27

Criteria Range

Front 28

This function calculates the principal payment for a specified payment period on a loan or an investment given a fixed interest rate, term, and periodic payments.

Back 28

PPMT (PRINCIPAL PAYMENT)

Front 29

This function calculates the cumulative interest throughout a loan authorization table:

Back 29

CUMIPMT (CUMULATIVE INTEREST PAYMENT)

Front 30

This function calculates the total present value of a series of future payments:

Back 30

PV (PRESENT VALUEEEE)

Front 31

This function calculates the future value of an investment, given a fixed interest rate, term, and periodic payment:

Back 31

FV (FUTURE VALUE)

Front 32

This function calculates the periodic rate for an investment or loan, given number of payment periods, a fixed periodic payment, and present value:

Back 32

RATE