il in the blanks 1) A Pivot Table allows us to have a quick glance of the summary analysis of a large database. -) To highlight any data entry errors during data validation, we may use the eta kyseis pe button from the Data Validation group under the Data tab. . :) A teacher may use the balle button in the Data Form dialog box to locate all records of a particular day in a class attendance register. #) While using Advanced filters, the conditions that need to be satisfied simultaneously must be in the same (row/column). ) While using Advanced Filter, the range of cells that contain the same labels as the database and certain conditions to be applied on the database is called 37 Features of MS Excel
Answers
Answer:
Branch office is the primary key and should be in ascending order.
B.
Salary is the primary key and should be in descending order.
C.
Salary is the primary key and should be in ascending order.
D.
Branch office is the primary key and should be in descending order.
4.
You have a list of all the employees in your organization. The list contains employee name, location, title, and salary. You want to list all employees in each location. The branches should be listed alphabetically, with the highest paid employee listed first for each location. Which is true of your sort order?
A.
Sort by location ascending, then by salary ascending.
B.
Sort by location ascending, then by salary descending.
C.
Sort by salary descending, than by loc
Answer:
Explanation:
Branch office is the primary key and should be in ascending order.
B.
Salary is the primary key and should be in descending order.
C.
Salary is the primary key and should be in ascending order.
D.
Branch office is the primary key and should be in descending order.
4.
You have a list of all the employees in your organization. The list contains employee name, location, title, and salary. You want to list all employees in each location. The branches should be listed alphabetically, with the highest paid employee listed first for each location. Which is true of your sort order?
A.
Sort by location ascending, then by salary ascending.
B.
Sort by location ascending, then by salary descending.
C.
Sort by salary descending, than by loc