Microsoft Excel Exam MO-210 (Microsoft
365) with correct answers 100% 2026
How do you insert multiple rows/columns at once? - Correct Answers Highlight where you want
new rows/columns to be.
Home tab --> Insert --> Row/Column
What is =RANDBETWEEN( )?
How do you format the function? - Correct Answers random number generator between two
numbers (X, Y)
=RANDBETWEEN(x,y)
What is =SEQUENCE( )?
How do you format the function? - Correct Answers produces a sequence of numbers in a row x
column format
=SEQUENCE (# of rows, # of columns, start #, increment)
How do you reference a named range from another worksheet? - Correct Answers
=[sheetname]![name of defined range]
What is =ROWS( )? - Correct Answers returns the number of rows of a reference
What is =COLUMNS( )? - Correct Answers returns the number of columns of a reference
, How do you convert a table to a cell range?
Why would you do this? - Correct Answers Table Design tab --> Convert to Range
Maintain same formatting without table functionality
How do you insert a "Total Row" in a table? - Correct Answers Table Design tab --> Click "Total
Row"
What is a relative reference? Give an example with SUM. - Correct Answers the return value
changes based on where the cell/value moved. =SUM(A1:A5)
What is an absolute reference? Give an example with SUM. - Correct Answers the return value
remains the same even if the cell/formula moves. =SUM($A$1:$A$5)
What is a mixed reference? - Correct Answers A reference where either the row or the column is
fixed, while the other part is relative.
A mixed reference is indicated by a dollar sign ($) before either the column or the row, but not
both.
What is a structured reference formula? - Correct Answers a formula that uses table and column
defined names [i.e. =ROWS(phones), where phones is the structured reference]
What is =AVERAGE( )?
How do you format the function? - Correct Answers Finds the mean of value range
What is =MAX( )?
365) with correct answers 100% 2026
How do you insert multiple rows/columns at once? - Correct Answers Highlight where you want
new rows/columns to be.
Home tab --> Insert --> Row/Column
What is =RANDBETWEEN( )?
How do you format the function? - Correct Answers random number generator between two
numbers (X, Y)
=RANDBETWEEN(x,y)
What is =SEQUENCE( )?
How do you format the function? - Correct Answers produces a sequence of numbers in a row x
column format
=SEQUENCE (# of rows, # of columns, start #, increment)
How do you reference a named range from another worksheet? - Correct Answers
=[sheetname]![name of defined range]
What is =ROWS( )? - Correct Answers returns the number of rows of a reference
What is =COLUMNS( )? - Correct Answers returns the number of columns of a reference
, How do you convert a table to a cell range?
Why would you do this? - Correct Answers Table Design tab --> Convert to Range
Maintain same formatting without table functionality
How do you insert a "Total Row" in a table? - Correct Answers Table Design tab --> Click "Total
Row"
What is a relative reference? Give an example with SUM. - Correct Answers the return value
changes based on where the cell/value moved. =SUM(A1:A5)
What is an absolute reference? Give an example with SUM. - Correct Answers the return value
remains the same even if the cell/formula moves. =SUM($A$1:$A$5)
What is a mixed reference? - Correct Answers A reference where either the row or the column is
fixed, while the other part is relative.
A mixed reference is indicated by a dollar sign ($) before either the column or the row, but not
both.
What is a structured reference formula? - Correct Answers a formula that uses table and column
defined names [i.e. =ROWS(phones), where phones is the structured reference]
What is =AVERAGE( )?
How do you format the function? - Correct Answers Finds the mean of value range
What is =MAX( )?
