Microsoft Excel Exam MO-210
(Microsoft 365) test questions
and answers
How do you insert multiple rows/columns at once? - answer
Highlight where you want new rows/columns to be.
Home tab --> Insert --> Row/Column
What is =RANDBETWEEN( )?
How do you format the function? - answer random number
generator between two numbers (X, Y)
=RANDBETWEEN(x,y)
What is =SEQUENCE( )?
How do you format the function? - answer 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? -
answer =[sheetname]![name of defined range]
What is =ROWS( )? - answer returns the number of rows of a
reference
, What is =COLUMNS( )? - answer returns the number of columns of a
reference
How do you convert a table to a cell range?
Why would you do this? - answer Table Design tab --> Convert to
Range
Maintain same formatting without table functionality
How do you insert a "Total Row" in a table? - answer Table Design
tab --> Click "Total Row"
What is a relative reference? Give an example with SUM. - answer
the return value changes based on where the cell/value moved.
=SUM(A1:A5)
What is an absolute reference? Give an example with SUM. - answer
the return value remains the same even if the cell/formula moves.
=SUM($A$1:$A$5)
What is a mixed reference? - answer 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? - answer a formula that
uses table and column defined names [i.e. =ROWS(phones), where
phones is the structured reference]
What is =AVERAGE( )?
(Microsoft 365) test questions
and answers
How do you insert multiple rows/columns at once? - answer
Highlight where you want new rows/columns to be.
Home tab --> Insert --> Row/Column
What is =RANDBETWEEN( )?
How do you format the function? - answer random number
generator between two numbers (X, Y)
=RANDBETWEEN(x,y)
What is =SEQUENCE( )?
How do you format the function? - answer 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? -
answer =[sheetname]![name of defined range]
What is =ROWS( )? - answer returns the number of rows of a
reference
, What is =COLUMNS( )? - answer returns the number of columns of a
reference
How do you convert a table to a cell range?
Why would you do this? - answer Table Design tab --> Convert to
Range
Maintain same formatting without table functionality
How do you insert a "Total Row" in a table? - answer Table Design
tab --> Click "Total Row"
What is a relative reference? Give an example with SUM. - answer
the return value changes based on where the cell/value moved.
=SUM(A1:A5)
What is an absolute reference? Give an example with SUM. - answer
the return value remains the same even if the cell/formula moves.
=SUM($A$1:$A$5)
What is a mixed reference? - answer 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? - answer a formula that
uses table and column defined names [i.e. =ROWS(phones), where
phones is the structured reference]
What is =AVERAGE( )?
