MS Excel Vocab 2

What is the purpose of Form Controls in Excel?

• To perform complex calculations

• To format a worksheet to look like a form and limit user input

• To create charts and graphs

• To sort and filter data

Which tool allows you to copy the formatting of one cell and apply it to others?

• Format Painter

• Conditional Formatting

• Data Validation

• Cell Styles

What does the Formula Calculation option in Excel allow you to do?

• Automatically create charts

• Define whether Excel calculates formulas automatically or manually

• Format cells with colors

• Protect worksheets from editing

What is the function of Freeze Rows and Columns in Excel?

• To lock cells for editing

• To keep rows and/or columns visible while scrolling

• To sort data in ascending order

• To apply conditional formatting

What does the GETPIVOTDATA function do?

• Creates a new PivotTable

• Extracts data from specified fields in a PivotTable

• Sorts data in a worksheet

• Filters data in a table

Which tool helps you determine how input values must change to achieve a specific goal?

• Solver

• Goal Seek

• Data Table

• Scenario Manager

What does the HLOOKUP function do in Excel?

• Searches for a value in the first column of a table

• Searches for a value in the top row of a table and returns a value in the same column

• Searches for a value in the last row of a table

• Searches for a value in the last column of a table

What is the purpose of the INDEX function in Excel?

• To find the average of a range of cells

• To return a value or reference from within a table or range

• To count the number of cells in a range

• To sum up a range of cells

What is a Macro in Excel?

• A single formula that performs multiple calculations

• A set of keystrokes or commands recorded to execute multiple commands with one command

• A chart that displays data trends

• A function that returns the current date

What does the MATCH function do in Excel?

• Finds the maximum value in a range

• Searches for a specified item in a range and returns its relative position

• Matches text strings in a worksheet

• Finds the minimum value in a range