Com Sci 113 exam 2

Goal seek

knowing the desired output

Solver

(Downloaded) finds optimum value for a variable given several constraints

Which of the following is the correct formula for COUNTIFS Function?

COUNTIFS(range1,criteria1, range2,criteria2,...)

Which of the following is the correct formula for SUMIF Function?

SUMIF( Range, Criteria, Sum_range)

"outline"

grouping rows or columns into related data

AND function

all values are true

data mining

analyzes large volumes of data use advanced statistical techniques identifies patterns

pivot table dynamics

data can be rearanged details can be expanded or collapsed stat can be organized and grouped differently row and column catergories can be swithed

Vlookup

easier to use looks up only 1st column

"report filter"

filters data that goes into the pivot table

"group filter"

filters selected columns and rows and fields

nested logical functions

function embedded within an argument

Index-match

more flexible two dimensional lookup more complicated

Index

returns a value at a specific row or column

NOT function

returns opposite argument

Match

searches and tell you where a value is positioned

Scenario manager

see how changing multiple inputs affects outputs

OR function

true if any conditions are true

Subtotals

used in large data sets to see subtotals for portions of data can be sum and averages

"use function"

what type of subtotal

"at each change"

where to place the subtotal rows

"add subtotal to"

which columns to calculate subtotals for