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

Microsoft Excel

Excel basics in Microsoft Office 2016

QuestionAnswer
How do you start a new spreadsheet? Click Blank workbook to display the Excel window with a new spreadsheet.
What does "workbook" refer too? the entire Excel file
Can a workbook contain multiple worksheets? yes
The Excel window displays a single worksheet, also called a _______, which is the Excel term for a spreadsheet. sheet
Quick Access Toolbar shortcuts to commonly used commands
What does the Customize Quick Access Toolbar do? adds or removes shortcuts
Window controls are in the upper-right corner are the Minimize button, which hides a window; the Restore button, which reduces or expands the window size; and the Close button, which closes the application window.
Ribbon contains Excel commands
Commands are organized into tabs that run along the top of the Ribbon
File tab is different from other Ribbon tabs. You click File to display the Backstage view with options for opening, saving, printing, sharing, and closing a file.
To get back to the spreadsheet window without executing a command on the File screen click the Back Arrow in the upper left of the screen or press the Esc key.
Tell Me box When you can’t locate a command, or when you want to learn how to perform an action, click Tell me what you want to do and type any word or phrase in the box to display a menu of related search results.
run vertically and are identified with letters Columns
run horizontally and are identified with numbers Rows
A cell is? an intersection of a row and column and has a cell name, which is made up of the cell’s location in a column and row
The name of the selected cell is displayed above the sheet in the Name Box (example = A1)
also called the selected cell active cell
An active cell is delineated on the sheet by what? a bold border
What is displayed above the column letters formula bar
formula bar displays the contents of a cell
Scroll bars located along the right side of the window and below the worksheet
use these to bring unseen cells into view Scroll bars
sheet tab is displayed at the bottom of a worksheet
Clicking the _________ button adds an additional sheet to the workbook. New Sheet
runs along the bottom of the window status bar
zoom slider use to change the magnification of your worksheet
Where is the zoom slider? On the right side of the status bar
Where are icons for changing the worksheet view? near the zoom slider
What are ScreenTips? small boxes that pop up when pointing to a command on the Ribbon or other features on the Excel document window
What do ScreenTips do? They display information about a feature, including keyboard shortcuts for executing the feature without having to remove your hands from the keyboard.
moves to the next cell in a row Tab key
moves to the next cell in a column Enter key
arrow keys select the next cell in the direction of the arrow, Ctrl+arrow selects the last cell with data
selects the cell at the beginning of a row Home key (Ctrl+Home)
Delete key is used to remove the active cell contents
Page Up and Page Down keys are used to scroll through a sheet within the window
Esc key’s function will vary depending on the action, but is commonly used to cancel the current operation
What is the difference between a workbook and a worksheet? A workbook is an Excel file; a worksheet is one sheet of the workbook.
What is a cell? the intersection of a row and column in a worksheet.
How is a cell identified? By a row number and column letter.
What is another name for cell reference? cell name
The ______ cell is where typed data appears. active
Press the _______ arrow key to select the cell above the current active cell. up
Created by: mtooner
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