Spreadsheet Basics Quiz

What is a workbook?

• A file which contains one or more spreadsheets.

• A single cell in a spreadsheet.

• A type of chart used in data analysis.

• A function used in calculations.

What does the term "cell address" refer to?

• A specific location in a spreadsheet.

• A range of cells in a spreadsheet.

• A type of data used in calculations.

• A function used in a formula.

What does the cell range A4:A16 refer to?

• A group of adjacent cells.

• A single cell in a spreadsheet.

• A type of data used in calculations.

• A function used in a formula.

What does Column A refer to in a spreadsheet?

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

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

• A specific cell in the spreadsheet.

• A type of data used in calculations.

What does a value classification indicate in cell data?

• The data has the potential to be used in calculations.

• The data will not be used in calculations.

• A specific cell in the spreadsheet.

• A function used in a formula.

Which type of cell reference remains static when copied to other locations?

• Relative

• Absolute

• Mixed

• Dynamic

Which of the following is NOT a formatting feature mentioned in the document?

• A header/footer

• Font Size and Style

• Justification

• Adding images

Which function finds the lowest number in a range of cells?

• =Sum

• =Average

• =Max

• =Min

Which formatting is usually applied to titles and column headings in a spreadsheet?

• Wrap

• Merge

• Center

• Column width

What is the function of the 'Wrap' feature in a spreadsheet?

• To combine two or more cells

• To align multi-line text within a cell

• To adjust the column width

• To add borders and shading