Find study materials for any course. Check these out:
Browse by school
Make your own
To login with Google, please enable popups
To login with Google, please enable popups
Don’t have an account?
To signup with Google, please enable popups
To signup with Google, please enable popups
Sign up withor
_______ of a workbook displays the file name as well as the software name.
____ button on a worksheet appears as a triangle at the intersection of the row and column headings.
The ________ command is helpful for navigating to a cell that is not visible onscreen.
To display a different worksheet click the sheet ________ at the bottom of the workbook window.
A number that represents a quantity or amount is called a(n) ________.
A combination of cell references, arithmetic operations, values, and/or functions used in calculations is called a(n) ________.
For Excel to recognize a formula, it must start with a(n) ________ sign.
The order of ________ controls the sequence in which Excel does math.
You can copy the contents of a cell or a range of cells by dragging the ________.
Use ________ to complete a sequence in a worksheet such as January, February, March, and April.
The Show Formulas button is accessible from the ________ tab.
Click Format in the Cells group on the ________ tab to change the color of a worksheet tab.
Adjust the column ________ to accommodate the widest entry in a column.
If you select cells R45:S46 and T49:V53 you have selected a(n) ________ range.
Use the ________ to select a range by clicking in it and typing a range address, and then pressing Enter.
When you've selected and subsequently cut the range, it is copied to the ________.
If you enter data into a worksheet and decide you want the columns and rows reversed, you can click the Paste arrow, and then click ________.
________ refers to how data are positioned in cells.
The default number format in Excel 2013 is ________.
The ________ format includes an optional dollar sign placed immediately to the left of a number.
The ________ feature on in Page Setup displays a list to set or clear a print area on a worksheet.
The ________ view displays print options and displays a worksheet in print preview mode.
A relative cell ________ indicates a cell's relative location.
The ________ key toggles between relative, absolute, and mixed references.
A(n) ________ cell reference provides a permanent reference to a specific cell.
If a formula contains a reference to the cell containing a formula, a(n) ________ reference exists.
________ references usually cause inaccurate results.
The ________ function category performs tests and returns the value of the tests.
The ________ function category performs calculations such as averages and standard deviations.
Formula ________ displays a list of functions and defined names that match the letters that you start typing when creating a formula.
The ________ function totals the values in two or more cells and displays the result in the cell containing the function.
The ________ function finds the midpoint value of a list.
Excel provides three basic count functions: COUNT, COUNTA, and ________.
________ is a set of analytical tools to use to apply formatting, create charts, and insert basic functions.
A(n) ________ function occurs when one function is embedded as an argument within another function.
The =DATE(year,month,day) function returns a(n) ________ for a date.
The =________(serial_number) function displays the day within a given month for a date or its serial number.
The ________ function returns one value if a condition is true and another if a condition is false.
The IF function in Excel 2013 has ________ arguments.
The ________ test is an IF function that tests for a true or false of a condition.
The ________ is the lowest value in a category of a lookup table.
The ________ function calculates the periodic payment for a loan with interest.
The PMT function uses ________ required arguments and up to two optional arguments.
The first argument in a PMT function is the ________.
A range name can contain 255 characters and must begin with a(n) ________ or an underscore.
You can highlight a range and create a name for the range by clicking on the ________ tab.
A range name cannot include special characters or ________.
The ________ of a chart is the region containing the graphical representation of the values in a data series.
The ________ of a chart is a horizontal border that provides a frame of reference for measuring data horizontally.
The ________ of a chart is a key that identifies each data series of the chart.
A(n) ________ label is text that describes a collection of data points in a chart.
In Excel 2013, Excel displays the ________ button in the bottom-right corner of a highlighted range
A(n) ________ chart displays a proportion of individual data points to the sum of all points.
A(n) ________ chart displays values vertically where the height represents the value.
A(n) ________ column chart compares groups of columns set side by side for easy display.
A(n) ________ chart is a derivative of a scatter chart in which both axes are value axes.
________ are small white-filled squares that display when a chart is selected.
To move a chart from one sheet to another, click the ________ tab and click Move Chart.
A(n) ________ is a worksheet that contains only a chart
To print only a chart, select the chart, click the ________ tab, and click Print
Excel creates charts on the same worksheet as the original data set, but you can ________ the chart to its own chart sheet.
A default chart sheet is named ________.
A(n) ________ is a grid that contains the data source values and labels.
A(n) ________ is a key that identifies the color, gradient, picture, texture, or pattern assigned to each data series.
A(n) ________ is a line used to depict trends and forecast future data.
A chart ________ is the label that describes the entire chart; it should reflect the purpose of the chart.
When you hover the mouse pointer over a chart, Excel 2013 display a(n) ________ with the name of that chart element.
________ Styles add artistic style, text fill, and text effects to an object.
Applying a chart ________ allows you to change any number of formatting options such as the color of the chart area, the data, series, and the plot area.
A chart ________ controls which data series and categories are visible in a chart.
Sparklines can be created by clicking the ________ tab.
The ________ group on the Sparkline Tools Design tab allows you to change the selected sparkline type.
Function key ________ accesses the Go To command in Excel.
________ keeps rows and/or columns visible as you scroll through a worksheet.
To keep columns and/or rows on the screen and visible, use the Windows group on the View Tab , and then click ________ Panes.
In a worksheet, it is possible to ________ a manual page break to a new, desired location.
A page ________ indicates where data starts on a new printed page.
A(n) ________ defines the range of data from a worksheet to print.
Print ________ is the sequence in which pages of a workbook are printed.
A(n) ________ is an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis.
A(n) ________ is a space for an individual piece of data within a record, such as a street name.
Each ________ in an Excel table represents a record.
To create a(n) ________ from an existing range of data, click the Insert tab and then click Table in the Tables group.
To ________ a table into a range, click within the table, click the Table Tools Design tab, and from the Tools group, select Convert to Range.
Click the ________ tab and click Remove Duplicates to open the Remove Duplicates dialog box.
________ displays alternate fill colors for even and odd rows to help distinguish fields.
The ________ Table Style option applies a different format to the first column of a table so that the row headings stand out
The ________ Table Style option displays the field names of a table when checked.
________ arranges records in a table by the value in the field or fields within a table.
Sorting by ________ arranges data together for cells containing a particular fill or font color.
Filtering the Last_Name field to show only records that begin with the letter P is an application of a(n) ________ filter.
The use of field headings without row references in a structured formula is called a(n) ________ reference.
A(n) ________ structured reference is a structured formula that includes references, such as table numbers.
A(n) ________ row appears as the last row of a table to display summary statistics, such as a sum.
The calculations on a total row in a table use the ________ function.
A(n) ________ bar is a horizontal gradient or solid fill indicating the cell's relative value compared to other selected cells.
In addition to sorting and filtering cells by content, you can sort and/or filter by ________ formatting.
Sign up for free and study better.
Get started today!