FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of these IF functions will result in 10 if A1 has a value of 5?A) =IF(A1>7, 10, 5)B) =IF(A1>3, 10, 5)C) =IF(A1>10, 10, 5)D) =IF(A1=5, 10, 5)
A
A
B
B
C
C
D
D
Explanation: 

Detailed explanation-1: -In the above spreadsheet, the LEFT formula in excel written is =LEFT (A1, 5). The result based on the syntax of the LEFT function is TOMAT.

Detailed explanation-2: -The average function returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers. (Range: Two or more cells on a sheet.

Detailed explanation-3: -For example, suppose we type the text “Good Night” in cell A1, and we need to know its characters. Then, we can use the LEN Excel function. In such cases, we can use the following function: LEN(A1), which would return the result 10.

Detailed explanation-4: -The following command gives the way to add 10 cells starting from a1 to a10: SUM(A1:A10). With this sum can be calculated.

There is 1 question to complete.
Previous
Next