Computer Applications and Business/Principles of Information Technology End of Course Exam

The selected design template can be applied

to current slide only, to all the slides, to all the new presentation you create

What happens if you select first and second slide and then click on New Slide button on toolbar?

A new slide is inserted as third slide in presentation

Which tabs are available on left panel when you open a slides presentation?

Outline and Slides

Portrait and Landscape are

Page Orientation

To add Gridlines to your printed worksheet you need to use which option?

Page setup

You can take a selection that you have cut or copied from the clipboard and _____________ it into a document.

Paste

How would you print formulas?

Point to Formula Auditing on the Formulas tab, click 'show formulas', click the Microsoft Office Button, and then click Print

Font size is measured in __________.

Points

In Microsoft PowerPoint in order to see all the slides on one screen use

view, slide sorter

PowerPoint presentations are widely used as

Note outlines for teachers, Project presentations by students, Communication of planning

What is the function of this key?

**undo

The divide symbol is

/

To add two cells (A1 and A2) together you use the following formula

=A1+A2

A worksheet is...

A table of data that is organized into rows and columns

To sort data in an Excel worksheet you can use the ______.

A. Sort A to Z and Sort Z to A buttons B. Quicksort Options C. Sort command on the Formulas tab

What PowerPoint feature will you use to apply motion effects to different objects of a slide?

Animation Scheme

If you have a PowerPoint show you created and want to send using email to another student you can add the show to your email message as a (an)

Attachment

What are the three options available in Insert >> Picture menu?

Clipart, From Files, AutoShapes

Which command will you use in PowerPoint if you need to change the color of different objects without changing content?

Color Scheme

This command creates a duplicate of a selection and saves it to the clipboard.

Copy

To remove a portion of text from a document, you can ___________.

Cut it

What lets you to create new presentation by selecting ready-made font color and graphics effects?

Design Template

How can you create a uniform appearance by adding a background image to all slides?

Edit the slide master

When using Excel which sign is used to create a formula or function in a cell?

Equal sign

The title of Madison's report is 28 points. This is the title's ____________.

Font Size

Different lettering designs which can be used to add variety to documents are called __________________.

Fonts

In which menu can you find features like Slide Design, Slide Layout etc.?

Format Menu

What is the best way to create another copy of a slide?

From Insert Menu choose Duplicate Slide

If you want to insert some slides from another presentation into current one choose

From Insert menu choose Slides from Files

Which tab would you choose to change the font size of a word from 12 points to 18 points?

Home

From which menu you can access Picture, Text Box, Chart, etc.?

Insert

If you want to add a table or a radial diagram to your document, which tab would you choose?

Insert

Which tab in Microsoft Word would you select to insert a shape in to a document?

Insert

To insert slide numbers

Insert a new text box and select 'Insert' >>slide Number

Which of the following should be used when you want to add a slide to an existing presentation?

Insert, New slide

What is a Chart?

It is a visual way to display and compare data

You can use the drag and drop method to

Move cell contents

You would use Excel to:

Record numerical data

Which of the following can you use to add times to the slides in a presentation?

Rehearse timings button

What tab do you go to for the spelling and grammar check?

Review

When your text is lined up on your right margin, you could say that it is _______________

Right Aligned

You have created a table and you want to add 3 more rows to it. To add the new rows to the table, you would .....

Right click and choose insert rows

Which of the following method can insert a new slide in current presentation?

Right click on the Slide panel and choose New Slide. or From Insert menu choose New Slide. or Click on New Slide button on toolbar

To save a document for the first time you would choose _________,

Save As

What happens in a document when the "cut" command is used?

Selected text or graphics are removed

Which menu provides you options like Animation Scheme, custom Animation, Slide Transition?

Slide Show Menu

What feature will you use to apply motion effects in between a slide exits and another enters?

Slide Transition

Want your logo in the same position on every slide, automatically? Insert it on the

Slide master

Which of the following views is the best view to use when setting transition effects for all slides in a presentation?

Slide sorter view

In a PowerPoint presentation

Sound clips can be inserted and Movie clips can be inserted

Microsoft Excel is a ___________________?

Spreadsheets Package

Which formula can add the all numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

Sum

What happens if you edit an image inserted in PowerPoint

The original file that was inserted is not changed

The feature that will reverse your action should you make a mistake is called __________.

Undo

When using PowerPoint, to play a PowerPoint show for previewing the show, select

View, slide show

Which of the following should you use if you want all the slides in the presentation to have the same 'look'?

a presentation design template

What is the function of this key?

align right

examples of font style

bold, italics, regular

You insert a clip art and it is too big. To resize it you would _____.

click on the clip art to show the handles and drag a handle to resize it

What would you do to highlight a word? You position the cursor next to the word and then _____.

drag the mouse while holding the left mouse button

Times New Roman, Comic Sans and Calibri are called

fonts

A table is a grid into which data can be entered. It is made up of ___________.

rows and columns

A feature of MS Word that saves the document automatically after certain interval is available on

save tab on 'options' dialog box

In Microsoft PowerPoint the entry effect as one slide replaces another in a show is called a (an)

slide transition