Spreadsheet 1
A function is used to add values in MS Excel.
What is the sum function?
The intersection of a row and a column on a spreadsheet in which data can be entered.
A Cell
The vertical lines of a spreadsheet are called what?
Column
How many worksheets are there in a spreadsheet by default?
Three (3)
List four (4) things we can use Microsoft Excel to do
1.Store and organize data,
2.Analyze data
3. Represent data graphically (e.g., in bar graphs, pie charts etc)
4.Do Simply and complex calculations
Fill in the blank........Rows are represented by ___________ While ____________ are represented by letters.
numbers
columns
Fill in the blank....The ___________is the column letter and the row number for e.g. A1
identify the error in the function below
sum(a1:a5)
The = sign is missing
what's the difference between the active cell and the cell address?
The active cell is the cell selected or in use, while cell address is the column letter and row number
Word Processing is to MS word while Spreadsheet is to_________________
MS Excel
Excel is a book called ___________ which consist of many pages called worksheet
A workbook
A single page in a Workbook is called a _______?
What is Worksheet?
John wants to find the smallest value from A1:A5, Which function should he use?
The Minimum function i.e. =min(A1:A5)
Identify the errors in this function
=averag(A1:5A)
The "e" is missing from average
5A should be A5
A Spreadsheet is made up of two lines what are they?
Vertical and horizontal lines
A collection or group of two or more cells on a spreadsheet.
What is a range?
The name box is a part of the spreadsheet, what is the purpose of the name box?
to display the the cell address of the active cell
John type a a formula but later realized it's incorrect, where should he click to adjust the formula?
The formula Bar
How is the active cell different from the other cells?
It has a thick green or dark border around it
A statement that performs a calculation in a spreadsheet.
What is Formula or function?
True or false, we can have more than one active cell at a time?
False
Which function would should be use to find the highest value in a range?
The Maximum Function