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

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.

Question

A ______ displays between columns to indicate page breaks and what will be printed on a page
click to flip
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't know

Question

the Keyboard shortcut for the insert function is
Remaining cards (66)
Know
0:00
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

BCIS Unit 2

Excel Worksheet

QuestionAnswer
A ______ displays between columns to indicate page breaks and what will be printed on a page vertical dotted line
the Keyboard shortcut for the insert function is [shift] + [f3]
A ____ chart is useful for illustrating comparisons among related numbers. column
_____ identify each worksheet in a workbook and are located along the lower left edge of the workbook window Sheet Tabs
A _________ format changes the appearance of a cell range based on certain criteria. conditional
To create a pie chart you must select ________ range of data two
______ is used to copy the formatting of one cell to other cell Format Painter
Bold, Italic, and underline are ____________, which means that you can click the button one time to turn the formatting on and click it again to turn it off. toggle buttons
From the page setup group, click the ___________ button to select the row headings that will repeat at the top of each page. Print titles
A ___________ surrounds the selected range to be copied. moving border
A _________ will display to indicate a cell contains an error message green triangle in the upper left corner of the cell
Use __________ to prepare the spreadsheet for printing Page Layout view
Use the _____ dialog box to insert a footer on a chart sheet Page Setup
In a line chart _________ is displayed along the bottom axis time
Commonly used font formats are found on the _________ group on the ribbon font
the default setting in fow a new Excel workbook to contain ______ worksheets three
Pressing ___ pastes the text and removes it from the Office Clipboard Enter
In the Print dialog box under print what, select ___ to print all sheets in a workbook, Entire Workbook
The command that enables you to select one or more rows or columns and lock them into place is called: Freeze Panes
From the Clipboard group, click the _______ button to copy the format of one cell to another. Format Copy
From the Format Cells dialog box under the Alignment Tab, click and drag the red diamond to change the: text orientation
____________ function preform common business calculations such as calculating a loan payment or calculating how much to save each month in order to buy something. Financial
to change the name of a sheet tab, _________ on the tab and type in the new name then press enter. double-click
Press _______ to access Microsoft Help [f1]
__________ is a method to find a specific value for a cell by adjusting the value of one other cell. Goal Seek
Sorting and Filtering arrows display _________ on an Excel Table in the header row
Pre-Written formulas that analyze a group of measurements are called statistical functions
From Preview group, click the _________ button to view each page page of the workbook. Next page
the keyboard shortcut for the copy command is [ctrl]+ [c]
From the Save As dialog box, click _______ to see a list of available storage devices. the save in Arrow
A workbook sheet that contains only a chart is called a: chart sheet
to group worksheet right-click on the sheet tab and click: Select All Sheets
______ is the process of changing the appearance of cells and the overall layout of the worksheet Formatting
The _______ are the values that an excel function uses to perform calculations or operations arguments
the intersection of a column and row is called a: cell
from the format cells dialog box, click the _____ tab in order to wrap text Alignment
If you want text to appear on multiple lines within a single cell, you can enter a manual line break
you can create new folders to store files from the ____ dialog box Save As
the keyboard shortcut to view print preview is [ctrl] + [f2]
Use the ______ command to display text on two lines within a cell Wrap Text
to reopen a workbook once Excel is opened, you can check the _____ for the Office menu to see if the file is there and click on it. recent documents
the function key used in Excel to repeat the last action when inserting columns and rows is: [f4]
when you start the excel program. a new blank ___ displays workbook
a __ displays trends over time line chart
a __ is a portion of a worksheet window bounded by and separated from outer portions by vertical or horizontal bars. pane
all formulas begin with the ____ sign = equal
Excel's prewritten formulas are called functions
the value at the end of the time periods for a loan is called the future value
the ______ feature will provide a list of available functions if you type = and the first letter of a function in the formula bar Formula Auto Complete
Formula results that are updated each time a workbook is opened are said to be volatile
in preforming calculations, _____ are processed first expressions within parentheses
the _ function finds the middle value min
When calls are selected and the Copy or Cut command is performed on them, the data is place on the: Office Clipboard
By default, text in Excel is: Left Aligned
Symbols used to specify the calculations to be preformed in a formula are called operators
New rows are inserted______ the selected row and existing rows shift accordingly above
the _ of a data bar represents the value in a cell length
to analyze a group of related data, you can convert a range of cells to a excel table
from anywhere in the worksheet, you can press __ to move to cell A1 [ctrl] + [home]
under date category, if type 3/14 is selected ____ will display in the cell Only the month and day
to center the contents of the worksheet horizontally on the paper click on the ______ tab from the page setup dialog box Margins
the keyboard shortcut for the paste command is ctrl + v
Press the ____ key to cancel a moving border and clear a selection from the Office Clipboard. Esc
The Worksheet that contains the totals from other worksheets is called an summary sheet
If information within a table has been sorted alphabetically A-Z a _____ arrow will display down
Press ___ to display the underlying formula ctrl + `
_____ charts show the relationship of each part of data in reference to the whole. pie
Created by: lucia1031
 

 



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