Excel Q6

The components of a structured reference are as follows: Table 1 is Table Name, [Net Amount] and [Commission Amount] are column specifiers and [#Totals] and [#Increase] are item specifiers. Which of these can be the formula for the structured reference?

=SUM(Table1[[#Totals],[Net Amount]],Table1[[#Increase],[Commission Amount]])

Hari wants to connect a slicer to three pivot tables so that he can control the entire dashboard with a single slicer. To do so, he selects the pivot tables to connect a slicer, then selects a cell in any of them, then clicks on three group/tab/button in a series. Next from the "Insert Slicer" dialog box, he selects the column to use as a filter in the slicer and clicks OK. What can be the three clicks he made during the procedure?

Analyze tab → Filter → Insert Slicer

Luke owns his own business. creates a table with three columns titled as: Date of order, Regions and Products Ordered. He applied filters on the columns to analyze the data he entered. He now wants to clear filters from the first column. What should Luke do after clicking on the column heading?

Click the Filter icon button next to the column heading and then click Clear Filter from <"Date of order">.

How can you remove Split panes in a worksheet you are working on?

Click the View tab in the Ribbon, then click the Split button in the Window group.

Mitchel wants to remove a row of unnecessary data in a table created in MS Excel. What should he do after selecting the row?

Click the arrow next to Delete on the Home tab, in the Cells group, and then click Delete Table Rows.

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.

False

To view a worksheet without gridlines showing on the screen, which of the following would you uncheck?

Gridlines View

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

Home tab > Format as Table > Clear

Josh teaches sixth grade math. He created a table showing marks that his students scored on an assessment—the last column on the right displays this information. He now wants to add another column to the right showing percentage of marks that each students scored. What should he do after selecting the current last column on the right?

Right click on it and select Insert from the drop-down menu.

A teacher creates a table that contains data in three columns, A to C under headings : First name, Last name, and Date of birth, respectively. To sort the table by the last names of students from A to Z, she can select a cell in the column B, select the Data tab on the Ribbon, then click the Ascending command.

True

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.

True

If you wish to see how formatting changes affect your table, the Preview list on the right side of the New Table Style box that opens under Table Styles gallery lets you do so.

True

To group specific rows in Excel, select them, then click the Group command on the Data tab in the Outline group. Finally select Rows or Columns in the Group dialog box and click OK.

True

We can use the Remove Duplicates feature to permanently delete the duplicate data by selecting the range of cells that has duplicate values we want to remove, then clicking Data > Remove Duplicates, and then checking the columns where we want to remove the duplicates under Columns.

True

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?

Uncheck (Select All), select the box beside the number 60 and click OK.