Advertisement Upgrade to remove ads

Which of the following methods does not save changes in a PowerPoint presentation?

press f1

The Quick Access Toolbar, containing commands you may need at any time regardless of what tab is active, includes which of the following commands?

undo and redo

You have created a very complex table with great detail on a slide. You want to give the audience a printout of the slide showing all the detail so they can review it with you during your presentation. Which of the following print methods would show the necessary detail?

full slide

While displaying a slide show, which of the following will display a list of shortcuts for navigating?

f1

The predefined slide formats in PowerPoint are:

slide layouts

If you need to add an object such as clip art or a picture to a slide, which tab would you select?

insert

The open command

brings a presentation from a storage device into RAM memory

The save command

stores the presentation in RAM memory to a storage device

Which of the following provides a ghost image of a toolbar for use in formatting selected text?

Mini toolbar

Which of the following is a true statement?

the design theme can be changed after all of the slides have been created

Microsoft Clip Organizer searches

all of the above

Which of the following views is best for reordering the slides in a presentation?

slide sorter view

Normal view contains which of the following components?

tabs pane, slide pane, and notes pane

Which of the following cannot be used to focus audience attention on a specific object on a slide during a slide show?

apply a transition to the object

What is an animation effect the controls how one slide changes to another slide

transition

A file that incorporates a theme, a layout, and content that can be modified is known as a:

template

To create a presentation based on an installed template, click the:

office button and then new

What advantage, if any, is there to collapsing the outline so only the slide titles are visible?

more slides are displayed at one time, making it easier to rearrange the slides in the presentation

Which of the following is true?

The slide layout can be changed after the template has been chosen

How do you insert identifying information on every slide in a presentation?

click the interest tab and click headers and footers

Which of the following is true?

PowerPoint supplies many different templates, and each template in turn has multiple color schemes

Which of the following is the fastest and most efficient method for reusing a slide layout you have customized in another presentation?

Save the custom slide layout and reuse it in the new presentation

You own a small business and decide to institute an Employee of the Month award program. Which of the following would be the fastest way to create the award certificate with a professional look?

Access Microsoft Office Online and download an Award certificate template.

Which of the following moves a bullet point from the first level to the second level in an outline?

tab

The Increase List Level and Decrease LIst Level commands are available from which tab?

home

Which of the following formats cannot be imported to use as an outline for a presentation?

.tiff

You create a presentation for a local volunteer organization. When you arrive to present at its office, you find the room you are presenting in has many windows. Which of the following procedures should you follow?

any of the above

Which of the following statements is a true text design guideline?

title text should be 36 pts or larger

Which of the following is not a field in the Header and Footer dialog box?

file name

To add existing content to a presentation, use which of the following features?

all of the above

Shapes are:

A collection of graphical shapes, such as lines, arrows, and squares, that you add by using the Shapes gallery.

You insert a lightning bolt shape on your slide and want to rotate it. You:

Drag the green handle at the top of the image.

The relationship between the height and width of a shape is referred to as:

aspect ratio

Which of the following is a reason for grouping shapes?

To move or modify the objects as one

Which of the following is a reason for ungrouping a clip art object?

to be able to individually change shapes used to create the composite image

Which of the following features would you use on an ungrouped clip art image after completing your modifications?

regroup

You have inserted a clip art image of the ocean with a palm tree on the right side of the beach. If you flip the image vertically, what would the resulting image look like?

the image would be upside down with the palm tree pointing down

Which of the following might be a reason for changing the stacking order of shapes?

all of the above

You stack three shapes on top of each other on a slide by inserting a large square on the page, then a small circle, and then a large triangle. Which shape will be on the top of the stacking order?

The triangle because it was added last

In the above example, how would you move the triangle to the bottom of the stacking order?

in the arrange group, click send to back, and then select send to back

A Microsoft Windows Metafile (.wmf) is a vector object created by:

mathematical formulas

Which of the following features does not help with arranging objects on a slide?

Cascade

Which of the following is not available from the SmartArt gallery?

periodic table

Which of the following SmartArt graphics displays objects in a continual process?

cycle

You are trying to align a shape directly on top of another, but it always jumps above or below where you need to place it. What feature should you deactivate in order to accomplish this task?

snap to

Which of the following file formats is best for photographs?

bitmap

Which of the following is not a Windows graphics file format?

PICT

Which of these is a feature that can be used to identify a photograph on a slide?

captions

All of the following are forms of multimedia except?

placeholders

Which of the following file formats supports 16 million colors, is optimized for photographs and complex graphics, and is the format of choice for most photographs on the web?

.jpg

Which procedure would you follow to change the resolution of a movie clip?

click the size and position dialog box launcher in the size group on the movie tools options tab

Which of the following Picture Tools would help you adjust a scanned photograph that appears muddy and does not show much difference between the light and dark areas of the image?

contrast

Which of the following is permitted for a student project in a class?

all of the above uses are permitted

