EXCEL/SPREADSHEET QUESTIONS

1.	Which function is a conditional sum function that supports multiple conditions?

SUMIF. SUMIFS. INDEX. VLOOKUP.

2.	The first argument of the SUMIFS function is:

THE COLUMN OF NUMBERS TO ADD. THE FIRST CRITERIA RANGE. THE FIRST CRITERIA VALUE. A CODE THAT IDENTIFIES THE TYPE OF MATH; 9 IS THE CODE FOR SUM.

3.	If your worksheet has a Table, and you type a value into a cell adjacent and under the Table:

THE TABLE WILL AUTOMATICALLY EXPAND TO INCLUDE THE NEW VALUE. THE TABLE WILL NOT AUTOMATICALLY EXPAND TO INCLUDE THE NEW VALUE. THE TABLE WILL ONLY EXPAND IF THE VALUE ENTERED IS A NUMERIC VALUE. THE TABLE WILL ONLY EXPAND IF THE VALUE ENTERED IS A TEXT STRING.

4.	If your worksheet has a Table named tbl_data, and the Table has a column named Amount, which of the following refers to the column?

AMOUNT[TBL_DATA]. AMOUNT(TBL_DATA). TBL_DATA[AMOUNT]. TBL_DATA(AMOUNT).

5.	When looking up a value in a lookup range, will a numeric value match the equivalent text value?

BOTH SUMIFS AND VLOOKUP WILL MATCH EQUIVALENT VALUES IF STORED AS DIFFERENT DATA TYPES. SUMIFS WILL MATCH EQUIVALENT VALUES OF DIFFERENT DATA TYPES, BUT VLOOKUP WILL NOT. VLOOKUP WILL MATCH EQUIVALENT VALUES OF DIFFERENT DATA TYPES, BUT SUMIFS WILL NOT. NEITHER SUMIFS NOR VLOOKUP WILL MATCH EQUIVALENT VALUES OF DIFFERENT DATA TYPES.

6.	Which technique helps Excel translate a data label to a report label?

SKINNY ROW. START HERE. ERRORCK. MAPPING TABLE.