Question: 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
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
