FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

You have sorted your employee listing by the department field and wish to total the salaries within each department. Which function would you use?

A	Total
B	Sum
C	Subtotal
D	Max

Explanation:

Detailed explanation-1: -What is the SUBTOTAL Function in Excel? The SUBTOTAL Function[1]in Excel allows users to create groups and then perform various other Excel functions such as SUM, COUNT, AVERAGE, PRODUCT, MAX, etc. Thus, the SUBTOTAL function in Excel helps in analyzing the data provided.

Detailed explanation-2: -The SUBTOTAL function is designed for columns of data, or vertical ranges. It is not designed for rows of data, or horizontal ranges. For example, when you subtotal a horizontal range using a function num of 101 or greater, such as SUBTOTAL(109, B2:G2), hiding a column does not affect the subtotal.

Detailed explanation-3: -function num-A number that specifies which function to use in calculating subtotals within a list. See table below for full list. ref1-A named range or reference to subtotal.

There is 1 question to complete.