NEW
Font size
WorksheetsGrade 7 - chapter 3 and chapter 4 combine
Total questions: 40
Worksheet time: 23mins
Functions are predefined Formulae.
True
False
_______ function multiplies two numbers.
round
sqrt
power
product
=sqrt (81) returns
6
4
9
12
=max ( 98,44,12,56,76,22,89,99,5) would returns _______
44
99
12
76
____ function returns the smallest value in a set of numbers.
min
max
average
power
=power(9,3) returns ______
81
729
243
27
=mod (39,5) returns _____
4
3
2
1
= Average ( 1,3,5,7,9 ) ____
6
8
10
5
=product ( 5,12 ) ____________
18
60
64
72
Fill button is available under ___________ group.
Editing
Styles
Home
Alignment
________function joins several text strings into one text string without blank space.
trim
replace
max
concatenate
=replace("hardwork",1,4,"neat") returns _______
workneat
neatwork
workhard
hardneat
_______ function removes all proceeding and trailing spaces in a text.
len
trim
replace
average
which logical function returns either true or false according to the condition ?
If
AND
OR
OR logical function gives the result as true if all the arguments are true or any one is true.
True
False
=len("CBSE SCHOOL")
13
11
12
10
Sorting Icon is available under ___ tab.
Edit
Format
Data
File
Advanced Filter is the quickest way to filter a database.
True
False
=concatenate("Anugrahaa","school")
school Anugrahaa
Anugrahaaschool
Anugrahaa school
schoolanugrahaa
To insert a function, click _____ tab.
Edit
Format
Formaulae
Data
The Minimum Font size is _______
3
5
8
10
__________ button is used to change the direction of text.
Formatting
Orientation
Smart Art
Clip art
Ctrl + Arrow Keys will Resize the shape.
True
False
_______ button aligns the content to the middle of the cell.
Top Alignment
Right Alignment
Center Alignment
Middle Alignment
The maximum font size is _________
52
62
72
82
Orientation has _____ types
2
4
6
5
The row height can be specified between __________
0 and 209
0 and 309
0 and 409
0 and 509
The Column width can be specified between _______
0 and 155
0 and 455
0 and 355
0 and 255
_________ are graphical representations of tabular data.
Smart Art
Clip Art
Charts
Once a Chart is inserted, the user cannot change the chart type.
True
False
What type of SmartArt is this ?
List
Process
Cycle
pyramid
What is the name of this Icon ?
Inserting Cells
Format Cells
Conditional Formatting
Cell Styles
This icon allows you to apply borders.
This drop-down menu allows you to change the background color.
What Icon is this ?
Chart
Clip Art
shapes
Smart Art
This option located in __________ tab.
Home
Insert
Format
Layout
What Kind of chart is this ?
Pie Chart
Radar Chart
Bubble Chart
Doughnut Chart
Merge & Center option is available under ________ group.
Alignment
cells
styles
Illustrations
Conditional Formatting option available under _______ group.
Illustrations
Styles
cells
Font
_______ is the writing style of the text.
Chart
Text
Font
Charts
