NEW
Font size
WorksheetsE-Tech na yan!
Total questions: 20
Worksheet time: 20mins
Displays the both name of application and the name of the spreadsheet.
Name Box
Spreadsheet Area
Worksheet Tabs
Title Bar
A grid of cells organized into rows and columns in which we enter and store our data.
Spreadsheet Area
Name Box
Insert Function
All of the above
The ___ is located at the bottom of the screen, below the working area. It displays information about the current activities in the worksheet.
Active Cell
Status Bar
Insert Function
Dialog Launcher
It is a section in Microsoft Excel and other spreadsheet applications. It shows the contents of the current cell and allow you to create and view formulas.
Active Cell
Formula Bar
Command Buttons
Ribbon Group
Alternatively referred to as a cell pointer, current cell, or selected cell, a ______ is a rectangular box that highlights the cell in a spreadsheet.
Formula Bar
Dialog Launcher
Ribbon Group
Active Cell
The function that lets you add up a range of cells or values
AVERAGE
SUM
MIN
MAX
The function COUNT is used for counting cells that contain
numbers and logical values only
text, numbers and logical values only
text, numbers, logical values and error values only
text, numbers, logical values, error values, and empty text (" ")
In a worksheet, the horizontal spaces with the headings 1, 2, 3 and so on
row
column
label
cell address
Microsoft Excel is categorized as a ________________ software.
Database
Spreadsheet
Presentation
Word Processing
In a worksheet, the vertical spaces with the headings A, B, C and so on
row
column
label
cell address
The ______________ function is used to determine how many pupils were able to get a passing score in a test.
COUNT
COUNTA
COUNTIF
COUNTBLANK
What computer application gives the user the ability to do calculations, create tables and can edit values?
Microsoft Word
Microsoft Excel
Microsoft OneNote
Microsoft PowerPoint
What is the formula that will add the data of cells A1 to A10?
=SUM(A1:A10)
=AVE(A1:A10)
SUM(A1:A10)
=A1+10
Teacher Mark wants to input an equation to his spreadsheet to calculate the grades of his student, where should he enter the equation?
EXCEL FORMULA
EQUATION BAR
FORMULA BAR
ALL OF THESE ARE CORRECT
A formula always starts with an _______.
Equal sign
Additional sign
Multiplication sign
Division sign
Ctrl + X is the shortcut key for?
Copy
Paste
Cut
Undo
What is the formula to calculate the average of cells A1 to A10?
=AVERAGE(A1:A10)/10
=AVERAGE(A1:A10)*10
=AVERAGE(A1:A10)
=SUM(A1:A10)/10
Sum, average, count, and maximum value are examples of what?
Formulas
Functions
Calculations
Spreadsheet Data
Part of Microsoft Excel that is located at the bottom of the spreadsheet.
Workbook
Sheets
Worksheet Tabs
Blank Sheets
Create a formula to determine the sum of the average grades of all female students in the list.
=SUMIF(B3:B8, “Female”, F3:F8)
=AVERAGEIF(B3:B8, “Female”, F3:F8)
=SUMIF(F3:F8, “Female”, B3:B8)
=AVERAGEIF(F3:F8, “Female”, B3:B8)
