Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

INTE 20013_Integrated Software Application

Total questions: 20

Worksheet time: 15mins

Name
Class
Date
1.

MS Word


Holds all of the information in previous versions of Microsoft Office in a more visual stream line manner through a series of tabs that include an immense variety of program features.

(a)  

2.

This tab has commands to adjust page elements such as margins, orientation, inserting columns, page backgrounds and themes.

(a)  

3.

This is the most used tab; it incorporates all text formatting features such as font and paragraph changes.

(a)  

4.

This tab allows you to insert a variety of items into a document from pictures, clip art, tables and headers and footers.

(a)  

5.

This tab allows you to change the view of your document to a different two page document or zoom.

(a)  

6.

MS Access


This tab holds an immense function library which can assist when creating any formula or function in your spreadsheet.

(a)  

7.

This tab allows you to modifying worksheets with large amounts of data by sorting and filtering as well as analyzing and grouping data.

(a)  

8.

This tab allows you to correct spelling and grammar issues as well as set up security protections. It also provides the track changes and notes feature providing the ability to make notes and changes someone’s document.

(a)  

9.

In Excel, the format of a cell is separate from the data that is stored in the cell. This display difference can have a significant effect when the data is numeric.

(a)  

10.

By using predefined border styles, you can quickly add a border around cells or ranges of cells. If predefined cell borders do not meet your needs, you can create a custom border.

(a)  

11.

MS PowerPoint


Click the ____ button in the Quick Access Toolbar – we recommend using this button often

a)

New

b)

Save

c)

Open

12.

Click ____, Choose type of Presentation then click Create.

a)

Open

b)

Save

c)

New

13.

Save a duplicate of the file with a new name

a)

New

b)

Save As

c)

Open

14.

Preview appears on the right side of the screen

a)

Close

b)

Print Preview

c)

New

15.

If you want to exit PowerPoint, you can click the x in the top right corner.

a)

Close

b)

Open

c)

New

16.

MS Access


Queries are questions you ask of your database. They allow you to select certain fields out of a table, or pull together data from various related tables and display it together.

a)

Notes on Query Results

b)

Understanding Queries

c)

Sort query results

17.

In Design View, click the Sort row in the column you wish to sort by. A dropdown arrow appears; choose Ascending or Descending. If you sort by more than one column, the sorts will be done left-to-right.

a)

Notes on Query Results

b)

Create a concatenated field in a query

c)

Sort query results

18.

If a query contains fields from two or more related tables, the results will only include records that have related records in all the tables.

a)

Notes on Query Results

b)

Sort query results

c)

Create a concatenated field in a query

19.

You can type criteria in more than one field.

a)

Create a parameter query

b)

Using Multiple Criteria

c)

Criteria Ranges

20.

Criteria ranges broaden and customize a search.

a)

Criteria Ranges

b)

Using Multiple Criteria

c)

Create a parameter query