Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

TLE 6 - MS EXCEL Window Parts

Total questions: 50

Worksheet time: 30mins

Name
Class
Date
1.

a)

Title Bar

b)

Name box

c)

Active cell

d)

Ribbon

2.
a)

Title Bar

b)

Ribbon

c)

Active Cell

d)

File Tab

3.

a)

Worksheet Area

b)

Quick Access Toolbar

c)

New Sheet Button

d)

Tabs

4.

a)

Name Box

b)

Title Bar

c)

Ribbon

d)

Active Cell

5.

a)

Name Box

b)

Ribbon

c)

Vertical Scroll Bar

d)

File Tab

6.

a)

Name Box

b)

Ribbon

c)

Vertical Scroll Bar

d)

File Tab

7.

a)

Pin the Ribbon

b)

Ribbon

c)

Tabs

d)

Status Bar

8.

a)

Vertical Scroll Bar

b)

Horizontal Scroll Bar

c)

Sheet Tabs

d)

New Sheet Button

9.

a)

Vertical Scroll Bar

b)

Horizontal Scroll Bar

c)

Formula Bar

d)

Name Box

10.

a)

Sheets Bar

b)

Status Bar

c)

Vertical Scroll Bar

d)

Horizontal Scroll Bar

11.

a)

Sheets Bar

b)

Status Bar

c)

Vertical Scroll Bar

d)

Horizontal Scroll Bar

12.

a)

Sheets Bar

b)

Status Bar

c)

Vertical Scroll Bar

d)

Horizontal Scroll Bar

13.

a)

Cell

b)

Cell Pointer

c)

Worksheet Area

d)

Blank Page

14.

How is the COLUMN in a MS Excel Spreadsheet named?

a)

Numbers

b)

Letters

c)

Cells

d)

Columns

15.

How are ROWS in MS EXCEL spreadsheet named?

a)

numbers

b)

letters

c)

cells

d)

columns

16.

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

a)

row

b)

column

c)

cell

17.

What does every formula in MS EXCEL start with?

a)

+

b)

-

c)

=

d)

*

18.

When is a MS Excel Spreadsheet used?

a)

Making a Drawing

b)

When Reading

c)

For Collecting Information

d)

For Baking a Cake

19.
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
20.
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
21.
This is a:
a)
cell
b)
row
c)
column
d)
none of the above
22.

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.

23.

Which area in an Excel window allows entering values and formulas?

a)

Standard tool Bar

b)

Title bar

c)

Formula Bar

d)

None of the above

24.

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

25.

What is a sheet in Excel?

a)

A single spreadsheet that typically contains labels, values, formulas, functions, and graphical representations of data.

b)

A single document that typically contains labels, values, formulas, functions, and graphical representations of data.

c)

A single file that typically contains labels, values, formulas, functions, and graphical representations of data.

26.

Name of the workbook is displayed in the ___________

a)

Menu bar

b)

Title bar or ribbon

c)

Tool bar

d)

option bar

27.

Define Cell?

a)

The dark bordered box in excel.

b)

A box in Excel that has formulas.

c)

The intersection of a column or row in a worksheet or table.

d)

Fx Bar where you input data

28.

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

29.

Which of these is Microsoft Excel?

a)
b)
c)
d)
30.

MS EXCEL was originally made just for what purpose?

4 lines
31.

What are some other uses if MS Excel applicable to you as a student?

4 lines
32.

This is a valid simple formula

a)

A2+A4

b)

=AB3+Y5

c)

(a2*t3)/100

d)

=(a2*t3)/100

33.

* is a symbol for:

a)

Multiplication

b)

Addition

c)

Subtraction

d)

Dividing

34.

/ is a symbol for:

a)

Multiplication

b)

Addition

c)

Subtraction

d)

Dividing

35.

- is a symbol for:

a)

Multiplication

b)

Addition

c)

Subtraction

d)

Dividing

36.

What is the reference of the active cell?

a)

g15

b)

H19

c)

B21

d)

V11

e)

a17

37.

=SUM(A1,A3,A4)

What is the purpose of this formula?

a)

To add up the values referenced inside the brackets.

b)

To multiply the values referenced inside the brackets

c)

To compare the values referenced inside the brackets.

d)

To find a value in the cells referenced inside the brackets.

38.

Write a formula to find calculate the total stock level in the bakery for all of its products combined.

Your formula MUST include cell references.

(a)  

39.

Why do you start a formula with an = sign?

a)

to tell Excel you are entering a formula

b)

just because

c)

you are entering text

40.

Where does Excel return the result of a formula

a)

the same cell where the formula is entered

b)

A1

c)

in your head

41.

Which arithmetic operator is being used in the following formula: =T75- AA45

a)

addition

b)

multiplication

c)

subtraction

d)

format

42.

Does Excel allow the use of numbers in formulas?

a)

yes

b)

no

43.

List the following in order of operations: addition (+), division (/), multiplication (*), subtraction (-).

a)

/,+,-,*

b)

*,/,+,-

c)

^,s,r,t

44.

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

a)

SUM

b)

AVERAGE

c)

MIN

d)

MAX

45.

All formulas used within the table are seen on the __________

a)

cells

b)

cell reference

c)

name box

d)

formula bar

46.

What is the Sum formula?

a)

Sum( )

b)

Sum( )=

c)

=Sum( )

d)

=( )Sum

47.

How would you write a cell reference formula for cell A1 subtracted from Cell C3?

a)

A1-C3

b)

A1-C3=

c)

=A1-C3

d)

=C3-A1

48.
What would be a correct formula for SUM in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
49.
Which response best completes the following statement: A formula is used to 
a)
perform calculations or other actions.
b)
find averages.
50.

A program using a table comprising of rows, columns and cells.

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

Similar Resources on Wayground

Pra SAS Ganjil TIK Kelas 6

45 questions

Pra SAS Ganjil TIK Kelas 6

quiz

Worksheet

•

6th Grade

Google Drawing

52 questions

Google Drawing

quiz

Worksheet

•

6th - 8th Grade

INFORMATICA NUEVA GRANADA 2023 SEXTO

50 questions

INFORMATICA NUEVA GRANADA 2023 SEXTO

quiz

Worksheet

•

6th Grade

CODING QUIZ

45 questions

CODING QUIZ

quiz

Worksheet

•

6th Grade

HTML,CSS

50 questions

HTML,CSS

quiz

Worksheet

•

3rd Grade - University

GWAM

50 questions

GWAM

quiz

Worksheet

•

6th - 8th Grade

ADVANCED FEATURES OF MS - WORD - 1

45 questions

ADVANCED FEATURES OF MS - WORD - 1

quiz

Worksheet

•

5th - 6th Grade

CAT - Gr 10 - Hardware & Software

50 questions

CAT - Gr 10 - Hardware & Software

quiz

Worksheet

•

KG - University