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.

microsoft excel

Quiz yourself by thinking what should be in each of the black spaces below before clicking on it to display the answer.
        Help!  

Question
Answer
Active Cell –   The cell in your worksheet that has been selected. It will have bolder gridlines around it.  
🗑
AutoFill –   A feature that allows you to quickly apply the contents of one cell to another cell or range of cells selected.  
🗑
AutoSum   A function that automatically identifies and adds ranges of cells in your worksheet.  
🗑
Cell   The rectangular shaped area on a worksheet that is created by the intersection of columns and rows.  
🗑
Cell Address   The name of the cell is determined by the name of the row and the column intersecting, such as A8.  
🗑
Cell Grid   The lines on your worksheet that separate the columns and rows  
🗑
Column   – In a worksheet, the vertical spaces with headings A, B, C, and so on  
🗑
Drag   When you move the mouse while holding down the mouse button (usually the left) to select a range of cells  
🗑
File   A document that is stored on your computer. In Excel, a file is also known as a workbook.  
🗑
Fill Down   A feature that allows you to copy information in an active cell to another cell or range of cells selected vertically.  
🗑
Fill Right   A feature that allows you to copy information in an active cell to another cell or range of cells you have selected horizontally.  
🗑
Formula-   Formula-  
🗑
Formula Bar –   A command line above the worksheet where text, numbers, and formulas are entered into a worksheet  
🗑
Function   A drop-down menu item and a button on the standard toolbar that allows you to select a formula that you wish to apply to data in your worksheet.  
🗑
Headings   The identifying letters and numbers for columns and rows. Columns are identified with letters, rows with numbers.  
🗑
Label   The identifying name that reflects the information contained in a column or row in a worksheet, such as name or date.  
🗑
Row   In a worksheet, the horizontal spaces with the headings 1, 2, 3, and so on.  
🗑
Sheet Tabs   Tabs you see at the bottom of your workbook file, labeled Sheet 1, Sheet 2, and so on. You can rename the tabs. They represent worksheets within the workbook.  
🗑
Workbook   An Excel file that contains individual worksheets. Also called a spreadsheet file.  
🗑
Worksheet   – A “page” within an Excel workbook that contains columns, rows, and cells.  
🗑


   

Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
 
To hide a column, click on the column name.
 
To hide the entire table, click on the "Hide All" button.
 
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
 
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.

 
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
Created by: mgvandorn
Popular Miscellaneous sets