MS Excel Vocab 4

What does the SUMIF function do in Excel?

• It multiplies all numbers in a range of cells based on criteria.

• It adds all numbers in a range of cells based on criteria.

• It subtracts all numbers in a range of cells based on criteria.

• It divides all numbers in a range of cells based on criteria.

Which function returns the current system date in Excel?

• NOW Function

• DATE Function

• TODAY Function

• CURRENT Function

What is the purpose of a template in Excel?

• To create a workbook with random styles and themes.

• To create a workbook from a preset workbook with defined styles, themes, colors, and fonts.

• To create a workbook with no predefined styles.

• To create a workbook with only default Excel styles.

What does the Trace Dependence tool do in Excel?

• It finds cells that contain formulas referring to other cells.

• It finds cells that are referred to by a formula in another cell.

• It finds cells that are independent of any formulas.

• It finds cells that contain errors.

What is the function of the VLOOKUP function in Excel?

• It performs a horizontal lookup by searching for a value in the first row.

• It performs a vertical lookup by searching for a value in the first column.

• It performs a diagonal lookup by searching for a value in the first cell.

• It performs a circular lookup by searching for a value in the entire table.

What does the Watch Window tool allow you to do in Excel?

• It allows you to watch videos within Excel.

• It allows you to inspect, audit, or confirm formula calculations and results.

• It allows you to view only the first cell of a worksheet.

• It allows you to hide all formulas in a worksheet.

What is Workbook Protection used for in Excel?

• To protect the content of individual cells.

• To protect the structure of the entire workbook from being changed.

• To protect the formatting of a single worksheet.

• To protect the workbook from being opened.

What does Worksheet Protect allow you to do in Excel?

• It allows you to protect the entire workbook with a password.

• It allows you to configure protection settings on an entire worksheet with a password.

• It allows you to protect only the formulas in a worksheet.

• It allows you to protect the worksheet from being printed.

What is the function of the Wrap Text feature in Excel?

• It hides text that goes beyond the cell width.

• It moves text that goes beyond the cell width to a second line, so all text is visible.

• It deletes text that goes beyond the cell width.

• It changes the text color to fit the cell width.

What does the Trace Precedence tool do in Excel?

• It finds cells that contain errors.

• It finds cells that are referred to by a formula in another cell.

• It finds cells that are independent of any formulas.

• It finds cells that contain text only.