wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Digital Literacy Common Assessment (Mid-term Exam) Review

Total questions: 80

Worksheet time: 1hrs 1mins

Name
Class
Date
1.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
2.
To create a formula, you first:
a)
Select the cell you want to place the formula into
b)
Type the equals sign (=) to tell Excel that you're about to enter a formula
c)
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
d)
Choose the new command from the file menu
3.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
4.
You can edit a cell by...
a)
Clicking the formula button
b)
Double clicking the cell
c)
Selecting Edit>Edit Cell from the menu
d)
None of above
5.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
6.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
7.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
8.
Which of the following formulas is not entered correctly?
a)
=10+50
b)
=B7+B8
c)
=B7+14
d)
10+50
9.
Which of the following formulas will Excel not be able to calculate?
a)
=SUM(Sales)-A3
b)
=SUM(A1:A5)*0.5
c)
=SUM(A1:A5)/(10-10)
d)
=SUM(A1:A5)-10
10.
Columns go...
a)
Across
b)
Down
11.
Rows go...
a)
Across
b)
Down
12.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
13.

Which of these symbols is used for divide on a computer?

a)

\

b)

*

c)

/

d)

|

14.
A cell name contains
a)
Cell name
b)
Column numbers and row letters
c)
Column letters and row numbers
d)
Cell locator coordinates
15.
When adding more than two cells together you can use the following . . .
a)
=SUM(B1:B4)
b)
=ADD(B1:B4)
c)
=TOTAL(B1:B4)
16.
To put names into alphabetical order use ...
a)
Filter
b)
Format
c)
Define
d)
Sort
17.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
18.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
19.
If your document will not fit on one page, you can always print it in
a)
Portrait
b)
Landscape
20.

What is this known as altogether?

a)

Tab

b)

Cell

c)

Column

d)

Ribbon

21.

Label the given picture.

a)

Name box

b)

Formula box

c)

Cell name

d)

None of these

22.

Is this feature of Auto fill is available in MS Excel 2016 ?

a)

Yes

b)

No

23.

In Excel, pre-defined formulas with a specific syntax pattern are called:

a)

Formulas

b)

Factors

c)

Functions

d)

Operations

e)

Calculations

24.

What symbol do we use in Excel to multiply?

a)

*

b)

-

c)

+

d)

/

25.

How would we multiply the value of cell A1 by the value of cell B3?

a)

=TIMES(A1:B3)

b)

A1xB3

c)

=A1*B3

d)

A1*B3

26.
What is the name of the cell that is selected? 
a)
B6
b)
6B
c)
6
d)
B
27.
Where is the formula bar located? 
a)
Top of screen
b)
Bottom of screen
c)
There is a formula bar? 
d)
Cyberspace
28.

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

a)

A1-C3

b)

A1-C3=

c)

=A1-C3

d)

=C3-A1

29.
You can only work in one cell at a time. The actual cell that you are working in is called what?
a)
Column
b)
Name Box
c)
Active Cell
d)
Row
30.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
31.
When entering numbers in  Excel, they are automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
32.
Cells are identified by the following:
a)
Column Letter followed by their Row Number
b)
Row Number followed by their Column Letter
c)
Row Number Only
d)
Column Letter Only
33.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
34.

What performs a calculation in a spreadsheet?

a)

formula

b)

function

c)

add

d)

multiply

35.
SUM, AVERAGE are examples of what?
a)
Functions
b)
Tables
c)
Formulas
d)
Statistical tools
36.
Excel is part of?
a)
Power Point
b)
Microsoft Office Suite
c)
Access
d)
Google
37.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
38.
What is the active cell in this picture? 
a)
A1
b)
D3
c)
B4
d)
C4
39.
Completes previously typed words when you begin to repeat the typing. 
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
40.

The dateline in a Personal Business Letter is located a SS below the

a)

Salutation

b)

Complimentary Close

c)

Return Address

d)

Letter Address

41.

The spacing within the paragraphs in the body of the Personal Business are

a)

Single Space (SS)

b)

Double Space (DS)

c)

Triple Space (TS)

d)

Quadruple Space (QS)

42.

When all the parts of a Personal Business Letter start at the Left Margin, the document is keyed in which format

a)

Modified Block Format

b)

Block Format

c)

Open Format

d)

Closed Format

43.

Which one of the following is the correct format for using reference intitials

a)

R.I.

b)

Ri

c)

ri

d)

r.i.

44.

The complimentary close is a DS below which part of the Personal Business Letter

a)

Letter Address

b)

Last line of the body

c)

Writer's Name

d)

Return Address

45.

The letter address is located a QS below from which part of the Personal Business Letter

a)

Return Address

b)

Dateline

c)

Complimentary Close

d)

Salutation

46.

How many spaces are there between the Reference Initials and Enclosure/Attachment Notation

a)

Single Space (SS)

b)

Double Space (DS)

c)

Triple Space (TS)

d)

Quadruple Space (QS)

47.

The top margin for a Personal Business Letter is what

a)

1"

b)

1.5"

c)

2"

d)

2.5"

48.

The name of the writer is located how spaces below the complimentary close in a Personal Business Letter

a)

Single Space (SS)

b)

Double Space (DS)

c)

Triple Space (TS)

d)

Quadruple Space (QS)

49.

Which is the proper way to key the Dateline in a MEMO

a)

10-16-18

b)

10/16/18

c)

October 16th 2018

d)

October 16, 2018

50.

When there are no punctuation marks after the salutation or complimentary close in a Personal Business Letter it is called

a)

Open punctution

b)

Mixed punctuation

c)

No punctuation

d)

Fixed punctuation

51.

Which is the proper way to format the SUBJECT LINE information

a)

Subject Line Information

b)

SUBJECT LINE INFORMATION

c)

subject line information

d)

SUBJECT Line information

52.

How many spaces are there between the headings when formatting a MEMO

a)

Single Space (SS)

b)

Double Space (DS)

c)

Triple Space (TS)

d)

Quadruple Space (QS)

53.

When formatting a Memo the body paragraphs have a __________ space between paragraphs

a)

Single Space (SS)

b)

Double Space (DS)

c)

Triple Space (TS)

d)

Quadruple Space (QS)

54.

If someone other than the originator of the memo keys the document, you should use

a)

Writer's Name

b)

Writer's Initials

c)

Writer's Address

d)

Reference Initials

55.

The Headings in Memos are keyed in

a)

All Upper Case Letters

b)

Lowercase Letters

c)

Upper and Lowercase Letters

d)

Mixed fonts

56.

The spacing between the Memo Heading and Body is

a)

Single Space (SS)

b)

Double Space (DS)

c)

Triple Space (TS)

d)

Quadruple Space (QS)

57.

The spacing between the Body of the MEMO and the Reference Initials is

a)

Single Space (SS)

b)

Double Space (DS)

c)

Triple Space (TS)

d)

Quadruple Space (QS)

58.

If a document accompanies the memo but is not attached to it you should use which notation

a)

Attachment Notation

b)

Enclosure Notation

c)

Accompany Notation

d)

No notation is required

59.

The Attachment/Enclosure Notation is keyed a _________ space below the reference initials if used in a MEMO

a)

Single Space (SS)

b)

Double Space (DS)

c)

Triple Space (TS)

d)

Quadruple Space (QS)

60.

The side margins for an Unbound Report are

a)

1"

b)

1.5"

c)

2"

d)

0.5"

61.

The bottom margin in an Unbound Report is

a)

0.5"

b)

1"

c)

1.5"

d)

2"

62.

Which is the correct format of a title for an Unbound Report

a)

Unbound Report Title

b)

unbound report title

c)

UNBOUND REPORT TITLE

d)

UNbound REport TItle

63.

First lines of paragraphs in an Unbound Report are

