Excel-120
Insert Pictures window
Click the Online Pictures button in the Illustrations group on the INSERT tab and the _____ displays:
Click the Select All check box on the filtered column's drop-down list.
After you have filtered a table, what is one way to get Excel to once again display all the records?
the equals sign (=).
All formulas in Excel begin with
January 1, 1900
Dates in Excel are stored as a serial number starting with ____ as 1 and increasing sequentially.
templates
Excel contains worksheets that are preformatted and contain text and formulas designed for specific uses. These worksheets are called
functions.
Excel features built-in, preprogrammed formulas called
styles
Excel provides _____ so that you can easily create a professional, consistent worksheet appearance.
100
Excel stores up to ____ actions that can be undone or redone using buttons on the Quick Access toolbar.
a comma in the thousands place
Excel's Accounting format adds ____ to the value in the cell.
active cell.
Excel's Spell Check feature begins checking at the
at the New backstage area
The options for choosing a template are available
worksheet area.
The portion of the Excel screen containing the lettered columns and numbered rows is called the
above; left
Inserted rows are placed ____ the selected row(s) and inserted columns are placed to the ____ of the selected column(s).
plus sign; copied
When you hold down the Ctrl key and drag a selected range of cells, a ____ attached to the pointer indicates that the source contents are being ____.
four-headed arrow
When you point at the border of a selected range of cells, the mouse pointer changes to a white arrow with the move icon attached. The move icon is represented by a
.xls
When you save a workbook in an Excel 97-2003 format, the ____ extension is applied.
a down-pointing black arrow
When you sort a table by one of its columns from largest to smallest, what appears in the filter button for the sort column?
automatically expands the table and applies the same formatting.
When you type data in a row immediately below an existing table, Excel
a screen tip
When you use the Formula AutoComplete list box to enter a formula, the first portion of the function is inserted in the active cell, and the required syntax for the arguments appears in
General
Which cell format is used by default in Excel?
space
Which of the following characters cannot be used when creating a range name?
=SUM(D2:R2)
Which of the following examples makes use of a range?
=SUM('Qtr1:Qtr4'!E4)
Which of the following is an example of a formula with a 3-D reference?
Cycle
Which of the following is not one of the groups of shapes listed on the Shapes button?
printer types
Which of the following options is not available in the Settings section of the Print backstage area?
Row height is automatically increased to accommodate an increase in font size.
Which of the following statements correctly describes the relationship between row height and font size?
It updates to display the most recently selected border style.
Which of the following statements describes how the Borders button changes?
Insert Function
Which of these buttons can be used to find an Excel function by typing a description of the formula?
Page Layout
Which view displays horizontal and vertical rulers to assist with measurements?
Use Large Text
Make the text in the Excel Help window larger by clicking this button.
Sparklines
Miniature charts that illustrate changes in a row or column of data and fit in a cell are called
Margins
On which tab of the Page Setup dialog box will you find options for centering your worksheet horizontally and/or vertically on the page?
HOME
On which tab will you find the Insert button?
the values identified within the function's parentheses
One component of an Excel function is the argument. What is an argument?
present value
One of the arguments needed in the PMT function is pv. What does pv stand for?
F1
One way to access Help resources in Excel is to point to a button on a tab and then press the ____ function key.
Ctrl
Holding down this key while dragging a worksheet tab will create a copy of the worksheet in the new position.
Share
Save files in a different format with options at this backstage area.
to check the computations in your formulas
Section 1 suggests that when working with formulas in Excel, it is a good idea to create proof formulas. Why?
as decimal numbers that represent the portion of the day
How are time values stored in Excel?
Click the Name Manager button in the Defined Names group on the FORMULAS tab.
How can you display a list of range names to make editing or deleting them easier?
right-click the worksheet tab
How do you activate the worksheet shortcut menu?
Click the desired shape and then click and drag in the worksheet to draw the shape.
How do you create a shape in your worksheet using the Shapes button?
It anchors them to the active cell.
How does Excel place comments in a worksheet?
It uses the zero values in the calculation, but ignores the empty cells.
How does the AVERAGE function deal with empty cells and cells containing a zero value?
one
How many data series does a pie chart generally use?
1,048,576
How many rows can an Excel 2013 workbook contain?
Click the Wrap Text button in the Alignment group.
If you do not want to widen a column, what can you do to fit the text into the column?
automatic
In Page Break Preview, a dashed blue line indicates this type of page break.
are not within the print area.
In Page Break Preview, grayed-out cells
dashed or solid blue
In Page Break Preview, page breaks are shown as ____ lines.
exclamation point (!)
In a 3-D range, this punctuation mark separates the worksheet range from the cell reference.
letters; numbers
In an Excel worksheet, columns are referenced with ____, while rows are referenced with ____.
The column will remain fixed at column B, but the row will change.
Suppose a cell in your worksheet contains the formula =B$7*0.5. How would this formula change if it were copied to another cell?
contents, formats, and comments
The Clear All option in the Clear button removes the ____ from the active cell.
labels, values, and formats
The Find & Replace dialog box can be used to search for and replace
Window; VIEW
The Freeze Panes button is located in the ____ group on the ____ tab.
the largest value in the argument.
The MAX functions returns
Editing
The Sort & Filter button is located in the _____ group on the HOME tab.
PAGE LAYOUT
The Themes group is located on the ____ tab.
Orientation
The ____ button in the Alignment group on the HOME tab can be used to rotate text within cells.
fonts; points
The ____ is the typeface used to display and print data. It is measured in ____.
FILE
The _____ tab displays the backstage area that contains options for working with and managing files.
all pages in the active worksheet.
The default settings in Excel's Print backstage area are to print one copy of
select the range of cells containing the data to be charted.
The first step in creating an Excel chart is to
Ctrl + X
The keyboard shortcut for cutting the selection and placing it on the Clipboard is
Ctrl + Y
The keyboard shortcut for repeating a command is
workbook.
Information created in Excel is saved in a file called a
comment
A ____ is a user-created pop-up box containing text.
filter
A ____ is used to display only certain records within a table that meet the specified criteria.
range
A _____ is a group of adjacent cells in an Excel worksheet.
translucent.
A chart can be modified when it is clicked, and its border becomes
Move Chart
A chart can be placed in the same worksheet as the data or it can be inserted into its own sheet with options at this dialog box.
3-D
A formula is said to contain a(n) ____ reference when it references a cell spanning two or more worksheets.
3
A header contains ____ boxes.
one worksheet named Sheet1
A new Excel workbook initially contains
255
A range name can include up to this many characters:
label
A(n) ____ is an entry in a cell that helps the reader understand the values in the corresponding column or row.
.xlsx
By default, Excel 2013 workbooks are saved with the ____ extension.
right edge
By default, Excel aligns date entries at the ____ of the column.
at the left edge of the column.
By default, Excel aligns values
8.11; 14.40
By default, Excel column widths are set at ____ characters, and row heights at ____ points.
symbols first, then numbers, then letters
By default, Excel sorts data alphanumerically, which means entries are sorted in this order:
relative
By default, when a formula is copied and pasted from one cell to another, Excel automatically changes the cell addresses to reflect the destination location. This is referred to as ____ addressing.
charts
Column, line, pie, bar, area, and scatter are types of Excel
opening the Find & Replace dialog box with the Find tab active.
Ctrl + F is the keyboard shortcut for
themes
Selecting which of these formatting options will always change the entire worksheet?
Number
Specify the appearance of dates in a worksheet with options at the Format Cells dialog box with this tab selected.
filter arrows
When you format a range of cells as a table, Excel displays ____ in the first row of the table.
Thesaurus
This Excel feature can be used to replace a word in the worksheet with another word of similar meaning.
double-clicking the boundary line
This action sets the width of a column to fit the longest entry in the column.
&[Tab]
This is the code that Excel enters in a header or footer when the Sheet Name button is clicked.
Alt + Enter
This is the command to insert a line break within a cell.
Alt + Page Up
This keyboard movement command moves the active cell one screen to the left.
Ctrl + P
This keyboard shortcut displays the Print backstage area.
F12
This keyboard shortcut displays the Save As dialog box to save an Excel file in a different file format.
Shift + F2
This keyboard shortcut inserts a new comment.
Ctrl + `
This keyboard shortcut turns on or off the display of formulas.
Formula bar
This part of the Excel screen displays the contents of the active cell.
pie
This type of Excel chart is especially useful in showing a data point's size in proportion to the total of all points in the data source range.
line
This type of Excel chart is used to depict trends and change over time intervals.
dashed line
This type of line indicates a page break in a worksheet.
Middle Align
To center text between the top and bottom of a cell, click the _____ button in the Alignment group on the HOME tab.
Settings
To change margins in your worksheet, click the margins gallery in the ____ category in the Print backstage area.
double-clicking
To copy a format from the active cell and paste it multiple times to other cells, begin by ____ the Format Painter button.
dollar sign ($)
To create an absolute cell address, type this character in front of the column letter or row number that you do not want to change.
REVIEW
To insert a comment, click the New Comment button in the Comments group on the ____ tab.
Online Pictures
To search for and insert images at Office.com, use the _____ button on the INSERT tab.
tab shortcut menu
To ungroup grouped worksheets, click Ungroup Sheets in the
Statistical
To which function category do the COUNT, MAX, and AVERAGE functions belong?
sheet
Use options in the Page Setup dialog box with this tab selected to specify printing comments in a worksheet.
&[Date]
What code does Excel insert when you click the Current Date button on the HEADER & FOOTER TOOLS DESIGN tab?
causes the specified rows and columns to remain fixed while scrolling
What does Excel's Freeze Panes option do?
adds another row to the dialog box so you can sort by additional columns
What does the Add Level button in the Sort dialog box do?
closes a workbook
What does the Ctrl + F4 keyboard shortcut do?
copies formats from a selected cell to another cell
What does the Format Painter feature do?
The worksheet is automatically recalculated so that all values are current.
What happens when you change the value of a cell that is referenced elsewhere in a formula?
The worksheet is moved to a different position in the workbook.
What happens when you click and drag a worksheet tab in Excel?
The contents of the active cell are indented approximately one character width.
What happens when you click the Increase Indent button?
a question mark (?)
What image appears on the Microsoft Excel Help button near the upper right corner of the screen?
logical test
What is the first argument required by Excel's built-in IF function?
fill handle
What is the green square at the bottom right corner of an active cell?
CHART TOOLS DESIGN and CHART TOOLS FORMAT
When a chart is selected, these tabs becomes available.
dotted line
When changing a column width by dragging the boundary line to the right or left, a ____ is displayed to indicate the new width.
replaces the content
When copying or moving cells, if data already exists in the destination cells, Excel
F4
When editing a cell address, pressing ____ causes Excel to insert dollar symbols in front of the row and column number immediately to the left of the insertion point.
negation
When included in a formula, which of the following operators does Excel calculate first?
scrolling with the scroll bars
When navigating a worksheet, which of the following methods does not move the position of the active cell?
copy the formula and change the cell references relative to each destination location.
When the active cell contains a formula, dragging the fill handle causes Excel to
10%
When the worksheet is set to 100% magnification, clicking the Zoom In or Zoom Out buttons at either side of the Zoom slider bar magnifies or shrinks the display of the worksheet by _____ each time the button is clicked.
background
When you change the color of the fill in a cell, you are changing its
at the end of the existing worksheets
When you click the New sheet button, where is the new worksheet placed?
Save As dialog box
When you convert a file to a different format in Excel 2013, you can do this in the
A diagonal red triangle appears in the upper right corner.
Without pointing to it, how can you tell if a cell contains a comment?
Copy and Paste copies the contents to the Clipboard; fill handle does not.
You can copy the contents of a cell by using either the Copy and Paste functions or the fill handle feature. What is the difference between these two methods?
Number; HOME
You can decrease the number of decimal places displayed in a number by clicking the Decrease Decimal button, which is located in the ____ group on the ____ tab.
a context-sensitive shortcut menu.
You can edit a chart by right-clicking one of its elements to display
Ctrl
You can group multiple nonadjacent worksheets by holding down the ____ key while clicking each tab.
Print Titles
You want to specify rows and columns to repeat on each printed page of your worksheet. Begin by clicking this button in the Page Setup group on the PAGE LAYOUT tab.
Page Layout
____ view allows you to see your worksheet along with the print settings.
