Formula

Question 1

MAX and MIN Functions

Answer 1

• Use: MAX returns the maximum value from a range or a set of values, while MIN returns the minimum value.
  Syntax:
  -For MAX: =MAX(range1, range2, …)
  -For MIN: =MIN(range1, range2, …)

Question 2

IF and IFS Functions

Answer 2

-Use: IF evaluates a condition and returns one value if the condition is true, and another value if false. IFS evaluates multiple conditions and returns a value corresponding to the first true condition.
Syntax:
- For IF: =IF(logical_test, value_if_true, value_if_false)
- For IFS: =IFS(test1, value1, [test2, value2], …)

Question 3

LENGTH Function

Answer 3

• Use: Returns the number of characters in a text string. {check SSN}
• Syntax: =LEN(text)

Question 4

RIGHT and LEFT Functions

Answer 4

• Use: RIGHT extracts a specified number of characters from the right side of a text string, and LEFT extracts from the left side. {extract year from date}
  Syntax:
• For RIGHT: =RIGHT(text, num_chars)
• For LEFT: =LEFT(text, num_chars)

Question 5

TEXT Function

Answer 5

• Use: Converts a value to text using a specified format.
• Syntax: =TEXT(value, format_text)

Question 6

TRIM Function

Answer 6

• Use: Removes extra spaces from a text string, excluding single spaces between words.
• Syntax: =TRIM(text)

Question 7

CONCATENATE Function

Answer 7

• Use: Joins multiple text strings into one single text string.
• Syntax: =CONCATENATE(text1, text2, …)

Question 8

SUBSTITUTE Function

Answer 8

• Use: Replaces occurrences of a specified substring with a new string within a given text.
• Syntax: =SUBSTITUTE(text, old_text, new_text, [instance_num])

Question 9

SUMIF and SUMIFS Functions

Answer 9

• Use: SUMIF calculates the sum of cells that meet a single condition, while SUMIFS calculates the sum of cells that meet multiple conditions.
  Syntax:
• For SUMIF: =SUMIF(range, criteria, [sum_range])
• For SUMIFS: =SUMIFS(sum_range, range1, criteria1, [range2, criteria2], …)

Question 10

COUNTIF and COUNTIFS Functions

Answer 10

• Use: COUNTIF counts the number of cells in a range that meet a single condition, while COUNTIFS counts the number of cells that meet multiple conditions.
  Syntax:
• For COUNTIF: =COUNTIF(range, criteria)
• For COUNTIFS: =COUNTIFS(range1, criteria1, [range2, criteria2], …)

Question 11

DAYS and NETWORKDAYS Functions

Answer 11

• Use: DAYS calculates the number of days between two dates, while NETWORKDAYS calculates the number of working days between two dates, excluding weekends and optional holidays.
  Syntax:
• For DAYS: =DAYS(end_date, start_date)
• For NETWORKDAYS: =NETWORKDAYS(start_date, end_date, [holidays])