Save
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


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. Your email address is only used to allow you to reset your password. See 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.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
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 An Excel file that contains one or more worksheets
Workbook window The program window that is currently being worked on.
Cell A spreadsheet cell is analogous to a field in database management systems. Individual cells are usually identified by a column letter and a row number.
Sheet tab A sheet tab appears at the bottom of your worksheet. It has the name of the worksheet on it, which can be changed and you can also change its colour.
Active worksheet The active sheet is the worksheet you are working on.
Workspace Group of Workbooks
Columns Colums are a fundamental part of any spreadsheet program such as Excel and Google Spreadsheets. Colums 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.
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 The Name Box normally displays the cell reference of the active cell. If a name has been defined for a cell or range of cells, the Name Box displays that name if the correct range is selected in the worksheet.
Formula Bar A toolbar at the top of the Microsoft Excel spreadsheet window that you can use to enter or copy an existing formula in to cells or charts
Formula Self-defined instructions for performing calculations.
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 Absolute references 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.
Active Cell The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border.
Enter Data The process of entering data into a spreadsheet
Range A group or block of cells in a worksheet that have been selected or highlighted.
Grid lines Gridlines are the faint lines that appear around cells in Excel. They are used to distinguish cells on the worksheet.
Individual cells are usually identified by a column letter and a row number. True
The selected cell in which data is entered when you begin typing is a Cell Reference. False
Absolute references remain constant, no matter where they are copied. True
An Excel file that contains one or more worksheets is a Spreadsheet. False
A group or block of cells in a worksheet that have been selected or highlighted are Grid lines. False
A cell reference refers to a cell or a range of cells on a worksheet. True
Range are the faint lines that appear around cells in Excel. False
Formulas are self-defined instructions for performing calculations. True
The selected cell in which data is entered when you begin typing is an Active Cell. True
By default, all cell references are relative references. True
Created by: ShinozakiKara
Popular Computers sets

 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards