admin@kcseforecast.com

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