You are in Edit mode any time you are entering or changing the contents of a cell.

Arguments are Excel’s built-in formulas.

You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.

A named range can begin with a letter or number.

Printing gridlines makes data easier to read.

Predefined formulas in Excel are called functions and can be accessed using the Insert Function button.

When using the Insert Function button or the AutoSum list arrow, it is necessary to type the equal sign.

An absolute cell reference changes the cell references when the formula is copied to a new location.

It is acceptable for dates to have a currency format.

You can change the font and font size of any cell or range using the Mini toolbar.

The Format Painter button copies both the cell’s content and formatting.

With Excel, you can adjust the width of one or more columns by using the mouse.

Normally, you don’t need to adjust row heights manually because row heights adjust automatically to accommodate font size changes.

You can add words to the dictionary of the spelling checker.

A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.

A chart must be located in a specific cell or at a specific address range.

Any data changed in the worksheet is automatically updated in the chart.

Dragging a chart object to a new location on the worksheet will change the data in the worksheet.

The CONCATENATE function breaks a text string into separate strings.

Linking to a workbook means that any changes to the original values are automatically reflected in the consolidation sheet as well.

You cannot use the fill handle to copy a formula with an external reference indicator

You can link a formula to both another worksheet and to another workbook

If there are invalid cell refrences in a formula, the error #REF! will display in the cell.

If a number is divided by zero, the error value #DIV/0! will display in the cell.

One way to check worksheet formulas for errors is to display the formulas on the worksheet rather then the formula results.

Names that you assign to cells and cell ranges can be used in formulas

Cell and range names can use uppercase and lowercase letters, digits, and spaces.

Symbols, such as less than(<), greater than(>), and equal to(=), are all examples of comparison operators

The symbol <> stands for "equal to"

Powerpoint allows you to input files from a variety of sources, such as Microsoft Access

Handouts are pages of your presentation that you print and distribute to your audience

The Quick Access toolbar is only visible when the home tab is active

A text box and a digital image are both examples of objects

It is impossible to open a powerpoint 97-2007 presentation in powerpoint 2013

The Quick Access toolbar contains basic text-formatting commands, such as bold and italic, and appears when you select text using the mouse

When you are working in outline view, a new slide is created when you press (Shift)(Tab)

There are nine basic categories of SmartArt graphics that illustrate text differently

In Powerpoint, it is possible to combine several shapes together to make a more complex figure

Merging shapes, Which combines multiple shapes together, provides you the potential to create a variety of unique geometric shapes that are not available in the shapes gallery

Paragraphs with one tab indent become slide titles when you insert text from Microsoft word into PowerPoint.

The cropped portion of a picture is no longer available to you if you change your mind and want to show that part of the picture again

Both types of text boxes can be formatted and edited just like any other text object

To change text box defaults, press [Shift], right-click the formatted text box, release [Shift], and then click Set as Default Text Box on the shortcut menu.

Click a chart in the PowerPoint window and then move your pointer over each bar in the chart to see the data source values.

You cannot add hyperlinks to charts in PowerPoint.

There are 3 master views: Slide Master, Handout Master, and Notes Master.

Every slide in a PowerPoint presentation has a background, the area behind the text and graphics.

While an annotation tool is visible, you still use mouse clicks to advance the slide show.

The Spell Checker checks the text in inserted pictures or objects.

An electronic _____ is an application you use to perform numeric calculations and to analyze and present numeric data.

In Excel, the electronic spreadsheet you work in is called a _____.

You can use predesigned, formatted files called _____ to create new worksheets quickly.

You can use a spreadsheet to _____ by using variable values to investigate and sample different outcomes.

As shown in the accompanying figure, item _____ points to the cell pointer, which outlines the active cell.

As shown in the accompanying figure, item 3 points to the _____.

The Excel operator for exponent is _____.

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?

In the accompanying figure, the entry in cell B4 is a _____.

Excel recognizes an entry as a value if it is a number or it begins with _____.

To quickly jump to the first cell in a worksheet press _____.

You can edit the contents of the active cell by _____.

As shown in the accompanying figure, item 2 points to the _____.

In the formula =D1+C1/F3, which calculation will be performed first?

All functions begin with the formula prefix _____.