The Photo Album dialog box enables you to make all but this edit to pictures:

crop

Which of the following are included in the Clip organizer?

animated GIF files (.gif)

Which of the following statements is not true?

objects linked to a PowerPoint slide show automatically move with the slide show when its location is changed

Which of the following sound formats may be embedded in a slide show?

windows audio file (.wav)

All of the following can be used to play a sound clip for preview except:

click the clip on the slide

Which of the following options for inserting sound is available under the Slide Show tab rather than the Insert tab?

record narration

Which of the following is a true statement regarding recording a narration?

the slide timings are recorded with the voice narration for use in a self-running presentation

references the active cell in the worksheet

name box

displays the contents of the active cell

formula bar

area where you can manipulate data

working area of doc

displays info about commands or operations taking place in excel.

status bar

toggle on/off the task pane

ctrl+f1

a grouping of horizontal cells 1,048,576 of them

rows

a grouping of vertical cells 16,384 of them

column

1 Excel spreadsheet

worksheet

at the bottom of the screen. They allow you to switch between worksheets

worksheet tabs

What an excel file is referred to as...contains multiple worksheets

workbook

allows you to edit the selected cell (in addition to double-clicking or using the formula bar)

F2

you can split the screen by grabbing the little line to the right of the horizontal scroll bar. Double click the split to make it go away.

screen split

on the top left hand corner gives you a smart tag, drop menu gives you options

green triangle

The green triangle on the top left hand corner gives you a _____, drop menu gives you options.

smart tag

if you click this on the formula bar, the data is accepted and the same cell remains the active cell.

green check markup

if you are typing over data already entered into a cell, and press this or click the red x on the formula bar, the data you are typing will be canceled and the data will go back to what was previously entered.

esc

if you are typing over data already entered into a cell, and press esc or click this on the formula bar, the data you are typing will be canceled and the data will go back to what was previously entered.

red x

right aligned

numbers

left aligned

text

select entire worksheet

ctrl+A

moves to the 1st column in the same row

home

moves to beginning of document (cell A1)

ctrl+home

CTRL+____ arrow key- moves the selected cell to the very last column (column IV) while staying in the same row

right

CTRL+____ arrow key- moves the selected cell to the very first column (column A) while staying in the same row

left

CTRL+_____ arrow key-moves the selected cell to the very last row (row 65536) while staying in the same column

down

CTRL+_____ arrow key-moves the selected cell to the very first row (row 1) while staying in the same column.

up

CTRL+_____- brings to bottom, right most cell of the spreadsheet where there is info entered

end

inserts a row or column when a column or row header is selected..brings up the insert dialogue box when a cell or group of cells is selected.

CTRL+SHIFT+

deletes a row or column when a column or row header is selected...brings up the delete dialogue box when a cell or group of cells is selected.

CTRL -

bring up the format cells dialogue box

CTRL+1

switches between normal and formula views

