11. The Chart wizard term data categories refers to;
a. A chart plot area b. A horizontal axis
c. The organization of individual
values with a chart’s data Series
d. The data range that supply
chart data
12. A worksheet range is a
a. A command used for data
modeling
b. A range of values such as
from 23 to 234
c. A group of cells
d. A group of worksheets
13. Getting data from a cell located
in a different sheet is called …
a. Accessing b.
Referencing
c. Updating d.
Functioning
14. Tab scrolling button
a. Allow you to view a
different worksheet
b. Allow you to view additional
worksheet rows down
c. Allow you to view additional worksheet
columns to the right
d. Allow you to view additional sheets tabs
15. A numeric value can be
treated as a label value if it precedes with
a. Apostrophe b. Exclamation (!)
c. Hash (#) d.
Ampersand (%)
16. Concatenation of text can
be done using
a. Apostrophe b.
Exclamation (!)
c. Hash (#) d.
Ampersand(%)
17. Data can be arranged in a worksheet in a easy to understand
manner using
a. auto formatting b.
applying styles
c. changing fonts d. all of above
20. Excel uniquely identifies
cells within a worksheet with a cell name
a. Cell names
b. Column numbers and row
letters
c. Column letters and row numbers
d. Cell locator coordinates
No comments:
Post a Comment