Spreadsheet 1
This shows which cell you are currently working in.
What is the Name Box.
This function is used to add values in MS Excel.
What is the sum function?
To apply specific formatting to a cell
Conditional Formatting
The vertical lines of a spreadsheet are called what?
Column
True/False: Excel automatically saves.
False
This function will automatically fill data into cells when it recognizes a pattern.
What is autofill.
A statement that performs a calculation in a spreadsheet.
What is Formula or function?
This chart is best used to show quantity
What are bar charts.
True or false, we can insert an image into a cell.
True
Which function would should be use to find the highest value in a range?
The Maximum Function
A Spreadsheet is made up ______ and __________which run horizontally and vertically.
What are column and rows.
A collection or group of two or more cells on a spreadsheet.
What is a cell 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, what shortcut allows him to "undo" his mistake?
What is "Control Z"
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
List two (2) 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