Laboratory work 4

Qué hay en esta ruleta (14 opciones)

• 1.Define the concept of a database.
• 2.List the rules for creating and managing databases in Excel.
• 3.Explain the usefulness of the Form dialog box for searching data. Give examples.
• 4.Identify the advantages and disadvantages of using the Form dialog box.
• 5.Explain sorting by two or more keys. Give examples.
• 6.Give examples of using Sort Options in Excel.
• 7.Explain how to create user-defined sorting sequences.
• 8.Define the concept of a simple filter and explain its use.
• 9.List the filtering options available in Excel. Give examples.
• 10.Identify the advantages and disadvantages of the Custom Filter option.
• 11.Explain how to organize the criteria range for an advanced filter.
• 12.Describe the differences between simple and advanced filters.
• 13.Explain the rules for creating logical expressions in advanced filters. Give examples.
• 14.Identify the functions used to calculate subtotals.