click below
click below
Normal Size Small Size show me how
NP Excel 1
New Perspective Excel Unit 1
Term | Definition |
---|---|
active cell | The cell currently selected in the active worksheet. |
arithmetic operator | An operator that performs addition, subtraction, multiplication, division, or exponentiation. |
AutoComplete | The feature that displays text that begins with the same letters as a previous entry in the same column to help make entering repetitive text easier. |
AutoFit | The feature that changes the column width or row height to display longest or tallest entry within the column or row. |
AutoSum | The button that inserts functions to sum, average, or count values in a range, or find the minimum or maximum value in a range. |
Backstage view | The FILE tab of the ribbon, which provides access to various screens with commands that allow you to manage files and Excel options. |
border | A line you can add along an edge of cell that prints. |
cell | The intersection of a row and a column. |
range | A group of cells in a rectangular block |
cell reference | The column and row location that identifies a cell within a worksheet. |
chart sheet | A sheet that contains only a chart that provides a visual representation of worksheet data. |
clipboard | A temporary storage location for copied or cut text and graphics. |
letters | Column headings along the top of the worksheet window that identify the different columns in the worksheet are identified by these. |
Flash Fill | The feature that enters text based on patterns it finds in the data. |
formula | A mathematical expression that returns a value. |
formula bar | The bar located below the ribbon that displays the value or formula entered in the active cell. |
hide | To make a row, column, or worksheet not visible. |
landscape | The page orientation where the page is wider than it is tall. |
nonadjacent | Separate cells that do not touch. |
Page Break Preview | The Excel view that shows the location of page breaks in the printed sheet |
Page Layout | The Excel view that shows how the sheet will appear when printed |
Portrait | The page orientation where the page is taller than it is wide. |
Numbers Row | headings along the left side of the workbook window that identify the different rows of the worksheet are represented by there. |
scale | To change the size of the worksheet on the printed page. |
ScreenTip | A box with descriptive text about a command that appears when you point to a button on the ribbon |
sheet | A page included in a workbook; can be a worksheet or a chart sheet. |
sheet tab | The area at the bottom of the worksheet that identifies the sheet by name. |
sum | The function that adds values in a specified range. |
template | A preformatted workbook with many design features and some content already filled in. |
unhide | To redisplay a hidden row, column, or worksheet. |
workbook | An Excel file that stores a spreadsheet; contains a collection of worksheets and chart sheets. |
worksheet | A grid of rows and columns in which content is entered. |