Font size
WorksheetsReview ICT 7 3rd Quarter
Total questions: 61
Worksheet time: 15hrs 15mins
Division symbol in spreadsheet.
/
+
=
Multiplication symbol in Microsoft Excel
&
*
^
Microsoft Excel is what kind of software?
Word Processing Software
Spreadsheet Software
Database Software
Presentation Software
The letters in Excel represent the...
Rows
Columns
Cells
Data
The numbers in Excel represent the...
Rows
Columns
Cells
Data
An Excel file format extension is
doc
xls
txt
mp3
Letters of the alphabet going across the top of the spreadsheet.
Title Bar
Column Labels
Row Labels
Status Bar
Numbers down the left side of the spreadsheet.
Status Bar
Formula Bar
Column Labels
Row Labels
The intersection of a column and a row is called a __________.
Four-way Stop
Formula Bar
Cell
Template
Where is the zoom function located in Excel?
Bottom right of spreadsheet document
Bottom left of spreadsheet document
Top right of spreadsheet document
Top left of spreadsheet document
The cell address of the highlighted cell is
C
4
A4
C4
These are known as
workbooks
worksheets
formula bar
cell
What does the indicated icon in the red box do?
Change number of active cells
Change font colour
Change font size
Change the number of calculations
Every formula starts with what?
=
+
-
( )
What is the name of the bar above the worksheet that always shows the content of a cell as is denoted by the symbol fx?
cell bar
formula bar
status bar
name box
If you see the following, what does it mean? ######
the formula has an error
the contents are too large to display
text was entered where numbers should be
If you selected (A1:B5) what is this called?
row
column
cell range
cell grouping
What function adds all of the numbers in a range of cells?
Calculate
Compute
Sum
Max
If I want to find an average of cells A1 through A25, which formula would I use?
=average(A1:A25)
=avg(A1:A25)
=average(A1-A25)
=avg(A1-A25)
Adding two cells,
A1+A3=SUM
SUM(_)
=SUM(A1+A3)
Total
It is composed of a worksheet, which has thousands of cells that each have a name to help
the user find a specific cell easily.
Microsoft Word
Power Point Presentation
HTML website
Microsoft Excel
What part of MS excel is this?
Name Box
Sheet Tan
Ribbon
Formula Bar
name the parts of ms excel.
name box
active cell
title bar
name the parts of ms excel
ms excel
title bar
book1
If you selected (A1:B5) what is this called?
row
column
cell range
cell grouping
Microsoft Publisher is a
Desktop Publishing Program
Web Browser
Word Processor
Operating System
Which of the following should Publisher NOT be used for?
Designing a flyers
Designing a labels
Calculating money
Create a holiday card
Which Menu item do I use to format my font styles and paragraph settings?
View
File
Insert
Home
WordArt is available on the ____________ tab
Format
Graphics
Insert
ClipArt
Which file extension is correct for MS Publisher?
.ppt
.doc
.xls
.pub
MS Publisher has many pre-created documents that you can edit. These are called....
images
slides
templates
edits
One of the publications that we can create in MS Publisher is ____
internet
bank account
brochure
paintings
The ____________________ contains multiple tabs each with several groups of commands.
publication page
ruler
zoom
ribbon
To design a publication from the scratch, we use,
blank publication
pencil
scratch
template
In MS Publisher, text is typed into ___
text lines
text box
text square
text triangles
This is one thing you can't create with MS Publisher
Brochure
Posters
spreadsheet
Flyer
If you want to type text in Publisher, you must first
Create a word wrap
Insert a picture
Insert a graphic
Insert a text box
If you want to remove a portion of the picture, you can use the ____________tool.
Cut
Copy
Crop
Delete
What does the blue dotted border represent on a publication?
Margin
Border
Frame
Design
What do you do if a text is in front of a picture and you want it behind?
Move it behind text
Delete it
Send backward
Move it away from the picture
What part of the Ms Publisher can you see the title of your document?
ribbon
title bar
page navigation pane
status bar
What part of the MS Publisher can you see the number of pages of your document?
page navigation pane
zoom control
page layout view buttons
status bar
What part of the MS Publisher where you can use multiple tabs for editing text, inserting images, shapes, etc.?
title bar
ribbon
status bar
quick access toolbar
Give the name of this logo made by Microsoft Corporation.
Microsoft Powerpoint
Microsoft Word
Microsoft Excel
Microsoft Publisher
Give the name of this logo made by Microsoft Corporation.
Microsoft Access
Microsoft Word
Microsoft Excel
Microsoft Publisher
The Microsoft Publisher logo is....
Joel, an entrepreneur, prepares brochures, flyers, calling cards, and other
materials for his business. What productivity tool does he need?
Microsoft Outlook
Microsoft Publisher
Microsoft Word
Microsoft Excel
Teacher Celeste computes the pupils’ grades and prepares the grading
sheet for the upcoming parent–teacher meeting. What productivity tool
does she need?
Microsoft Outlook
Microsoft Access
Microsoft Excel
Microsoft Publisher
Ms. Daecel Anne, an accountant, computes the company’s monthly income
and expenses. What productivity tool does she need?
Microsoft Word
Microsoft Powerpoint
Microsoft Publisher
Microsoft Excel
To save an existing document with a new file name which command is used?
save
exit
close
save as
Which icon is used to insert an image in Publisher?
The menu for saving documents is...
Save
Exit
Open
Select
One of the templates found in MS Publisher is
calculator
house
greeting cards
pictures
Which of the following computer program is an electronic spreadsheet which allows you to organize
and calculate financial information such as household expenses and grading sheets?
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Microsoft Publisher
cells
file
Spreadsheet
Document
Which of the following icons is used to make text bold?
