wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

DIT EOC

Total questions: 75

Worksheet time: 40mins

Name
Class
Date
1.

Pre-designed and formatted files called ______ help to create new worksheets quickly.

a)

Documents

b)

Templates

c)

Folders

d)

Cell Reference

2.

The electronic spreadsheet made of cells and organized by rows and columns is known as the _____.

a)

Document

b)

Presentaion

c)

Publicaiton

d)

Worksheet

3.

This area tells you the name of the project and the name of the program you have open.

a)

Status Bar

b)

Formula Bar

c)

Title Bar

d)

Quick Access Toolbar

4.

Letters of the alphabet going across the top of the spreadsheet.

a)

Title Bar

b)

Column Labels

c)

Row Labels

d)

Status Bar

5.

Numbers down the left side of the spreadsheet.

a)

Status Bar

b)

Formula Bar

c)

Column Labels

d)

Row Labels

6.

The intersection of a column and a row is called a __________.

a)

Four-way Stop

b)

Formula Bar

c)

Cell

d)

Template

7.

A cell that has a dark border around it.

a)

Jail Cell

b)

Sleepy Cell

c)

Active Cell

d)

Stem Cell

8.

Every cell has its own unique address or _____ _____, which is identified by the specific coordinates of the intersecting column and row.

a)

PO Box

b)

Cell Reference

c)

Status Bar

d)

Formula Bar

9.

The horizontal and vertical lines on the spreadsheet that identify each cell on the spreadsheet are known as the _____.

a)

Cell Blocks

b)

Scroll Bars

c)

Mapping LInes

d)

Grid-lines

10.

A selection of two or more cells is known as a ____.

a)

Cluster

b)

Range

c)

Conglomorate

d)

Big mess

11.

A ____ is another name for an equation used in Excel.

a)

Formula

b)

Calculation

c)

Mode Indicator

d)

Template

12.

Every Excel formula/equation must begin with _____.

a)

an equal sign

b)

please and thank you

c)

cell reference

d)

a prayer

13.

The ____ performs the arithmetic calculations in a formula.

a)

Calculator

b)

Grid-lines

c)

Status Bar

d)

Operator

14.

Numerical data entered into the spreadsheet cells will appear _____ according to place-value.

a)

Magically

b)

Right Aligned

c)

Left Aligned

d)

Centered

15.

Any data (text or numerical) entered into a cell will appear in the active cell as well as in the ____ ____.

a)

Status Bar

b)

Scroll Bar

c)

Outside Window

d)

Formula Bar

16.

The small dot in the lower-right corner of an active cell. It allows you to copy or duplicate information to other cells.

a)

Scroll Box

b)

Fill Handle

c)

Cell Reference

d)

Ribbon Tab

17.

The contents of a worksheet will print across the length of the page in ____ ____.

a)

Landscape Orientaion

b)

Portrait Orientation

c)

7th grade Orientation

d)

Total Disorientation

18.

The contents of a worksheet will print across the width of the page in ____ ____.

a)

Landscape Orientaion

b)

Portrait Orientation

c)

7th grade Orientation

d)

Total Disorientation

19.

If you want to compare parts to the whole, which type of graph/chart would work the best?

a)

Pie

b)

Bar

c)

Column

d)

Line

20.

Which of these will you find on the AutoSum dropdown menu?

a)

All of them

b)

MUL

c)

DIV

d)

SUM

21.

Which of the following is considered a range in Excel?

a)

9B:30C

b)

A1:B8

c)

A1, C22, D14

d)

They are all ranges

22.

Clicking this icon after selecting the range, will result in all selected cells merging into one larger cell.

a)

Merge and Center

b)

Center

c)

Wrap Text

d)

FlashFill

23.

What is the address of this cell?

a)

B3

b)

3B

c)

AB3

d)

None of them is correct

24.

Where do your formulas appear when you type them in a worksheet?

a)

Name Box

b)

Formula Bar

c)

Search Box

d)

Function Bar

