Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
24 Cards in this Set
- Front
- Back
to write an effective spreadsheet, what are two basic principles?
|
1) Focus on form
a) descriptive info should be on the top and left sides b) summary info should be on the bottom and right sides 2) Explain everything |
|
What does conditional format do for a spreadsheet?
|
allows you to apply an interpretation to the data and express that interpretation in an easy to perceive manner.
|
|
how do you select a conditional format in excel?
|
select columns you'd like to apply formatting to, go to "format" "conditional formatting" which will bring you to a window where you can specify changes.
|
|
what is the general specification for an If function?
|
If(condition, action_on_true_outcome, action_on_false_outcome)
|
|
What is the general specification for the Left function and what does it do?
|
distinguishes between segments in the left column, such as types of currencies.
Left(text_value, num_charts) |
|
how do you combine a left and if function?
|
If(Left(text_value, num_charts)="another text_value", True, False)
|
|
what is a name?
|
a word or phrase assigned to a cell or range of cells
|
|
how do you apply scenarios to a spreadsheet?
|
specify cells a scenario affects, go to tools, scenarios, and manage specifications
|
|
how do you set a filter?
|
go to data, filter, autofilter.
|
|
how do you execute an advanced filter?
|
give a column a name and a filtering criterion. add a new column with the same heaidng, the in cell below enter a criterion to indicate that values in the other columns by the same name should be filtereted to be greater than 175. Then you can run a filtering opertaion. Choose data, filtering, advanced search, then specify the range.
|
|
what is an entity?
|
anything that can be identified by a fixed number of its characterstics, called attributes.
|
|
what are entity instances?
|
values in rows
|
|
what are table instances?
|
tables containing specific rows
|
|
What is a candidate key?
|
set of attributes for which all entities are different
|
|
what is a primary key?
|
the one key the database system will use to decide uniqueness.
|
|
what is atomic data?
|
not decomposable into any smaller parts, like an address value
|
|
What are five database operations?
|
Select, project, union, difference, and product
|
|
what does select do?
|
specifies a row
|
|
what does project do?
|
specifies a column
|
|
waht does union do?
|
combines two tables with same attributes
|
|
waht does Difference do?
|
removes from one table the rows also listed in the second table.
|
|
what does the product operation do?
|
creates a supertable that has the columns from both tables.
|
|
what does the join operation do?
|
combines table like product, but doesn't necessarily produce all the pairings. it is hepful for matching alike attributes
|
|
what is a relationship?
|
correspondence between rows o one table and rows of another
|