Iba Exam

Front 1

T-F You can use pictures as bullets in a list.

Back 1

True

Front 2

t-f You can only apply one animation to an object

Back 2

false

Front 3

You can change your mouse to a highlighter or pen during your presentation in order to draw attention to parts of the slide.

Back 3

true

Front 4

In PowerPoint, you can find common tasks at the top in the Taskbar.

Back 4

false

Front 5

The compare feature allows you to combine two versions of the same presentation and view the difference

Back 5

true

Front 6

PowerPoint uses a spreadsheet to create charts within your presentation.

Back 6

true

Front 7

Which of these features allows you to add voiceover narration to your presentation?

Back 7

record slide show

Front 8

Priya would like to change the look and feel of her whole PowerPoint presentation like in the examples below. What is the quickest way for her to do this?

Back 8

Change the theme

Front 9

What does the Compress Pictures command do?

Back 9

it reduces the overall file size

Front 10

Lupita would like to add an icon on the last slide of her presentation to take her back to slide #2. What should she use?

Back 10

an action button

Front 11

Maya would like to insert a SmartArt graphic into one of her placeholders. Which of these icons should she click?

Back 11

The upper right icon

Front 12

What is an advantage of using the outline view?

Back 12

It allows you to easily view and edit the text of your slides and see the overall organization of your presentation

Front 13

Which of these things can you do with a video in PowerPoint? Trim the video

Create a frame around the video

Apply artistic effects to the video

Back 13

C. 1 2 & 3

Front 14

Dimitri would like to take a photo of Microsoft PowerPoint’s Ribbon to put into his presentation. Which of these should he use?

Back 14

screenshot

Front 15

osie would like to evenly space these strawberries in a line along the bottom of the slide. Which commands should she use to do this?

Back 15

allign bottom and distribute horizontally

Front 16

Which of the following effects will add thickness and a rounded edge to a shape?

Back 16

bevel

Front 17

John would like to print his presentation for his class so that they have a thumbnail of each slide as well as a space to write notes. Which print layout should he choose?

Back 17

handouts

Front 18

Anh would like to add her company’s logo to the upper right corner of every slide. What is the fastest way for her to do this?

Back 18

Insert the logo on the Slide Master

Front 19

While reviewing her slideshow, Megan noticed she had made a mistake in several places and used the color name “burgundy” when she should have used “maroon”. Which tool will let her quickly correct her mistake?

Back 19

find and replace

Front 20

By default, Microsoft Excel automatically saves a copy of your spreadsheet every 10 minutes.

Back 20

true

Front 21

Grouping worksheets allows the user to make changes to several worksheets at once.

Back 21

true

Front 22

The fill handle only allows you to copy formulas to several different cells.

Back 22

false

Front 23

Any changes made to an Excel document can be tracked in a separate worksheet.

Back 23

true

Front 24

The Subtotals command adds numbers in a designated column.

Back 24

false

Front 25

Sparklines are tiny charts that fit into one cell.

Back 25

true

Front 26

Luisa is creating a worksheet tracking her company’s spending on a project. However, when viewing her document, she has noticed that some of the cells contain pound signs like in the example below.

Back 26

make the cell wider

Front 27

Lauren currently has each month’s sales entered into a spreadsheet. She wants to know what she will need to sell in the month of June in order to meet her quarterly average sales goal of $40,000.Which of the following features will allow her to easily calculate what she would need to make in June?

Back 27

goal seek

Front 28

What is an advantage, if any, to using cell references instead of just typing in values?

Back 28

if this cell is changed, your formula will automatically update

Front 29

Petra placed all of her grades from her science class into a worksheet. She wants to highlight all of the failing grades with red. Which of the following is quick way for her to do this?

Back 29

conditional formatting

Front 30

Jun is the director of a summer camp. This spreadsheet contains campers’ names, information, and their counselors.

Back 30

custom sorting and hide columns

Front 31

What are predesigned spreadsheets called and where can they be found?

Back 31

template; backstage view

Front 32

What are Advanced Text Filters used for?

Back 32

filtering cells that meet very specific requirements

Front 33

Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this?

Back 33

=(A1+A2+A3)/4

Front 34

Minh wanted to find the average of all of her grades, but can not get her function work. Her spreadsheet is below. What error is Min making?

Back 34

She is missing an equal sign at the beginning of her formula

Front 35

Gerilynn wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?

Back 35

=(C3+C5+C9)

Front 36

When creating a table in Excel, what will clicking the drop down arrows in the headings allow you to do

Back 36

filter the data

Front 37

Charles wants to print only the highlighted text shown below. Which of the following options will allow him to do this?

Print Pane

Print Selection

Print Area

Back 37

2 and 3 only

Front 38

Which of the following shows an example of a cell with a left horizontal alignment and a middle vertical alignment?

Back 38

A,

Front 39

Which of the following best explains the difference between formatting your spreadsheet as a table and creating a PivotTable?

Back 39

Formatting your spreadsheet as a table changes the overall look and feel of your spreadsheet. PivotTables instantly calculate and summarize the data separately from your original spreadsheet.

Front 40

What is the purpose of the Document Inspector?

Back 40

To inspect the document for hidden properties and personal information

Front 41

True or False: In a hyperlink, the address and display text must be the same.

Back 41

false

Front 42

True or False: The Mail Merge feature can be used to address the same letter to several different people.

Back 42

true

Front 43

True or False: You can customize the Ribbon with different tabs.

Back 43

true

Front 44

True or False: It is not possible to change the shape of a text box.

Back 44

false

Front 45

True or False: By default, Microsoft Word automatically saves a file every ten minutes.

Back 45

true

Front 46

Kara had to write an essay describing her favorite hobby. The essay should be typed in 12 point, Times New Roman font, double-spaced, with a first line indent. What’s wrong with her formatting, and how can she fix it

Back 46

Her paragraph is single-spaced. She can correct this by highlighting her text, choosing the “line spacing” option under the Home tab, and choosing 2.0.

Front 47

How can you increase the indent space at the beginning of a line?

Press the TAB

keyClick the increase indent command

Drag the indent marker

Back 47

1, 2 ,3

Front 48

What’s one reason to add a section break into a document?

Back 48

To be able to format text before the break and after the break differently

Front 49

What does the Compress Pictures command do?

Back 49

to reduce the overall file size

Front 50

Jerome created the following list. What’s the quickest way he can add bullets to the list?

Pencil

Paper

Calculator

Notebook

Back 50

Select the text and click the Bullets icon

Front 51

What’s one advantage to using the Quick Print feature?

Back 51

It allows you to print with a single click

Front 52

Entering text in SmartArt is most similar to

Back 52

creating a multi-level list

Front 53

Cierra created an invitation for her work’s annual holiday party. She asked her boss to look over it and this is what she sent back: Cierra agreed with all of her boss’s editing suggestions. How can she finalize the document?

Back 53

Under the Review tab, click Accept drop-down arrow, then select Accept All Changes in Document

Front 54

Which of these is an example of justified text?

Back 54

d.

Front 55

Juan wants to convert text to a table. What is the first step Juan should take?

Back 55

select the text

Front 56

What’s one way to edit the header after it has been created?

Back 56

double click the header

Front 57

In order to move a picture freely around a document, which setting must be changed?

Back 57

text wrapping

Front 58

Which of the following orientations would work best with a very wide table?

Back 58

landscape

Front 59

Which of the following can be used to remove text from a document?

The delete key

The backspace key

The cut feature on the Home tab

Ctrl + C

Back 59

1,2, and 3 onlyy

Front 60

Where are templates located in Microsoft Word 2010?

Back 60

under the file tab in the backstage view