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.

Excel - Module 5 study guide

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
show store, retrieve subset of data, create reports.  
🗑
show range.  
🗑
A data ____ table describes the fields you plan to maintain in a table.   show
🗑
show change the font style or color of text, apply a boldface.  
🗑
Press ____ to return to cell A1 in a worksheet.   show
🗑
show freezing.  
🗑
A dark, horizontal line appears ____ the column headers to indicate which row is frozen.   show
🗑
In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet.   show
🗑
When you designate a range as a(n) ____, Excel provides the same operations as are available for a structured range of data.   show
🗑
To create a table, click the ____ tab on the Ribbon and then, in the Tables group, click the Table button.   show
🗑
A table name can include all of the following EXCEPT ____.   show
🗑
As you type in a cell, ____ displays any existing entry in the column that matches the characters you typed.   show
🗑
show tab.  
🗑
show match entire cell contents.  
🗑
show descending.  
🗑
show fields.  
🗑
show 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.   show
🗑
When you have more than one sort field, you should use the Sort ____ to specify the sort criteria.   show
🗑
You can sort by ____.   show
🗑
To add a sort field in the Sort dialog box, click the ____ button.   show
🗑
show delete level.  
🗑
Excel provides ____ predefined custom sort lists.   show
🗑
show sort, chart or copy.  
🗑
show clear.  
🗑
show data.  
🗑
show and.  
🗑
The ____ condition requires that only one of the selected criteria be true for a record to be displayed.   show
🗑
Criteria filters allow you to specify relationships other than those that are based on a(n) "____" the criterion.   show
🗑
show criteria.  
🗑
show begins with.  
🗑
The ____ criteria filter requires the records displayed to have the specified text string anywhere.   show
🗑
The ____ criteria filter requires the records displayed not to have the specified text string anywhere.   show
🗑
The ____ criteria filter requires the records displayed to be greater than or equal to and less than or equal to the specified numbers.   show
🗑
The ____ filtering option displays the top or bottom 10 (or specified number) items in a list.   show
🗑
The ____ criteria filter requires the records displayed to have the current date.   show
🗑
The ____ criteria filter requires the records displayed to be since January 1 of the current year to .the current date.   show
🗑
show Apr, May, June  
🗑
show arrow  
🗑
You can split the worksheet window into ____ separate panes.   show
🗑
show and.  
🗑
show or.  
🗑
show total.  
🗑
You can click the More Functions command on the Total arrow button list to open the ____ dialog box and select any available function.   show
🗑
show count s, sums, averages.  
🗑
To calculate subtotal for a table, the first step is to use the ____ button on the Table Tools Design tab.   show
🗑
show outline.  
🗑
In addition to displaying subtotals, the Subtotal feature "____" your worksheet so you can control the level of detail that is displayed.   show
🗑
show min.  
🗑
show rearrange, hide or display.  
🗑
show insert.  
🗑
show access database file, excel table in current workbook, excel range in current workbook.  
🗑
show table tools design.  
🗑
show column.  
🗑
By default, the PivotTable report uses the ____ function for numbers in the Values area.   show
🗑
show live preview.  
🗑
You can use the ____ tab to change the SUM function to a different summary function, in a PivotTable.   show
🗑
The ____ report layout displays one column for each field and leaves space for column headers.   show
🗑
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   show
🗑


   

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: galvanl
Popular Computers sets