INFORMATION AND COMMUNICATION TECHNOLOGY
ICT LEVEL ONE & TWO
SUBJECT: SPREADSHEET MANAGEMENT QUESTIONS
INSTRUCTIONS: Answer all question in SECTION A and SECTION B You
Are advised not to spend more than 1 hour on SECTION A.
SECTION A
Answer All Question
A spreadsheet is a software application or tool used for organizing, analyzing, and storing data in a tabular form.
It consists of rows and columns, where each intersection of a row and column is called a cell.
Spreadsheets are commonly used for tasks such as data entry, calculations, data analysis, and creating visual representations of data using charts and graphs.
It consists of rows and columns, where each intersection of a row and column is called a cell.
Spreadsheets are commonly used for tasks such as data entry, calculations, data analysis, and creating visual representations of data using charts and graphs.
A worksheet is a single sheet or tab within a workbook where data is entered, organized, and manipulated. It is the basic unit of a spreadsheet and contains rows, columns, and cells.
A workbook is a collection of worksheets that are grouped together. It acts as a container for multiple worksheets and allows you to organize related data and calculations.
In Excel, when you open the application, a new workbook is created by default.
Workbooks can be saved as separate files and can contain various worksheets, charts, macros, and other elements.
AutoFormat is a feature in MS Excel that allows you to quickly apply predefined formatting styles to selected cells or ranges. It helps to improve the visual appearance of the data and make it more readable and presentable.
- Bar Chart: displays data using rectangular bars, where the length of each bar represents the value of a particular category. It is commonly used to compare and show the relative values of different data points or categories.
- Line Chart: displays data points connected by lines, emphasizing the trend or change in values over a continuous period. It is useful for visualizing data that shows a progression over time, such as sales figures or stock prices.
- Pie Chart: represents data as slices of a circle, where each slice represents a specific category or proportion of the whole. It is effective for showing the composition or distribution of data and is commonly used for displaying percentages or parts of a whole.
To protect a worksheet in MS Excel, you can use the "Protect Sheet" feature.
This feature allows you to restrict certain actions or modifications to the worksheet, such as preventing users from editing or deleting data, changing cell formatting, or adding new sheets.
By protecting a worksheet, you can ensure the integrity and security of the data while allowing users to view and interact with the worksheet according to the specified permissions.
This feature allows you to restrict certain actions or modifications to the worksheet, such as preventing users from editing or deleting data, changing cell formatting, or adding new sheets.
By protecting a worksheet, you can ensure the integrity and security of the data while allowing users to view and interact with the worksheet according to the specified permissions.
A cell is the basic unit of a spreadsheet, It is the intersection of a row and a column and is identified by a unique address, such as A1, B2, C3, etc.
Each cell can contain different types of data, including numbers, text, formulas, or functions.
Cells are used for data entry, calculations, and data manipulation.
Each cell can contain different types of data, including numbers, text, formulas, or functions.
Cells are used for data entry, calculations, and data manipulation.
Logical operators in MS Excel are used to perform comparisons or logical operations between two or more values.
They return a logical value of TRUE or FALSE based on the evaluation of the specified conditions. Here are three examples of logical operators in MS Excel:
They return a logical value of TRUE or FALSE based on the evaluation of the specified conditions. Here are three examples of logical operators in MS Excel:
- Equal to (=):
The equal to operator compares two values and returns TRUE if they are equal, and FALSE otherwise.
For example, the formula "=A1=B1" compares the values in cell A1 and B1. If they are equal, the result will be TRUE; otherwise, it will be FALSE. - Greater than (>):
The greater than operator compares two values and returns TRUE if the left value is greater than the right value, and FALSE otherwise.
For example, the formula "=A1>B1" compares the values in cell A1 and B1. If the value in A1 is greater than the value in B1, the result will be TRUE; otherwise, it will be FALSE. - Not equal to (<>):
The not equal to operator compares two values and returns TRUE if they are not equal, and FALSE if they are equal.
For example, the formula "=A1<>B1" compares the values in cell A1 and B1. If they are not equal, the result will be TRUE; if they are equal, the result will be FALSE.
Notes
These logical operators can be used in various formulas, functions, and conditional formatting to perform logical tests, make comparisons, and control the flow of calculations or actions based on specific conditions.
SECTION B - PRACTICALS
| Job Category | 2006 | 2007 |
|---|---|---|
| Fishing | 2141 | 2200 |
| Farming | 4330 | 6421 |
| Transport | 5400 | 66 |
| Retail | 1350 | 4350 |
| Services | 185 | 200 |
From the above table, you are required to:
- Create a worksheet
- Format the two columns to display commas with no decimal places. Add an appropriate title to the worksheet.
- Add a third column with the heading “% change”
- Enter the formula to calculate the percentage change from 2006 to 2007.
- Format the data appropriately.
- Draw an embedded pie chart of job category and % change.
- Save the work as JOB
- Print your work
