WorksheetsMOAC Excel 2016 Lesson 09
Total questions: 10
Worksheet time: 8mins
Which Excel ribbon contains the command to Insert Data from Text?
Insert
Data
Home
Page Layout
To have Excel remove any duplicate records that have the same ID#, which value(s) should be checked?
ID# only
ID# and Last Name
ID # and Last Name and First Name
No values should contain a check mark
Which sort option would showing increasing values or alphabetical order?
Ascending
Descending
What is the name of the table used in this function =COUNT(Fbla[Schools])?
COUNT
Fbla
Schools
The table name is not shown
Referring to the table above, which sort order would be the FASTEST way to sort by Country in this order: United States, Canada
Ascending
Descending
Create a Custom Sort List
Referring to the table above, which sort box will sort by Country (with United States listed first), then by State in ascending order, then by Postal Code in ascending order?
Referring to the table above, what is the quickest method of filtering so that only Oklahoma (OK) is shown?
Uncheck every state or province except OK
Uncheck Select All and then check OK
Sort A to Z and then check OK
Sort Z to A and then check OK.
What option should you choose to remove a table's functionality?
Remove Duplicates
Resize Table
Convert to Range
Summarize with PivotTable
Referring to the table above, which Table Style Option should be enabled so that every other row is filled with a shading color as shown in the 2nd picture?
First Column
Last Column
Banded Columns
Banded Rows
How do you add a Total Row to a table?
Enable the Total Row table style option
Insert a blank row at the bottom of the table and then type "Total Row" as its heading
Enable the Total Row conditional formatting option
Use the Insert ribbon, then check Total Row
