Test 1

Question 1

Cell

Answer 1

A container for numbers, text or other objects

Question 2

formatting

Answer 2

describes how a cell looks, includes borders, font size, number format

Question 3

formula

Answer 3

a command in excel that returns information based on inputs(typically a number)

Question 4

sort

Answer 4

Arrange cells of data in a specific way, such as largest ot smallest. can be done with linked data, maintaining a relations in a row.

Question 5

locking cell reference

Answer 5

a way to keep a reference from moving as a formula is compiled from one cell to another. use the $ to indicate which part of the reference should be locked.

Question 6

View modifications

Answer 6

a way to tell Excel to keep part of your file visible at all times as you navigate around the file

Question 7

Iferror

Answer 7

a function in Excel that lets you handle an error the way you want to

Question 8

Conditionsals

Answer 8

used to check if some condition is true

Question 9

named lists

Answer 9

a range of cells given a unique identifier

Question 10

value look-up

Answer 10

INDEX and MATCH functions used to find and return information based on the value of a cell

Question 11

Random formula

Answer 11

A formula which returns a different value each time it is calculated.

Question 12

Conditional Formatting

Answer 12

Changes how a cell looks based on the contents of the cell

Question 13

Cell Protection

Answer 13

A way to keep your data from being changed accidentally

Question 14

Graph

Answer 14

A visual way to show data

Question 15

Logic

Answer 15

The study of the methods and principles of reasoning.

Question 16

Argument

Answer 16

Uses premises to build to a conclusion.

Question 17

Premise

Answer 17

A set of facts or assumptions.

Question 18

Conclusion

Answer 18

The result of an argument or what an argument is attempting to say.

Question 19

Fallacy

Answer 19

A deceptive argument in which the conclusion is not well supported by the premises.

Question 20

Proposition

Answer 20

A statement that makes a claim that is either true or false.

Question 21

Negation

Answer 21

The opposite of a proposition.

Question 22

Venn Diagram

Answer 22

A graphical representation of a set or collection.

Question 23

Inductive Argument

Answer 23

Makes a general conclusion from more specific premises.

Question 24

Deductive Argument

Answer 24

Makes a specific conclusion from more general premises.

Question 25

Set

Answer 25

A collection of objects, living or nonliving.

Question 26

Critical Thinking

Answer 26

The objective Analysis and Evaluation of an issue in order to form a judgement.

Question 27

Five steps of evaluating media

Answer 27

1) Consider the source. 2) Check the date. 3) Validate the accuracy. 4) Watch for hidden agendas. 5) Don’t miss the big picture.

Question 28

Identify a proposition

Answer 28

?

Question 29

Know how to negate a proposition

Answer 29

?

Question 30

Know how to create a truth table

Answer 30

?

Question 31

Know how to rephrase a quotation into one or more conditional statements.

Answer 31

?

Question 32

Know how to construct and interpret a Venn Diagram

Answer 32

?

Question 33

Know how to construct a two-way table and a Venn diagram from given information.

Answer 33

?

Question 34

Know how to analyze inductive arguments- are the premises true, is the argument strong or weak, is the conclusion true?

Answer 34

?

Question 35

Know how to analyze deductive arguments- is the argument valid? and is the argument sound? Use a Venn diagram to help

Answer 35

?

Question 36

Know the seven hints of practicing critical thinking.

Answer 36

Read or listen carefully.
Look for hidden assumptions.
Identify the real issue.
Understand all the options. 
Watch for fine print and missing information. 
Are other conclusions possible?
Don't miss the big picture.

Question 37

Which parts of the Basic excel assignment were the most challenging and why

Answer 37

?

Question 38

Which parts of the Advanced excel assignment were most difficult and why?

Answer 38

?