JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.
Assessment: Tables
Was I successful in communicating table advantages
* Indicates required question
Email
*
Your email
Quiz Questions
Which of these is true?
*
1 point
All Excel Tables are list
All lists in Excel are Excel Tables.
What can tables contain (check all that are appropriate)?
*
1 point
Lists of categories
Lists of valid entries
Lists of people
Lists of calculations
Lists of properties
Required
Plain lists are not named. Are tables?
*
1 point
Only if we name them in name manager
Only if we create a dynamic named range in name manager
They are automatically named by Excel.
When we convert a list to an Excel table, the list gains (check all that apply):
1 point
A name that automatically grows as we add rows or columns
Maintenance free structured references that make formulas self documenting
Formulas and formats that automatically extend to new rows
Alerts a formula in a column is inconsistent with other formulas in that column
Special formats that can help make lists more readable like banded rows
The ability to add a total row without writing formulas
Automatic auto-filters and the ability to be filtered by slicers
Send me a copy of my responses.
Submit
Page 1 of 1
Clear form
reCAPTCHA
Privacy
Terms
This content is neither created nor endorsed by Google.
Report Abuse
-
Terms of Service
-
Privacy Policy
Forms
