Spreadsheet Basics Quiz

What is a spreadsheet commonly used for?

• To organize, analyze, calculate, and report information, usually in numerical form.

• To create visual art and designs.

• To write and format large text documents.

• To manage and track inventory in warehouses.

What is a workbook in the context of spreadsheets?

• A printed set of financial reports.

• A file which contains one or more spreadsheets.

• A manual for learning how to use spreadsheet software.

• A collection of written worksheets for students.

Which of the following is NOT a daily use of spreadsheets mentioned in the material?

• Balancing a checkbook

• Calculating car loans

• Household budgets

• Writing a formal letter

What is one reason a business might use spreadsheets?

• To play video games

• To create visual art

• To manage payroll

• To browse the internet

What is a Cell in a spreadsheet?

• A collection of rows and columns

• The name of a spreadsheet software

• An individual location on a spreadsheet

• A function used in spreadsheet calculations

How are Columns identified in a spreadsheet?

• By numbers

• By letters of the alphabet

• By special symbols

• By colors

What does Column A refer to in a spreadsheet?

• All of the contents in a horizontal range of cells in the first row

• The first cell in the top-left corner of the spreadsheet

• All of the contents in a vertical range of cells in the first column

• The entire spreadsheet

How are Rows identified in a spreadsheet?

• By letters of the alphabet

• By colors

• By numbers

• By special symbols

What does Row 3 refer to in a spreadsheet?

• All of the contents in a vertical range of cells on Column 3

• All of the contents in a horizontal range of cells on Row 3

• The third cell in the top row of the spreadsheet

• The entire third column of the spreadsheet

What does the cell range A4:A16 refer to?

• A single cell at the intersection of column A and row 16

• A group of adjacent cells from A4 to A16

• The entire column A in a spreadsheet

• A specific function in a spreadsheet