wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

DWA Final

Total questions: 129

Worksheet time: 1hrs 10mins

Name
Class
Date
1.

What is the intersection of a column and a row in a table or worksheet called?

a)

Column Heading

b)

Cell

c)

Print Area

d)

Workbook

2.

An equation that calculates a new value from values currently in a worksheet.

a)

Sum Button

b)

Cell

c)

Worksheet

d)

Formula

3.

A computerized spreadsheet.

a)

Worksheet

b)

Row

c)

Column

d)

Workbook

4.

The cells and ranges designated for printing.

a)

Column

b)

Row

c)

Print Area

d)

Sum Button

5.

The column letter.

a)

Row

b)

Column

c)

Sum Button

d)

Column Heading

6.

The file used to store worksheets.

a)

Workbook

b)

Worksheet

c)

Print Area

d)

Formula

7.

The row number.

a)

Cell

b)

Column Heading

c)

Row Heading

d)

Sum Button

8.

A vertical stack of cells in a table or worksheet.

a)

Print Area

b)

Cell

c)

Row

d)

Column

9.

Adds together long columns or rows of numbers.

a)

Column

b)

Sum Button

c)

Column Heading

d)

Row

10.

The horizontal placement of cells in a table or worksheet.

a)

Column

b)

Print Area

c)

Row

d)

Cell

11.

Match the following

a)

This area contains all of the commands you will need to perform common tasks in Excel. It has multiple tabs, each with several groups of commands.

1.

Excel Ribbon Menu

b)

In this box, you can enter or edit data, a formula, or a function.

2.

Formula Bar

c)

This refers to a group of cells that runs from the top of the page to the bottom.

3.

Column

d)

This refers to the rectangle boxes in an Excel workbook which is at the intersection of a row and a column.

4.

Cell

e)

This refers to a group of cells that runs from the left of the page to the right.

5.

Row

12.

Match the following

a)

This feature lets you access common commands no matter which tab is selected.

1.

Quick Access Toolbar

b)

These are the files that are in the Excel workbooks. They also make up the different pages in Excel.

2.

Worksheets

c)

This area displays the location of a selected cell.

3.

Name Box

d)

This feature allows you to drag a slider to control the size of the worksheet in Excel.

4.

Zoom Control

e)

This area controls the different ways that the Excel worksheets are displayed.

5.

Worksheet View Options

13.

In Excel, how would you access the backstage view?

a)

Insert Tab

b)

File Tab

c)

Formula Tab

d)

Help Tab

14.

What is Excel?

a)

A Presentation Program

b)

An Email Program

c)

A word Processing Program

d)

A Spreadsheet Program

15.

Which is NOT one of the worksheet view options in Excel?

a)

Page Layout

b)

Normal

c)

Page Break Preview

d)

Data

16.

What do dialog box launchers allow us to see? (see picture below)

a)

Nothing

b)

Data of the box

c)

All features and commands of that particular section

d)

Page Layout Features

17.

Once you’ve added all of your choice buttons to the quick access toolbar, you can’t reset it back to its default settings.

a)

True

b)

False

18.

What steps do you need to follow in order to add a button to the QAT?

a)

From the QAT menu, let your mouse rest on the button of your choice and right click.

b)

From the QAT menu, let your mouse rest on the button of your choice and left click.

c)

From the QAT menu, double-click the button of your choice.

d)

From the QAT menu, hover over the button of your choice until it turns yellow.

19.

Almost all buttons of your choice can be added to the QAT.

a)

True

b)

False

20.

Rows are _______ and identified by ___________.

a)

Vertical, Letters

b)

Horizontal, Numbers

c)

Top Down, Vowels

d)

Bottom Up, Numbers

21.
Question Image

Match the following

a)

A

1.

Worksheet

b)

B

2.

Row

c)

C

3.

Cell

d)

D

4.

Column

22.

Columns are ___________ and identified by __________.

a)

Vertical, Letters

b)

Horizontal, Numbers

c)

Top Down, Vowels

