Font size
WorksheetsQUIZ #4 LESSON 4
Total questions: 21
Worksheet time: 20mins
It is a software application that enables a user to save, sort and manage data in an arranged form of rows and columns.
(a)
Identified with numeric headings.
(a)
The Name of the Student is Shalleen Guzman from section Theus . This is the grades of Shalleen Per Subject . English 85 , Science 90 , ICT 89 , Math 95 , Filipino 90 .
Now solve this Grades to get the Average of Shalleen using Formula . And after you get the Average . Get the Remarks of Shalleen using the formula . Show your complete formula in your Answer . If not , not counted.
Use MS Excel/Spread Sheet to solve this Question . If you don't have a Laptop use Cellphone and Download the MS excel or WPS
( THIS IS 5 POINTS )
Identified with alphabetic headings
(a)
the currently selected cell in a spreadsheet and is indicated by a bold outline that surrounds the cell
(a)
also known as cell address that identifies a cell on a worksheet.
(a)
are the intersection of rows and columns
(a)
uses standard operators for formulas.
(a)
These are pre-defined formulas that are already available in MS Excel.
(a)
A formula always begin with an (a)
Returns the smallest number in a set of values.
( USE CAPITAL LETTER )
(a)
Returns the largest number in a set of values.
( USE CAPITAL LETTER )
(a)
Returns the average (arithmetic mean) of the arguments.
(a)
These are the cells containing numeric values and the cells to add if the condition is met.
(a)
A value or logical expression that can be evaluated as True or False.
(a)
Adds all the numbers in a range of cells
( USE CAPITAL LETTER )
(a)
How Many columns in Alphabetical Headings
1,098,873 Colums
16,384 Columns
17,930 Columns
188,288 Columns
How Many columns in Numeric Headings
1,049,578 Columns
3,038,546 Columns
2,688,516 Columns
1,048,576 Columns
Identifies the purpose of the cell, it can be a brief instruction, a title or caption.
Texts or Data
Texts or labels
Texts or Source
Texts or If
A value that doesn’t change and is directly inserted into a cell.
Number data
Number Sign
Data Text
Data Source
This function is one of the most popular functions in Excel. It can perform a logical test
(a)
