Font size
WorksheetsICT 5 - 3RD QT ASSESSMENT
Total questions: 25
Worksheet time: 15mins
What is a spreadsheet?
Choose the best answer.
It is a computer program that we use.
It is a computer program used to process mathematical data.
It is a computer program that people use for work.
It is a computer program that helps feed the hungry.
Who uses spreadsheets?
Everyone no matter how old or young!
Teachers and Students
Teachers, Parents, Business People, and Students
(a) is one of the most popular spreadsheet programs today. It allows us to store, organize, and analyze information.
How many types of basic data do we have?
Two
Three
Four
Five
Study the picture above.
What kind of data is it?
Label
Value
Formula
How do we call the kind of data that begins with an equal sign and may contain mathematical operators?
Value
Argument
Formula
Function
What does the Thick Cross mouse pointer do in Excel?
It selects a single or group of cells.
It copies a formula.
It is used to widen a column.
It is used for menus.
How many significant mouse pointer appearances do we have to take note of on Excel?
Six (6)
Seven (7)
Eight (8)
Nine (9)
It is a single cell that is created by combining two or more cells. What is it?
Merged Cell
Mergeable Cell
Merging Cell
Margin Cell
In the Ribbon of Excel as seen above, which group can we find the command to merge cells together?
Font Group
Editing Group
Styles Group
Alignment Group
What happens when we Wrap Text on Excel?
It helps us see all of the text by displaying it into multiple lines.
It wraps the text like a bubble wrap! Literally!
It makes the font smaller so the text fits inside the cell.
It helps make a cell wider.
What can we not do with a worksheet among the choices below?
Put graphics around it
Rename it
Change its color
Hide and Unhide it
What is the shortcut key to cut a text/cell?
CTRL + S
CTRL + C
CTRL + X
CTRL + R
What is the shortcut key for pasting a content of a cell?
CTRL + C
CTRL + P
CTRL + V
CTRL + O
(a) is an expression in Excel which calculates the value of a cell.
How do you call the Cell Reference that changes when copied into another cell?
(a)
What is keyboard shortcut that we use to make a cell absolute?
F4
F2
F3
F6
When do we see this error (########) in Excel? What could it possibly mean?
Excel does not recognize the text in the formula.
Wrong type of argument.
Cell is not valid.
Column is not wide enough to display the value.
When do we see this error (#NAME?) in Excel? What could it possibly mean?
Excel does not recognize the text in the formula.
Column is not wide enough to display the value.
A formula tries to divide a number by 0 or an empty cell.
Cell is not valid.
Now, how about this common error (#REF!) in Excel? What could it possibly mean?
Wrong type of argument.
Excel does not recognize the text in the formula.
Cell is not valid.
Column is not wide enough to display the value.
What must we add before the letter and number when we want to make a cell absolute?
#
$
*
@
What are the two (2) types of Cell References?
Relative References
Relevant References
Functional References
Absolute References
(a) are ready-made formulas that perform calculations on a specified range of values.
This function allows us to calculates the average of a group of numbers.
=SUM()
=NOW()
=AVE()
=AVERAGE()
Study the table above. What function was used in the second column (Result Column)?
=SUBSTITUTE
=LOWER
=UPPER
=TEXT
