FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

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: -Insert the nested subtotals. On the Data tab, in the Outline group, click Subtotal. The Subtotal dialog box is displayed. In the At each change in box, click the nested subtotal column.

Detailed explanation-3: -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.

There is 1 question to complete.