Microsoft Excel 2019 Advanced Vocabulary Assessment

What is an absolute cell reference in Excel?

• A cell reference that changes when copied

• A reference that includes dollar signs and doesn't change when copied

• A reference that combines both relative and absolute elements

• A cell reference based on relative position

Which Excel feature automatically updates a web page when changes are saved?

• AutoSave

• Data Form

• AutoRepublish

• Auto Update

What is the primary purpose of buttons in Excel?

• To display date and time

• To run macros for specific actions

• To show cell references

• To create formulas

What is a data form used for in Excel?

• To create new worksheets

• To format cells automatically

• To enter one complete row of information without horizontal scrolling

• To design custom buttons

Which term describes tests that evaluate whether conditions are true or false?

• Data Source

• Conditional Formulas

• Arguments

• Mixed References

What is a sparkline in Excel?

• A. A type of button control

• B. A formula calculation

• C. A tiny chart within a worksheet cell

• D. A cell reference type

What is the function of check boxes in Excel?

• To increase or decrease values

• To toggle a value on or off

• To display multiple options

• To group related controls

How are group boxes utilized in Excel?

• To organize related controls visually

• To create new worksheets

• To format cells automatically

• To design custom buttons

What is a pivot table used for?

• To store date and time data

• To create visual representations

• To analyze and explore data

• To format text entries

What defines a mixed cell reference?

• A. A combination of text and numbers

• B. A combination of relative and absolute references

• C. A reference that only uses dollar signs

• D. A reference that changes when copied