When the Subtotal function is used by clicking the Subtotal button on the Data tab, data is summed within the data range to give subtotals and a grand total.
Correct Answer:
Verified
Q601: The COUNTA function counts the number of
Q602: To count cells with text, you use
Q603: The function number 5 calculates SUM.
Q604: After you name a range, Excel remembers
Q605: Named ranges are helpful if you need
Q607: You use the HLOOKUP function when the
Q608: The _ function locates data when it
Q609: Table_array is the range of cells for
Q610: The SUMIF function will only total data
Q611: After data is filtered, only the cells
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents