Exam 14: Advanced Spreadsheets for Planning

Filtering applies only to spreadsheets that have column ________ .

The advanced filtering technique that allows you to select two criteria where either one or both can be present, you choose the ________ option .

In a spreadsheet conditional formatting allows you to specify a particular format for cells that meet certain criteria .

Select all that apply . The Advanced Filter feature includes a

A named alternative to a spreadsheet using different inputs is a

The first thing to focus on when setting up an effective spreadsheet is

To control how contents display in spreadsheet cells based on the values stored in the cells, you can use ________ formatting .

The function that returns the specified number of characters from the start of a text string is

The advanced filtering technique that allows you to select two criteria where both must be present, you choose the ________ option .

In a spreadsheet, a ________ is a word or phrase assigned to a cell or range of cells .

Select all that apply . The IF function specifies

Flexibility is an important characteristic of a spreadsheet .

To make the entire computation of a cell contingent on the outcome of a condition, you can use ________ formulas .