Week 4 - Pre-Assessment

What program is used to create spreadsheets which can later be used to analyze statistical tool?

• MS Excel

• MS Word

• MS Publisher

• MS OneNote

What MS Excel function adds a range of cells?

• ADD

• PLUS

• SUM

• TOTAL

Which of the following objects can't be inserted in your document?

• Pictures

• Sound

• Chart

• Shapes

Which of the following is NOT an animation type?

• Entrance

• Exit

• Emphasis

• Encore

In MS Word, what menu is “Mail Merge” found?

• Insert

• Format

• Design

• Mailings

What do you call the cells that do not change?

• Constant cells

• Relative Reference

• Absolute Reference

• Single cells

What type of Excel function searches for a specific value in your data using the spreadsheet columns and a unique identifier within those columns?

• VLOOKUP

• IF Function

• COUNTIF

• Absolute Reference

What two Microsoft applications are used to create a mail merge?

• Word & PowerPoint

• PowerPoint & Excel

• Word & Excel

• Word & Publisher

What are hyperlinks in PowerPoint?

• A tool that you use to navigate from one slide to another.

• A tool that you use to play in PowerPoint.

• A tool that you use to save a file and slide.

• A tool that you point to another image in the PowerPoint.

What do you call the software that people use to create and produce professional quality documents, presentations, databases, charts, and graphs?

• Production Tools

• Productivity Tools

• Professional Tools

• Advanced Application Tools