In Excel, MAX and AVERAGE are examples of _____.

In the accompanying figure, the dialog box illustrates what element of a function?

In the accompanying figure, the item marked number _____ indicates the Clipboard dialog box launcher.

You can create an absolute cell reference by placing a _____ in front of both the column letter and row number of the cell address.

Which function key on the keyboard allows the Excel user to cycle through all possible combinations of relative, mixed, and absolute cell references for a formula?

A(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.

To continue a sequence in adjacent cells, such as months of the year, use the ____ feature of Excel.

Excel templates make creating a professional looking spreadsheet easier by including all of the following EXCEPT ____ in the template.

The file extension .xltx indicates what type of Excel file?

The ____ of a cell determines how the labels and values look.

To format a cell or range, first you select it, and then you apply the formatting using the ____, the Mini toolbar, or a keyboard shortcut.

Cells and ranges in a worksheet can be formatted ____.

In the accompanying figure, item 1 is the ____ button.

To apply a table style, select the data to be formatted or click anywhere within the intended range, click the Format as Table button in the ____ group on the HOME tab, and then click a style in the gallery.

In the ____ window you can search for online pictures (or Clip Art) in Office.com, through the Bing search engine, or on your SkyDrive.

You can apply font styles and alignment options using the ____ tab of the Ribbon.

Font ____ are formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet.

You can change the ____ of labels and values in cells to be left, right, or center.

In the accompanying figure, item ____ shows the button that wraps long text into multiple lines.

Double-clicking the column line to the right of a column activates the ____ feature for the column.

##### in a cell means that the ____.

Which of the following removes only the contents of a selected row or column?

You insert a comment in a worksheet by using a command on the ____ tab on the Ribbon.

____ shows you how a fill color will look before you apply it.

A theme can be applied using the Themes button in the Themes group on the ____ tab on the Ribbon.

The Find & Select button is found in the Editing group on the ____ tab on the Ribbon.

Each value in a cell selected for a chart is called a ____.

On a chart created in Excel, the horizontal axis is also called the ____.

On a chart created in Excel, the vertical axis is also called the ____.

Based on the chart in the accompanying figure, what data marker represents the smallest data point?

In the accompanying figure, item 5 represents ____.

To show how individual volume changes over time in relation to total volume, use a(n) ____.

A pie chart ____.

Which chart type do you use to compare distinct objects over time using horizontal bars?

A scatter chart ____.

A chart that is inserted directly in the current worksheet is called a(n) ____ chart.

You can ____ the chart title text to select it.

An example of a(n) ____ chart is a column chart with a line chart.

Which of the following will NOT be affected or rearranged by choosing a new layout on the CHART TOOLS DESIGN tab?

In the accompanying figure, item 3 points to a ____.

In the accompanying figure, item 4 points to a ____.

Which of the following is not an option that the Data Labels can produce?

Text annotations are ____ that you can add to further describe the data in your chart.

What Excel feature uses worksheet data to predict what should be entered into similar column cells?

Which Excel function counts the number of cells in a range?

Which Excel function averages cells in a range based on a specified condition?

When used in formulas, names become ____ cell references by default.

In the accompanying figure, there are ____ arguments in the formula.

In the accompanying figure, ____ separates the condition from the action to be taken.

Which of the following is NOT a comparison operator you can use in Excel?

Which of the following is NOT one of the arguments of a PMT function?

In the accompanying figure, item 1 refers to the ____.

In the accompanying figure, item 2 refers to the ____.

The default view that PowerPoint opens in is called ____ view.

The ____ is fully customizable.

The pane on the left-hand side in the accompanying figure is the ____ pane.

You can press ____ to decrease the indent level.

Tom has just started working as intern for a local radio station. He is responsible for managing the request line and presenting request trends to management each month. Tom uses PowerPoint to create his presentations. Tom is ready to create his first presentation. He starts PowerPoint and sees ____.

Mary is creating a cookbook in PowerPoint for her close friends and family. She uses PowerPoint to enter the recipes in text placeholders and then inserts photos of the finished products. Mary wants to make sure that her family and friends do not need to have the same fonts installed on their computers in order to view the recipes properly. She decides to:

To select an unselected text object, press [____], click the text object, and then release [____].

The Convert to SmartArt Graphic button is in the ____ group.

In the accompanying figure, the small vertical line that is sticking down from the rectangular graphic is the ____.

In the accompanying figure, the yellow circle in the lower-right corner of the rectangular graphic is a(n) ____.

You can copy a selected shape by holding down the _____ key and then dragging the shape.

A shape color's red, green, and blue (RGB) values are also known as its _____.

The Header and Footer dialog box has which of the following tabs?

To create superscript text in PowerPoint, select the text, number, or symbol, and then press _____at the same time.

To evenly space three gray arrows pointing to the right on a slide, you should select the three arrows and then apply the _____ command.

What steps are necessary to create an additional guide on a slide?

The Corrections button is in the _____ group.

PowerPoint uses _____ to create numerical charts.

Cells in the first or top row of a chart are _____ names and provide further information about the data.

A(n) _____ is an example of a data series marker.

The items shown in the accompanying figure are assorted _____ types.

In the accompanying chart, the words "Suite, Food, and Overall" label the _____.

To add a hyperlink to a slide, use the Hyperlink button in the Links group on the _____ tab.

By using the Reuse Slides pane, you can insert slides from another presentation or a network location called a _____.

To copy noncontiguous slides, open Slide Sorter view, click the first slide thumbnail, press and hold _____, click each additional slide thumbnail, release the key, and then click the Copy button.

You can format any text with a WordArt style. Select the text, click the DRAWING TOOLS _____ tab on the Ribbon, then click a WordArt style option in the WordArt Styles group.

To organize a list of pros and cons in a presentation, it would be best to use what tool?

To change the color behind the text of a table, click the ______ list arrow in the Table Styles group and then choose the desired color.

To open the Insert Picture dialog box, click the _____ tab on the Ribbon and then click the Pictures button in the Images group.

All of the following are placeholders you can add EXCEPT _____.

All of the following are theme color options EXCEPT _____.

The _____ keyboard command erases an annotation drawing.

During a slide show, which key is pressed to pause the show?

Pressing [Ctrl] _____ changes the current pointer during a slide show back to the arrow key.

When _____ is selected under Advance Slide in the Timing group, you have to click to manually advance slides during a slide show.

In the accompanying figure, the icon that shows two short vertical lines will _____ the presentation.

Entrance and Exit are _____.

The name of the author who created the presentation is included in _____.

_____ help you organize your slides into logical groups.

You can use the Document Inspector dialog box to _____.

To make sure you are familiar with the flow of animated objects on the last slide, you should review the _____.

To temporarily hide a slide during a slide show, you should right-click the screen, point to Screen, then click _____.

A dark rectangle that outlines the cell in which you are working

provides a brief description of the active command or task in progress

identified by the coordinates of the intersection column and row

displays the active cell address

a selection of two or more cells

allows the user to move or copy data from one cell to another without using the Clipboard

predesigned workbook files that contain labels, values, formulas, and formatting

the Excel function that returns the number of cells in a range containing numeric data

absolute cell reference

mixed cell reference

the type of cell reference used to preserve the relationship to the formula location

the Excel feature used to selectively copy formulas, values, etc. by choosing options such as "paste formulas only"

a statistical function

the name for a collection of characters (letters, numerals, symbols, and punctuation marks) with a similar, specific design

equal to ¹/₇₂ of an inch

has a default value of 8.43 characters, a little less than one inch

a predefined set of attributes that gives your Excel worksheet a professional look

a type of conditional formatting that visually illustrates differences among values

before creating this, you need to plan the information you want it to show

often contains the names of data groups, such as locations, months or years

often contains numerical values that help you interpret the size of chart elements

visually represents each data point

an independent element on a worksheet

displays the computer's measurement system

makes it easy to move objects

is sometimes transparent

moves items in a stack

snaps objects to a grid of evenly spaced vertical and horizontal lines

tracks values over time

boxes with numbers along the left side of a worksheet

vertical axis

intersection of a row and column

cells in the first or top row that provide further information about the data

graphical representations such as bars, columns, or pie wedgies

specific information about a presentation

created using computer cryptography

how a slide moves in and out of view during a slide show

cannot be edited or modified in any way

to draw on a slide during the presentation

can locate and remove hidden information from a presentation