Answer: Data from multiple workbooks can be combined in a single step.
Explanation:
The Subtotal command allows the creation of groups automatically and common functions such as COUNT, SUM, and AVERAGE are used in the summarizing of data.
An advantage of using the Subtotal dialog box is that data from multiple workbooks can be combined in a single step. Therefore, the correct option is B.
Answer: C) Both a and b
Explanation:
The main benefit of normalizing the database as it reduced the redundant data and due the lack of the redundant data, it saves lots of space in the database.
It also improve the update time in the database so it is easy to handle the database security in the system.
It is also has ability to store the dangling tuples so it can easily store all the information of the customer without introduce any inconsistencies in the database system.
Therefore, Option (C) is correct.