Computer Applications I

 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39

Across
7.justification for titles and column headings
9.square located at the bottom right of a cell used to create the continuation of a data series when dragged
11.this type of chart appears on the same sheet as the spreadsheet it represents
12.used for subcategories
14.a horizontal or vertical line that extends across the plot area of a graph
19.data that contains numbers that may be used in calculations
21.used to compare a cell value to an array of cells and return a value that matches the location of the value in the array
22.makes comparisons and generalizations about groups of data
23.describes the vertical data labels
25.allows the rows and/or column titles to remain stationary on the screen while you scroll
26.returns the number of cells in a range that contain numbers
27.instruct the software to perform calculations
29.the area bound by the values (y) and the categories (x) axes
31.used to validate how data is represented on paper before printing
33.this function returns one value if a condition you specify evaluates to True and returns another value if the condition evaluates to False
35.used to fill a column or row with consecutive data such as numerical numbers
37.default justification for values
38.compares the contribution of the individual items to the whole
39.used in a graph to clarify data categories or values
Down
1.this type of chart may be used to immediately reflect up-to-date changes made to a spreadsheet
2.math procedure of calculating formulas used in spreadsheets
3.applied to cells that require more space when a row or column size is adjusted
5.an enhanced version of the pie chart
6.all formulas begin with an
7.finds how many cells have a value entered
8.data that contains text, symbols, dates, or numbers not used in calculations
10.this object explains the symbols, colors, or patterns used to differentiate the data
13.used to combine adjacent cells or cell ranges
15.compares trends such as the sales trends of 3 departments over a period of time
16.analyzing statistical or scientific data to determine a correlation
17.used to calculate a 30 day due date for a record of spreadsheet invoices
18.an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information
20.used in a graph to indicate data values
23.usually contains the numerical data
24.describes the horizontal data labels
26.this chart component is the main heading which describes the purpose and content of the chart
28.the bottom horizontal side of the graph
30.default justification for labels
32.indicates the relationship of one component or data element to the whole data series such as the percentage of product sales to total sales
34.returns the number of cells in a range that contain any value/label
36.a validated _____ limits data entry to specific choices programmed into the function

Use the "Printable HTML" button to get a clean page, in either HTML or PDF, that you can use your browser's print button to print. This page won't have buttons or ads, just your puzzle. The PDF format allows the web site to know how large a printer page is, and the fonts are scaled to fill the page. The PDF takes awhile to generate. Don't panic!

 Web armoredpenguin.com