Home
My Puzzles
FAQ
Report bug
Collected Puzzles
User listed puzzles
Random Puzzle
Log In/Out

Spreadsheet Vocabulary

Computer Applications I

No description

plotarea this object explains the symbols, colors, or patterns used to differentiate the data
indent this type of chart may be used to immediately reflect up-to-date changes made to a spreadsheet
right default justification for labels
count instruct the software to perform calculations
xaxis the bottom horizontal side of the graph
countA data that contains numbers that may be used in calculations
piechart finds how many cells have a value entered
center used for subcategories
orderofoperations a horizontal or vertical line that extends across the plot area of a graph
embedded this function returns one value if a condition you specify evaluates to True and returns another value if the condition evaluates to False
spreadsheet justification for titles and column headings
merge indicates the relationship of one component or data element to the whole data series such as the percentage of product sales to total sales
yaxis 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
datamarkers analyzing statistical or scientific data to determine a correlation
fillseries used in a graph to indicate data values
columnchart all formulas begin with an
values describes the horizontal data labels
lookup an enhanced version of the pie chart
legends makes comparisons and generalizations about groups of data
left this type of chart appears on the same sheet as the spreadsheet it represents
datefunction math procedure of calculating formulas used in spreadsheets
formulas used to fill a column or row with consecutive data such as numerical numbers
list allows the rows and/or column titles to remain stationary on the screen while you scroll
freezingpanes describes the vertical data labels
linechart an arrangement of cells in columns and rows used to organize, analyze, calculate, and report information
wraptext used to add identifying information to a spreadsheet
labels used to calculate a 30 day due date for a record of spreadsheet invoices
gridline compares the contribution of the individual items to the whole
iffunction used to combine adjacent cells or cell ranges
tickmark compares trends such as the sales trends of 3 departments over a period of time
charttitle this chart component is the main heading which describes the purpose and content of the chart
yaxistitle default justification for values
stackedbar used in a graph to clarify data categories or values
count square located at the bottom right of a cell used to create the continuation of a data series when dragged
headerfooter returns the number of cells in a range that contain numbers
equalsign used to validate how data is represented on paper before printing
explodedpie the area bound by the values (y) and the categories (x) axes
printpreview applied to cells that require more space when a row or column size is adjusted
linked returns the number of cells in a range that contain any value/label
XYscatter usually contains the numerical data
xaxistitle data that contains text, symbols, dates, or numbers not used in calculations
fillhandle 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!




Google
 
Web armoredpenguin.com

Copyright information Privacy information Contact us Blog