25.
Which term describes software programs and services that you access over the Internet?
a)
Network connection
b)
Cloud computing
c)
Applications
d)
Documents
26.
The ability to retrieve files from anywhere at any time is called:
a)
autosave
b)
templates
c)
accessibility
d)
collaboration
27.
Which of the following contains the commands you use often such as Save, Undo, and Redo?
a)
Quick Access Screen
b)
Quick toolbar
c)
Quick Access Toolbar
d)
Quick command
28.

If you can't see the Ruler, select the ______________________ tab, then click the check box next to the Ruler.

a)

Home

b)

Layout

c)

View

d)

Insert

29.

Backstage is accessed by clicking which tab?

a)

File

b)

Home

c)

Insert

d)

View

30.
Before you can format text you must first...
a)
Exit Word
b)
Save your work
c)
Select the text
d)
Rename your document
31.

What does the I button do?

a)

Make text thicker

b)

Underline text

c)

Move the text to the bottom corner of a line

d)

Make the text slant or lean to one side

32.

Heading 1, Emphasis, and Title are all types of

a)

Styles

b)

Text Effects

c)

Character Formats

d)

Themes

33.
Which of the following features removes all formatting from the selected text?
a)
Format Painter
b)
Erase All Formatting
c)
Remove All Formatting
d)
Clear All Formatting
34.

This icon has function to....

a)

Insert picture from our files

b)

Insert picture from internet

c)

Insert ready-made shapes

35.

Function of this icon is....

a)

to create a large capital letter at a beginning of paragraph

b)

to choose where an image will appear on the page

c)

to choose how your text wraps around an image

36.
What is the function of this icon? 
a)
To fill color of shape
b)
To remove (crop picture) any unwanted areas
c)
To insert picture from file
37.

TRUE/FALSE

Insert text from another file by clicking the Insert tab, Object button, then Text from File.

a)

TRUE

b)

FALSE

38.
Page ______ elements include watermarks, page color, and page borders.
a)
cover
b)
design
c)
background
d)
format
39.
A document ____ includes colors, fonts, and effects, that can be customized.
a)
theme
b)
layout
c)
design
d)
column
40.

To change document properties, like add an author, you should: _________.

a)

Click on the Layout tab then the Change Properties button

b)

Click on the File tab, then on Info

c)

Click on the Developer tab and then the Edit button

d)

Click on the File tab and then Options

41.

To protect the document with a password, you should go Backstage and then click on: __________

a)

About

b)

Advanced

c)

Info

d)

Options

42.

The Tab used to Create/Insert a Table into Word.

a)

Insert Tab

b)

Design Tab

c)

Layout Tab

43.

The Tab to use to Insert Rows and Columns above and below and to insert columns on the left and right

a)

Insert Tab

b)

Layout Tab

c)

Design Tab

d)

Home Tab

44.

Allows you to sort text from Z to A or largest to smallest

a)

Split Sort

b)

Ascending Sort

c)

Descending Sort

d)

Merge Sort

45.

The Tab to use to change Table Styles, Shading, and Borders

a)

Home Tab

b)

Insert Tab

c)

LayoutTab

d)

Design Tab

46.

The feature that combines or joins cells together in a table.

a)

Split Cells

b)

Merge Cells

c)

Distribute Rows

d)

Distribute Columns

47.
It allows you to look at your presentation in different ways.
a)
Review Tab
b)
View Tab
c)
Show Tab
d)
Look Tab
48.
This tab set up the way that you want to show your presentation to others.
a)
Slide Show
b)
Master Slide
c)
Slide Navigation Pane
d)
Slide
49.
It sets up how your slides change from one to the next.
a)
Transition Tab
b)
Edit Tab
c)
Animation Tab
d)
Slide Tab
50.
This tab use to choreograph the movement of things on your slides.
a)
Transition Tab
b)
Design Tab
c)
Animation Tab
d)
Tools Tab
51.
This tab lets you add comments, run spell-check or compare one presentation w/ another version.
a)
Comments
b)
Notes
c)
Spell-check
d)
Review
52.
 It allows you to create dynamic slide presentations.
