Spreadsheet 1
What are the pages in a workbook called?
Worksheets
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)
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?
list 2 types/ example of data that can be entered in a cell?
text, numbers, formula, 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
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
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?
what type of range is A1:C6
MIX RANGE
In the range "A1:A5", List all cells in the range
A1,A2,A3,A4,A5
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
What is the purpose of the formula bar
calculate and edit cells,formula
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