BITM 215 ch 9-12 QUESTIONS & ANSWERS
What is the purpose of grouped worksheet?: D. To apply formatting or data to multiple sheets at the same
time.
1. What is the purpose of a Watch Window?: D. To arrange windows in an easy-to-read format
2. What is the purpose of data validation?: D. To limit the number of data entry errors.
3. PowerQuery is used to and PowerPivot is used to ?: A. Get and
Transform Data,
Analyze Data
4. Why would you create and use a data model?: C. To integrate data from multiple sources in
Excel.
5. What is a text string in Excel?: C. A sequence of alphanumeric characters and symbols.
6. What is the primary function of the Document Inspector in Excel?: B. It reviews the
document for hidden metadata and personal information.
7. What is a macro in Excel?: C. A series of commands and instructions grouped together to automate
repetitive tasks.
8. Grouped worksheets can only be ungrouped when workbook protection is
enabled.: False
9. Watch Windows can only show cell contents of one sheet: False
10. Data shaping refers to transforming rows into columns.: True
11. Text strings will not work when used in mathematical calculations: False
12. An array function is a function that performs multiple calculations on one or more
sets of values, andthen returns either a single result or multiple results.: True
13. A template is a partially completed document used as a model to create other
documents that have the same structure and purpose.A. TrueB. FalseC- ompatibility
checker evaluates the workbook's contents to identify what data and features are not
compatible with previous versions.A. TrueB. False: True
1/9
, 14. Compatibility checker evaluates the workbook's contents to identify what data
and features are not compatible with previous versions.: True
15. What is concat used for in excel?: Combining text strings
16. What are database functions used for in excel?: Working with lists of data and extracting
specific information
17. What are functions used for in excel?: Performing calculations on multiple values or ranges of cell
simultaneously
2/9
What is the purpose of grouped worksheet?: D. To apply formatting or data to multiple sheets at the same
time.
1. What is the purpose of a Watch Window?: D. To arrange windows in an easy-to-read format
2. What is the purpose of data validation?: D. To limit the number of data entry errors.
3. PowerQuery is used to and PowerPivot is used to ?: A. Get and
Transform Data,
Analyze Data
4. Why would you create and use a data model?: C. To integrate data from multiple sources in
Excel.
5. What is a text string in Excel?: C. A sequence of alphanumeric characters and symbols.
6. What is the primary function of the Document Inspector in Excel?: B. It reviews the
document for hidden metadata and personal information.
7. What is a macro in Excel?: C. A series of commands and instructions grouped together to automate
repetitive tasks.
8. Grouped worksheets can only be ungrouped when workbook protection is
enabled.: False
9. Watch Windows can only show cell contents of one sheet: False
10. Data shaping refers to transforming rows into columns.: True
11. Text strings will not work when used in mathematical calculations: False
12. An array function is a function that performs multiple calculations on one or more
sets of values, andthen returns either a single result or multiple results.: True
13. A template is a partially completed document used as a model to create other
documents that have the same structure and purpose.A. TrueB. FalseC- ompatibility
checker evaluates the workbook's contents to identify what data and features are not
compatible with previous versions.A. TrueB. False: True
1/9
, 14. Compatibility checker evaluates the workbook's contents to identify what data
and features are not compatible with previous versions.: True
15. What is concat used for in excel?: Combining text strings
16. What are database functions used for in excel?: Working with lists of data and extracting
specific information
17. What are functions used for in excel?: Performing calculations on multiple values or ranges of cell
simultaneously
2/9