d)

Bottom Up, Numbers

23.

Every workbook has at least ______ worksheet(s).

a)

4

b)

3

c)

2

d)

1

24.

What actions do you need to take to customize the status bar?

a)

Left-click and select what you would like to add.

b)

Right-click and select what you would like to add.

c)

Double-click status tab.

d)

Click status tab once.

25.

The status bar is located where in your Excel workbook?

a)

Bottom

b)

Right

c)

Left

d)

Top

26.

The mini toolbar can be turned off.

a)

True

b)

False

27.

A mini toolbar will allow the display of formatting options.

a)

True

b)

False

28.

Which of the following should you select in order to customize your ribbon after you have right-clicked on a tab?

a)

Customize the Tab

b)

Customize the Ribbon

c)

Customize Formulas

d)

Customize Design

29.

If you choose to remove a tab when customizing your ribbon, you can never put that tab back in place.

a)

True

b)

False

30.

What key is necessary for you to click on your keyboard to access shortcuts?

a)

Alt

b)

Caps Lock

c)

Tab

d)

Shift

31.

Which button should you click, to clear the content of an active cell?

a)

Page Up

b)

Backspace

c)

Escape

d)

Shift

32.

If you ever need to change a named range, go to the formulas tab and click ___.

a)

Text

b)

AutoSum

c)

Calculations Options

d)

Name Manager

33.

Spaces are allowed in named ranges.

a)

True

b)

False

34.

How many different printing options do you have?

a)

1

b)

2

c)

3

d)

4

35.

If you only wanted to print a certain area of your spreadsheet which option should you choose?

a)

Print Active Sheets

b)

Print Entire Workbook

c)

Print Some Workbook

d)

Print Selection

36.

You can tell how many pages there are because they are clearly marked behind your information.

a)

True

b)

False

37.

The page break between the information is indicated by what?

a)

Solid Green Line

b)

Dashed blue line

c)

Greyed out area

d)

Page 1

38.

If you want to adjust the Page Break area, what do you need to do?

a)

Drag the solid red line

b)

Highlight the cells

c)

Adjust the dashed blue line

d)

Drag the green line

39.

What orientation would allow more information to be displayed on the page?

a)

Landscape

b)

Portrait

40.

You can adjust both the page layout as well as margins from the Page Setup Menu.

a)

True

b)

False

41.

You can print both the data and the chart together.

a)

True

b)

False

42.

Select "Print Selected Chart" to print the entire workbook.

a)

True

b)

False

43.

If you would like to clear the print area, what tab do you need to first enter into?

a)

Insert

b)

Page Layout

c)

Formula

d)

Data

44.

The amount of space above and below a paragraph is referring to ____.

a)

Line Spacing

b)

Paragraph Spacing

c)

Paragraph Formatting

d)

Line Formatting

45.

If a green underline appears under a word, what does this mean?

a)

There is a grammatical error.

b)

There is a spelling error.

c)

There is a spacing error.

d)

There is a coloring error.

46.

Located in the upper left-hand corner of Word, this will allow you to easily access the save, undo, and repeat buttons.

a)

Paragraph Toolbar

b)

Ribbon

c)

Quick Access Toolbar

d)

Paragraph Formatting

47.

What kind of document opens each time you open the Word program?

a)

Red document

b)

Pre-filled document

c)

Template

d)

Blank Document

48.

Changing the appearance of the entire paragraph is known as what?

a)

Line Spacing

b)

Paragraph Formatting

c)

Font Group

d)

Paragraph Spacing

49.

The amount of space between the lines of text.

a)

Line Spacing

b)

Paragraph Spacing

c)

Line Formatting

d)

Paragraph formatting

50.

If a red line appears under a word, what does this mean?

a)

There is a grammatical error.

b)

There is a spelling error.

c)

There is a spacing error.

d)

There is a coloring error.

51.

What contains the buttons that can quickly change the appearance of the font?

a)

Quick Access Toolbar

b)

Paragraph Group

c)

Font Group

