GRADED
What is the purpose of grouped worksheet?
To apply formatting or data to multiple sheets at the same time.
What is the purpose of a Watch Window?
To see how changes in data affect formulas on another table
What is the purpose of data validation?
To limit the number of data entry errors
PowerQuery is used to ____ and PowerPivot is used to ____?
Get and Transform Data, Analyze Data
Why would you create and use a data model?
To integrate data from multiple sources in Excel.
What is a text string in Excel?
A sequence of alphanumeric characters and symbols.
What is the primary function of the Document Inspector in Excel?
It reviews the document for hidden metadata and personal information.
What is a macro in Excel?
A series of commands and instructions grouped together to automate repetitive tasks.
Grouped worksheets can only be ungrouped when workbook protection is
enabled.
False
Watch Windows can only show cell contents of one sheet.
False
Data shaping refers to transforming rows into columns.
False
Text strings will not work when used in mathematical calculations.
False
An array function is a function that performs multiple calculations on one or more
sets of values, and then returns either a single result or multiple results.
True
A template is a partially completed document used as a model to create other
documents that have the same structure and purpose.
True
Compatibility checker evaluates the workbook's contents to identify what data
and features are not compatible with previous versions.
True
What does the Concatenate do in Excel.
The CONCAT function is a text function that joins up to 254 text strings into one text
string.
What does the database function do in Excel.
A function that analyzes data for selected records in a dataset using a criteria range.
What two traces are provided by the audit options?
Precedent, Dependents