Save
Upgrade to remove ads
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 presents tables of values arranged in rows and columns that can be manipulated manually using both basic and complex arithmetic operations and functions.
Workbook A workbook is a spreadsheet file. By default, each workbook in Excel contains three pages.
Worksheet A sheet used to store, manipulate, and display data.
Workbook window A workbook is an Excel file that contains one or more worksheets. Each of the wordbook worksheets are in separate tabs on the bottom of the Excel window.
Cell A cell is the intersection point of a vertical column and a horizontal row.
Sheet Tab is the current worksheet that is being displayed. Every Excel file is capable of having multiple worksheets.
Active Worksheet The worksheet you are working on.
Work Space Workspaces allow you to manage which windows are on your screen. You can imagine workspaces as being virtual screens, which you can switch between at any time.
Column Columns run vertically in the worksheet. Each column is identified by a letter in the column header.
Rows Rows run horizontally in the worksheet and is identified by a number in the row header. There are over one million rows in one worksheet.
Heading the column header is the colored row of letters used to identify each column within the sheet. In Excel, the row header is the grayish - colored column containing the numbers used to identify each row in the worksheet.
Cell reference Cell reference identifies the location of the cell or a group of cells in the worksheet. Sometimes referred to as a cell address.
Name Box The Name Box is located next to the formula bar above the worksheet area. The Name Box normally displays the cell reference of the active cell.
Formula Bar Located above the work area. Formula bar displays the data or formula stored in an active cell. Can also be used to edit of enter the data in the cell.
Formula Formulas are used to perform calculations on values stored and entered in the program. Formulas can range from basic mathematical problems- to complex engineering.
Relative Reference An Excel and other spreadsheets, a relative cell reference identifies the location of a cell or group of cells.
Absolute Reference an absolute cell reference, like other cell references, identifies the location of a cell or group of cells and is used in such things as formulas, functions, and charts.
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 the cell that is currently being worked on.
Enter Data Data is stored in cells in a worksheet. Generally, each cell holds a single item of data.
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.
Gridine 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.
I can create graphs/charts on excel. True/False True
It is impossible to change the color of the cell on Excel. True/False False
On Excel you're not allowed to rename the sheet. True/False False
On Excel you can change the dimension of a row/column. True/False True
You can calculate numbers on Excel using auto sum. True/False True
On Excel you're not allowed to insert more than one graph/chart on one sheet. True/False False
On Excel you're limited to only 3 sheets per document. True/False False
On Excel There are only 26 rows. True/False False
On Excel there are only 10 columns. True/False False
On Excel you can change a decimal to a percent using the percentage button. True
Created by: JohnsonAtalig
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