wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Form # Word and Excel

Total questions: 60

Worksheet time: 39mins

Name
Class
Date
1.

what does Microsoft Word create ?

a)

Documents

b)

Spreadsheets

c)

Publications

d)

Presentations

2.

This contains all of the commands you'll need in order to perform common tasks.

a)

Header

b)

Save

c)

Ribbon

d)

Red Line

3.

The process of naming, saving and storing files.

a)

Save

b)

Edit

c)

Save As

d)

File Management

4.

To save a document, which tab would you click on?

a)

Insert

b)

Page Layout

c)

File

d)

View

5.

To change the color of the text, you would ____________.

a)

Click on the B

b)

Click on the Paint Brush that's not even in the font box

c)

Click on the A with a red line under it.

d)

Click on the ab with a yellow line under it.

6.

The black blinking line that shows where you will type is called a(n) __________.

a)

Arrow

b)

Beam

c)

Tab

d)

Cursor

7.

11 is the __________.

a)

Font Size

b)

Type Face

c)

Font Type

d)

Text Size

8.

When you are editing a document you are __________.

a)

creating new content

b)

correcting or modifying a document

c)

copying someone else's content

d)

none of the above

9.

This is located above the ribbon and offers shortcuts to commonly used tasks

a)

Backstage

b)

Status Bar

c)

Ribbon

d)

Quick Access Toolbar

10.

A horizontal bar, typically at the bottom of the screen or window, showing information about a document being edited or a program running.

a)

Spelling and Grammar

b)

Status

c)

Undo

d)

Ribbon

11.

The Spelling and Grammar feature is located on which tab?

a)

File

b)

Review

c)

Insert

d)

References

12.

Which keyboard shortcut can you use to save a file?

a)

CTRL + S

b)

CTRL + X

c)

CTRL + V

d)

CTRL + Z

13.

Which is a tab common to Word, Excel and Powerpoint?

a)

Animations

b)

Slides

c)

File

d)

Formulas

14.

What button reverses the most previous action?

a)

Review

b)

Undo

c)

Redo

d)

Delete or Backspace

15.

Most Microsoft Office Programs have this in common.

a)

They have presentation tabs.

b)

They all have the exact same tab names

c)

They have cloud based storage

d)

They have the Ribbon.

16.

Microsoft Excel is what kind of software?

a)

Word Processing Software

b)

Spreadsheet Software

c)

Database Software

d)

Presentation Software

17.

An Excel file format extension is

a)

doc

b)

xls

c)

txt

d)

mp3

18.

The numbers in Excel represent the...

a)

Rows

b)

Columns

c)

Cells

d)

Data

19.

When creating a chart in Excel, what is the first thing you need to do?

a)

Select the data to be graphed.

b)

Select the Insert Tab

c)

Choose a chart from the ribbon

d)

Double click the active cell

20.

To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.

a)

&

b)

=

c)

#

d)

*

21.

What function adds all of the numbers in a range of cells?

a)

Calculate

b)

Compute

c)

Sum

d)

Max

22.

To sort data in Excel, go to the __________ ribbon.

a)

Home

b)

Data

c)

Insert

d)

View

23.

What does the mouse look like in a spreadsheet?

a)

Arrow

b)

Pointer

c)

Two headed arrow

d)

Selection cross

24.

If I want to find an average of cells A1 through A25, which formula would I use?

a)

=average(A1:A25)

b)

=avg(A1:A25)

c)

=average(A1-A25)

d)

=avg(A1-A25)

25.
Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this? 
a)
=(A1+A2+A3)/4
b)
A1+A2+A3/4
c)
=A1+A2+A3^4
d)
(A1+A2) + A3/4
26.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
27.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
28.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
29.
What button will add up a group of numbers
a)
Equals button
b)
Plus symbol button
c)
Auto-sum button
30.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
31.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
32.
When inserting a formula, always start with
a)
equals symbol
b)
plus symbol
c)
minus symbol
33.
What kind of chart should you use to show the pieces (percentages) of a whole
a)
Bar Chart
b)
Column Chart
c)
Pie Chart
34.
Excel is part of
a)
Access
b)
Microsoft Office
c)
PowerPoint
35.
To allow you to evenly distribute a title over a table of numbers, use the
a)
Center button
b)
Merge and Center button
c)
Merge cells only button
36.
If you see a series of "######" in a cell, that means the following:
a)
You keyed in an incorrect number
b)
The row height is too high
c)
The text is incorrectly spelled
d)
The column width is not wide enough
37.
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
38.

What is the purpose of the Count function in Excel?

a)

Determines the largest value in the range of cells

b)

Counts the numeric values in a range

c)

Calculates the mean or average of a group of numbers

d)

Calculates the total in a range of cells

39.

What is the purpose of the Max function in Excel?

a)

Determines the smallest value in the range of cells

b)

Determines the largest value in the range of cells

c)

Calculates the mean or average of a group of numbers

d)

Calculates the total in a range of cells

40.

What is the purpose of the Sum button in Excel?

a)

Increase the decimal positions

b)

Automatically add a range of cells without typing a formula

c)

Change values to percentages

d)

Merge several cells into one and center the text

41.

