Exam 2: Microsoft Excel Basics

Case EX 11-1 Venecia is using a worksheet to track her spending each month. So far the worksheet has the information for January up to August. Finding the ____ would give Venecia the total for all the data in the worksheet.

Formatting where the rows and columns of a table appear in different formats is referred to as ____.

If you click a cell that has a SUM function and then click the Trace Precedents button, an arrow called a(n) ____ is drawn to the cell with the SUM function.

Three types of cell references are used in formulas that do NOT include ____.

When a file is protected , several people can make changes to the workbook at the same time.

The Circle Invalid Data feature helps you ensure that valid data is entered into a worksheet.

To access the Format dialog box, select the chart you want to edit. Then, on the Format tab under Chart Tools on the Ribbon, in the Current Selection group, click the ____ button.

Worksheet formulas consist of two components: ____________________ and operators.

Number fills change the way data looks in a cell.

To change fonts and sizes, you must first select the cells you want to change. Then, on the Home tab of the Ribbon, in the ____ group, click the arrow next to the Font box to display a gallery of available fonts.

You can count cells that have text with the COUNT function.

____ refer to cells that supply the values used in a function.

The Switch Row/Column button is found on the ____ tab.

Case EX 6-2 Harry has inserted a picture into his Excel worksheet and wants to make some adjustments. Harry wants to adjust the brightness and contrast. He accesses the Format contextual tab and uses the tools in the ____ group to change the brightness and contrast.

You can split the worksheet window into horizontal or vertical panes, but not both.

Case EX 7-1 Kristin wants to arrange multiple workbooks in a way where she can compare figures. Kristin wants to access the Arrange Windows dialog box. She clicks the ____ tab on the Ribbon, and then in the Window group, clicks the Arrange All button.

To protect your Excel data from unwanted changes, you can add ____ protection to worksheets and workbooks.