You are asked to create a worksheet in Excel that shows the number of states for each sales person. What would you put as the header for column A and column B (in that order)?1 pointNo. of States, SalespersonSalesperson, No. Of StatesColumn A, Column BName, State

n an Excel table, which of the following contains descriptive titles or labels? 1. Table 2. Field 3. Header row 4. Record

Write a query to retrieve the names of all employees and sort them in ascending order.Table: EmployeeInput records:Input format :The input table is already created, and records are already prepopulated, as mentioned in the problem statement.Output format :The output displays the names of all employees in ascending order as shown below.NameAngelMarkMathewSteveRefer to the sample output for the column headers.

You are creating a spreadsheet for your employer and the header of Spending for Q1 is not showing in column A. What would you do to expand the column to have all characters show?1 pointDouble-click the boundary to the right of the column heading.Press ALT and single-click anywhere in the column.Single-click the boundary to the left of the column heading.

Use a UNION to create a list of all the employee's and customer's first names and last names ordered by the last name in descending order.

You are creating a spreadsheet for your employer and the header of Spending for Q1 is not showing in column A. What would you do to expand the column to have all characters show?1 pointSingle-click the boundary to the left of the column heading.Press ALT and single-click anywhere in the column.Double-click the boundary to the right of the column heading.