wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Grade 7 - chapter 3 and chapter 4 combine

Total questions: 40

Worksheet time: 23mins

Name
Class
Date
1.

Functions are predefined Formulae.

a)

True

b)

False

2.

_______ function multiplies two numbers.

a)

round

b)

sqrt

c)

power

d)

product

3.

=sqrt (81) returns

a)

6

b)

4

c)

9

d)

12

4.

=max ( 98,44,12,56,76,22,89,99,5) would returns _______

a)

44

b)

99

c)

12

d)

76

5.

____ function returns the smallest value in a set of numbers.

a)

min

b)

max

c)

average

d)

power

6.

=power(9,3) returns ______

a)

81

b)

729

c)

243

d)

27

7.

=mod (39,5) returns _____

a)

4

b)

3

c)

2

d)

1

8.

= Average ( 1,3,5,7,9 ) ____

a)

6

b)

8

c)

10

d)

5

9.

=product ( 5,12 ) ____________

a)

18

b)

60

c)

64

d)

72

10.

Fill button is available under ___________ group.

a)

Editing

b)

Styles

c)

Home

d)

Alignment

11.

________function joins several text strings into one text string without blank space.

a)

trim

b)

replace

c)

max

d)

concatenate

12.

=replace("hardwork",1,4,"neat") returns _______

a)

workneat

b)

neatwork

c)

workhard

d)

hardneat

13.

_______ function removes all proceeding and trailing spaces in a text.

a)

len

b)

trim

c)

replace

d)

average

14.

which logical function returns either true or false according to the condition ?

a)

If

b)

AND

c)

OR

15.

OR logical function gives the result as true if all the arguments are true or any one is true.

a)

True

b)

False

16.

=len("CBSE SCHOOL")

a)

13

b)

11

c)

12

d)

10

17.

Sorting Icon is available under ___ tab.

a)

Edit

b)

Format

c)

Data

d)

File

18.

Advanced Filter is the quickest way to filter a database.

a)

True

b)

False

19.

=concatenate("Anugrahaa","school")

a)

school Anugrahaa

b)

Anugrahaaschool

c)

Anugrahaa school

d)

schoolanugrahaa

20.

To insert a function, click _____ tab.

a)

Edit

b)

Format

c)

Formaulae

d)

Data

21.

The Minimum Font size is _______

a)

3

b)

5

c)

8

d)

10

22.

__________ button is used to change the direction of text.

a)

Formatting

b)

Orientation

c)

Smart Art

d)

Clip art

23.

Ctrl + Arrow Keys will Resize the shape.

a)

True

b)

False

24.

_______ button aligns the content to the middle of the cell.

a)

Top Alignment

b)

Right Alignment

c)

Center Alignment

d)

Middle Alignment

25.

The maximum font size is _________

a)

52

b)

62

c)

72

d)

82

26.

Orientation has _____ types

a)

2

b)

4

c)

6

d)

5

27.

The row height can be specified between __________

a)

0 and 209

b)

0 and 309

c)

0 and 409

d)

0 and 509

28.

The Column width can be specified between _______

a)

0 and 155

b)

0 and 455

c)

0 and 355

d)

0 and 255

29.

_________ are graphical representations of tabular data.

a)

Smart Art

b)

Clip Art

c)

Charts

30.

Once a Chart is inserted, the user cannot change the chart type.

a)

True

b)

False

31.

What type of SmartArt is this ?

a)

List

b)

Process

c)

Cycle

d)

pyramid

32.

What is the name of this Icon ?

a)

Inserting Cells

b)

Format Cells

c)

Conditional Formatting

d)

Cell Styles

33.

This icon allows you to apply borders.

a)
b)
c)
d)
34.

This drop-down menu allows you to change the background color.

a)
b)
c)
d)
35.

What Icon is this ?

a)

Chart

b)

Clip Art

c)

shapes

d)

Smart Art

36.

This option located in __________ tab.

a)

Home

b)

Insert

c)

Format

d)

Layout

37.

What Kind of chart is this ?

a)

Pie Chart

b)

Radar Chart

c)

Bubble Chart

d)

Doughnut Chart

38.

Merge & Center option is available under ________ group.

a)

Alignment

b)

cells

c)

styles

d)

Illustrations

39.

Conditional Formatting option available under _______ group.

a)

Illustrations

b)

Styles

c)

cells

d)

Font

40.

_______ is the writing style of the text.

a)

Chart

b)

Text

c)

Font

d)

Charts