Across
- 2. , a series of one or more cells, contiguous or non-contiguous, upon which you preform operations, such as moving or copying. you specify a range by highlighting the cells or by typing the cell references.
- 4. format, , a numeric format you use to enter a date into a cell.
- 7. bar, , displays messages about the active worksheet selection.
- 10. toolbar, , a set of shortcut buttons you use for common commands, located by default beneath the menu bar.
- 11. , the area of a workbook in which you enter and manipulate data. an excel worksheet contains a grid of 256 columns by 65,536 rows.
- 14. range, , a range in which not all cells are adjacent
- 16. , the intersection of a column and row in a worksheet.
- 17. handle, , the square at the lower-right corner of the selected cell. You drag the fill handle to copy the contents of the selected cell to adjacent cells.
- 18. cell, , the cell in which you paste cut or copied data.
- 19. range, , a range in which all the sells in the series are adjacent.
- 22. format, , a numeric format that displays numbers with leading dollar signs ($) and thousand separators (,).
- 23. format, , a numeric format that displays numbers with leading dollar signs ($) and thousand separators (,), positioned in the cells so that the dollar sign and decimals are aligned vertically.
- 24. , a worksheet entry that performs a calculation. A formula must begin with equal sign (=).
- 25. , a grid of rows and columns in which you enter data and perform numerical calculations.
- 26. menu, , a pop-up men that displays commands related to the current selection. you display the shortcut menu by right-clicking on a cell, range, or other worksheet items.
- 27. , the data you use in a function to produce a value. Each function requires at least one argument.
- 29. cell reference, , the exact location of a cell without regard to the location of the formula that contains it. A dollar sign precedes the column and row reference.
- 30. title bar, , the bar containing the name of the current workbook that displays at the top of the workbook window.
- 31. reference, , the location of a cell, consisting of a column letter and row number.
- 32. format, , a numeric format that displays numbers with thousand separators(,) and specified number of decimals.
- 33. bar, , displays the contents of the active cell.
- 34. format, , a numeric format that displays number with a specified number of decimal places
- 35. worksheet, , the worksheet containing the active cell.
Down
- 1. box, , the box located at the left end of the formula bar that displays the cell reference of the active cell
- 3. , vertical and horizontal lines that extend across the worksheet and define the cells.
- 5. fit, , a feature that determines the correct column width for the data contained within the selected range.
- 6. , a pre-defined formula that performs special of advanced calculation.
- 8. , a characteristic of text formatting, such as bold, italics, or underline.
- 9. and drop, , a method you use to copy or move a selected range by dragging it from one location and placing it at another location in the worksheet.
- 12. formula, , a formula that refers to cells in other worksheets.
- 13. , the electronic file in which you work and store data.
- 15. function, , a function you use to total a range of numeric values.
- 20. , symbols you use in formulas that preform mathematical operations, such as addition (+), subtraction (-), multiplication (*), division (/), and exponentiation (^).
- 21. point, , a vertical line appearing in a selected cell or the formula bar that indicates where text will be entered or keyboard actions applied
- 24. wizard, , a tool that guides you through each step of unction creation and helps to eliminate potential errors of omissions that can occur when typing the full syntax of function.
- 25. tabs, , tabs containing the names of the individual worksheets within a workbook. you move between worksheets by clicking on the sheet tabs. the tab for the active worksheet displays in bold.
- 28. format, , a numeric format that displays numbers as percentages with trailing percent symbols (%) and a specifies number of decimal places.
- 29. function, , a function to average a range of numeric values.