Question

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

a. The table will automatically expand to include the new value.
b. The table will not automatically expand to include the new value.
c. The table will only expand if the value entered is a numeric value.
d. 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?

a. Amount[tbl_data].
b. Amount(tbl_data).
c. tbl_data[Amount].
d. tbl_data(Amount).

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

a. Both SUMIFS and VLOOKUP will match equivalent values if stored as different data types.
b. SUMIFS will match equivalent values of different data types, but VLOOKUP will not.
c. VLOOKUP will match equivalent values of different data types, but SUMIFS will not.
d. 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?

a. Skinny row.
b. Start Here.
c. ErrorCk.
d. Mapping table.

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

Question 3:

Answer :a. The table will automatically expand to include the new value.

Explanation :When below the table in the adjacent cell when value is typed then the table will automatically expand to include the new value.

***************************

Question 4:

Answer :c. tbl_data[Amount].

Explanation : tbl_data[Amount] will refers to the amount column.

***************************

Question 5:

Answer :c. VLOOKUP will match equivalent values of different data types, but SUMIFS will not.

***************************

Question 6:

Answer :d. Mapping table.

Explanation :Mapping table helps Excel translate a data label to a report label

***************************

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.