Excel Dynamic Arrays Quiz

What is an Excel spreadsheet document referred to as?

• Workbook

• Worksheet

• Spreadsheet

• Table

What does a workbook in Excel do?

• Saves all of the information and helps you to filter and measure the results

• Formats text and numbers

• Creates charts and graphs

• Manages email contacts

What is the primary function of a cell in a spreadsheet?

• To store data

• To print documents

• To send emails

• To browse the internet

What is the orientation of columns in a spreadsheet?

• Vertically

• Horizontally

• Diagonally

• Randomly

What can headings be used to adjust in a spreadsheet?

• Font style

• Row height or column width

• Cell color

• Page layout

What is the Ribbon in a workbook?

• A single cell

• A section of control tabs

• A type of formula

• A collection of worksheets

Where is the Ribbon located in a workbook?

• Below the workbook

• To the left of the workbook

• Just above the workbook

• To the right of the workbook

What does the cell reference C4:F9 indicate?

• A single cell

• A range of cells in column C

• A range of cells from column C to F and rows 4 to 9

• A 3-D reference

What does the term "array" refer to in Excel?

• A single cell

• A set of cells grouped together

• A type of chart

• A formula

Which of the following is an example of a 3-D reference?

• A1:B1

• Sheet1!A1:Sheet2!B1

• A1

• B1:C1