wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

MS Excel Test #1

Total questions: 45

Worksheet time: 23mins

Name
Class
Date
1.

What is a cell in MS Excel?

a)

It is the rectangle at the intersection of a row and column on a spreadsheet.

b)

It is a highlighted rectangular box.

c)

It is an expression which calculates the value of a cell.

d)

It is a feature that allows the user to extend a series of numbers, dates, or text to have the amount of wanted cells.

2.
Where is a name box and what does it do?
a)
It is a box to the right of the formula bar that displays the cell that is currently selected in the spreadsheet.
b)
It is a toolbar at the top of MS Excel spreadsheet .window that you can use to enter or copy an existing formula into the cells or charts.
c)
It is a box to the left of the formula bar that displays the cell reference of the cell that is currently selected.
d)
It is a single spreadsheet that contains cells organized by rows and columns.
3.

What function will copy the formula across the adjacent cells?

a)

Formula

b)

Cell reference

c)

Active cell

d)

Fill handle

4.
A formula is a mathematical expression which calculates the value of a(n) _________.
a)
Chart
b)
Active Cell
c)
Cell(s)
d)
Number(s)
5.

What is a workbook?

a)

It is the information you enter into a spreadsheet.

b)

An Excel file that contains one or more worksheets.

c)

It is a highlighted rectangular box.

d)

None of the answers

6.
When MS Excel puts a bold border around a rectangular box, it is considered a(n) __________________.
a)
Range
b)
Active cell
c)
Formula
d)
Cell reference
7.
What is the purpose for using conditional formatting?
a)
To use a formatting that is applied to a cell when a specified condition is met.
b)
To copy the contents of a cell to adjacent cells
c)
To display the active cell's contents.
d)
None of the answers
8.

When you have an Excel file with one or more worksheets, the document is called a(n) _____________.

a)

Portfolio

b)

Agenda

c)

Book

d)

Workbook

9.
The data that is inside a cell in considered _____________________.
a)
Cell Data
b)
Cell Contents
c)
Active Cell
d)
Formats
10.
A2, B3, and D6 are all examples of what?
a)
Cell names
b)
Cell data
c)
Cell filters
d)
Cell references
11.
What is shown in the Formula Bar?
a)
Active cell contents
b)
Active cell formulas
c)
Active cell data
d)
All the answers
12.

How is an active cell different than just a cell?

a)

Formula

b)

Content

c)

Bold Border

d)

None of the answers

13.
What type of program is MS Excel?
a)
Word processing
b)
Presentation
c)
Graphic
d)
Spreadsheet
14.
What kind of business activities could you use MS Excel for?
a)
Accounting
b)
Database
c)
Calculations
d)
All the answers
15.
What does the cursor look like when using the fill handle?
a)
Thick plus sign
b)
Thin plus sign
c)
Four arrows
d)
Arrow
16.
What ribbon do you find conditional formatting?
a)
Home
b)
Page Layout
c)
Insert
d)
Design
17.
What number format do you use for money?
a)
General
b)
Number
c)
Currency
d)
Decimal
18.
What is the main purpose people use MS Excel?
a)
Write a letter to business associates
b)
Keep track of your emails
c)
Organize data and make calculations quicker and easier
d)
Develop a presentation
19.
What starts an equation?
a)
Parenthesis 
b)
Quote marks
c)
Cell reference
d)
Equal sign
20.
What ribbon is themes?
a)
Layout
b)
Design
c)
Data
d)
Home
21.

How do you double underline a cell with text content?

a)

Double border

b)

Double underline

c)

Cell styles

d)

All the answers

22.
What dialogue box do you open to format the date?
a)
Paragraph
b)
Format Cells
c)
Font
d)
Print
23.

Which ribbon can you add a picture to a file?

a)

Home

b)

Insert

c)

View

d)

References

24.

How do you make the cell automatically wide enough for the contents?

a)

Double click on the line between the column headings.

b)

Wrap text

c)

Merge cells

d)

None of the answers

25.

What does it mean when you have just number signs "#" in the cell?

a)

You have the wrong data.

b)

The cell contains information that shouldn't be seen.

c)

The cell is too small.

d)

The cell is incorrectly formatted.

26.

