Mastering Spreadsheets for IGCSE ICT

What is a spreadsheet?

• A spreadsheet is a tool for editing images and graphics.

• A spreadsheet is a software used for creating presentations.

• A spreadsheet is a digital tool for organizing and analyzing data in tabular form.

• A spreadsheet is a type of physical notebook for writing notes.

How do you create a new spreadsheet in Excel?

• Open Excel, go to View > New Window.

• Right-click on the desktop and select New > Excel Spreadsheet.

• Open Excel, go to File > Save > New Document.

• Open Excel, go to File > New > Blank Workbook.

What is cell referencing in spreadsheets?

• Cell referencing is the method of using cell addresses to access and manipulate data in spreadsheets.

• Cell referencing is the method of printing spreadsheet data on paper.

• Cell referencing refers to the color coding of cells in a spreadsheet.

• Cell referencing is the process of creating new spreadsheets.

Explain the difference between relative and absolute cell references.

• Relative references adjust based on the position of the cell, while absolute references do not change when copied.

• Both relative and absolute references are the same in functionality.

• Relative references are fixed and do not change when copied.

• Absolute references adjust based on the position of the cell.

How do you format a cell in a spreadsheet?

• Select the cell, click 'Delete', and remove formatting.

• Highlight the cell, press 'Ctrl + Z', and undo any changes.

• Click on the cell, go to 'File', and save the document.

• Select the cell, right-click, choose 'Format Cells', and select formatting options.

What is the purpose of using formulas in spreadsheets?

• To create visual charts and graphs only.

• To format text and change colors in cells.

• The purpose of using formulas in spreadsheets is to perform calculations and automate data processing.

• To store data without any calculations.

How do you enter a formula in a cell?

• Right-click the cell, choose 'Insert Formula', and type your formula.

• Click on the cell, type '=', enter the formula, and press Enter.

• Select the cell, type '=', and click the formula bar to enter the formula.

• Click on the cell, type '!', enter the formula, and press Enter.

What is the function of the SUM formula?

• To determine the maximum value in a list of numbers.

• To count the number of entries in a dataset.

• To find the average of a set of numbers.

• The function of the SUM formula is to calculate the total of a set of numbers.

How can you create a chart from spreadsheet data?

• Choose chart type, then delete the data.

• Select data, go to 'File', and print.

• Select data, go to 'Insert', choose chart type, and customize.

• Go to 'View', select 'Chart', and export.

What types of charts can be created in Excel?

• histogram charts

• Bar charts, line charts, pie charts, scatter plots, area charts, column charts, doughnut charts, radar charts, and surface charts.

• waterfall charts

• box plots