wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Grade 6

Total questions: 48

Worksheet time: 39mins

Name
Class
Date
1.

Worksheet is an ________________ document.

a)

electronic

b)

tabular

c)

word processing

2.

Worksheet is an electronic document in which data is arranged in rows and __________.

a)

columns

b)

pages

c)

tabs

3.

A column is a _______________set of cells.

a)

vertical

b)

horizontal

c)

straight

d)

diagonal

4.

A row is a _______________set of cells.

a)

vertical

b)

horizontal

c)

straight

d)

diagonal

5.

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

6.

Identify the name of the arithmetic operator

a)

minus -

b)

plus +

7.

A formula begins with an EQUAL SIGN.

a)

true

b)

false

8.

Identify the arithmetic operator by looking at the image

a)

plus +

b)

multiply *

c)

minus -

9.

I am able to add, subtract and multiply numbers in excel using formula

a)

yes

b)

no

10.

Sum of 15 and 9 is ------------

a)

24

b)

25

c)

26

11.

The graph is Ms Excel will represent your

a)

date

b)

shapes

c)

class

d)

data

12.

Excel file is saved as a ____________

a)

Document

b)

workbook

c)

worksheets

d)

Presentation

13.

The name box or the address bar contains

a)

Formulas

b)

menu options

c)

Cell address

d)

Numbers

14.

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

15.

Microsoft Excel is categorized as a ________________ software.

a)

Database

b)

Spreadsheet

c)

Presentation

d)

Word Processing

16.

The bar where information appears as you input data is called ______________.

a)

file bar

b)

help bar

c)

window bar

d)

formula bar

17.

There are ______________ columns in a worksheet.

a)

16385

b)

16384

c)

18634

d)

13684

18.

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

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

19.
What do you call the blank boxes on a spreadsheet?
a)
cells
b)
info
c)
squares
d)
spots
20.
Cells that run horizontally on a spreadsheet
a)
Row
b)
Column
c)
Workbook
d)
Range
21.
This is a
a)
Column
b)
Row
c)
Cell
d)
Range
22.
The area within the red box is called
a)
Active Cell
b)
Fill Handle
c)
Cell
d)
Row
23.

Excel file is saved as a ____________

a)

Document

b)

workbook

c)

worksheets

d)

Presentation

24.

The name box or the address bar contains

a)

Formulas

b)

menu options

c)

Cell address

d)

Numbers

25.

Numbers in the worksheet represent

a)

data

b)

columns

c)

rows

d)

functions

26.

1) Which cell is selected in this picture?

a)

B2

b)

B3

c)

C3

d)

m3

27.

?

a)

File

b)

save

c)

clear

28.

To edit something on a worksheet you need to select this first?

a)

Columns

b)

Rows

c)

Cell Range

d)

Worksheet

29.

Columns go in what direction?

a)

Vertical

b)

Horizontal

30.

This symbol must be typed first to use a formula.

a)

Plus Sign

b)

Equal Sign

c)

FX

d)

Function

31.

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

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

32.

Which of the following is an operator for multiplication in Excel?

a)

/

b)

*

c)

%

d)

&

33.

The formula =2+3*5 gives the result as

a)

25

b)

17

c)

22

d)

11

34.

Which view of table is used to insert a field name in table.

a)

Date sheet

b)

Design

c)

Database

d)

all of the above

35.
What kind of data type do you use when entering a Client Number?
a)
Short Text
b)
Currency
c)
Number
d)
Autonumber
36.
Client Name is an example of a:
a)
Field Name
b)
Record
37.

Which data type would be most suitable for the 'DateofBirth' field?

a)

Currency

b)

Number

c)

Date/Time

d)

Yes/No

e)

Memo

38.

The Primary Key is a unique value for that column and hence, it cannot be the same for two ________________.

a)

Fields

b)

records

c)

Data

d)

None of these

39.

Which field has primary key in the given table

a)

Address 1

b)

CustomerName

c)

Customer ID

40.
Which Application program saves data automatically as it is entered?
a)
MS Word
b)
PowerPoint
c)
MS Access
d)
MS Excel
41.

In Microsoft Access, a field labelled “Price” must be created as

a)

Currency

b)

Primary Key

c)

Number 

d)

Short Text

42.

Which view do we usually use to enter field and datatype in the database?

a)

Design View 

b)

Record View

c)

Field View

d)

Form View

43.

Information we enter in MS Access is stored in the ______________ we created

a)

Column

b)

Row

c)

Database

d)

Data type

44.

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

a)

MS Word

b)

MS PowerPoint

c)

MS Outlook

d)

MS Excel

45.

Microsoft Excel is categorized as a ________________ software.

a)

Database

b)

Spreadsheet

c)

Presentation

d)

Word Processing

46.

?

a)

B1

b)

B2

c)

B3

47.

?

a)

B1

b)

B2

c)

B3

48.

1) Which cell is selected in this picture?

a)

B2

b)

B3

c)

C3

d)

m3