a)

Indented

b)

Blocked

c)

Placed at Left Margin

d)

Centered on the page

64.

References for an Unbound Report are keyed

a)

On a separate page

b)

Double Space (DS) after the last line of the body

c)

Quadruple Space (QS) after the last line of the body

d)

At the end of the first page

65.

Where is the page number for the first page located for an Unbound Report

a)

At the Right Margin 2" mark

b)

At the Right Margin 1" mark

c)

At the Right Margin .5" mark

d)

None of the Above

66.

The correct spacing used for the paragraphs of an Unbound Report are

a)

Single Space (SS)

b)

Double Space (DS)

c)

Triple Space (TS)

d)

Quadruple Space (QS)

67.

When formatting the references for the Reference Page they should be keyed

a)

Single Space within/Double Space after

b)

Double Space within/Double Space after

c)

Double Space within/Single Space after

d)

Single Space within/Single Space after

68.

When formatting the references used for the Reference page which line should be indented

a)

The first line of the reference

b)

The second line of the reference

c)

No indention is required

d)

None of the Above

69.
What is an interoffice memorandum?
a)
a written message used within an organization to communicate with one another
b)
an audio message used by employees within an organization to communicate with one another
c)
a written message used by people outside the organization to communicate with one another
d)
an audio message used by friends to communicate with one another
70.
Which of the following is the correct format for reference initials?
a)
O.C.
b)
oc
c)
Oc
d)
OC
71.
The ___ line is who the memo is addressed to.
a)
TO:
b)
FROM:
c)
DATE:
d)
SUBJECT:
72.
The spacing for the heading is:
a)
single spaced
b)
double spaced
c)
triple spaced
d)
quadruple spaced
73.
The ___ line is when the memo is written.
a)
DATE:
b)
FROM:
c)
TO:
d)
SUBJECT:
74.
The ___ line is who authored the memo.
a)
TO:
b)
FROM:
c)
DATE:
d)
SUBJECT:
75.
Which of the following is not found in the heading of a memo?
a)
To
b)
From
c)
Subject
d)
Initials
76.
A special notation at the of a memo or letter that indicates that an item(s) is attached to the letter or memo.
a)
Attachment
b)
Enclosure
c)
Copy Notation
d)
Typist Initials
77.
The main text of a personal letter, business letter, memo, email, or report. 
a)
Attachment
b)
Body
c)
Enclosure
d)
Typist Initials
78.
If someone other than the originator types the memo you must include...
a)
Reference initials
b)
Name of typest
c)
Author
d)
None of the above
79.

How do we key the subject line's information?

a)

All Caps

b)

All Lowercase

c)

Upper and Lowercase

d)

It doesn't matter

80.

When changing the spacing before and after each character you should have the number set on what?

a)

Auto

b)

0 pt

c)

6 pt

d)

12 pt

Similar Resources on Wayground

Excel 2016 1.01- 1.07

83 questions

Excel 2016 1.01- 1.07

quiz

Worksheet

•

9th - 12th Grade

Employability Skills Passport

76 questions

Employability Skills Passport

quiz

Worksheet

•

7th Grade - University

Business Studies End of Easter Term Quiz

80 questions

Business Studies End of Easter Term Quiz

quiz

Worksheet

•

9th Grade

Credit Unit Test

77 questions

Credit Unit Test

quiz

Worksheet

•

9th - 12th Grade

Career Planning and Development

80 questions

Career Planning and Development

quiz

Worksheet

•

9th Grade

9D - Angel Miller 6 11 2023

75 questions

9D - Angel Miller 6 11 2023

quiz

Worksheet

•

9th - 12th Grade

EntI_EOQ_1st 9wks_4th Block

80 questions

EntI_EOQ_1st 9wks_4th Block

quiz

Worksheet

•

9th - 12th Grade

Technical Writing First Unit Test

85 questions

Technical Writing First Unit Test

quiz

Worksheet

•

9th Grade