Spreadsheet Features and Functionalities

Explain how calculations/formulae such as SUM/COUNT/IF can be used in spreadsheets to perform calculations/answers/maths.

• They automate data analysis and calculations.

• They are used for formatting text.

• They are used to create charts and graphs.

• They are used to import data from the internet.

Linking spreadsheets/worksheets using formula can be beneficial because:

• it allows for dynamic data updates across sheets.

• it makes the spreadsheet look more colorful.

• it prevents any errors in data entry.

• it automatically creates charts and graphs.

Figures are recalculated or automatically updated when the numbers change in a spreadsheet by:

• manually refreshing the data

• using formulas and functions

• re-entering all data

• saving the spreadsheet again

What are the steps to sort data into ascending or descending order in a spreadsheet?

• Select the data range, then choose 'Sort' from the menu and select 'Ascending' or 'Descending'.

• Click on 'File', then 'Open', and choose 'Sort'.

• Go to 'Insert', then 'Chart', and select 'Sort'.

• Select 'View', then 'Zoom', and choose 'Sort'.

How can text formatting tools like bold, borders, font, text alignment, and color be used to make important data stand out in a spreadsheet?

• By making the data visually distinct and easier to read

• By hiding the data from view

• By converting the data into a different format

• By removing all formatting from the data

Explain how number formats like currency, percentages, and decimal places can be applied in spreadsheets.

• By using the format cells option in the spreadsheet software.

• By manually typing the format in each cell.

• By using a separate software to format numbers.

• By converting numbers to text format.

The purpose of merging cells to make a heading in a spreadsheet is to:

• create a unified title across multiple columns

• increase the font size of the text

• add color to the cells

• insert a hyperlink

How can naming cells make them absolute in a spreadsheet?

• By using the cell name in formulas

• By locking the cell reference

• By using the $ symbol

• By changing the cell format

Absolute cells allow you to replicate a formula without a cell changing in a spreadsheet because:

• they lock the reference to a specific cell.

• they automatically adjust the reference.

• they allow dynamic cell referencing.

• they enable conditional formatting.

The process of creating a chart (e.g., bar, line, pie) to present information in a spreadsheet involves:

• Selecting the data range and choosing the chart type

• Writing a formula to calculate chart values

• Entering data manually into the chart

• Using a template to automatically generate a chart