1|Page
TPI FITNESS LEVEL 2 FINAL EXAM UPDATED
2026 EDITION | VERIFIED QUESTIONS & 100%
CORRECT ANSWERS | GUARANTEED PASS
1 As a visual guide to see the variation of values in a range, Excel provides each of
the following except
Choose one answer.
a. two-color scales.
b. three-color scales.
c. data bars.
d. animated graphics.
Page: Excel Level 2, page 14 - ANSWER: d. animated graphics.
2 Can you create your own conditional formatting rules? If so, how?
Choose one answer.
a. No; you must use Excel's predefined rules.
b. Yes; edit a predefined rule.
c. Yes; use the New Formatting Rule dialog box.
d. Yes; create a macro.
Page: Excel Level 2, page 8 - ANSWER: c. Yes; use the New Formatting Rule
dialog box.
,2|Page
3 Changing the appearance of a cell based on a condition is called
Choose one answer.
a. what-if formatting.
b. what-if cell analysis.
c. conditional formatting.
d. conditional analysis.
Page: Excel Level 2, page 6 - ANSWER: c. conditional formatting.
4 Conditional formats can be based on any of the following except
Choose one answer.
a. dates.
b. values in a range.
c. duplicated values.
d. formatting.
Page: Excel Level 2, page 6 - ANSWER: d. formatting.
5 Excel can add text such as GX- to the values you type in cells if the cells have
been formatted using the category.
Choose one answer.
a. Special
b. Text
c. Custom
,3|Page
d. General
Page: Excel Level 2, page 20 - ANSWER: c. Custom
6 Excel provides special number formats that are specific to which of the
following?
Choose one answer.
a. country and language
b. language and dialect
c. region and language
d. country and alphabet
Page: Excel Level 2, page 18 - ANSWER: a. country and language
7 How are numbers displayed when the format code is [Red];[Blue]?
Choose one answer.
a. Positive numbers are displayed in red; negative numbers in blue.
b. Positive numbers are displayed in blue; negative numbers in red.
c. Numbers to the left of the decimal point are displayed in red; numbers to the
right in blue.
d. Numbers to the left of the decimal point are displayed in blue; numbers to the
right in red.
Page: Excel Level 2, page 20 - ANSWER: a. Positive numbers are displayed in
red; negative numbers in blue.
, 4|Page
8 How can you format a cell based on the value in a different cell?
Choose one answer.
a. Use a formula.
b. Apply two conditional formatting rules.
c. Apply conditional formatting rules to both cells.
d. You cannot format a cell in this way.
Page: Excel Level 2, page 15 - ANSWER: a. Use a formula.
9 Icon sets allow you to
Choose one answer.
a. classify data into three to five categories.
b. create your own symbols.
c. modify the shapes of threshold symbols.
d. change the images that appear on Excel buttons.
Page: Excel Level 2, pages 12 and 13 - ANSWER: a. classify data into three to
five categories.
10 If the appropriate formatting has been applied, data can be filtered by all of the
following except
Choose one answer.
a. cell color.
TPI FITNESS LEVEL 2 FINAL EXAM UPDATED
2026 EDITION | VERIFIED QUESTIONS & 100%
CORRECT ANSWERS | GUARANTEED PASS
1 As a visual guide to see the variation of values in a range, Excel provides each of
the following except
Choose one answer.
a. two-color scales.
b. three-color scales.
c. data bars.
d. animated graphics.
Page: Excel Level 2, page 14 - ANSWER: d. animated graphics.
2 Can you create your own conditional formatting rules? If so, how?
Choose one answer.
a. No; you must use Excel's predefined rules.
b. Yes; edit a predefined rule.
c. Yes; use the New Formatting Rule dialog box.
d. Yes; create a macro.
Page: Excel Level 2, page 8 - ANSWER: c. Yes; use the New Formatting Rule
dialog box.
,2|Page
3 Changing the appearance of a cell based on a condition is called
Choose one answer.
a. what-if formatting.
b. what-if cell analysis.
c. conditional formatting.
d. conditional analysis.
Page: Excel Level 2, page 6 - ANSWER: c. conditional formatting.
4 Conditional formats can be based on any of the following except
Choose one answer.
a. dates.
b. values in a range.
c. duplicated values.
d. formatting.
Page: Excel Level 2, page 6 - ANSWER: d. formatting.
5 Excel can add text such as GX- to the values you type in cells if the cells have
been formatted using the category.
Choose one answer.
a. Special
b. Text
c. Custom
,3|Page
d. General
Page: Excel Level 2, page 20 - ANSWER: c. Custom
6 Excel provides special number formats that are specific to which of the
following?
Choose one answer.
a. country and language
b. language and dialect
c. region and language
d. country and alphabet
Page: Excel Level 2, page 18 - ANSWER: a. country and language
7 How are numbers displayed when the format code is [Red];[Blue]?
Choose one answer.
a. Positive numbers are displayed in red; negative numbers in blue.
b. Positive numbers are displayed in blue; negative numbers in red.
c. Numbers to the left of the decimal point are displayed in red; numbers to the
right in blue.
d. Numbers to the left of the decimal point are displayed in blue; numbers to the
right in red.
Page: Excel Level 2, page 20 - ANSWER: a. Positive numbers are displayed in
red; negative numbers in blue.
, 4|Page
8 How can you format a cell based on the value in a different cell?
Choose one answer.
a. Use a formula.
b. Apply two conditional formatting rules.
c. Apply conditional formatting rules to both cells.
d. You cannot format a cell in this way.
Page: Excel Level 2, page 15 - ANSWER: a. Use a formula.
9 Icon sets allow you to
Choose one answer.
a. classify data into three to five categories.
b. create your own symbols.
c. modify the shapes of threshold symbols.
d. change the images that appear on Excel buttons.
Page: Excel Level 2, pages 12 and 13 - ANSWER: a. classify data into three to
five categories.
10 If the appropriate formatting has been applied, data can be filtered by all of the
following except
Choose one answer.
a. cell color.
