CGS 2518 EXAM 2 QUESTIONS WITH CORRECT ANSWERS

a range of cells that shows calculated results of one or more formulas is called a


Give this one a try later!


data table




the statistical function that does computations only after data meets multiple criteria is


Give this one a try later!


COUNTIFS




database functions all allow the same syntax and have three

, Give this one a try later!


Arguments




this function displays the content of the cell at the intersection of an identified column
and row


Give this one a try later!


INDEX




a cell with a formula that can be solved for specific results is called an


Give this one a try later!


objective cell




what settings determine how data is summarized in a pivot table


Give this one a try later!


value field




to create a slicer click the insert slicer button in the filter group on the


Give this one a try later!