IDONTASSOCCIATE

Formula

A ________ is an equation used to calculate a value.

Font

A __________ refers to a set of characters of a certain design.

Slicer

A ___________ is a visual representation of filtering options.

Data table

A _____________ displays a table of the data point values below the chart.

Template

A ________________ is a file with predefined settings that you can use a starting point for your workbook.

=TODAY()

A formula using the Today function looks like.

Range of cells

A named range refers to a ______________ in your formula.

Chart

A(n) ___________ is a graphic that transforms numerical data into a more visual representation.

PivotChart

A(n) _____________ is a graphic representation of a PivotTable.

Cell

A(n) ______________ is the intersection of a column and a row.

Mixed

A(n) ______________ reference is a combination cell reference with a row position that stays constant with a changing column position (or vice versa).

Relative

A(n) _______________ reference is a cell reference that adjusts to the new location in the worksheet when the formula is copied.

Error

#DIV is an example of a worksheet ____________ that can display in a cell.

One million

An Excel 2013 worksheet can include more than ____________ rows of data.

=CONCATENATE(B2,¿ ¿,A2)

An example of a valid concatenate formula is ____________________.

=NOW()

An example of the NOW function is:

Enter

Another method to enter a formula, you can click the ___________ button to the left of the formula bar.

]

Another way to change the cell reference type is to select the cell reference in the formal bar, and then press F4 to cycle through the various reference types

table

Certain data analysis tools, including creating subtotals and grouping outlines, are not available if data are formatted as an Excel ___________.

Format

Click AutoFit Row Height from the _________ button in the Cells group of the Home tab to autofit a row.

Top/Bottom Rules

Conditional formatting using ____________ when analyzing a worksheet you may want to highlight the highest or lowest values or values that are above or below the average.

Worksheet

Electronic ledger in which you enter data

Message Bar

Files that are opened in Protected View display a warning in the _________________ at the top of the window, below the Ribbon.

column; row

If your worksheet includes a large table of data that prints on more than one page, you should ensure that the ___________ or ___________ labels print on every page.

Labels

If your worksheet is organized in a table format, with column or row labels, you can automatically create names ranges using the ___________ as names.

Table

In Excel you can define a series of adjacent cells as a _________.

Row Labels

In a PivotTable, Excel will place fields with numeric data in the Values area and text fields in the _________ area.

Data Markers

In a chart, the values selected in the worksheet, the data points, are transformed into graphic ____________.

Exploded

In a(n) "____________" pie chart, each slice is slightly separated from the whole.

Formatting

In addition to finding and replacing data you can also use the commands to find and replace _____________.

Shortcuts

Names assigned to cells act as a list of ___________ to the cell locations.

Unique

Names created in a worksheet need to be ____________ within their scopes.

Tab

Pressing ________ on the keyboard after entering text will move the cursor to the right one cell.

Text

Text wrapping feature only works for cells that contain ___________.

View

The Freeze Panes button is located in the Window group on the ________ tab.

Different

The Function Arguments dialog is _____________ for each function.

Numerical

The IF function can return either a ________value or display a text string.

Update

The NOW and TODAY functions are termed volatile, in that they ___________ the current date or date and time each time that the workbook is opened.

date

The TODAY function inserts only the current __________ into your Excel worksheet.

Text

The Title style is used to the title of a worksheet and is a __________ style.

Status Bar

The ___________ appears at the bottom of the worksheet grid and displays information about the selected data, including the number of cells selected that contain data and the average and sum of the selected values.

Chart Area

The ___________ is the area that encompasses the entire chart including the plot area and optional elements.

legend

The chart ____________ provides a key so you know which data series is represented by each color.

Ctrl+V

The keyboard shortcut for the Paste command is ___________.

To delete a

To delete a worksheet you can also right-click on a sheet tab and then select Delete from he shortcut menu.

Delete Sheet

To delete an unwanted version of a worksheet, select ____________ from the Delete menu.

To re

To remove all the manual page break at once, on the Page Layout tab, in the Page Setup group, click the Breaks button, and click Reset All Page Breaks.

False

True or False - Formulas begin with a dollar sign.

True

True or False - Regardless of the amount of work you put into a workbook, a spelling error or typo can make the entire workbook appear unprofessional or the data to be incorrect.

True

True or False - To change the type of data AutoFill inserts, click the AutoFill Options button that appears after using the Fill Handle tool.

False

True or False - When you merge cells together, Excel will keep only data in the rightmost cell.

Order of Operations

When you enter a formula with more than one mathematical operation, the formula is not necessarily calculated left to right as Excel calculations follow the mathematical rules called the ________________.

Yo

You can also open Zoom dialog by clicking the zoom level number that appears at the right side of the zoom slider.

Mini

You can right-click the Format Painter to activate it on the ______________ toolbar.

Alignment

_______________ refers to how text and numbers are positioned with the cell both horizontally and vertically.

Clear All

_________________ clears all cell contents and formatting and deletes any comments or hyperlinks attached to the cell.

Name Box

displays the address of the selected cell. If a group of cells is selected, the name box displays the address of the first cell in the group.