Questions about Excel2016 1) What is not true about creating a data table? a Eac
ID: 3732246 • Letter: Q
Question
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 : )
Explanation / Answer
1) For efficiency, make sure your data table does not exceed 256 rows
It is not necessary to have limit till 256 rows to make the table efficient.
2) Below the last row in the table
As we need to have total of all the values in that specified column.
3) A colored border appears around that column
We can identify structured reference by looking at the colored border.
4) All the tests must be of the same data type, for example: all numbers or all text
5) Row headings stay on the screen automatically
They don’t stay visible automatically.
6) Question Mark ?
It is used to check for a specific thing like a character in the word.
7) Current row
8) Last Column
9) Make sure to leave one blank row below the data labels
It is not mandatory to leave the row blank.
10) Alt+F7
Go to Dialog Box cannot be achieved using above combination.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.