d)

Ribbon

52.

If a blue line appears under a word, what does this mean?

a)

There is a grammatical error.

b)

There is a spelling error.

c)

There is a spacing error.

d)

There is a word used inappropriately.

53.

This button is used to reverse the last action performed and is located in the Quick Access Toolbar.

a)

Font

b)

Undo

c)

Italics

d)

Center

54.

Match the following

a)

This area contains all of the commands you will need to perform common tasks in Word.

1.

Word Ribbon Menu

b)

This area lets you access common commands no matter which tab is selected. By default, it includes the Save, Undo, and Redo commands.

2.

Quick Access Toolbar

c)

This area allows you to search for commands, which is especially helpful if you don't remember where to find a specific command.

3.

Tell Me

d)

This is located at the top and to the left of your document. It makes it easier to make alignment and spacing adjustments.

4.

The Ruler

e)

This is where you'll type and edit text in the document.

5.

Document Pane

55.

Match the following

a)

This area contains a series of different commands. Simply click any command to apply it.

1.

Command Group

b)

From here, you can quickly see the number of words and pages in your document.

2.

Page and Word Count

c)

This is where you can switch between the Read Mode, Print Layout, and Web Layout.

3.

Document Views

d)

This tool allows you to enlarge the size of the screen.

4.

Zoom Control

e)

This tool allows you to move up and down through the page of your document.

5.

Scroll Bar

56.

If you have already saved a document named "MyEssay" and need to exit to come back to it later, which should you click to save your work?

a)

Save

b)

Save As

c)

File

d)

Home

57.

Which view allows you to see all of the file properties such as the word count, author, date modified and so on?

a)

Front stage view

b)

Home Tab

c)

Font Group

d)

Backstage View

58.

What tab can you find the options to print or save on?

a)

Home

b)

Insert

c)

File

d)

Design

59.

You can view different pre-made templates while in the backstage view.

a)

True

b)

False

60.

What tab houses the Font Group?

a)

Design

b)

Home

c)

Layout

d)

View

61.

Once you have typed a document, you can no longer modify the text, such as making it larger, changing colors, and so on.

a)

True

b)

False

62.

What shortcut keys would you use to copy a set of text?

a)

Ctrl + C

b)

Ctrl + V

c)

Ctrl + P

d)

Ctrl + R

63.

What shortcut keys would you use to paste a set of text?

a)

Ctrl + C

b)

Ctrl + V

c)

Ctrl + P

d)

Ctrl + R

64.

What group under the Home tab houses the symbols or lists?

a)

Styles

b)

Clipboard

c)

Paragraph

d)

Font

65.

Numbered lists keep a document clean and organized.

a)

True

b)

False

66.

By default save, undo, and design appear on the Quick Access Toolbar.

a)

True

b)

False

67.

Where is the Quick Access Toolbar located?

a)

Top right corner

b)

Top left corner

c)

Bottom Right Corner

d)

Bottom Left Corner

68.

Once you’ve decided on the buttons you want to add to the QAT you cannot choose their order.

a)

True

b)

False

69.

To customize the ribbon, what do you need to do first?

a)

Left-click on the ribbon

b)

Double-click the ruler.

c)

Right-click on the ribbon.

d)

Double-click the document

70.

If you don’t see the commands you are looking for, what can you click?

a)

All Commands

b)

Some Commands

c)

Word Commands

d)

Ruler Commands

71.

The mini toolbar is customizable.

a)

True

b)

False

72.

If you need to change something like making the font bold or changing the color, you can do so from the mini toolbar

a)

True

b)

False

73.

Where on the Word document is the status bar located?

a)

Top

b)

Left side

c)

Bottom

d)

Right Side

74.

Everything in the status bar is clickable.

a)

True

b)

False

75.

The ___ allows you to move text and images from other apps.

a)

Clipboard

b)

Home

c)

Page

d)

View

76.

What shortcut method would you use to cut text? Ctrl +___.

a)

C

b)

V

c)

X

d)

Z

77.

