BUSI 520 CHAPTER 7 QUESTIONS AND ANSWERS
_____ can be used as a method to share data and a description of that data in an open
nonproprietary format for use by different programs. - Answers - XML
What's the best FUNCTION to use to change all instances of United States of America"
to U.S.A. ? - Answers - SUBSTITUTE is the best function to use. Enter the text phrase
"Welcome to the United States of America!" into a cell, and then attempt to use the
REPLACE function to replace "United States of America" with "U.S.A." You can't do it
without a significant amount of extra work (and using an additional function...LEN).
Sorting by ascending order is from Z to A. - Answers - False
The function of _____ returns the serial number of the last day of the month before or
after a specified number of months. - Answers - EOMONTH
You want to show the Average Salary for your Employees subtotaled by Title, so that
your Employees are grouped by Title, with the average salary for each Title summarized
beneath each group. You used the subtotal tool; however, rather than showing three
average salary values (for Managers, Account Reps and Trainees), it is showing
multiple averages for each of the Titles (as shown in the below screenshot). What's the
problem? - Answers - The data wasn't sorted properly before activating the Subtotal
tool.
The SEARCH function is case sensitive. - Answers - False
The FIND function is not case sensitive. - Answers - False
A database is a collection of fields that describe a specific entity. - Answers - False
Below is a list of descriptions (from the text/PowerPoint slides) that might help:
*Database -- Set of related data that is stored in tables *Table -- Collection of fields that
describe a specific entity *Field -- A single characteristic of the entity *Record -- Set of
fields that describes one product or person *Database management system -- Software
program that creates and accesses data in a database (e.g., Microsoft Access and
Oracle)
Use the _____ function to locate the position of an uppercase letter C in a text string,
while ignoring any instance of a lowercase "c". - Answers - FIND
The _____ function determines the number of characters in a text string. - Answers -
LEN
_____ can be used as a method to share data and a description of that data in an open
nonproprietary format for use by different programs. - Answers - XML
What's the best FUNCTION to use to change all instances of United States of America"
to U.S.A. ? - Answers - SUBSTITUTE is the best function to use. Enter the text phrase
"Welcome to the United States of America!" into a cell, and then attempt to use the
REPLACE function to replace "United States of America" with "U.S.A." You can't do it
without a significant amount of extra work (and using an additional function...LEN).
Sorting by ascending order is from Z to A. - Answers - False
The function of _____ returns the serial number of the last day of the month before or
after a specified number of months. - Answers - EOMONTH
You want to show the Average Salary for your Employees subtotaled by Title, so that
your Employees are grouped by Title, with the average salary for each Title summarized
beneath each group. You used the subtotal tool; however, rather than showing three
average salary values (for Managers, Account Reps and Trainees), it is showing
multiple averages for each of the Titles (as shown in the below screenshot). What's the
problem? - Answers - The data wasn't sorted properly before activating the Subtotal
tool.
The SEARCH function is case sensitive. - Answers - False
The FIND function is not case sensitive. - Answers - False
A database is a collection of fields that describe a specific entity. - Answers - False
Below is a list of descriptions (from the text/PowerPoint slides) that might help:
*Database -- Set of related data that is stored in tables *Table -- Collection of fields that
describe a specific entity *Field -- A single characteristic of the entity *Record -- Set of
fields that describes one product or person *Database management system -- Software
program that creates and accesses data in a database (e.g., Microsoft Access and
Oracle)
Use the _____ function to locate the position of an uppercase letter C in a text string,
while ignoring any instance of a lowercase "c". - Answers - FIND
The _____ function determines the number of characters in a text string. - Answers -
LEN