CTRL+`

shortcut for setting cell references

F4

select the cell in the formula and press F4 once-______ reference

absolute

$A$1

absolute reference

select the cell in the formula and press F4 twice- the anchor will be on the _____

row

A$1

row anchor

$A1

column anchor

select the cell in the formula and press F4 three times- the anchor will be on the _____

column

select the cell in the formula and press F4 four times-_____ reference. (default)

relative

A1

relative reference

automatically inserts a column to the left of the column the focus is currently on

insert sheet columns

right click the column header click insert

insert sheet columns to left of column in focus

right click the cell=> click insert=>insert dialogue box appears=>select entire column

insert sheet columns to left of column in focus

select the column header=>press CTRL and Shift and + =>

insert sheet columns to left of column in focus

automatically inserts the row above the row the focus is currently on

insert sheet row

right click the row header => click insert=>

insert row above row in focus

right click the cell => click insert=>insert dialogue box appears =>select entire row=>

insert row above row in focus

select the row header=> press CTRL and Shift and +=>

insert row above row in focus

1. Click the insert=> insert cells
2. Right click on a cell or group of selected cells=>click insert
3. Select a cell or group of cells=> press =CTRL AND SHIFT AND +

bring up insert dialogue box

right click the column header=> click delete

deletes the entire column

right click a cell in the column you wish to delete=> click delete=> delete dialogue box appears=> select entire column

deletes the entire column

select the column header=> press CTRL and -

deletes the entire column

right click the row header => click delete

deletes the entire row

right click a cell in the row you wish to delete => click delete=> delete dialogue box appears=> select entire row =>

deletes the entire row

select the row header=> press CTRL AND -

deletes the entire row

1. Delete=> delete cells
2. right click a cell or group of cells=> click delete
3. select a cell or group of cells=> press CTRL AND -

brings up delete dialogue box

a dialogue box appears where you can enter the numerical size you would like the column or row to be..how?

right click the column/row header
select column width/row height

radio button that allows you to scale your workbook so that it fits to a specified number of pages.

scaling

the small black square at the bottom right of the currently selected cell

autofill handle

Press CTRL+1
CTRL+SHIFT+F
right click, format cells
home tab=> click the right corner of the font, alignment or number ribbons

open the format cells dialogue box

will select all consecutive worksheets or cells between the current selected worksheet and the worksheet that is left clicked

Shift+left click

will select any worksheet that you click on in addition to the current selected worksheet...sheets do not have to be consecutive

CTRL+left click

1. Right click on a sheet tab=>select insert=>select worksheet=> click OK
2. Select home tab=>insert=>select worksheet
3. To delete a worksheet, right click sheet tab=>delete

insert/delete a worksheet

instead of moving the select worksheet to the location you choose, this check box makes it so Excel creates a copy of the selected worksheet in the location you choose

create a copy check box

an incorrectly formed formula...."Not a value error"
ex: =A1+"Hello"

#VALUE!

divide by zero error or referencing a blank cell
Ex: =45/0

#DIV/0!

name error...occurs when Excel does not recognize text in a formula
Ex: =IF(A2=A2, go gators)

#NAME?

invalid cell reference error...occurs when a formula refers to an invalid cell

#REF!

when a formula refers to the cell it is located in its formula. If you try to make a cell a circular reference it will give a 0 as the result of the formula

circular reference

a number that is to wide to display in the cell

#####

is the process that enables you to keep headings on the screen as you work with large worksheets, rows and columns.

freezing

To do this to rows and columns:
1. Select the cell below the row(s) and to the right of the column(s) you want to freeze.
2. Click the View tab and click Freeze Panes in the Window Group.

freeze

is the process of making rows, columns, and sheets invisible.

hidden

To do this to a particular row or column in a worksheet:
1. Select the row or column you want to hide.
2. Click the Home Tab
3. Click Format in the Cells group and point to Hide & Unhide.
4.Click Format in the Cells group and point to Hide & Unhide.
4. Select the appropriate hide option.

hide

To allow data to be entered in this:
1. Select the cells where entering or changing data will be allowed.
2. Click the Home Tab, click Format in the Cells group, and select Format Cells to open the Format Cells dialog box.
3. Select the Protection tab, clear the Locked check box, click OK.
4. Click the Home tab, click Format in the Cells group, and click Protect Sheet.
5. Select a password if desired and clear the Select locked cells check box.

some cells but not all

To do this to a worksheet:
1. Click the Home tab and click Format in the Cells group.
2. Click Protect Sheet.
3. Select a password if desired and click the options that users will be permitted in the worksheet.
4. Click OK.

protect

To protect this:
1. Click the Review tab and click Protect Workbook in the Changes group.
2. Click the boxes for the protection desired.
3. Enter a password if desired in the Protect Workbook dialog box.
4. Click OK.

workbook

All dependent formulas recalculate every time a change is made to a value, formula, or name. Click this under Calculation Options in the Calculation group.

automatic

All dependent formulas recalculate except data tables, every time a change is made to a value, formula, or name. Click this under Calculate Options in the Calculation group.

Automatic Except for Data Tables

Turn off automatic recalculation and recalculate open workbooks only when desired. Click this under calculate options in the Calculation group.

manual

manually recalculate. Click this in the calculation group on the Formulas tab, or press F9.

calculate now

shows where page breaks occur and gives you the opportunity to change where the page breaks.

Page Break preview

To see and adjust this:
1. Click Page Break Preview on the status bar.
2. A watermark shows the page numbers.
3. Move the dashed blue lines as appropriate to adjust the page breaks.

page breaks

To change this:
1. Click Orientation in the Page Setup group on the Page Layout tab.
2. Select Portrait or Landscape

page orientation

Print this of a worksheet:
1. Select the portion of the worksheet you want to print.
2. Click the Page Layout Tab, and then click Page Setup Dialog Box Launcher in the Page Setup Group.
3. Click Print, and then click Selection in the Print what section.
4. Verify the selection using Preview.
5. Click Print in the Print group on the Print Preview tab.

selection or range

To change this of the printing pages:
1. Click the Page Setup Dialog Box Launcher on the Page Layout tab.
2. Click the Sheet tab.
3. Change the Page order options, as appropriate.
4. Click OK

order

Known as a list in previous versions of Excel; is an area in the worksheet that contains rows and columns of related data organized in such a way to facilitate data management and analysis.

table

filter drop-down lists for efficient sorting and filtering, predefined table styles to format table rows and columns with complementary fill colors, ability to create and edit calculated columns, calculated total row enabling the user to choose from a variety of functions, use of structured references instead of cell references in formulas, ability to export the table data to a SharePoint list.

table

To create without data:
1. Select a range of cells on a sheet.
2. Click the Insert tab and click Table in the Tables group. The Create Table dialog box opens, asking for the range of data for the table. If the table has (or will have) field names at the top of the columns, select the My table has headers check box.
3. Click OK

table

See More

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set