Flashcards
Grade 9 ICT Exam- Excel
Cards in this deck (12)
- 1What is a cell?The intersection of a row and column.
- 2What is a relative cell reference?A cell reference that reflects the row or column it has been copied to.
- 3What is formula?A mathematical statement used to calculate value.
- 4What are adjacent cells?Cells that are next to each other.
- 5What is an absolute cell reference?A cell reference that does not change when copied because of a dollar sign put in front of the column letter and row number.
- 6What is PMT function?Function that calculates the periodic payment for an installment loan.
- 7What does the IF function?A function that is used to make a decision based on comparison.
- 8What is a sparkline?A mini chart that can be displayed in a cell.
- 9What colour triangle will a cell show when an invalid formula is entered?A green triangle will appear with an error value.
- 10List three example uses for a spreadsheet application.Data Collection, Personal Budgets and Cost Calculations.
- 11What is the difference between plot area and chart area?Plot area is the area where data is displayed on a chart. Chart Area is the entire chart with all its elements.
- 12Where are category axis labels displayed and value axis labels?Category axis labels are displayed on the bottom and value axis labels are displayed on the left of the chart.
Information
- Description
- Grade 9 ICT Flashcards on Grade 9 ICT Exam- Excel, created by Gurman on 05/12/2014.
- Created by
- Gurman
- Views
- 17
- Rating