Where is the widow and orphan control located?

a)

Home Tab, Paragraph Group

b)

Home Tab, Font Group

c)

Home Tab, Styles Group

d)

Home Tab, Clipboard

78.

In the same place that you can find the widow and orphan control, you can also find the command for “keep lines together."  This will allow you to keep both lines and paragraphs together.

a)

True

b)

False

79.

If you wanted to make a comment in the document, where would you locate it?

a)

Home Tab, Styles Group

b)

References Tab, Footnotes Group

c)

Review Tab, Comments Group

d)

View Tab, Zoom Group

80.

When creating a document as a group, it is possible to see what others are doing using the track changes feature.

a)

True

b)

False

81.

What feature allows you to have commonly used words entered without you typing them completely?

a)

Autocorrect

b)

Autochange

c)

Autotyping

d)

Autotexting

82.

If you wanted to compare and combine documents which tab would you need to access?

a)

Layout

b)

References

c)

View

d)

Review

83.

When comparing documents, if you click “View Side by Side" how many documents will appear on your screen?

a)

1

b)

2

c)

3

d)

4

84.

What is the keyboard shortcut to access the "tell me" feature?

a)

Alt + T

b)

Alt + Q

c)

Alt + H

d)

Alt + B

85.

The "tell me" feature helps you find what you are looking for and provides you with shortcut key information if there is any.

a)

True

b)

False

86.

The first slide in a presentation.

a)

Title Slide

b)

Header Slide

c)

Final Slide

d)

Slide View

87.

The combined use of more than one media, text, sound.

a)

Animation

b)

Transition

c)

Clip Art

d)

Multimedia

88.

The Movement of text, graphics, or other objects within a slide.

a)

Effects

b)

Transitions

c)

Animation

d)

Slide Layout

89.

A view that displays a single slide and allows the user to insert clipart, change backgrounds and edit transitions.

a)

Slide Layout

b)

Effects

c)

Transitions

d)

Slide view

90.

A single page of a presentation in a slideshow.

a)

Slide

b)

Slide layout

c)

PowerPoint

d)

Clip Art

91.

What is PowerPoint?

a)

A software program that allows you to create professional tables.

b)

A software program that allows you to create professional clipart graphics.

c)

A software program that allows you to create professional looking multimedia presentations.

d)

A software program that allows you to create professional looking math problems.

92.

What is the definition of effects in PowerPoint?

a)

Formatting feature that allows you to turn background colors on and off.

b)

Formatting features that move the text and graphics on, off, or around the single slide.

c)

Formatting feature that autocorrects spelling.

d)

Formatting feature that allows you to change the slide layout.

93.

A predefined slide format that determines the position of objects on the slide.

a)

Effects

b)

Slide transition

c)

Slide layout

d)

Multimedia

94.

What are transitions in PowerPoint?

a)

Effects that move one slide off the screen and the next slide on during a slide show

b)

Moving objects.

c)

Change in the background color.

d)

Interesting graphics.

95.

This is the main control button. It will control commands such as save, open, close, new, print, save & send, and

exit.

a)

FIle Tab

b)

Home Tab

c)

Insert Tab

d)

Design tab

96.

This tab links to the Cut and Paste features, Font and Paragraph options, and what you need to add and organize

slides.

a)

File Tab

b)

Home Tab

c)

Insert Tab

d)

Design tab

97.

Click this tab to add something to a slide. This includes pictures, shapes, charts, links, text boxes, video and more.

a)

Home Tab

b)

Insert Tab

c)

Design Tab

d)

Animations tab

98.

On this tab, you can add a theme or color scheme, or format the slide background.

a)

Home tab

b)

Insert tab

c)

Design tab

d)

Animations tab

99.

Use this tab to choreograph the movement of things on your slides.

a)

Animations Tab

b)

Home tab

c)

Insert tab

d)

Design tab

100.

This tab sets up how your slides change from one slide to the next slide.

a)

Transitions tab

b)

Review tab

c)

View tab

d)

