Questions about Excel2016

1) What is not true about creating a data table?

a Each record should be unique somehow.

b Delete any blank columns in your table.

c For efficiency, make sure your data table does not exceed 256 rows.

d It is best to put individual data tables on separate sheets.

2) Where does Excel display the Total row in a table?

a Below the last row in the table

b Two rows below the last row in the table

c At the top of the table

d After each subtotal in the table

3) How does Excel indicate that a column has been selected in a structured reference? (1 point)

a A colored border appears around that column.

b There is nothing to indicate a column has been selected.

c A type of colored sticky note is attached to that column.

d A light shading appears in that column.

4) What is not true about using the AND function in a custom conditional formatting rule? (1 point)

a You must have at least two tests in the formula.

b All the logical tests must be true for the formatting to be applied.

c You may have as many tests as you need in the formula.

d All the tests must be of the same data type, for example: all numbers or all text.

5) What is not true about tables in Excel? (1 point)

a Row headings stay on the screen automatically.

b You can export the data to a SharePoint list.

c Filter arrows make it quick and easy to filter the data in the table.

d Column headings stay on the screen automatically.

6) Which wildcard character only replaces one character with one other character? (1 point)

a Question Mark ?

b Number sign #

c Asterisk *

d Tilde ~

7) To what does the @ symbol refer in a structured reference? (1 point)

a Current row

b Current table

c Current column

d Current cell

8) Which table style option is useful to display aggregated data when it is checked? (1 point)

a Filter Button

b Header Row

c Total Row

d Last Column

9) What is not true about creating a data table? (1 point)

a Make sure no column labels are the same.

b Format the field names so that they stand out visually.

c Keep field names short.

d Make sure to leave one blank row below the data labels.

10) Which of the following is not a way to bring up the Go To dialog box? (1 point)

a Alt+F7

b Name Box

c Ctrl+G

dF5

Thank you very much : )