wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

MS EXCEL 9

Total questions: 54

Worksheet time: 54mins

Name
Class
Date
1.

What does every formula in MS EXCEL start with?

a)

+

b)

-

c)

=

d)

*

2.
This is a:
a)
tab
b)
ribbon
c)
group
d)
none of the above
3.

Excel file is saved as a ____________

a)

Document

b)

workbook

c)

worksheets

d)

Presentation

4.

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

a)

AVERAGE

b)

SUM

c)

MIN

d)

MAX

5.

What function was used to find the highest data ?

a)

AVERAGE

b)

MIN

c)

SUM

d)

MAX

6.

See the following formula. Which of the following formula is the another method of the given formula?

=(B2+C2+D2+E2)/4

a)

= SUM (B2,C2,D2,E2)

b)

= MAX(B2:E2)

c)

= SUM(B2,E2/4)

d)

= AVERAGE (B2:E2)

7.

The result of the following Excel formula is____?

=SUM(Max(9,5,1),Average(3,4,8))

a)

9

b)

14

c)

5

d)

18

8.

Cell A1 contains a Function that shows the following data. What can be the function in A1?

22.10.2020

a)

=TIME()

b)

=ABS(-18.12)

c)

=TODAY()

d)

=NOW()

9.

Which of the following is a valid formula in Excel?

a)

=A1<>4A

b)

K1+K9

c)

=SUMM(A2:B6)

d)

=D3/E4

10.

What is the extension of Ms Excel?

a)

.xlsx

b)

.docx

c)

.excel

d)

.pptx

11.
To change the font, font size, color, or style: Select the ________ you want to modify.
a)
Column Headings
b)
Cells
12.
Allows you to create clear and defined boundaries for different sections of your worksheet.
a)
Cell Borders and Fill Colors
b)
Headings
c)
Font Size
d)
Font Color
13.
A quick way to include professional formatting for different parts of your workbook, such as titles and headers.
a)
Font Color
b)
Cell Style
c)
Borders
d)
Fill Color
14.
To insert a new row, select the row heading _______ where you want the new row to appear.
a)
Above
b)
Below
15.
To insert a new column, select the column heading to the _______  of where you want the new column to appear.
a)
Left
b)
Right
16.
If you want to remove the content from a row or column without causing others to shift, right-click a heading, then select ________ Contents from the drop-down menu
a)
Clear
b)
Delete
17.
_____________ will automatically modify a cell's row height.
a)
Wrapping Text
b)
Adjusting Column Height
18.
__________ merges the selected cells into larger cells while keeping each row separate
a)
Merge and Center
b)
Merge Across
19.
Excel 2016 will treat "October" as a 
a)
Date
b)
Text string
20.
To copy a worksheet: Right-click the worksheet you want to copy, then select _______ or _________ from the worksheet menu.
a)
Copy, Move
b)
Copy, Select
21.
By default, any new workbook you create in Excel will contain one ________, called __________.
a)
workbook, workbook
b)
worksheet, sheet1
22.

How are ROWS in MS EXCEL spreadsheet named?

a)

numbers

b)

letters

c)

cells

d)

columns

23.

How is the COLUMN in a MS Excel Spreadsheet named?

a)

Numbers

b)

Letters

c)

Cells

d)

Columns

24.

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

a)

row

b)

column

c)

cell

25.

What is one way to ADD a Range of rows and columns in MS EXCEL other than using the + symbol.

a)

SUMMING

b)

SUM

c)

ALL

d)

None at all

26.

What is an example of a RANGE in MS Excel.

a)

B2-F5

b)

F5:B2

c)

B2:5F

d)

(B2:F5)

27.

When is a MS Excel Spreadsheet used?

a)

Making a Drawing

b)

When Reading

c)

For Collecting Information

d)

For Baking a Cake

28.
Located on the left side or the entry bar, displays the active cell reference:
a)
entry bar
b)
cell reference
c)
name box
d)
none of the above
29.
The cell in a spreadsheet application in which data may be entered:
a)
cell reference
b)
name box
c)
active cell
d)
none of the above
30.
Unique address of a cell that is the coordinate of the intersection of a row and a column:
a)
entry bar
b)
cell reference
c)
name box
d)
none of the above
31.

