wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Excel 2019 Moment 3

Total questions: 12

Worksheet time: 24mins

Name
Class
Date
1.

What is the "Active Cell" in Excel?

a)

The Bottom cell in a worksheet. It is indicated by a dark border onscreen.

b)

The current cell in a worksheet. It is indicated by a dark border onscreen.

c)

The top cell in a worksheet. It is indicated by a dark border onscreen.

d)

The past cell in a worksheet. It is indicated by a dark border onscreen.

2.

Define Formula Bar?

a)

Area to display table values

b)

Shows the number of pages from the Excel spreadsheet

c)

The Excel element that allows you to zoom your values

d)

An element in Excel that appears below the Ribbon and to the right of the Insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function.

3.

What is a spreadsheet?

a)

An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.

b)

An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.

c)

An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.

d)

An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.

4.

When starting a formula what is the first thing you type in the cell?

a)

+

b)

-

c)

%

d)

=

5.

The letters in Excel represent the _______?

a)

columns

b)

rows

c)

data

d)

functions

6.

The numbers in Excel represent the _____?

a)

columns

b)

rows

c)

data

d)

functions

7.

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

8.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
A5
9.
Which feature enables you to preview headers and footers, page breaks, and other features that will print?
a)
Page preview
b)
Print Layout
c)
Synchronous Scrolling
d)
Window View
10.

When you want to total up 2 cells what formula do you use?

a)

SUM

b)

AVERAGE

c)

MIN

d)

MAX

11.

You can use Excel to create charts, Tables and even automatically add up input

a)

True

b)

False

12.

You can enter two basic kinds of data into worksheet cells:

a)

Numbers and figures

b)

Text and charts

c)

Music and Video

d)

Numbers and text