Exam 6: Creating, sorting, and Querying a Table

Which of the following keys will you press when the cell cursor is in the last cell of the last record (row)to add new data for the next record?

Which of the following series of clicks will you select to remove banded columns from a table?

If you see a cells with blue fills of varying lengths representing the values,the cells most likely have ________ applied to them.

Adele wants to extract a list of unique items in a database.Which of the following will she select in the series of clicks to do so: Select cell > Data tab > Advanced > Select option under Action (X)> Specify List range > Select a starting cell for copying to location > Check box beside Unique records only > OK?

What will you select as X in the following series of clicks/entries/selections to apply a table style: Select cell to format as table > X > Format as table > Desired table style?

Cedric has a list of data that he wants to group and summarize,For this,he can create an outline of up to eight levels,one for each group.

A student creates data for trees in an orchard.He enters headings in cells A1,B1,C1,D1 and E1 as Tree,Height,Age,Yield,and Height,respectively.He mentions the criteria ="=Mango",>10,="Orange",>12 and <15 in cells A2,B2,A3,and B3,respectively.Cells A4 to A10 with heading "Type of trees" in A4 cell contain data for the type of trees,cells B4 to B10 with heading "Height" in B4 cell contain data for the height of trees,cells C4 to C10 with heading 'Age' in C4 cell contain data for the age of trees and cells D4 to D10 with heading "Yield" in D4 cell contain data of their annual yield.He can use the formula: =DGET(A5:E10,"Yield",A1:E3)to extract the value of yield that matches the specified criteria.

To apply a banded column to a table,we can select the range of cells that we want to apply banded columns to,then click on the following: Home tab > Table > OK in Create table dialog box > View tab > Table Styles Options group > Check Banded Columns box.

Dante wants to calculate the currently monthly subtotals for the sales of golf balls in his store.Which of the following will he select as X in the series of clicks to do so: Cell in the range > Data > X > Subtotal > OK?

The manager of a footwear company creates a table that contains data in three columns,A to C under headings: Names of customers,Date of order,and Size of footwear ordered,respectively.To select a separate table to sort the number of footwear that were ordered on different dates,she can select the cell range she wants to sort,select the Data tab on the Ribbon,then click the Sort command.In the Sort dialog box that appears,she can choose the column she want to sort by,decide the sorting order and click OK.

In which of these boxes will you list all the possible fields that can be included in your formula in a PivotTable?

To open a workbook after you start Excel,you can use the Open Other Workbooks command on the Navigation bar.

Ngabile wants to insert a Treemap chart for a data set.To do so,she can click on the following series: Range of cells > Page Layout tab > Apps group > Insert Hierarchy Chart > Treemap.

To remove duplicate values from an Excel worksheet,click Data > Data Tools > Remove Duplicates.

Which of the following will you do to manually turn off autofilter in a table between the steps: Clicking any cell in the filtered range and clicking the Filter button?

Which dialog box opens after selecting a cell in the list of prepared data,clicking the Insert tab on Ribbon and then clicking the Table command in the Tables group?

Gregory creates data for different colors of paints he has bought to paint his house.He enters headings in cells A1,B1,C1,and D1 as Color,Price,Quantity,and Total,respectively.He mentions the criteria: Green and >3 in cells A2 and C2,respectively.Cells A4 to A10 with heading "Colors" in A4 cell contain data for the color of paints bought,cells B4 to B10 with heading "Price" in B4 cell contain data for the price of each color of paint,cells C4 to C10 with heading "Quantity" in C4 cell contain data for the quantity of each paint bought and cells D4 to D10 with heading "Total" in D4 cell contain data of total cost of each color of paint bought.Gregory can use the formula: =DCOUNTA(A1:D10,"Price",A1:D2)to determine the average price value from the column labeled "Price," entries where the colors are green and the quantity is less than 3.

Shelley creates a table containing the marks of Language Arts students in her class with these columns: Names of Students and Marks.She now wants to see the names of students who scored exactly 60 marks.What will Shelley do after selecting the column header arrow for the column with heading Marks?

Rogelio wants to use a named range formula in a cell.To do so,he can select the cell,press F2 to edit the cell,then select (Insert > Name > Paste)and select the name for the cell.

A manager creates data for cost of products of the firm he works for.He enters headings in cells A1,B1,C1 and D1 as Order ID,Quantity,Unit Cost and Total Cost respectively.He mentions the criteria >1000 and >=5 in cells A2 and B2 respectively.Cells A3 to A10 with heading "Order ID" in A4 cell contain data for the order IDs,cells B3 to B10 with heading "Quantity" in B3 cell contain data for quantities for each order ID,cells C3 to C10 with heading "Unit Cost" in C3 cell contain data for unit cost of each order ID and cells D3 to D10 with heading "Total Cost" in D3 cell contain data for total cost of each order ID.He can use the formula: =DCOUNT(A4:D10,"Unit Cost",A1:B2) to count the occurrences that meet the conditions in A1:B2.