Question: 10. A Table in Excel is like a a) a place to insert a diagram b) a place to meet others who work on the
10. A Table in Excel is like a
a) a place to insert a diagram
b) a place to meet others who work on the spreadsheet
c) a "flat" spreadsheet
d) database
e) all of the above
11. An Excel table may have
a) column headings
b) a "totals" column
c) alternating row colors
12. When working with an Excel Table you may
a) add a column or a row
b) delete a column or a row
c) apply styles to the Table
13. Data inserted into an Excel Table may be validated to ensure that it is
a) the correct type of data
b) within the correct range of permissible values
c) taken from a list of permissible values
14. In Excel, you may sort data by
a) the values in the columns
b) the fill color or font color
c) cell icons
d) custom lists
15. AutoFilter allows you to
a) quickly hide rows
b) quickly hide columns
c) quickly hide rows or coulmns
d) quickly hide rows and columns
e) all of the above
f) answers 1 & 2
16. Using Autofilter you may filter by
a) values
b) empty cells
c) cell fill
17. We may find and replace based on
a) "wild cards"
b) the time when the text was entered
c) the subject of the paragraph
d) all of the above
18. Colors may be modeled by
a) RGB
b) HSL
c) Red, Green, Blue
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
