The ____ criteria filter requires the records displayed to have the current date.

The ____ dialog box provides options for moving charts between worksheets and chart sheets.

The ____ function is useful when you want to assign a value to a cell based on a logical test.

The _____ error value means that a value is not available to a function or formula.

The ________ displays the current cell mode, the page number, and the zoom buttons.

The ________ group on the design tab is useful for adjusting the data source of a chart.

Cell A1 contains 'Chang', and cell A2 contains 'Pie'. What is the result of the formula: =CONCATENATE(A1,' ','and',' ',A2)

How do you debug a formula by looking at each part of the formula individually?

Cell A1 has the number '3' in it. Cell A2 has the value '5' in it. If you merge these two cells together, what is left in the merged cell?

What function would you use to extract a portion of a text string from the center of the string?

A 'frequency distribution' is a summary table that shows the frequency of each value in a ___?