Excel Functions Quiz

What Excel feature is used to create a relationship between two tables based on a common column?

What function in Excel is used to find and correct errors in formulas?

• Error Check

• Formula Auditing

• Error Trace

• Error Correction

Which Excel feature is used to combine the contents of two or more cells into one cell?

• Merge and Center

• Paste Special

• Consolidate

• Concatenate

What function in Excel is used to split a single cell into multiple cells based on a delimiter?

• Text to Columns

• Concatenate

• Split Cells

• Merge Cells

What Excel feature is used to quickly add up a range of cells?

• AutoSum

• Summarize

• Aggregate

• Calculate

Which Excel function is used to round a number to a specified number of decimal places?

• Roundup

• Rounddown

• Round

• Approximate

What feature in Excel is used to visually represent data using charts and graphs?

• Data Visualization

• Graphical Analysis

• Chart Wizard

• Visualize Data

What Excel function is used to find the largest number in a range of cells?

• Max

• Largest

• Maximum

• Biggest

Which Excel feature is used to apply a specific format to a cell based on its value?

• Conditional Formatting

• Format Painter

• Cell Styling

• Value Formatting

What function in Excel is used to count the number of cells in a range that meet a certain condition?

• Countif

• Sumif

• Conditional Count

• Range Count