You are creating formulas in your workbook that refer to a named Table on a different worksheet. What is the following f
Posted: Thu Jul 14, 2022 2:12 pm
You are creating formulas in your workbook that refer to a namedTable on a different worksheet. What is the following formulacalculating?
=SUBTOTAL(9,Sales[Transactions])
A. This is calculating a total for a column called Sales in aworksheet called Transactions.
B. This is calculating a total for a column called Sales in aTable called Transactions.
C. This is calculating a total for a column called Sales in aTable called Transactions.
=SUBTOTAL(9,Sales[Transactions])
A. This is calculating a total for a column called Sales in aworksheet called Transactions.
B. This is calculating a total for a column called Sales in aTable called Transactions.
C. This is calculating a total for a column called Sales in aTable called Transactions.