How do you insert Greek letters into a document?

a)

Use symbols

b)

Change the language of the file to Greek.

c)

You can't.

d)

All of the above

27.

How do you change the look of the whole document?

a)

Cell styles

b)

Themes/Design

c)

Widening the cells

d)

Adding a picture

28.

What do you add when you want a section of the spreadsheet to show the lines of your table?

a)

Shapes

b)

Underline

c)

Borders

d)

None of the answers

29.

How do you design a table with a color scheme or design in one step?

a)

Widening the cell

b)

Selecting a theme

c)

Design styles

d)

Table styles

30.

What symbol do you use in a formula to divide?

a)

+

b)

-

c)

/

d)

*

31.

What does it show in the name box?

a)

Your name

b)

Column letter and row number of the selected cell

c)

Title of the document

d)

None of the answers

32.

What do you use AutoSum for?

a)

Multiply a range of cells

b)

Divide a range of cells

c)

Add the adjacent a range of cells

33.

What is a range of cells?

a)

A group of touching cells

b)

A bunch of cells not related

c)

A document

d)

A colored theme

34.

Which ribbon do you find themes?

a)

Home

b)

Insert

c)

Page Layout

d)

References

35.

Which ribbon do you find your number formats?

a)

Home

b)

Insert

c)

Page Layout

d)

Data

36.

What is the path to insert a Header?

a)

Page Layout, Header

b)

Home, text, Header

c)

Insert, text, Header

d)

None of the answers

37.

What do you do to protect your document?

a)

Encrypt with a password

b)

Add code words

c)

Don't give out the file name

d)

Manage a document

38.

When should you save a document/file?

a)

When class is over.

b)

When you start the document and every 15 minutes there after.

c)

Every 30 minutes

d)

Only if you decide to close the program.

39.

How do you locate a cell on a spreadsheet?

a)

By its coordinates

b)

By its cell reference

c)

By the column letter and row number

d)

All the answers

40.

How can you wrap two lines of text within a cell?

a)

Format the cell with two lines

b)

Use wrap text

c)

Paragraph

d)

Use design document

41.

What happens when you text is too long for the cell?

a)

The text is cut off when the adjacent cell is used.

b)

The text automatically wraps.

c)

The cell will automatically widen.

d)

The cell will show error message.

42.

What view will let you see the header and footer?

a)

Normal view

b)

Page break view

c)

Page layout view

d)

Custom view

43.

Which number format DOES NOT automatically puts in the dollar sign "$"?

a)

Currency

b)

General

c)

Accounting format

d)

None of the answers

44.

How many decimal places do you need when inputting a money amount that includes coins?

a)

One decimal

b)

Two decimal

c)

Three decimal

d)

No decimal

45.

The formula =(B3+C3+D3+E3)/4 is looking for what?

a)

Average

b)

Total

c)

Percentage

Similar Resources on Wayground

XII MM [DESAIN MULTIMEDIA INTERAKTIF] PAS

40 questions

XII MM [DESAIN MULTIMEDIA INTERAKTIF] PAS

quiz

Worksheet

•

12th Grade

TABLAS EN WORD

45 questions

TABLAS EN WORD

quiz

Worksheet

•

6th - 12th Grade

HAM_LEFT_RIGHT_MID_INT_MOD_COUNT_RANK_ROUND_VLOOKUP_HLOOKUP_SQRT

50 questions

HAM_LEFT_RIGHT_MID_INT_MOD_COUNT_RANK_ROUND_VLOOKUP_HLOOKUP_SQRT

quiz

Worksheet

•

11th Grade

Ulangan Harian Bab V TIK Kelas XI

50 questions

Ulangan Harian Bab V TIK Kelas XI

quiz

Worksheet

•

11th Grade

KUIZ TMK TAHUN 6

40 questions

KUIZ TMK TAHUN 6

quiz

Worksheet

•

12th Grade

Quiz TIK

45 questions

Quiz TIK

quiz

Worksheet

•

12th Grade

Microsoft Word Tekrar

50 questions

Microsoft Word Tekrar

quiz

Worksheet

•

9th - 12th Grade

ÔN TẬP HK1

50 questions

ÔN TẬP HK1

quiz

Worksheet

•

12th Grade