WorksheetsExcel Dynamic Arrays Quiz
Total questions: 15
Worksheet time: 8mins
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
What is an example of a sub-category in a pivot table's value area?
A formula.
A Country field.
An operator.
A template.
What is a template in Excel?
A sequence of characters within a cell that is used to generate a value.
Symbols and signs that determine which calculations to be performed.
An Excel workbook or worksheet designed to assist users in completing a given task.
The data that went into making the pivot table.
What is another name for a formula in Excel?
Template.
Expression.
Operator.
Value area.
What is the function of the AutoSum feature in Excel?
To copy data to several cells
To add up the figures in your sheet
To apply a format to cells that meet certain criteria
To detect issues with formulas
What is a Table Pivot most often used for in Excel?
To create charts and graphs
To dynamically organize, aggregate, and sum data
To format text in cells
To protect the worksheet with a password
