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

CTS 130 EM05

Excel - Module 5 study guide

QuestionAnswer
Using Excel, you can ____. store, retrieve subset of data, create reports.
In Excel, a collection of similar data can be structured in a(n) ____ of rows and columns. range.
A data ____ table describes the fields you plan to maintain in a table. definition
You should ____ the field names to make it easier to Excel to distinguish between the data in the list and the field names. change the font style or color of text, apply a boldface.
Press ____ to return to cell A1 in a worksheet. Ctrl & Home
____ rows and columns lets you keep headings on the screen as you work with the data in a large worksheet. freezing.
A dark, horizontal line appears ____ the column headers to indicate which row is frozen. below.
In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet. rows and columns.
When you designate a range as a(n) ____, Excel provides the same operations as are available for a structured range of data. table.
To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button. insert.
A table name can include all of the following EXCEPT ____. spaces.
As you type in a cell, ____ displays any existing entry in the column that matches the characters you typed. autocomplete.
After Excel displays an existing entry in the column that matches the characters you typed, press the ____ key to accept the entry. tab.
You can find fields whose contents match a value exactly by clicking the Options button in the Find & Replace dialog box, and checking the ____ check box. match entire cell contents.
____ order arranges labels in reverse alphabetical order, from Z to A. descending.
The fields you use to order your data are called sort ____. fields.
You can use up to ____ sort fields in a single sort. 64.
You can access the Sort buttons in the ____ group on the Home tab by clicking the Sort & Filter button and clicking a sort option. editing.
When you have more than one sort field, you should use the Sort ____ to specify the sort criteria. dialog box.
You can sort by ____. cell color, font color, cell icon.
To add a sort field in the Sort dialog box, click the ____ button. add level
To delete a sort field in the Sort dialog box, click the ____ button. delete level.
Excel provides ____ predefined custom sort lists. four.
After data is filtered, you can ____ it. sort, chart or copy.
After you filter a column, the ____ Filter command becomes available so you can remove the filter and redisplay all the records. clear.
You can display or hide filter arrows for an Excel table by using the Filter button in the Sort & Filter group on the ____ tab. data.
The ____ condition requires that all of the selected criteria be true for the record to be displayed. and.
The ____ condition requires that only one of the selected criteria be true for a record to be displayed. or.
Criteria filters allow you to specify relationships other than those that are based on a(n) "____" the criterion. equals.
You use ____ filters to find all objects with a value greater than X or acquired after a certain date. criteria.
The ____ criteria filter requires the records displayed to start with the specified text string. begins with.
The ____ criteria filter requires the records displayed to have the specified text string anywhere. contains
The ____ criteria filter requires the records displayed not to have the specified text string anywhere. does not contain.
The ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers. between.
The ____ filtering option displays the top or bottom 10 (or specified number) items in a list. top 10.
The ____ criteria filter requires the records displayed to have the current date. today.
The ____ criteria filter requires the records displayed to be since January 1 of the current year to .the current date. year-to-date
With the Last Quarter criteria filter, quarters are defined as, for example, ____. Apr, May, June
When you click in each cell in the Total row, a(n) ____ appears that you can click to open a list of the most commonly used functions. arrow
You can split the worksheet window into ____ separate panes. either two or four.
You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet both of two criteria. and.
You select the ____ option button in the Custom AutoFilter dialog box if you want to display rows that meet either of two criteria. or.
When you click in each cell in the ____ row, an arrow appears that you can click to open a list of the most commonly used functions. total.
You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function. insert function.
The Subtotals command offers summary information such as ____. count s, sums, averages.
To calculate subtotal for a table, the first step is to use the ____ button on the Table Tools Design tab. convert to range.
The three ____ buttons at the top of the outline area allow you to show or hide different levels of detail in the worksheet. outline.
In addition to displaying subtotals, the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed. outlines.
A PivotTable summarizes data in different categories using functions such as ____. min.
One advantage of PivotTables is that you can easily ____ different categories in the PivotTable to provide alternative views of the data. rearrange, hide or display.
The PivotTable button is available in the Tables group on the ____ tab. insert.
PivotTable data can be a(n) ____. access database file, excel table in current workbook, excel range in current workbook.
You can create a PivotTable by clicking the Summarize with PivotTable button in the Tools group on the ____ tab. table tools design.
In laying out the PivotTable on the worksheet, you can drag the Condition field button from the Row Labels box to the Column Labels box. The PivotTable is rearranged so that the Condition field is a ____ label. column.
By default, the PivotTable report uses the ____ function for numbers in the Values area. sum.
You can point to any style in a gallery to see a ____ of the PivotTable with that style applied. live preview.
You can use the ____ tab to change the SUM function to a different summary function, in a PivotTable. summarize values by.
The ____ report layout displays one column for each field and leaves space for column headers. Tabular Form
You cannot change data directly in the PivotTable. Instead, you must edit the Excel table, and then ____, or update, the PivotTable to reflect the updated data Refresh.
Created by: galvanl
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