FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
If there is an “h” before the “m", then Excel interprets the “m” as ____
A
minutes
B
money
C
months
D
moments
Explanation: 

Detailed explanation-1: -In the Format Cells dialog box, click the Number tab. Under Category, click Custom. In the Type box, type [h]:mm. TIP You can also show the results in minutes and seconds by setting the format to [m]:ss, or minutes only by typing [m].

Detailed explanation-2: -In the Format Cells box, click Custom in the Category list. In the Type list, click h:mm (for hours and minutes), and then click OK.

Detailed explanation-3: -Divide the minute value by 1440 ( A1/1440 ). Format the value as “Time".

Detailed explanation-4: -Right click the selected cells and then click Format Cells, or press Ctrl + 1. This will open the Format Cells dialog box. On the Number tab, under Category, select Custom, and type one of the following time formats in the Type box: Over 24 hours: [h]:mm:ss or [h]:mm.

There is 1 question to complete.