Master Excel with 380+ detailed practice questions, step-by-step guidance, and tips & tricks from beginner to expert.
Showing 380 of 380 questions
Learn to add values from different cells using cell references
Master the SUM function to add multiple values efficiently
Learn to calculate the average of test scores using the AVERAGE function
Use the COUNT function to count only numeric values in a range
Use the MAX function to find the highest value in a range
Use the MIN function to find the smallest value in a range
Learn to multiply values using the multiplication operator and cell references
Learn to divide values using the division operator and cell references
Learn to calculate what percentage one value represents of another
Use COUNTA function to count all non-empty cells including text and numbers
Master the IF function to create conditional logic in Excel
Learn to combine or concatenate text values using the & operator
Learn to round numbers to specific decimal places using the ROUND function
Use the ABS function to convert negative numbers to positive
Use the TODAY function to display the current date that updates automatically
Use the LEN function to count the number of characters in text
Use the UPPER function to convert text to all uppercase letters
Use the LOWER function to convert text to all lowercase letters
Use the PROPER function to capitalize the first letter of each word
Use the TRIM function to remove leading and trailing spaces from text
Use the POWER function to calculate a number raised to a specific power
Use the SQRT function to calculate the square root of a number
Use the MOD function to find the remainder when one number is divided by another
Use the CONCATENATE function to join multiple text values together
Learn to subtract values using cell references
Learn to calculate savings by subtracting expenses from salary
Learn to calculate total cost by multiplying quantity and unit price
Learn to calculate unit price by dividing total cost by quantity
Use the AVERAGE function to calculate the mean value across a range
Use the MIN function to find the smallest value in a range
Use the COUNT function to count only numeric values, ignoring text and empty cells
Learn to combine SUM functions with subtraction to calculate net profit
Learn to calculate percentage increase between two values
Learn to perform multiple calculations in one formula using order of operations
Learn to use absolute references with dollar signs to lock cell references
Use the IF function to make conditional decisions in your spreadsheet
Learn to use nested IF functions to evaluate multiple conditions
Use the COUNTIF function to count cells that meet a specific condition
Use the SUMIF function to sum only values that meet a specific condition
Use the AVERAGEIF function to calculate the average of values that meet a specific condition
Use the ampersand operator to combine first and last names into full names
Use the UPPER function to convert text to all uppercase letters
Use the LOWER function to convert text to all lowercase letters
Use the LEFT function to extract characters from the beginning of text
Use the RIGHT function to extract characters from the end of text
Use the MID function to extract characters from anywhere in a text string
Use the LEN function to count the number of characters in text
Use the TRIM function to remove leading and trailing spaces from text
Use the NOW function to display the current date and time that updates automatically
Use the TODAY function to display the current date that updates automatically
Use the YEAR function to extract the year from a date
Use the MONTH function to extract the month number from a date
Use the DAY function to extract the day of month from a date
Use the DATE function to create a valid date from separate year, month, and day values
Use the ROUND function to round numbers to specified decimal places
Use the ROUNDUP function to always round numbers up to the next higher value
Use the ROUNDDOWN function to always round numbers down to the next lower value
Use the POWER function to calculate a number raised to a specific power
Use the SQRT function to calculate the square root of a number
Use the PRODUCT function to multiply all values in a range
Use the MOD function to find the remainder when one number is divided by another
Use the ISEVEN function to check if a number is even
Use the ISODD function to check if a number is odd
Use the ISBLANK function to check if a cell is empty
Use the ISNUMBER function to check if a value is numeric
Use the ISTEXT function to check if a value is text
Learn to combine text and numbers using concatenation to create descriptive labels
Use the VALUE function to convert text that looks like a number to an actual numeric value
Use the TEXT function to format numbers as text with specific formatting patterns
Use the FIND function to locate the position of specific text within a larger text string
Use the SUBTOTAL function to sum values that automatically adjust when rows are filtered or hidden
Use the RANK function to determine the rank of a number within a list
Use the RANK.EQ function to rank values where tied values get the same rank
Use the LARGE function to find the kth largest value in a range
Use the SMALL function to find the kth smallest value in a range
Use the STDEV function to calculate the standard deviation of a sample dataset
Use the VLOOKUP function to look up values in a table with exact match
Use the INDEX function to retrieve a value from a specific position in a range
Use the OR function to check if at least one condition is true
Use the AND function to check if all conditions are true simultaneously
Use the NOT function to reverse a logical value (TRUE becomes FALSE and vice versa)
Use the CONCATENATE function to join multiple text strings together into one
Use the REPLACE function to replace characters in a string based on starting position and length
Use the SUBSTITUTE function to replace all occurrences of specific text within a string
Use the PROPER function to capitalize the first letter of each word in a text string
Use the REPT function to repeat text a specific number of times
Use the CELL function to retrieve information about a cell's formatting, location, or contents
Use the ISNA function to check if a value is the #N/A error
Use the ISERROR function to check if a value is any type of error
Learn the difference between COUNTA (counts all non-empty cells) and COUNT (counts only numbers)
Calculate the number of days between two dates by subtracting them
Add a specific number of days to a date to calculate a future date
Use the HOUR function to extract the hour component from a time value
Use the MINUTE function to extract the minute component from a time value
Use the SECOND function to extract the second component from a time value
Convert time values to decimal hours by multiplying by 24
Calculate the number of hours worked between start and end times
Use the CEILING function to round a number up to the nearest specified multiple
Use the FLOOR function to round a number down to the nearest specified multiple
Use the ABS function to convert negative numbers to positive
Use the INT function to extract the integer part of a number by rounding down
Use the ROUND function with negative digits to round to the nearest ten, hundred, or thousand
Use the SUMPRODUCT function to multiply corresponding arrays and sum the results in one step
Calculate the average manually by dividing SUM by COUNT instead of using the AVERAGE function
Calculate what percentage each value represents of the total using division with absolute references
Calculate the percentage change between two values using the formula (new-old)/old
Use the modern CONCAT function to join multiple text strings together
Use the EOMONTH function to get the last day of a month offset by specified months
Use the EDATE function to add a specified number of months to a date
Use the WEEKDAY function to get the day of week as a number (1-7)
Use the NETWORKDAYS function to count working days (Monday-Friday) between two dates, excluding weekends
Use the modern IFS function to handle multiple conditional checks in a single formula
Use the SWITCH function to return different values based on exact value matching
Use the SUMIFS function to sum values that match multiple criteria simultaneously
Use the COUNTIFS function to count cells that meet multiple criteria simultaneously
Use the AVERAGEIFS function to calculate the average of values that meet multiple criteria simultaneously
Use SUM combined with IF to conditionally sum values that meet a criteria
Use the DATEVALUE function to convert text that looks like a date into an actual Excel date value
Use the TEXT function with currency format codes to display numbers as formatted currency text
Use the SEARCH function to find the position of text within a string (case-insensitive)
Use the IF function to check for error conditions and handle them gracefully
Use LEN combined with TRIM to count characters after removing leading and trailing spaces
Combine CONCAT and TEXT to join text strings with properly formatted currency values
Use MAX combined with IF in an array formula to find the maximum value that meets a condition
Use an array formula combining SUM and IF to count how many values meet a dynamic criteria (above average)
Find employee salary using VLOOKUP
Check multiple conditions
Check if any condition is true
Count cells meeting criteria
Sum values meeting criteria
Average values meeting criteria
Alternative to VLOOKUP using INDEX/MATCH
Grade assignment based on score
Extract characters from left
Extract characters from right
Extract characters from middle
Extract characters from middle
Find position of text
Find position of text
Replace text within string
Replace text within string
Create date from components
Create date from components
Extract year from date
Extract year from date
Extract month from date
Extract month from date
Extract day from date
Extract day from date
Get day of week
Get day of week
Calculate difference between dates
Calculate difference between dates
Handle errors gracefully
Handle errors gracefully
Round to nearest hundred
Round to nearest hundred
Round up to nearest multiple
Round up to nearest multiple
Round down to nearest multiple
Round down to nearest multiple
Rank value in array
Rank value in array
Find percentile value
Find percentile value
Horizontal lookup
Horizontal lookup
Choose value from list
Choose value from list
Reference cell indirectly
Reference cell indirectly
Reference offset from base cell
Reference offset from base cell
Format number as text
Format number as text
Convert text to number
Convert text to number
Check if cell is blank
Check if cell is blank
Check if value is number
Check if value is number
Check if value is text
Check if value is text
Reverse logical value
Reverse logical value
Use the advanced XLOOKUP function to perform powerful lookups with superior flexibility
Master the powerful SUMPRODUCT function for efficient array-based calculations
Use COUNTIFS to count cells that meet multiple criteria simultaneously
Use SUMIFS to sum values that meet multiple criteria simultaneously
Use AVERAGEIFS to calculate the average of values that meet multiple criteria simultaneously
Master array formulas using SUM to perform element-wise multiplication and summation
Use the TRANSPOSE function to convert data from horizontal (rows) to vertical (columns)
Use the FREQUENCY function to create frequency distributions and histograms
Use the LINEST function to perform linear regression analysis and extract regression statistics
Use the MMULT function to multiply two matrices according to linear algebra rules
Use the MINVERSE function to calculate the inverse of a square matrix
Use the MDETERM function to calculate the determinant of a square matrix
Use the LOOKUP function to perform approximate match lookups in sorted arrays
Use the HYPERLINK function to create clickable hyperlinks with custom display text
Use the CELL function to retrieve detailed information about cells including column/row numbers
Use the INFO function to retrieve information about the operating environment and Excel application
Use the TYPE function to determine the data type of a value
Use the ISERROR function to detect any type of error in a formula expression
Use the ISNA function to specifically detect #N/A errors from lookup functions
Use the powerful AGGREGATE function with options to handle errors, hidden rows, and subtotals
Use the SUBTOTAL function to calculate sums, averages, and other aggregates that automatically ignore hidden rows
Use the SMALL function to find the kth smallest value in a dataset
Use the LARGE function to find the kth largest value in a dataset
Use the QUARTILE function to calculate quartile values for statistical analysis
Use the MEDIAN function to find the middle value in a dataset
Sum values that fall within a date range using SUMIFS
Return an intersection value using INDEX and MATCH
Join non-blank text values with a delimiter
Extract rows that meet a condition with FILTER
Return a custom message when a lookup fails
Calculate a weighted total with SUMPRODUCT
Assign letter grades with IFS
Count working days between two dates
List unique values in sorted order
Average a range while ignoring errors with AGGREGATE
Extract the prefix before a hyphen
Count rows matching two conditions
Wrap VLOOKUP with IFERROR for clean output
Return the last day of the month
Return specific columns from a range
Calculate a fixed loan payment with PMT
Find the maximum value meeting a criterion
Replace characters inside text
Approve only when two conditions are true
Flip a horizontal range into a vertical spill
Always round away from zero to 2 decimals
Return the relative position of a value
Use LET to store intermediate names in a formula
Generate a sequential list of numbers
Calculate net present value of cash flows
Map codes to labels with SWITCH
Convert a number to currency-style text
Find the lowest value for a category
Add business days to a start date
Stack ranges horizontally into one array
Project the future value of periodic savings
Pass if either condition is true
Pull characters from the middle of a string
Rank a score within a list
Convert a block into a single column
Use the advanced XLOOKUP function to perform powerful lookups with superior flexibility
Master the powerful SUMPRODUCT function for efficient array-based calculations
Use COUNTIFS to count cells that meet multiple criteria simultaneously
Use SUMIFS to sum values that meet multiple criteria simultaneously
Use AVERAGEIFS to calculate the average of values that meet multiple criteria simultaneously
Master array formulas using SUM to perform element-wise multiplication and summation
Use the TRANSPOSE function to convert data from horizontal (rows) to vertical (columns)
Use the FREQUENCY function to create frequency distributions and histograms
Use the LINEST function to perform linear regression analysis and extract regression statistics
Use the MMULT function to multiply two matrices according to linear algebra rules
Use the MINVERSE function to calculate the inverse of a square matrix
Use the MDETERM function to calculate the determinant of a square matrix
Use the LOOKUP function to perform approximate match lookups in sorted arrays
Use the HYPERLINK function to create clickable hyperlinks with custom display text
Use the CELL function to retrieve detailed information about cells including column/row numbers
Use the INFO function to retrieve information about the current operating environment
Use the TYPE function to determine the data type of a value or cell
Use the ISERROR function to check if a formula or value results in any error
Use the ISNA function to specifically check for #N/A errors from lookup functions
Use the AGGREGATE function to perform statistical calculations with options to ignore errors and hidden rows
Use the SUBTOTAL function to perform calculations that automatically ignore hidden rows from filtering
Use the SMALL function to retrieve the kth smallest value from a dataset
Use the LARGE function to retrieve the kth largest value from a dataset
Use the QUARTILE function to divide data into quartiles for statistical analysis
Use the MEDIAN function to find the middle value of a dataset, resistant to outliers
Use the FILTER function to dynamically extract rows from an array based on specified criteria
Use the SORT function to dynamically sort arrays by one or more columns
Use the UNIQUE function to extract unique values from a range, automatically removing duplicates
Use the SEQUENCE function to dynamically generate sequences of numbers with custom patterns
Use the RANDARRAY function to generate arrays of random numbers with specified dimensions and ranges
Use the LAMBDA function to create custom, reusable functions directly in Excel formulas
Use the LET function to define named variables within a formula for improved readability and performance
Use XLOOKUP with concatenated criteria to perform lookups based on multiple conditions
Use INDEX with MATCH functions to perform two-way lookups across rows and columns
Use array formulas with boolean arrays to sum values meeting multiple AND conditions
Use the INDIRECT function to create dynamic cell references from text
Use the OFFSET function to create dynamic ranges that adjust based on specified dimensions
Use nested array functions to find maximum values that meet specific criteria
Use FIND and MID functions to extract specific text from complex strings
Use the NPV function to calculate the net present value of an investment with variable cash flows
Use NORM.INV with RAND to generate random values from a normal distribution for Monte Carlo simulations
Use Binet's formula to directly calculate Fibonacci numbers without recursion
Use COUNTIF to create a validation formula that ensures values are unique within a specified range
Use MOD and ROW functions to create conditional formatting formulas that highlight rows in patterns
Use OFFSET with COUNTA to create dynamic chart ranges that automatically expand with new data
Use nested IFERROR functions to create multiple fallback calculations with graceful error handling
Use SUBSTITUTE, MID, and TRIM to extract specific items from a comma-separated list
Use SUMPRODUCT to calculate weighted averages where different items have different importance weights
Use mathematical formulas to avoid circular references in iterative calculations
Use nested IF functions to create a complex multi-tier bonus calculation based on performance thresholds
Use the FILTER function to dynamically extract rows from an array based on specified criteria
Use the SORT function to dynamically organize array data by specified column and order
Use the UNIQUE function to extract distinct values from an array and remove duplicates
Use the SEQUENCE function to dynamically generate arrays of sequential numbers with custom parameters
Use the RANDARRAY function to dynamically generate arrays of random numbers with specified dimensions and range
Use the LAMBDA function to define and use custom reusable functions within Excel formulas
Use the LET function to define named variables within formulas for improved readability and performance
Use XLOOKUP with concatenated criteria to perform lookups based on multiple conditions simultaneously
Use INDEX with nested MATCH functions to perform two-dimensional lookups by matching both row and column criteria
Two-way lookup with multiple criteria
Use array formula multiplication to sum values that meet multiple conditions simultaneously
Sum with multiple array conditions
Use the INDIRECT function to create cell references from text strings and construct dynamic ranges
Create dynamic cell reference
Use the OFFSET function to create dynamic ranges with variable dimensions controlled by cell values
Create expanding range with OFFSET
Use nested array functions to perform conditional calculations and find maximum values meeting specific criteria
Complex nested array calculation
Use FIND and MID functions together to extract specific text patterns from strings
Complex text manipulation
NPV calculation with variable cash flows
Use NPV function to calculate the net present value of an investment with initial cost and future cash flows
Random scenario generation
Use NORM.INV with RAND to generate random values from a normal distribution for Monte Carlo simulations
Fibonacci sequence calculation
Use Binet's formula to calculate Fibonacci numbers directly without recursion or iteration
Complex validation rule
Use COUNTIF to create data validation rules that ensure values are unique within a specified range
Highlight every 3rd row
Use MOD and ROW functions to create conditional formatting rules that highlight rows in repeating patterns
Create expanding chart range
Use OFFSET with COUNTA to create dynamic ranges that automatically expand as new data is added
Multiple fallback calculations
Use nested IFERROR functions to create error handling chains with multiple fallback calculations
Split delimited text
Use SUBSTITUTE, REPT, and MID functions to extract specific items from comma-delimited text without using Text to Columns
Calculate weighted average
Use SUMPRODUCT and SUM to calculate weighted averages where different values contribute proportionally to the result
Iterative calculation without circular reference
Use explicit mathematical formulas to perform iterative calculations without circular references
Complex business calculation
Create a complex tiered calculation using nested IF functions to implement business rules with multiple thresholds
Filter rows using AND logic across columns
Create an inline LAMBDA and call it
Apply a calculation to each array element
Build a running total with SCAN
Reduce an array to a single product
Average each row of a matrix
Sum each column with BYCOL
Find the last matching value with XLOOKUP
Two-way lookup with INDEX and dual MATCH
Sum values when either condition is true
Split delimited text into columns
Create category totals with UNIQUE and SUMIF
Generate a 3x3 multiplication grid
Return a full record row with XLOOKUP
Detect whether text contains a keyword
Sum a dynamically sized range with OFFSET
Reference a cell address stored as text
Build a frequency distribution array
Return the regression slope with INDEX+LINEST
Return selected rows from a range
Return the first N rows of a spill range
Drop the first row from a range
Stack two ranges vertically
Return text before a delimiter
Return text after a delimiter
Wrap a list into multiple columns
Sort a table by a helper column
Convert an array to a text representation
Force a value into text
Return the ISO week number of a date
Sum with text and numeric criteria together
Fallback across two lookup tables
Compute simple return from price pairs
Generate a 2x3 grid of random integers 1-10
Convert TRUE/FALSE to 1/0 with N
Return Excel type codes for a value
Display another cell formula as text
Count areas in a multiple-area reference
Combine SUM and IF for cube-like slice totals
Test whether text matches a pattern (365)
Filter rows using AND logic across columns
Create an inline LAMBDA and call it
Apply a calculation to each array element