Excel & PowerPoint Terms

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

$

In the formula, =(G15-G14)*$M$3/4, which mathematical operations is performed first

(G15-G14)

excel recognizes an entry as a value if its is a number or it begins with

+ = $

the excel operator for division is

/

you can insert _ different kinds of pictures into PowerPoint

14

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

5

All functions begin with the formula prefix

=(equal sign)

Pressing ctrl+ changes the current pointer during a slide show back to the arrow key

A

You can press and hold _ to turn off the snap-to-grid feature while dragging objects on a slide

ALT

Which type of cell references preserves the exact cell address in a formula?

Absolute

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

Area chart

Although your email programs allows you to attack files, you can send a presentation using Outlook from within PowerPoint, Click the FILE tab, click share, click Email in the center pane, then click send as_

Attachment

Double-slicking the column line to the right of a column activates the _ features for the column.

AutoFit

When you are typing in a text placeholder, which feature decreases the font size in order to fit the text in the placeholder?

AutoFit option

In _ view, you have the options of saving your presentation to your computer of SkyDrive

Backstage

when cells or rows are interested or deleted in an Excel worksheet, how are cells referenced affected by the insertions or deletion?

Cell references are automatically adjusted

#### in a cell means that_

Columns is too narrow to display the value completely

A pie

Compares sizes of pieces as part of a whole

_ formatting is automatically updated if you change data in the worksheet

Conditional

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

Coordinates

To copy noncontagious slides, open slide, sorter view, click the first thumbnail, press and hold _, click each additional slide thumbnails, release the key, and then click the copy button

Ctrl

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

Ctrl

A collection of related data point is called

Data series

You an use the _ to delete ink annotations

Document Inspector

right-click a slide in the thumbnails pane and then click _ to create an exact copy of a slide

Duplicate slide

The _ keyboard command erases an annotation drawing

E

which keyoard shortcut turns on edit mode

F2

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

F4

Which of the following is an exception to copyright protection?

Fair use

To continue a sequences in adjacent cells, such as months of the year, use the _ feature of Excel

Fill handle

The New Slide button is in the slides group on the __ Tab

Home

The x-axis and y-axis are respectively, the

Horizontal and vertical axes

When you embed fonts, the size of your presentation__

Increases

A(n) _ identifies each data series in a chart, generally with a different color.

Legend

Which two charts compare trends over time intervals?

Line and scatter

_ shows you how a fill color will look before you apply it

Live preview

With PowerPoint, you can import text, photographs, numerical data, and facts from files created in such programs as __

Microsoft word, excel and access

The head and the footer dialog box has which of the following tabs?

Notes and Handouts

the counta functions is used to count the number of cells in a range that contains which type of data

Numbers dates formulas

When _ is selected under advance slide in timing group, you have to click to manually advance slides during a slide show

On mouse click

other than slide pane, where can you enter a slide text?

Outline view

The convert to SmartArt graphic button is in the _ group

Paragraph

Which dialog box do you to embed fonts?

PowerPoint Options

A cell references tells excel to substitute new cell references within the copied formulas as necessary

Relatives

You can use the _ command to replace one font for another in presentation

Replace

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

Ribbon

If you create a conditional formatting rule you can modify it using the conditional formatting

Rules Manager

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

S

The_ option helps fit the data on a single page without making changes to individual margins

Scale to fit

_ below the worksheet grid lets you switch from sheet to sheet in a workbook

Sheet tabs

To select an unselected text object, press _, click the text object, and then release _

Shift

You can add multiple worksheets to a workbook by clicking the home tab on the ribbon, pressing and holding_, and then clicking the number of existing worksheet tabs that correspond with the number of sheets you want add, clicking the insert list arrow in the cells group on the home tab, then clicking insert sheet

Shift

_ view to display your presentation on the whole computer screen

Slide Show

_lets you create diagrams types including list, process, cycle, hierarchy, relationships, matrix, and pyramids.

SmartArt

A presentation with a clear message that read _ and is illustrated with appropriate visual aids will have the greatest impact on your audience

Story

you can radically change how a SmartArt graphic looks by applying smart art

Style

In the formula=Round(D4:F4,0), what does the zero indicate?

The number of decimals placed in the rounded number

In presenter view, the next slide in the presentation appears _ corner of the screen

Upper-right

in excel, a worksheet is contained in a file called

Workbook

You can press _ to decrease the indent level

[Shift][Tab]

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

alignment

all of the following are placeholders you can add except

backgrounds

Cells and ranges in a worksheet can be formatted

before and after data is entered

Using _ computing, you can take advantage of Microsoft Office Web apps to do your work in a virtual environment

cloud

A(n) _ chart compares distinct objects levels using vertical bars; it is excel default

column

A scatter charts

compares trends over uneven times or measurements intervals

you can use a spreadsheet to _ by using variable values to investigate and sample different outcomes

create what if data scenarios

To create superscripts text in PowerPoint, select the text, number, or symbol

ctrl,shift,+

When you enter a slide from another presentation, the new slides has the design style and formatting of the _ presentation

destination

the _ commands found on the align list evenly space objects horizontally or vertically relative to each other or the slide

distribute

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

embedded

Which key do you press to create a new bullet?

enter

when working with a table, press _ to move to the next line within the same cell

enter

All excel formulas begin with the

equal sign (=)

In a worksheet, the _ is called the formula prefix

equal sign (=)

In a pie chart, slices that are pulled away are said to be__

exploded

You can save your PowerPoint presentations as a full- _ video, which incorporates all slide timing, transitions, animations and narrations

fidelity

To move an object to the bottom of the stack, click the send backwards arrow and then click send to back in the arrange group on the drawing tools _ tab

format

In excel, max and average are example of

functions

a(n) _ is a built in formula that uses arguments to calculate information

functions

To replace specific text in a presentation, click the _ tab on the ribbon, then click the replace button in editing group

home

you can insert a chart using the Insert Chart button in the _ group, on the Insert Tab

illustrations

To add a hyperlink to a slide, use the hyperlink button in the links group on the _tab

insert

A(n) _ is an entry in a cell that contained text such as "2013 sales" or " travel expenses"

label

After you enter text in a placeholder, the placeholder becomes text__

object

animations tags identify the _ in which objects are animated during slide show

order

_ view is a special view that you typically use when showing a presentation through two monitors

presenter

Pressing Shift as you drag to create a shape maintain the shape's _ as you change its size

proportions

A small, _ triangle appears in the upper-right corner of a cell containing a comment

red

instead of changing individuals attributes, you can apply a quick style to a

shape

it is a good idea to limit each slide to six words per line and _ lines per slide

six

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

spreadsheet

To apply a table style, select the data to be formatted or click anywhere within the intended range ( excel can automatically detect a range of cells). Click the format as table button in the _ group on the home tab, and then click a style in the gallery

styles

a SmartArt graphic consist of two parts: the SmartArt graphic itself and a(n) _ pane

text

You can _ the chart title text to select

triple-check

As a general rule, use no more than _ fonts in a presentation and vary the font size

two

the default accounting number format adds dollar signs and _ decimal places to the data

two

Every chart has a corresponding _ that contains the numerical data displayed by the chart

worksheet

in excel, the electronic spreadsheet you work in is called

worksheet