What is the purpose of the Chart button in Excel?

a)

Change values into dollars and cents

b)

Automatically add a range of cells without typing a formula

c)

Merge several cells into one and center the text

d)

Create visual representation of data stored in a range of cells

42.
When entering numbers in  Excel, they are automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
43.
Rows in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside Down
d)
Right Side
44.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
45.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
46.
Which of these formulas will find the correct average of the cells?
a)
=AVERAGE(A1:A10)
b)
=MEAN(A1:A10)
c)
AVERAGE(A1:A10)
d)
=(A1+A2+A3+A4+A5+A6+A7+A8+A9+A10)/10
47.
4) Study the orange circled area of the worksheet in the image below.  Which of the following best describes the function of this area?
 
 
   
 
a)
a) The Name Box displays a name given to a cell or set of cells. 
b)
b) The Name Box reflects the contents of the first cell that is selected in a range. 
c)
c) The Name Box gives you options for duplicating the selected cells.
d)
d) All of the above options are correct. 
48.
5) The Formula Bar is the block located above the grid in a worksheet and preceded by the letters fx. Which of the following comments about the Formula Bar is NOT correct:  
 
   
 
  
a)
a) The Formula Bar is only used to create formulas by pressing the fx located to the left of the box.
b)
b) The Formula Bar contains the contents of the cell you have selected.
c)
c) You can type numbers or text directly into the formula bar. 
d)
d) You can edit words or numbers contained in selected cells in the Formula Bar. 
49.
8) Study the section of a worksheet in the image below.  What is the cell address of the cell containing the word "Qtr3"?
 
 
 
   
a)
a) The cell address is D1 
b)
b) The cell address is E 5 
c)
c) The cell address is D 4 
d)
d) The cell address is D 5
50.
Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this? 
a)
=(A1+A2+A3)/4
b)
A1+A2+A3/4
c)
=A1+A2+A3^4
d)
(A1+A2) + A3/4
51.

Microsoft Word is which type of program

a)

Spreadsheet

b)

Typing Program

c)

Word processor

d)

Database

52.

Timmy wants to create a brochure highlighting the new pastry shop he opened. He doesn't want to design the brochure from the start. Timmy can use

a)

A document already created by his friend

b)

A Word template

c)

A photocopy of a flyer

d)

A new blank document

53.

Which job is NOT suitable for Microsoft Word ?

a)

Creating an Accounts system that automatically calculates profit and loss

b)

Writing a research paper including pictures and graphs

c)

Typing up a homework assignment

d)

Creating a flyer to advertise a bake sale

54.

Which best describes a Font ?

a)

The colour of the text on screen

b)

The alignment of the text

c)

The style of the text

d)

The images in a document

55.

Which of the following is TRUE about a header or footer

a)

They have to be created on each page separately

b)

They can be created once and then appears on every page

c)

You cannot places images into a header / footer

d)

They cannot hold page numbers

56.

The justify alignment

a)

Places the text to the right of the page

b)

Places the text to the left of the page

c)

Places the text between the top and bottom margins

d)

Places the text evenly between the left and right margins

57.

When anything has to be done to text on a document it must first

a)

Be Underlined

b)

Be highlighted

c)

Be capitalized

d)

Be in a table

58.

Copy and Paste is

a)

An Edit function

b)

A Layout Function

c)

A Page function

d)

A Design Function

59.

Which one of the following can indicate a spelling error

a)

Red strike through

b)

Red underline

c)

Blue Strike Through

d)

Blue Underline

60.

What are the correct steps to copy and paste a line of text from the top of the page to the bottom?

a)

1. Highlight the text

2. Click copy

3. Move to the end of the document and click paste

b)

1. Move to the end of the document and click paste

2. Highlight the text

3. Click copy

c)

1.. Click copy

2. Move to the end of the document and click paste

3. Highlight the text

d)

1. Move to the end of the document and click paste

2. Click copy

3. Highlight the text

Similar Resources on Wayground

IC3_GS6_LV2

60 questions

IC3_GS6_LV2

quiz

Worksheet

•

7th Grade - University

Computer Safety and Security - 2

65 questions

Computer Safety and Security - 2

quiz

Worksheet

•

7th - 8th Grade

Đề cương ôn tập giữa kỳ 2 môn Tin học 7 Năm học 2023-2024

55 questions

Đề cương ôn tập giữa kỳ 2 môn Tin học 7 Năm học 2023-2024

quiz

Worksheet

•

7th Grade

History of technology

60 questions

History of technology

quiz

Worksheet

•

7th - 9th Grade

Chu de 1 Tin 7 (2)

60 questions

Chu de 1 Tin 7 (2)

quiz

Worksheet

•

7th Grade

Ôn tập Tin học 3 học kỳ 2

58 questions

Ôn tập Tin học 3 học kỳ 2

quiz

Worksheet

•

4th Grade - University

TIN 6- CÂU HỎI ÔN TẬP GK1

60 questions

TIN 6- CÂU HỎI ÔN TẬP GK1

quiz

Worksheet

•

6th Grade - University

Equipos de Reprografía

55 questions

Equipos de Reprografía

quiz

Worksheet

•

6th - 12th Grade