a)
Slide Presentation
b)
Tools
c)
Insert
d)
PowerPoint Presentation
53.

_____________________ is a presentation software.

a)

Microsoft Word

b)

Microsoft Excel

c)

Microsoft PowerPoint

d)

Microsoft Paint

54.

_____________________ is the method of arranging things or objects on a slide.

a)

Layout

b)

Object

c)

Smart Lookup

d)

Comments

55.

______________ is the shortcut to paste an object.

a)

Ctrl + C

b)

Ctrl + X

c)

Ctrl + S

d)

Ctrl + V

56.

__________________ key is used to end the slide show.

a)

Ctrl

b)

Shift

c)

Esc

d)

Alt

57.

The ___________________ view is used to hide or show the text levels in PowerPoint presentation.

a)

Slide Sorter

b)

Outline

c)

Slide Show

d)

Reading View

58.

A ________________ is a type of note that can be added to a text, object or to an entire slide of PowerPoint presentation.

a)

View

b)

Comment

c)

Smart Lookup

d)

Photo Album

59.

_____________________ view allows all the slides in the presentation at the same time, in miniature form.

a)

Reading

b)

Slide Show

c)

Slide Sorter

d)

Outline

60.

___________________ key combination takes us to the beginning of the presentation.

a)

Page Up

b)

Page Down

c)

Ctrl + End

d)

Ctrl + Home

61.

__________________ option collapses the entire data of each slide to the slide's Title, making our work easier.

a)

Demote

b)

Collapse

c)

Promote

d)

Expand

62.

______________________ is the shortcut key to start the slide show.

a)

F1

b)

F3

c)

F5

d)

F7

63.

_____________, _______________, ________________ and _____________ are the four available office themes in MS PowerPoint.

a)

Colourful, white, black, dark gray

b)

Red, green, white, blue

c)

Gray, white, black, brown

d)

Colourful, white, black, red

64.

The Apply Design Template command is used to:

a)

Change the order of the slides

b)

Change the shape of the slides

c)

Change the background and fonts of the entire presentation.

d)

Create a new, empty presentation.

65.

You can re-arrange slides in:

a)

Slide view

b)

Sorter view

c)

Notes Page View

d)

Slide Show View

66.

Using a custom animation effect, how do you make text appear on a slide letter by letter?

a)

Apply the animation scheme Fade in one by one.

b)

Apply an entrance effect, and then set it to By letter in the Effect Options dialog box.

c)

Apply the Fly In entrance effect to the text, and then set its speed to Very Slow.

67.

In outline view you can:

a)

Move slides

b)

Edit slides

c)

Create a new slide

d)

All of above

68.

Holly created a membership presentation in the most current version of PowerPoint. She wants to make sure that all features of her presentation will be visible in older versions of the software. Which specific feature would she use?

a)

check for compatibility

b)

check for accessibility

69.

Owen wants to look for hidden properties and personal information in a presentation that he created. Which feature would he use?

a)

inspect the document

b)

check for issues

70.

Garrett is sending his presentation to the national FBLA office and wants to ensure its integrity. What feature should he use in his presentation?

a)

Add a Digital Signature

b)

Mark as Final

71.

The relationship of width to height in a picture, shape, or slide

a)

Aspect Ratio

b)

Orientation

c)

Custom Show

d)

Ink

72.

Refers to the number of pixels that makes up a slide display on the monitor and is applicable only in Slide Show view

a)

Resolution

b)

Slide Size

c)

Landscape Orientation

d)

Portrait Orientation

73.

Mrs. Thomas, FBLA state adviser, wants to remove hidden properties and personal information in a PowerPoint she is sending. Which feature should she use?

a)

Check for Issues

b)

Check for Accessibility

c)

Check for Compatibility

d)

Inspect the Document

74.
One of Janice's presentation slides has content that is taller than it is wide. Which command on the design tab would she use to change this?
a)
Background
b)
Page Setup
c)
Slide Orientation
d)
Themes
75.
Which command is used to test animations on a slide before delivering the presentation?
a)
Rehearse
b)
Preview
c)
Test
d)
Review