NEW
Font size
WorksheetsICT 4 - 3RD QT ASSESSMENT
Total questions: 25
Worksheet time: 13mins
This may contain different types of data. It can be words, numbers, mathematical formulas, or functions.
Worksheet
Workbook
Workplace
Work Material
Which among the choices below best describes what a Spreadsheet is?
It is a computer program used to process mathematical data.
It is a computer program that helps us do what we want.
It is a computer program that makes life easier!
It does all the solving for me.
Why is Excel important? Who even uses it?
Parents, business people, and even our teachers!
Me, Myself and I
Those who are bored
Companies and their employees
The three (3) basic types of data are:
Labels, Values, and _____?
Text
Formulas
Solutions
Words
Do you still remember how to merge cells together?
Which command do we choose in the Alignment Group to do it so?
Merge & Center
Wrap Text
It is a single cell that is created by combining two or more cells.
Merged Cell
Combined Cell
Collaboration Cell
Merging Cell
What is the keyboard shortcut to cut a text?
CTRL + P
CTRL + C
CTRL + X
CTRL + V
How do we easily copy a text/cell?
CTRL + C
CTRL + P
CTRL + O
CTRL + V
Which group in the Ribbon can we find the command to insert and delete a cell/row/worksheet?
Clipboard Group
Font Group
Cells Group
Editing Group
Which among the choices below can we hide/unhide?
Worksheet
Workbook
Cell
Row
It is a set of formatting attributes such as font name, size, alignment, and text color.
Style
Font
Table
Design
When do we use the command Cell Styles on Excel?
When we want to edit a cell
When we want to edit a table
When we want to make our worksheet look pretty
When we're bored!
How many ways can we format numbers on Excel?
6 ways
7 ways
8 ways
1 ways
Which among the number formats displays and aligns currency sign and a dash for zero values?
Currency
Accounting
General
Number
Which number format on Excel do we choose when we want to format time values?
Date
Time
General
Percentage
What's the keyboard shortcut for printing on Excel?
CTRL + O
CTRL + P
CTRL + C
CTRL + H
How do we call a document/workbook that has already been printed?
Soft Copy
Hard Copy
It is a data type that tells the computer what mathematical operation to perform upon a specific value.
Function
Formula
Operator
Cell Reference
The formula consists of three (3) parts:
Equal Sign, Function Name and _______?
Data
Cell Reference
Arguments
Operator
What keyboard shortcut do we use to make a cell absolute?
F4
F2
F5
F1
What operation does the operator above do?
Addition
Multiplication
Subtraction
Division
This operator divides the value of a cell.
/
*
+
-
What's the role of Functions in Excel?
It allows us to quickly add the values in a range of cells.
They are ready-made formulas that are displayed.
They are ready-made formulas that perform calculations.
It allows us to make ready-made formulas.
This type of Function calculates the average group of numbers.
=AVERAGE
=SUM
=VALUE
=DIVIDE
Which function do we use to key in the current date?
=TODAY()
=RIGHTNOW()
=NOW()
=DATE()
