Spreadsheets
Explain the function of the protect sheet feature in the spreadsheet program
- It is a feature used to prevent unwanted changes to be made on the data contained in a sheet by limiting the ability to make changes
Explain the purpose of each of the following features of a spreadsheet chart (KCSE 2021 Computer Studies, Q19 (a))
Legend
- Legends are a small visual representation of the chart's data series to understand each without confusion.
A data series
- is a row or column of numbers that are entered in a worksheet and plotted in your chart, such as a list of quarterly business profits
- A group of related data points or markers that are plotted in charts and graphs
Data Marker
Explain the purpose of each of the following features of a spreadsheet chart (KCSE 2021, Q19 (a))
Legend
- Legends are a small visual representation of the chart's data series to understand each without confusion.
A data series
- is a row or column of numbers that are entered in a worksheet and plotted in your chart, such as a list of quarterly business profits
- A group of related data points or markers that are plotted in charts and graphs
Data Marker
- A symbol on the chart that represents a single value in the worksheet.
- A column, dot, pie slice, or another symbol in the chart representing a data value
https://www.lifewire.com/data-series-data-points-data-labels-3123411
Distinguish between a formula and a function as used in spreadsheets
- A formula is a mathematical expression that returns a value
- A function is an excel inbuilt formula that returns a value given a range of values or arguments
Explain the purpose of each of the following features of a spreadsheet chart (KCSE 2021, Q19 (a))
- Legend
-
A data series
-
Data Marker
Legend
- Legends are a small visual representation of the chart's data series to understand each without confusion.
A data series
- is a row or column of numbers that are entered in a worksheet and plotted in your chart, such as a list of quarterly business profits
- A group of related data points or markers that are plotted in charts and graphs
Data Marker
- A symbol on the chart that represents a single value in the worksheet.
- A column, dot, pie slice, or another symbol in the chart that represents a data value
State the formatting features used in Ms Excel
-
Font Formatting:
- Font Style: You can change the font style (e.g., Arial, Times New Roman) for cell content.
- Font Size: Adjust the size of the text within cells.
- Bold, Italic, and Underline: Apply these formatting options to emphasize text.
- Font Color: Change the color of the text.
-
Cell Formatting:
- Number Formats: Apply various number formats, such as currency, percentage, date, and time.
- Cell Borders: Add or remove borders around cells or cell ranges.
- Fill Color: Change the background color of cells.
- Text Alignment: Control how text is aligned within cells (left, right, center, top, bottom).
- Text Wrapping: Allow text to wrap within a cell if it's too long to fit in one line.
State four data types used in MS Excel
- Labels
- Values
- Formula
- Functions
State any four applications of electronic spreadsheets
- Financial accounting
- Prediction and forecasting
- Inventory keeping
- Budgeting
- Keeping records
