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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!