MO-201: Microsoft Excel Expert Exam
Review with correct answers 100% 2026
Automatic Formula Calculation - Correct Answers Default Calculation mode; excel immediately
calculates values
once they are entered
Automatic Except for Data Tables - Correct Answers This is a good choice for worksheets that
include one or more
massive data tables that are slowing down re-calculation
Manual - Correct Answers Excel will not automatically calculate any entries unless you
manually calculate the sheet or save the workbook
Iterations - Correct Answers How many calculations that Excel will carry out until
solved or stops calculating. To change this setting click on FILE then
OPTIONS then FORMULAS
Add an authoring language - Correct Answers file, options, language, add a language
Proofing in another language - Correct Answers file, options, proofing, custom dictionaries
Linear Fill Series - Correct Answers finds the next series value by adding or subtracting a
constant step value to the previous cell (e.g. 1, 3, 5, 7; step value = 2)
Growth - Correct Answers finds the next series value by multiplying the preceding
value by the step value (e.g. 1, 1⁄3, 1/9... step value = 1⁄3)
, Date - Correct Answers creates a series based on the options you select in the Date
Unit group
Autofill - Correct Answers works a lot like the fill handle by extending a numeric
pattern or a text series (e.g. Quarter1, Quarter2, Quarter3...)
Excel numeric syntax - Correct Answers positive format;negative format;zero format;text format
Three parts used (Excel numeric syntax) - Correct Answers positive format;negative format;zero
format
Two parts used (Excel numeric syntax) - Correct Answers positive and zero format;negative
format
One part used (Excel numeric syntax) - Correct Answers positive, negative, and zero format
# - Correct Answers Holds a place for a digit and displays the digit exactly
as typed. Displays nothing if no number is entered. For
example, if a cell's custom format is ### and you enter 25
in the cell, Excel displays 25.
0 - Correct Answers Holds a place for a digit and displays the digit exactly as
typed. Displays zero if no number is entered. For example,
if a cell's custom format is 000 and you enter 25 in the cell,
Excel displays 025.
Review with correct answers 100% 2026
Automatic Formula Calculation - Correct Answers Default Calculation mode; excel immediately
calculates values
once they are entered
Automatic Except for Data Tables - Correct Answers This is a good choice for worksheets that
include one or more
massive data tables that are slowing down re-calculation
Manual - Correct Answers Excel will not automatically calculate any entries unless you
manually calculate the sheet or save the workbook
Iterations - Correct Answers How many calculations that Excel will carry out until
solved or stops calculating. To change this setting click on FILE then
OPTIONS then FORMULAS
Add an authoring language - Correct Answers file, options, language, add a language
Proofing in another language - Correct Answers file, options, proofing, custom dictionaries
Linear Fill Series - Correct Answers finds the next series value by adding or subtracting a
constant step value to the previous cell (e.g. 1, 3, 5, 7; step value = 2)
Growth - Correct Answers finds the next series value by multiplying the preceding
value by the step value (e.g. 1, 1⁄3, 1/9... step value = 1⁄3)
, Date - Correct Answers creates a series based on the options you select in the Date
Unit group
Autofill - Correct Answers works a lot like the fill handle by extending a numeric
pattern or a text series (e.g. Quarter1, Quarter2, Quarter3...)
Excel numeric syntax - Correct Answers positive format;negative format;zero format;text format
Three parts used (Excel numeric syntax) - Correct Answers positive format;negative format;zero
format
Two parts used (Excel numeric syntax) - Correct Answers positive and zero format;negative
format
One part used (Excel numeric syntax) - Correct Answers positive, negative, and zero format
# - Correct Answers Holds a place for a digit and displays the digit exactly
as typed. Displays nothing if no number is entered. For
example, if a cell's custom format is ### and you enter 25
in the cell, Excel displays 25.
0 - Correct Answers Holds a place for a digit and displays the digit exactly as
typed. Displays zero if no number is entered. For example,
if a cell's custom format is 000 and you enter 25 in the cell,
Excel displays 025.
