Busy. Please wait.
or

show password
Forgot Password?

Don't have an account?  Sign up 
or

Username is available taken
show password

why


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.
We do not share your email address with others. It is only used to allow you to reset your password. For details read our Privacy Policy and Terms of Service.


Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.

Remove ads
Don't know
Know
remaining cards
Save
0:01
To flip the current card, click it or press the Spacebar key.  To move the current card to one of the three colored boxes, click on the box.  You may also press the UP ARROW key to move the card to the "Know" box, the DOWN ARROW key to move the card to the "Don't know" box, or the RIGHT ARROW key to move the card to the Remaining box.  You may also click on the card displayed in any of the three boxes to bring that card back to the center.

Pass complete!

"Know" box contains:
Time elapsed:
Retries:
restart all cards




share
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

Excel Vocab

TermDefinition
Spreadsheet An electronic document in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations.
Workbook A single file containing several different types of related information as separate worksheets.
Worksheet An Excel worksheet is a single spreadsheet that contains cells organized by rows and columns.
Workbook Window In most versions of Excel, Excel workbooks open to the first or most recently used spreadsheet tab. The tabs can be seen at the bottom left of the screen. Clicking on a tab selects a new spreadsheet within the workbook for viewing and editing.
Cell In any spreadsheet program such as Excel, each rectangular box in a worksheet is referred to as a cell. A cell is the intersection point of a vertical column and a horizontal row.
Sheet Tab A sheet, sheet tab, or worksheet tab is the current worksheet that is being displayed.
Active Worksheet In a spreadsheet program such as Excel or Google Spreadsheets, the active sheet is the worksheet you are working on.
Workspace A term used by software vendors for applications that allow users to exchange and organize files over the Internet.
Columns Columns are a fundamental part of any spreadsheet program such as Excel and Google Spreadsheets. Columns run vertically in a worksheet.
Rows Rows run horizontally in an Excel worksheet. Each row is identified by a number in the row header.
Headings The column header is the colored row of letters used to identify each column within the sheet, or workbook. The column header row is located above the row one.
Cell Reference A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.
Name Box You define a name by using the: Name box on the formula bar this is best used for creating a workbook level name for a selected range. Create a name from selection you can conveniently create names from existing row and column labels.
Formula Bar The formula bar in Excel is located above the work area of the spreadsheet. The formula bar displays the data or formula stored in the active cell. The formula bar can be used to enter or edit a formula, a function, or data in a cell.
Formula Formulas are self-defined instructions for performing calculations. In contrast, functions are pre-defined formulas that come with Excel. In either case, all formulas and functions are entered in a cell and must begin with an equal sign '='.
Relative Reference By default, all cell references are relative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2
Absolute Reference Relative references change when a formula is copied to another cell. Absolute references, on the other hand, remain constant, no matter where they are copied.
Mixed Reference A mixed cell reference is either an absolute column and relative row or absolute row and relative column. When you add the $ before the column letter you create an absolute column or before the row number you create an absolute row.
Active Cell Alternatively referred to as a cell pointer or selected cell, an active cell is a rectangular box, highlighting the cell in a spreadsheet. It helps identify what cell is being working with and where data will be entered.
Enter Data The process of entering data into a computerized database or spreadsheet. Data entry can be performed by an individual typing at a keyboard or by a machine entering data electronically.
Range A range is a group or block of cells in a worksheet that have been selected or highlighted. When cells have been selected they are surrounded by an outline or border.
Gridlines Worksheet gridlines are the lightly-colored horizontal and vertical lines that appear around cells in a worksheet. These gridlines are used to define the boundaries of cells, columns, and rows in a worksheet.
True or False: Each rectangular box in a worksheet is referred to as a cell. True
True or False: Gridlines are not used to define the boundaries of cells, columns, and rows in a worksheet. False
True or False: You define a name by using the: Name box on the formula bar. True
True or False: Data entry can be performed by an individual typing at a keyboard or by a machine entering data electronically. True
True or False: Active Worksheet: Is the worksheet that you do not currently have selected. False
True or False: A range is a group or block of cells in a worksheet that have been selected or highlighted. True
True or False: When cells are selected they are surrounded by an outline or border. True
True or False: An Excel worksheet is a single file containing several different types of related information as separate worksheets. False
True or False: Rows run vertically in an Excel worksheet. False
True or False: Workspace is a term used by software vendors for applications that allow users to exchange and organize files over the Internet. True
Created by: jpferrer670