wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

EXCEL QUIZ 1.

Total questions: 38

Worksheet time: 22mins

Name
Class
Date
1.

How is the COLUMN in a MS Excel Spreadsheet named?

a)

Numbers

b)

Letters

c)

Cells

d)

Columns

2.

How are ROWS in MS EXCEL spreadsheet named?

a)

numbers

b)

letters

c)

cells

d)

columns

3.

What is a rectangular box in a MS EXCEL Spreadsheet called?

a)

row

b)

column

c)

cell

4.

What is the name of the cell that is colored blue?

a)

A

b)

B

c)

2B

d)

B2

5.
What kind of software program is Microsoft Excel?
a)
presentation program
b)
database program
c)
word processing program
d)
spreadsheet program
6.
What do you call files you are working with in Excel?
a)
queries
b)
slides
c)
workbooks
d)
documents
7.
Identify the highlighted area:
a)
name box
b)
formula bar
c)
worksheet
d)
cell
8.
Identify the highlighted area:
a)
name box
b)
formula bar
c)
worksheet
d)
cell
9.
Identify the highlighted area:
a)
formula bar
b)
name box
c)
cell
d)
worksheet
10.
Which view is the default view of all worksheets in Excel?
a)
Normal View
b)
Page Layout View
c)
Page Break View
d)
Worksheet View
11.
In Excel, which View can you add headers and footers?
a)
Normal View
b)
Page Break View
c)
Worksheet View
d)
Page Layout View
12.
What best describes AutoRecover:
a)
Undoes the last task
b)
Makes a print copy
c)
Saves a copy of the last workbook
d)
Returns to a previous state
13.

A cell is a...

a)

area where columns and rows intersect

b)

grid made of columns and rows

14.

The highlighted region of the picture below is a:

a)

Active Cell

b)

Cell Name

15.

What tool is in number 3?

a)
b)
c)
d)
16.

What tool is in number 6?

a)

Copy

b)

Center

c)

Font

d)

Wrap text

17.

An arrow in the lower-right corner of a group on the ribbon tells you that which of the following is available?

a)

a dialog box or task pane

b)

an additional workbook

c)

a list of worksheets

d)

An additional part of the current range

18.

Which feature enables you to preview headers and footers, page breaks, and other features that will print?

a)

Page Layout

b)

Print Layout

c)

Synchronous Scrolling

d)

Screenips

19.

How many worksheets does a new Excel workbook open with?

a)

one

b)

two

c)

three

d)

four

20.

Page Layout view is useful when preparing your data for printing.

a)

True

b)

False

21.

Which of the following is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series?

a)

Cell pointer

b)

Column marker

c)

Fill handle

d)

Formula Bar

22.

Which of the following can you drag or double-click to change the width of a column?

a)

Cell pointer

b)

Column marker

c)

Fill handle

d)

Formula bar

23.

The formula bar is found at the bottom of the Excel window.

a)

True

b)

False

24.

Which of the following is where you can save, select a template, change document properties, and close or exit Excel?

a)

Backstage

b)

Print

c)

Edit

d)

Windows

25.

To change printer, layout, or margin settings, you click the File tab and use which of the following options?

a)

Info

b)

Options

c)

Print

d)

Open

26.

To access an Excel template, you can click the File tab and then click New.

a)

True

b)

False

27.

If you have too many columns on a page, the only option to display them all on a printed page is to decrease the column width.

a)

True

b)

False

28.

What kind of software is Excel?

a)

Spreadsheet software

b)

Word Processing

c)

Drawing

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.
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
31.
When entering text in Excel, it is automatically (by default):
a)
Left Justified
b)
Right Justified
c)
Center Justified
d)
Full Justified
32.
Columns in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside down
d)
right side
33.
Rows in a spreadsheet are:
a)
Vertical
b)
Horizontal
c)
Upside Down
d)
Right Side
34.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
35.
An Excel file that contains an individual worksheet or worksheets. 
a)
Workbook
b)
Worksheet
c)
Label
d)
Cell Address
36.

A cell range is defined by ....

a)

the reference of the upper left cell (minimum value) of the range and the reference of the lower right cell (maximum value) of the range in a spreadsheet.

b)

the reference of the upper right cell (minimum value) of the range and the reference of the lower left cell (maximum value) of the range in a spreadsheet.

37.

When writing a formula, begin the formula with the (a)   sign.

38.

There are ..... methods for writing a formula.

a)

2

b)

3

c)

4

Similar Resources on Wayground

Python Basis (S3)

41 questions

Python Basis (S3)

quiz

Worksheet

•

9th Grade

UEFI

35 questions

UEFI

quiz

Worksheet

•

9th - 12th Grade

Flowcharts

35 questions

Flowcharts

quiz

Worksheet

•

9th Grade

Microsoft Word 2013 Units 1-4

40 questions

Microsoft Word 2013 Units 1-4

quiz

Worksheet

•

9th - 12th Grade

แบบทดสอบ Photoshop

35 questions

แบบทดสอบ Photoshop

quiz

Worksheet

•

9th Grade

BAB 3 PERANGKAT KERAS KOMPUTER

41 questions

BAB 3 PERANGKAT KERAS KOMPUTER

quiz

Worksheet

•

9th - 12th Grade

CSP 2.1.3 Protocols and Bandwidth

37 questions

CSP 2.1.3 Protocols and Bandwidth

quiz

Worksheet

•

10th - 12th Grade

Loop Control Statement in C

41 questions

Loop Control Statement in C

quiz

Worksheet

•

University