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