Which function you can use to quickly calculate rows of related data?Group of answer choicesSubtotalGroupUngroupRelationships

In a database file, which is organized in a two-dimensional table, the rows represent records of related data elements.Group of answer choicesTrueFalse

Grouping related columns(F and G) of data as shown in the above is called?Group of answer choicesCreating an expandCreating an OutlineCreating a pivot tableNone of the answers are correct

What function allows the user to pull a subset of data from a larger table of data based on some criterion?Group of answer choicesIFSUMIFVLOOKUPCOUNTIF

The process of systematic arrangement of data in rows and columns is calledGroup of answer choicesArrayTabulationArrangementClassification

The Excel function HLOOKUP looks up a value in the top row of a table and returns a value in the same column from a row you specify. Group of answer choicesTrueFalse