In Excel, Columns are labelled as ___

a)

A, B, C, etc

b)

1,2,3 etc

c)

A1, A2, etc

d)

$A$1, $A$2, etc.

32.

In Microsoft Excel, the file you create and edit is called:

a)

A form

b)

A ledger

c)

A table

d)

A workbook

e)

A record

33.

What function was used to find the highest data ?

a)

AVERAGE

b)

MIN

c)

SUM

d)

MAX

34.

Cell A1 contains a Function that shows the following data. What can be the function in A1?

22.10.2020

a)

=TIME()

b)

=ABS(-18.12)

c)

=TODAY()

d)

=NOW()

35.

Numbers in Excel are known as ------------------------

a)

values

b)

labels

c)

numbers

36.

10 times 5 is ----------

a)

40

b)

50

c)

60

37.

A cell formed at the intersection of row 8 and column E is addressed as _____________.

a)

E8

b)

8E

38.

A group of cells which are adjacent to each other are called _________________.

a)

Active Cell

b)

Cell range

39.

The address of the currently active cell is displayed in the ___________________________.

a)

Formula Bar

b)

Name Box

40.

We must __________________ data to do operations on it.

a)

select

b)

click

41.

Thick border around the active cell is called the ______________________________.

a)

Cell pointer

b)

Active cell

42.

What is a way to add up a column of numbers without using the symbol + ?

a)

=SUM(A2:F2)

b)

EQUAL +

c)

=SUM(A2:A7)

d)

=(A2*F2)

43.

What function do you press to center a title in 5 cells in one row?

a)

Title YES

b)

Merge and Center

c)

A1+B1+C1+D1+E1

d)

Center

44.

When is a MS Excel Spreadsheet used?

a)

Making a Drawing

b)

When Reading

c)

For Collecting Information

d)

For Baking a Cake

45.

__________ is a area that holds all the elements of a chart.

a)

Plot Area

b)

Chart Title

c)

Chart Area

d)

Legends

46.

Vertical axis of a chart is _______

a)

X axis

b)

Y axis

c)

X axis

d)

B axis

47.

Click __________ tab to create a chart.

a)

CREATE

b)

INSERT

c)

FORMAT

d)

HOME

48.

What are the two additional tabs that appears after inserting a chart

a)

INSERT, FORMAT

b)

LAYOUT, DESIGN

c)

FORMAT, LAYOUT

d)

DESIGN, FORMAT

49.

To quickly create a chart press _______ function key.

a)

F8

b)

F9

c)

F10

d)

F11

50.

Legends are added at the ________ of a chart by default.

a)

top

b)

bottom

c)

middle

d)

right

51.

A Chart can be moved to a separate sheet.

a)

True

b)

False

52.

Name of the workbook is displayed in the ___________

a)

Menu bar

b)

Title bar or ribbon

c)

Tool bar

d)

option bar

53.

The default page orientation in excel is

a)

Portrait

b)

Landscape

c)

Horizontal

d)

All of these

54.

The total area of the chart in Excel is called

a)

Plot area

b)

Data area

c)

Chart area

d)

None of the above

Similar Resources on Wayground

DATABASE QUIZ

50 questions

DATABASE QUIZ

quiz

Worksheet

•

9th Grade

Computer Servicing Ch 1-3 Review

53 questions

Computer Servicing Ch 1-3 Review

quiz

Worksheet

•

9th - 12th Grade

HTML

50 questions

HTML

quiz

Worksheet

•

8th Grade - University

SAINS KOMPUTER TINGKATAN 4 BAB 1

50 questions

SAINS KOMPUTER TINGKATAN 4 BAB 1

quiz

Worksheet

•

3rd Grade - University

TEST EXCEL

50 questions

TEST EXCEL

quiz

Worksheet

•

9th - 12th Grade

LATIHAN PAT INFORMATIKA KELAS X

50 questions

LATIHAN PAT INFORMATIKA KELAS X

quiz

Worksheet

•

9th - 12th Grade

Section 2.1 Input Devices and Their Uses

50 questions

Section 2.1 Input Devices and Their Uses

quiz

Worksheet

•

9th Grade

HTML_Assessment

52 questions

HTML_Assessment

quiz

Worksheet

•

7th - 9th Grade