Upgrade to remove ads
SIMNet Final Exam - Excel 2016
Terms in this set (100)
#DIV/0 is an example of a worksheet _______ that can display in a cell.
If you move a named cell, the name updates with the new cell location automatically.
When you type text in a cell, the text will appear to continue to the __________ as far as it can until there is another cell that contains data.
To make changes to grouped sheets, just make the change in one sheet and this same change will be made to the same cell in all sheets in the group.
The Decrease Decimal button permanently deletes decimal places from the number entered into the cell.
Excel includes a special group of functions to modify text.
When you change a name, Excel automatically updates the name in any formula that references that name.
To move or copy more than one non-consecutive worksheet, press _______ on the keyboard and click the worksheets you want to copy or move.
The VLOOKUP function finds a value or cell reference in a cell range and returns another value from the same row.
A _______ is a special report view that summarizes data and calculates the intersecting totals.
If you want more of your worksheet columns to fit on a printed page, change the orientation to Portrait.
The Format Painter is located on the Home tab in the _______ group.
To remove the contents of a cell without removing the cell from the worksheet, use one of the Clear commands.
A _______ is text that appears at the top of every page.
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 ___________________________.
Order of operations
Excel''s _______ function lets you enter a desired value (outcome) for a formula and specify an input cell that can be modified in order to reach that goal.
If you select an entire column and then click the Insert button, Excel will automatically insert a _______.
A two-variable data table works the same way as a one-variable data table, using inputs for both a column and a row variable.
A(n) __________ reference is a cell reference that adjusts to the new location in the worksheet when the formula is copied.
You can arrange workbooks to view several at the same time.
The Fill Handle tool is located at top left of the selected cell.
To add emphasis to a pie chart slice, you can "explode" a single slice by clicking it and dragging it away from the rest of the slices.
When a filter has been applied to a column, the column header will display an arrow.
For the Subtotal command to work properly, you must sort the rows into order by the first column.
To define more than one print area, you need to hold down the _______ key after selecting the first print area and drag across the cells to include in the second print area.
Names assigned to cells act as a list of _______ to the cell locations.
One of the most useful financial functions in Excel is the _______ function, which you can use to calculate loan payments.
Cells that include potential errors are marked with a green _______.
In addition to finding and replacing data you can also use the Find and Replace commands to find and replace _______.
When a new sheet is added in Excel the default name used is _______ plus the next number available.
Which of the following functions can be inserted by the Subtotal command?
All of the above (SUM, MIN&MAX, AVERAGE)
Excel displays a _______ to help you resolve errors.
When you _______ the top row or the left column, you can keep column headings and row labels visible as you scroll through your data.
When you select a cell that contains a formula, the formula bar displays the ____________.
A _______ is a graphic representation of a PivotTable.
After selecting the Insert Sheet Rows option, the new row will appear below the selected cell.
The Count function counts the number of cells that contain numbers within a specified range of cells.
When you first type numbers in a worksheet, Excel applies the General number format automatically.
You can unmerge a merged cell back into its original cells, but you cannot split a single cell into two new columns or two new rows.
Sorting works the same whether or not the data have been formatted as a table.
A _______ style is a combination of effects that can be applied at one time to a cell.
When you delete a column, the columns to the right of the deleted column will shift _______.
If a cell contains text data, Excel displays a series of # symbols when the cell is too narrow to display the entire text.
The chart _______ provides a key so you know which data point or data series is represented by each color in the chart.
You can remove conditional formatting from cells by clearing the data.
The left side of the Formula Bar displays which mode you are in, such as Ready or Edit.
To remove the contents of a cell without removing the cell from the structure of your workbook, use one of the _______ commands.
To make a column automatically fit the contents, double-click the right column boundary.
In Excel, in Normal View, both headers and footers can be viewed.
_______ display a color bar (gradient or solid) representing the cell value in comparison to other values.
Names for cell ranges can contain spaces.
When you enter a formula in a table, you can reference column names by enclosing the column header text in brackets.
Conditional formatting provides a visual analysis of data by applying formatting to cells based on their values.
Cell references like A4 and B34 provide much information about the data contained in the cell.
When you first create a chart, Excel places the chart in a new worksheet.
When you click the AutoSum button, Excel automatically inserts a formula with the SUM function, using the range of mostly likely cells based on the structure of your worksheet.
_______ applies a fill color to alternating rows or columns, making the table easier to read.
The Redo command allows you to reverse the Undo command and restore the file to its previous state.
The table that can be added below a chart is known as a data table.
If a cell contains text data, Excel displays a series of pound signs (#) when the cell is too narrow to display the entire text.
If you add another row to your worksheet, Excel automatically adjusts the references in affected formulas to reflect the change.
By default, gridlines are visible on-screen when you are working in Excel but they do not print.
You can _______ cells to create a header cell across multiple columns of data or center a title across your worksheet.
Zooming a worksheet will affect how the worksheet appears when it prints.
Use the _______________ feature to fill a group of cells with the same data or to extend a data series.
A _______ is text that appears at the bottom of every page.
To use Edit mode to change text, ________ the cell you want to change.
The ___________ displays the address of the selected cell and can be used to navigate to a specific cell in the worksheet by typing the cell address.
Line charts feature a line connecting each data point which shows movement of values over time and work best when data trends over time are important.
Most functions require you to provide input called the:
In the IF function, the Logical_test argument always includes a _______ operator.
Deleting cells deletes the information in the cell but does not shift the layout of the worksheet.
A cell style can include formatting such as borders, fill color, font size, and number formatting.
When you insert new cells, the cells will use the same formatting as the cells either above, if you shifted down, or to the left, if you shifted right.
In Excel, you cannot view all of the formulas in your worksheet at one time.
To move or copy more than one consecutive worksheet, press _______ on the keyboard and click the worksheets you want to move or copy.
In column charts, Excel uses column labels as the categories along the horizontal (x) axis.
If you do not want to print an entire worksheet you can set a _______, which is a range of cells that you designate as the default print selection.
In Excel you can split the worksheet view into _______ or _______ panes.
Use the _______ tool to copy formatting from one part of your worksheet to another, rather than trying to recreate the exact combination of font color and size, number formatting, borders, and shading to reuse.
Cell references are limited to cells within the same worksheet.
Cells formatted as dates can be used in calculations.
To enter a formula, the first step after selecting the cell is to enter a ________.
The _______ lists all the named ranges used in your workbook.
Alignment refers to how text and numbers are positioned within the cell both horizontally and vertically.
To concatenate means to _______ items such as when you combine the text values of cells in Excel.
PivotTables do not contain any data themselves¿they summarize data from a range or a table in another part of your workbook.
If you have a large table, it may be difficult to identify rows with duplicate data. Excel includes a tool to find and remove duplicate rows in a spreadsheet.
Viewing a worksheet in _______ shows all the worksheet elements as they will print.
Page Layout view
Every function can be entered using its Function Arguments dialog and the dialog is different for each function.
A _______ is the cell containing a formula that references the value or formula in the selected cell.
When printing a worksheet, you always need to print the entire worksheet.
Tracer arrows usually appear in the worksheet in the color _______.
Data tables provide a quick what-if analysis of the effect of changing one or two variables within a formula.
When you add data to the right of the table, Excel includes the new _______ in the table automatically.
_______ display data values for each data marker.
Although you can move a worksheet around the current workbook, you cannot move it to a different workbook.
If you type a $ before a number, Excel automatically applies the ___________ number format.
A function's arguments can include cell references.
_______ rearranges the rows in your worksheet by the data in a column or columns.
YOU MIGHT ALSO LIKE...
Chapter 1: Creating a Worksheet and Charting Data
BCIS EXAM #2 EXCEL
OTHER SETS BY THIS CREATOR
CSC60 - StandardIO Assignment
CSC60 - Pointer Assignment
CSC60 - Quiz on Arrays
CSC60 - Quiz on Control Structures
OTHER QUIZLET SETS
Fluid and Electrolites (2)
Freshmen Grammar Test