USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
AND
|
|
|
OR
|
|
|
IF
|
|
|
SUM
|
Detailed explanation-1: -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-2: -The COUNTIF Function[1] will count the number of cells that meet a specific criterion. The function is categorized under Excel Statistical functions.
Detailed explanation-3: -Use CONCATENATE, one of the text functions, to join two or more text strings into one string.
Detailed explanation-4: -We could use the COUNTIFS function, as it allows us to set more than one condition. Note: Excel will only include the cells in column C in the count when both conditions (Brian & South) are met.
Detailed explanation-5: -The VLOOKUP function uses the following arguments: Lookup value (required argument) – Lookup value specifies the value that we want to look up in the first column of a table. Table array (required argument) – The table array is the data array that is to be searched.