Microsoft Excel 2019 Advanced Vocabulary Assessment

Front

What is an absolute cell reference in Excel?

Back

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

Front

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

Back

AutoRepublish

Front

What is the primary purpose of buttons in Excel?

Back

To run macros for specific actions

Front

What is a data form used for in Excel?

Back

To enter one complete row of information without horizontal scrolling

Front

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

Back

Conditional Formulas

Front

What is a sparkline in Excel?

Back

A tiny chart within a worksheet cell

Front

What is the function of check boxes in Excel?

Back

To toggle a value on or off

Front

How are group boxes utilized in Excel?

Back

To organize related controls visually

Front

What is a pivot table used for?

Back

To analyze and explore data

Front

What defines a mixed cell reference?

Back

A combination of relative and absolute references.