FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Functions save time and help ensure accuracy, although they are available only for simple calculations.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Using cell references will ensure that your formulas are always accurate because you can change the value of referenced cells without having to rewrite the formula.

Detailed explanation-2: -In order to calculate how much time has elapsed since the start time to now, you simply use the NOW function to return today’s date and the current time, and then subtract the start date and time from it.

Detailed explanation-3: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false.

Detailed explanation-4: -To create a formula using the point-and-click method: Instead of typing cell addresses manually, you can point and click the cells you want to include in your formula. This method can save a lot of time and effort when creating formulas.

There is 1 question to complete.