Spreadsheet and Tabulation Quiz

What is the primary purpose of a spreadsheet?

• To store only text data.

• To create simple tabulations such as invoices and price lists.

• To perform advanced text processing.

• To create presentations.

Which software suite includes Excel as a spreadsheet application?

• Google Workspace

• OpenOffice

• Microsoft Office

• LibreOffice

What is a worksheet in a spreadsheet program?

• A collection of related spreadsheets.

• A single working area consisting of a grid of columns and rows.

• A type of chart used for data visualization.

• A document that contains only text.

What does a formula in a spreadsheet do?

• It saves the spreadsheet.

• It creates a new worksheet.

• It performs calculations on values in the worksheet.

• It formats the text in a cell.

Which of the following is NOT a type of chart available in spreadsheets?

• Bar chart

• Column chart

• Pie chart

• Text chart

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

• To delete data from cells.

• To copy data or formulas to adjacent cells.

• To format cells.

• To create a new workbook.

What is a workbook?

• A single spreadsheet file.

• A document for text processing.

• A collection of related worksheets saved as one file.

• A type of chart.

Which of the following is a pre-defined function in spreadsheets?

• TOTAL

• SUM

• AVERAGEALL

• COUNTIF

What does the Name Box display in a spreadsheet?

• The last saved date.

• The total number of cells.

• The cell reference of the active cell.

• The name of the workbook.

What is the purpose of formatting a worksheet?

• To change the appearance and improve readability.

• To delete unnecessary data.

• To create new worksheets.

• To save the file.