ICT G-10 Electronic Spreadsheets Quiz

What is the primary function of a spreadsheet?

• Drawing charts

• Performing calculations

• Writing text

• Managing databases

Which of the following is NOT a common spreadsheet software?

• Microsoft Excel

• LibreOffice Calc

• Adobe Photoshop

• Apple Numbers

What is a worksheet in a spreadsheet?

• A set of rows and columns

• A set of tabs and functions

• A tool for formatting data

• A type of chart

In Excel, what is the formula bar used for?

• Viewing formulas and cell contents

• Adding charts

• Formatting cells

• Protecting data

What does the SUM function do?

• Finds the largest value

• Adds a range of cells

• Subtracts a range of cells

• Formats cells

What is a cell address in a spreadsheet?

• The name of a worksheet

• The name of a column

• The location of a cell defined by its column and row

• The title of the spreadsheet

What is the function of the fill handle in a spreadsheet?

• It copies formulas or data

• It formats cells

• It calculates the sum

• It enters text into cells

What is the symbol used for multiplication in a spreadsheet formula?

• +

• -

• *

• /

What does absolute cell reference mean in a formula?

• The cell reference changes when copied

• The cell reference stays constant

• The formula is deleted

• The data is formatted

In Excel, how are columns named?

• With numbers

• With Roman numerals

• With letters (A, B, C)

• With symbols