H. Microsoft Excel Teacher-made Exam 2024-2025

Conditional formatting changes the of designated cells based on criteria.

• content

• Formulas

• appearance
• relationship

What tools allow you to outline your data?

• group

• sum

• total

• aggregate

What formulas can you NOT use to change the case of text?

• UPPER()

• SENTENCE()

• LOWER()

• PROPER()

If you add seven days to an existing date that was a Monday, using the WORKDAY function, and within those seven days, there's one national holiday, what is the resulting day of the week?

• Monday

• Wednesday

• Thursday

• Tuesday

If you configure Excel to update formulas manually, which of the following methods can you use to update the formulas in a whole workbook?

• Select Shift + F9

• Select F6

• Select F9

• Select the Formulas tab, and then select Calculate Sheet

The MATCH function returns the of the value you want to find within a list.

• position
• answer

• number

• value

An exponential increase in a series of numbers is known as a trend.

• growth
• time

• linear

• date

Use the Fill Series command to fill a series, Growth series, Date series, or AutoFill

• linear
• formula

• time

• function

When you trace dependents, arrows will indicate which cells affect the value of the selected cell's current value. When you trace precedent cells, arrow will display to indicate which cells are affected by the current cell.

• True

• False

Which of these functions are helpful for payment analysis?

• RANK

• YEAR

• PMT

• SUM