[cite_start]”What is the AND function?”
A logical function used to test multiple conditions at the same time. It returns TRUE only if all conditions are met. [cite: 2]
Notation: =AND(logical1, [logical2], …)
[cite_start]”What is the IF function?”
Performs a logical test and returns one result if TRUE and another if FALSE. [cite: 2]
[cite_start]Notation Example: =IF(A1>70, “Pass”, “Fail”) [cite: 2]
[cite_start]”What is the IFERROR function?”
Returns a custom result when a formula generates an error, and a standard result when no error is detected. [cite: 2]
Notation: =IFERROR(value, value_if_error)
[cite_start]”What is the IFS function?”
Runs multiple tests and returns a value corresponding to the first TRUE result. [cite: 2]
Notation: =IFS(logical_test1, value_if_true1, …)
What is the OR function?
Tests multiple conditions and returns TRUE if any condition is TRUE. [cite_start]It returns FALSE only if all conditions are FALSE. [cite: 2]
Notation: =OR(logical1, [logical2], …)
[cite_start]”What is the LOOKUP function?”
Looks up a value in one range/array and returns a corresponding value from another (approximate match only). [cite: 2]
[cite_start]Notation: =LOOKUP(lookup_value, lookup_vector, [result_vector]) [cite: 2]
[cite_start]”What is the VLOOKUP function?”
Scans the first column of a table for a match and returns a result from the same row. [cite: 2]
[cite_start]Notation: =VLOOKUP(lookup_value, table_array, column_index_num, [range_lookup]) [cite: 2]
[cite_start]”What is the XLOOKUP function?”
Searches a row or column for a value and retrieves the corresponding value from another range. [cite: 2]
[cite_start]Notation: =XLOOKUP(lookup, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]) [cite: 2]
[cite_start]”What is the FILTER function?”
Extracts matching values from data based on one or more conditions (dynamic array). [cite: 2]
[cite_start]Notation: =FILTER(array, include, [if_empty]) [cite: 2]
[cite_start]”What is the COUNTIFS function?”
Returns the count of cells in a range that meet one or more conditions. [cite: 3]
[cite_start]Notation: =COUNTIFS(range1, criteria1, [range2], [criteria2]) [cite: 3]
[cite_start]”What is the SUMIFS function?”
Returns the sum of cells that meet multiple conditions. [cite: 3]
[cite_start]Notation: =SUMIFS(sum_range, range1, criteria1, [range2], [criteria2]) [cite: 3]
[cite_start]”What is the DMAX function?”
Returns the maximum value in a field from a set of records that match criteria. [cite: 3]
[cite_start]Notation: =DMAX(database, field, criteria) [cite: 3]
[cite_start]”What is the RANDBETWEEN function?”
Returns a random integer between two given numbers. [cite: 3]
[cite_start]Notation: =RANDBETWEEN(bottom, top) [cite: 3]
[cite_start]”What is the RAND function?”
Returns a random number between 0 and 1. [cite: 3]
[cite_start]Notation: =RAND() [cite: 3]
[cite_start]”What is Conditional Formatting?”
Used to highlight cells based on specific rules. [cite: 4]
[cite_start]”What is a Pivot Table?”
Used to analyze data. [cite: 5]
[cite_start]Steps: Select all data > Pivot Table (New Worksheet) > Select Rows/Values. [cite: 6, 7, 8]
[cite_start]”How do you visualize percentages?”
Insert a chart. [cite: 9]
[cite_start]”What is a Slicer?”
A tool to select exactly what data you want to see (filtering). [cite: 10]
[cite_start]”What is Forecasting?”
Predicts future outcomes based on current trends and data. [cite: 12]
[cite_start]Steps: Insert > Chart Line > Add Trendline. [cite: 13]
[cite_start]”What is Goal Seek?”
Works backward from a desired outcome to find the single input needed to achieve it. [cite: 14]
[cite_start]Method: Identify a cell that must reach a value by changing a linked cell. [cite: 15]
