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.