NEW
Font size
WorksheetsTerm3 - Grade 7 - Revision 2023-2024
Total questions: 52
Worksheet time: 19mins
In MS Excel Count Function will tell us the number of cells that contain ..............
Numbers
Text
Anything
Which function should be used to get the number of the absent students In MS Excel?
Count
CountA
CountBlank
Which function will display the number of the cells that are not empty?
Count
CountA
CountBlank
Formula always begins with this symbol ...........
%
*
=
The bar where we can write the functions above the column headers is called.........
Data bar
Function bar
Formula bar
The cell name is displayed in ...............
Location box
Reference box
Name box
To succeed you must get greater than or equal to 50, otherwise you fail.
select the correct code :
=if(g1>50,"success","fail")
=if(g1>=50,"success","fail")
=if(g1>50 or equal 50,"success","fail")
In if function, the condition part is part number ............
1
2
3
In if function, the else part is part number ............
1
2
3
In if function, the result_if_true part is part number .....................
1
2
3
................. image format is not acceptable in PowerPoint
.bmp
.webp
.jpg
The following video format is the best in PowerPoint ...................
avi
mkv
mp4
Transitions can be applied to ..........................
Text
Images
Slides
Animations can be applied to .........................
Slides
Images
Both of them
Videos inserted to PowerPoint file is .................
Embedded
Linked
The extension of PowerPoint presentation is .................
pptx
pppx
ppsx
The extension of PowerPoint show is .................
pptx
pppx
ppsx
To change the slide content , we can change the .........
Design
Layout
Theme
To save our time after we add a slide transition we should select ...........
Apply to one
Apply to All
Apply to none
To display the data graphically ...............
clipart
SmartArt
Tables
Charts are the best method to represent ..........
Text data
Numeric data
Graphical data
If I represent to total of my students, I should use ........... chart type.
Column
pie
Both
If I represent data of one student, I can use ............. chart type
Column
pie
Both
A visual representation of your information and ideas:
Chart
SmartArt
ClipArt
An Excel spreadsheet is primarily used for .......................
Writing formulas
Making tables
Making charts
All of the above
What is the type of this chart?
Column chart
Line chart
Pie chart
What is the type of this chart?
Column chart
Line chart
Pie chart
Which of the following is not a valid function in MS Excel?
SUM()
COUNT()
SUBTRACT()
A ____________ is the basic unit of a worksheet into which you enter data.
Cell
Tab
Chart
The function Count will tell us the number of Cells that contain any thing written inside.
True
False
The function CountA will tell us the number of cells that contain numbers ONLY
True
False
Charts easily analyze the large amount of data.
True
False
Average function works on selected range.
True
False
The borders of the selected range can be any color.
True
False
PowerPoint presentation can accept mp4 files to be inserted. ....
True
False
To start the show in PowerPoint, you can press F6
True
False
Table can't be inserted in PowerPoint slides.
True
False
Pptx is the default file format for PowerPoint presentation. .
True
False
The function IF contains condition, value if true , and value if false
True
False
The Count function can count the names of the students.
True
False
The If function is used to choose between two choices .
True
False
There are only 2 types of charts to use in MS Excel. ..
True
False
To insert a chart, choose ……………….
home tab
insert tab
input tab
You can print a sheet with numbers or graph just like you print a document. On the FileTab Click on Print or press ……………………….
Ctrl+P
Ctrl+Z
Ctrl+R
The function CountBlank used to count empty cell
True
False
The Count function counts the number of cells that contain numbers.
True
False
Inserted videos to PowerPoint file makes the file size bigger .
True
False
The function IF contains 4 parts.
True
False
Mp3 files are perfect video files
True
False
Charts can be inserted in PowerPoint
True
False
The best mark can be detected by using the Min function
True
False
The SUM function gives the average number of a range of cells
True
False