Tool tabs

101.

This tab lets you add comments, run spell-check, or compare one presentation with another (such as an earlier

version).

a)

Transitions tab

b)

Review tab

c)

View tab

d)

Tool tabs

102.

This allows you to look at your presentation in different ways, depending on where you are in the creation or delivery

process.

a)

Transitions tab

b)

Review tab

c)

View tab

d)

Tool tabs

103.

In this area, you will find Drawing Tools, Picture Tools, SmartArt tools, Chart tools, Table tools, and Video tools. These

applications will help you enhance your presentations.

a)

Transitions tab

b)

view tab

c)

Tool tabs

d)

Slide Show tab

104.

With this tab, you can set up the way that you want to show your presentation to others.

a)

Slide Show Tab

b)

Transitions Tab

c)

Review Tab

d)

View Tab

105.

An easy way to end a presentation without having to go all the way to through to the last slide is to press the _____ key.

a)

F5

b)

Alt + E

c)

Esc

d)

Ctrl + X

106.

Pressing the control key plus the letter "z" will do what?

a)

Insert a picture

b)

Undo the last action

c)

Move to the next slide

d)

Save the presentation

107.

After copying text to the clipboard, what shortcut would paste the text?

a)

Ctrl + V

b)

Ctrl + P

c)

Alt + C

d)

prt sc

108.

What happens if you use the control key plus the letter “c”?

a)

Your content will be deleted.

b)

Your content will turn yellow.

c)

Your content will shift right.

d)

Your content will be copied to the clidboard.

109.

What is the name of the ribbon that will allow you see all of your different viewing options?

a)

Transitions

b)

Design

c)

View

d)

Insert

110.

What view allows you to see a text-only version of your presentation?

a)

Outline

b)

Normal

c)

Slide Sorter

d)

Reading View

111.

What view would allow you to see any speaker notes that may have been added?

a)

Slide Sorter

b)

Normal

c)

Reading View

d)

Notes Page

112.

The ribbon is divided into tabs to make it easier to find what you are looking for.

a)

True

b)

False

113.

How do you access the backstage view from PowerPoint?

a)

Exit PowerPoint

b)

Click File

c)

Slide Sorter

d)

Outline View

114.

What tab do you use to get to the header and footer section?

a)

Insert Ribbon Tab

b)

Design Ribbon Tab

c)

Animations Ribbon Tab

d)

Design Ribbon Tab

115.

You can use the slide master to edit your footer notes.

a)

True

b)

False

116.

How many ways can you access the comment pane once a comment is made?

a)

1

b)

2

c)

3

d)

4

117.

You cannot delete comments once they are made.

a)

True

b)

False

118.

Cut, copy, and paste in the clipboard group can be used to make edits to text you already have in your presentation.

a)

True

b)

False

119.

Text in the text box cannot be copied.

a)

True

b)

False

120.

One way to access pictures is through a saved file on your computer.

a)

True

b)

False

121.

What ribbon toolbar would you use to edit a photo?

a)

Slideshow

b)

Design

c)

Insert

d)

Format

122.

There are lots of different ways to insert an image.

a)

True

b)

False

123.

Working in an office can be dangerous.

a)

True

b)

False

124.

What is one hazard of working with a computer?

a)

Carpal Tunnel Syndrome

b)

Stress

c)

Teamwork

d)

Online Time

125.

Posture is not impacted by using a computer

a)

True

b)

False

126.

What are some things your office chair should have?

a)

Adjustable Arms

b)

Ability to swivel

c)

Supports your back

d)

all of these

127.

What is the most common classroom accident?

a)

Spilled drinks

b)

Banana peels

c)

Falls

d)

Dancing

128.

How many filing cabinet drawers should you have open at a time?

a)

All

b)

None

c)

One

d)

Two

129.

Of the following, what is the most helpful thing you can do to prevent eye strain when using a computer?

a)

Increase the screen brightness as much as possible

b)

Reduce glare

c)

Bend over to look at the screen

d)

make the screen blue