MS Excel Vocab 1

What is an Absolute Reference in Excel?

• A reference that changes when a formula is copied to another cell.

• A reference that remains constant, even when copied or moved.

• A reference that only applies to a single worksheet.

• A reference that automatically updates based on data changes.

Which function in Excel returns true only if all specified conditions are met?

• OR Function

• AND Function

• IF Function

• NOT Function

What does the Autofill feature in Excel do?

• It automatically saves your work at regular intervals.

• It fills cells with patterned values automatically.

• It formats cells based on user-defined conditions.

• It validates data entered into cells.

Which function calculates the average of numbers in a range based on multiple criteria?

• AVERAGE Function

• SUMIFS Function

• AVERAGEIFS Function

• COUNTIFS Function

What is a Cell Style in Excel?

• A tool to create charts and graphs.

• An option to format a cell to a user-defined format.

• A function to calculate averages.

• A feature to validate data entry.

What is a Common Delimiter used for in Excel?

• To separate text into different fields during import.

• To calculate the sum of a range of cells.

• To format cells based on conditions.

• To create a dual-axis chart.

What does Conditional Formatting allow you to do in Excel?

• Format data based on user-defined conditions.

• Automatically fill cells with data.

• Validate data entry.

• Create pivot tables.

Which function counts the number of cells that meet one or more criteria?

• COUNT Function

• COUNTIF Function

• COUNTIFS Function

• COUNTA Function

What are Cube Functions used for in Excel?

• To create 3D charts.

• To access data from an analysis services data source.

• To calculate financial metrics.

• To validate data entry.

What is a Chart Trendline used for in Excel?

• To create a dual-axis chart.

• To show data trends or moving averages in a chart.

• To format cells based on conditions.

• To validate data entry.