wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Microsoft Excel-Version 2

Total questions: 50

Worksheet time: 24mins

Name
Class
Date
1.

What shape is a pie chart?

a)

Circle

b)

Triangle

c)

Line

d)

Square

2.

Where do you click to sort the contents of the cells by A to Z?

a)

Custom Sort

b)

Sort Z to A

c)

Sort A to Z

d)

Filter

3.

What is the range of cells highlighted in the spreadsheet?

a)

D4:D8

b)

A1:A4

c)

D1:D4

d)

A4:A8

4.

Which button do you click to use Fill to copy the formula?

a)

Down

b)

Right

c)

Left

d)

Right

5.

Where do you click to delete column A?

a)

Delete Sheet Rows

b)

Delete Sheet Columns

c)

Delete Sheet

d)

Delete Workbook

6.

Where do you type the file name "July"?

a)

File name

b)

Save as Type

c)

Documents - Work

d)

Search

7.

Where do I click to save the workbook in the folder "Work"?

a)

Recent

b)

OneDrive

c)

Work

d)

Desktop

8.

Which tab do I click to freeze the headings?

a)

Formulas

b)

Data

c)

Review

d)

View

9.

Where do you click to make column D wider?

a)

On the line between cell C and cell D

b)

On the line between cell D and cell E

c)

On the header "Expenses"

d)

On the label "Type"

10.

What button do you click to merge two cells?

a)

Merge and center

b)

Align left

c)

Center align

d)

Indent paragraph

11.

What does this button do?

a)

Merge and center

b)

Align right

c)

Center align

d)

Indent

12.

Where do you click to change the font size to 22?

a)

11

b)

B

c)

I

d)

U

13.

Where do you click to rename the worksheet?

a)

Rename

b)

Insert

c)

Delete

d)

Move or Copy

14.

Which formula adds the contents of cells C1 and C2?

a)

=(C1*C2)

b)

=(C1/C2)

c)

=SUM(C1:C2)

d)

=(C1-C2)

15.

The SUM formula adds the contents of the highlighted cells.

a)

True

b)

False

16.

You can click the pie chart button to insert a pie chart.

a)

True

b)

False

17.

What is in Cell A3?

a)

Office Item

b)

white copy paper

c)

Quantity

d)

12

18.
Which formulas will add up the numbers for a given range? 
a)
COUNT
b)
SUM
c)
AVERAGE
d)
MIN
19.
The ______ symbol is used to show addition in Excel.
a)
-
b)
+
c)
*
d)
/
20.
To __________ the contents of a cell means to change its appearance.
a)
format
b)
Search
c)
Data
d)
Sort
21.
What is the column heading for 2008 Salary?
a)
3
b)
D
c)
D3
d)
3D
22.
If you want to save a different version of a workbook while keeping the original, you can create a copy by using the ___________.
a)
Save
b)
Save As
c)
Copy
d)
Page setup
23.
What is the row heading for Mrs. Hathaway?
a)
1
b)
4
c)
A4
d)
4A
24.
What is the cell address for Mr. Bates 2007 Salary?
a)
C
b)
13
c)
13C
d)
C13
25.

The function that lets you add up a range of cells or values

a)

SUM

b)

AVERAGE

c)

MIN

d)

MAX

26.

All formulas used within the table are seen on the __________

a)

cells

b)

cell reference

c)

name box

d)

formula bar

27.

To sort names in a worksheet, we can use this button.

a)
b)
c)
d)
28.
A single highlighted location (contains a dark outlined box on a spreadsheet that is ready to insert data is a/an...
a)
cell
b)
row
c)
active cell
d)
home address
29.
Horizontal portions of the spreadsheet identified by numbers (1, 2, 3..) are…
a)
columns
b)
rows
c)
active cell
d)
name box
30.
Excel is a __________ software
a)
word processing
b)
slide show presentation
c)
spreadsheet
31.
A column letter and a row number (ex:  A3, F15..) are referred to as the 
a)
Status Area
b)
Mode Indicator
c)
Cell Address
d)
Formula Bar
32.

What is this icon?

a)

Sum

b)

AutoSum

c)

Insert Function

d)

Object

33.

What is this icon?

a)

Sum

b)

AutoSum

c)

Insert Function

d)

Object

34.

What is this icon?

a)

Line Chart

b)

Pie Chart

c)

Pivot Chart

d)

Column Chart

35.

What is this icon?

a)

Freeze Panes

b)

Sort

c)

Hyperlink

d)

Conditional Formatting

36.

What is this icon?

a)

Zoom

b)

Sort and Filter

c)

Symbol

d)

Merge and Center

37.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
38.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
39.
What kind of software is Excel?
a)
Word processing software
b)
Spreadsheet Software
c)
Data Base Software
40.
What button will add up a group of numbers
a)
Equals button
b)
Plus symbol button
c)
Auto-sum button
41.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
42.
When inserting a formula, always start with
a)
equals symbol
b)
plus symbol
c)
minus symbol
43.
What kind of chart should you use to show the pieces (percentages) of a whole
a)
Bar Chart
b)
Column Chart
c)
Pie Chart
44.
Excel is part of
a)
Access
b)
Microsoft Office
c)
PowerPoint
45.
If your document will not fit on one page, you can always print it in
a)
Portrait
b)
Landscape
46.
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
47.
You can do other functions (besides addition) with the auto sum button ∑ such as average, max, min
a)
True
b)
False
48.
You can use the Auto Sum Key ∑ to subtract numbers.
a)
True
b)
False
49.

What does this button do?

a)

Merge the heading row so you can always see it when scrolling down

b)

Freeze the heading row so you can always see it when scrolling down

c)

Freeze the last row so you can always see it when scrolling up

d)

Merge the last row so you can always see it when scrolling up

50.

What do you click to freeze the heading row so you can always see it when scrolling down?

a)

Freeze Panes

b)

Freeze Top Row

c)

Freeze First Column

Similar Resources on Wayground

Economics

46 questions

Economics

quiz

Worksheet

•

12th Grade

LATIHAN PAT INFORMATIKA KELAS X

50 questions

LATIHAN PAT INFORMATIKA KELAS X

quiz

Worksheet

•

9th - 12th Grade

Shark 1 - (3/12/2024)

48 questions

Shark 1 - (3/12/2024)

quiz

Worksheet

•

9th - 12th Grade

Computer Servicing Ch 1-3 Review

53 questions

Computer Servicing Ch 1-3 Review

quiz

Worksheet

•

9th - 12th Grade

Google: Formula tu proyecto

54 questions

Google: Formula tu proyecto

quiz

Worksheet

•

10th - 11th Grade

US INFORMATIKA SEMUA JURUSAN 2025

50 questions

US INFORMATIKA SEMUA JURUSAN 2025

quiz

Worksheet

•

12th Grade

Pemrograman Dasar

50 questions

Pemrograman Dasar

quiz

Worksheet

•

10th - 12th Grade

Data Communication and Network

50 questions

Data Communication and Network

quiz

Worksheet

•

11th Grade - University