Test Android StudyStack App
Please help StudyStack get a grant! Vote here.
or...
Reset Password Free Sign Up


incorrect cards (0)
correct cards (0)
remaining cards (0)
Save
0:01
To flip the current card, click it or press the Spacebar key.  To move the current card to one of the three colored boxes, click on the box.  You may also press the UP ARROW key to move the card to the Correct box, the DOWN ARROW key to move the card to the Incorrect box, or the RIGHT ARROW key to move the card to the Remaining box.  You may also click on the card displayed in any of the three boxes to bring that card back to the center.

Pass complete!

Correct box contains:
Time elapsed:
Retries:
restart all cards



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

Excelfinal4

Part 4 of 4

QuestionAnswer
A total row appears as the last row of a table to? Display summary statistics, such as a sum.
Sorting arranges records in a table by what? the value in field(s) within a table.
A page break? Indicates where data starts on a new printed page.
A table is? an area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis.
To Freeze Columns and/or rows..? Use the View Tab, Window Group, and click Freeze Panes/
A structured reference is? is a tag or use of a table element as a reference in a formula.
Using Conditional Formatting to draw attention to cells containing errors does what? Helps locate errors in cells quickly.
Filtering the Cost column (field) to show only records Greater than $10,000 is an application of what? a Number filter
Sorting Values smallest to largest does what? arranges numbers in sequential order.
Using Conditional Formatting to draw attention to cells that are bland does what? helps locate where data may be missing.
A Table Style controls what? The fill color of the header row, columns, and records in a table.
A Table is what? An area in the worksheet that contains rows and columns of related data formatted to enable data management and analysis.
A Field is what? An individual piece of data, such as a last name.
A print area is? It defines the range of data to print.
A data bar is? a horizontal gradient or solid fill indicating the cell's relative value compared to other cells.
Top Bottom Rules? Format cells based upon their value in relation to the value of other cells such as the top 10%.
To convert a table back into a range..? Click within the table, click the Table Tools Design tab, and then select Convert to Range.
A structured reference..? is a tag or use of a table element as a reference in a formula.
What does previewing the worksheet in Backstage view do? it enables you to adjust settings to control how the worksheet will print.
A Record is ..? a complete set of data for and entity.
To remove duplicate records (rows), Select any cell in the table, then click Remove Duplicates from the TOols group on the Table Tools Design tab.
An color scale...? a conditional format that displays a particular color based on the relative value of the cell contents to other selected cells.
Conditional Formatting? highlights or emphasizes cells that meet certain conditions.
Filtering the Date column (field0 to show only records older than January 2001 is an example of what? a Date filter
What is an icon set? a conditional format that displays an icon representing a value in the top third, quarter, or fifth based on values in the selected range.
Freeze Top Row keeps only the top row visible as you scroll through a worksheet.
Filtering the Cost column (field) to show only record Greater than $10,000 is an application of what? a Number Filter
Sorting Values smallest to largest does what? arranges numbers in sequential order.
Created by: jphoto on 2013-07-18



Copyright ©2001-2014  StudyStack LLC   All rights reserved.