Exam 2: Microsoft Excel Basics

The ____________________(logical) function returns a value of TRUE if the argument is false, and FALSE if the argument is true;

You can add formulas to a worksheet that instantly calculate totals within the worksheet data using Excel's ____ feature.

Excel offers quite a variety of table sizes in the Table Format gallery.

To make a workbook active, just click ____.

The ____________________ calculation lists how many of the selected cells contain numbers.

To make all formulas visible, click the Formulas tab on the Ribbon, and then click the Show Formulas button in the ____ group.

The cell in the worksheet in which you can type data is called the open cell.

Formats are composed of ____.

You can pull one or more slices away from the pie to distinguish them, creating what is called a(n) ____________________ pie chart.

You can copy and paste formats from one label to another using the Format ____ feature.

A(n) ____ is a digital photograph or other image file.

To display data or formula results from one worksheet in another worksheet of the same workbook, you use a(n) ____________________ with a reference to another worksheet.

If someone tries to open a password-protected workbook, he or she will first be prompted to enter the ____ in a dialog box.

If the next cell already contains data, any text that does not fit in the cell is ____________________, or hidden from view.

You can use the Ribbon to select chart elements. Click the Format tab or the ____ tab on the Ribbon. In the Current Selection group, click the arrow next to the Chart Elements box.

You can choose a style for the slicer on the ____________________ tab.

Date and time functions can be used to convert serial numbers to a ____.

The Format Painter button is found on the Clipboard group on the ____ tab.