BCIS EXAM #2 QUESTIONS WITH VERIFIED
ACCURATE ANSWERS
If the destination file is closed when you make a change in the ____ file, you can
choose whether to update the link to display the current values when you open the
destination file. - Answers - •Target, origin, source or key
•source
DART (Deep-ocean Assessment and Reporting of Tsunamis) - Answers - mooring
system that can warn far shores of tsunami threats
Describe the scientific method - Answers - •Observe
•Hypothesize
•Collect data
•Analyze
•test
GIS - Answers - Geographic Information System, A computer system that stores,
organizes, analyzes, and displays geographic data.
Describe the steps in the engineering process - Answers - •Research
•Plan
•Prototype
•Test-revise-retest
•Proposal-to-build-or-produce
•Build/make
Logical functions (IF, AND, and OR - Answers - determine whether a condition is true or
false
Conditions use a comparison operator (<, <=, =, <>, >, or >=) - Answers - to compare
two values
Combine two or more functions in one formula to? - Answers - create more complex
conditions
Summarize data using: - Answers - COUNTIF, SUMIF, and AVERAGEIF functions
Use conditional formatting to: - Answers - highlight some value
the IF Function - Answers - •A logical function that evaluates a single condition and
results in only one value
, •Returns one value if the condition is true and another value if the condition is false
•Syntax: IF(logical_test, value_if_true, value_if_false)
the AND Function - Answers - •A logical function that tests two or more conditions (up to
255) and determines whether all conditions are true
•Returns the value TRUE if all logical conditions are true and the value FALSE if any or
all logical conditions are false
•Syntax: AND(logical1[,logical2]...)
the OR Function - Answers - •A logical function that returns a TRUE value if any of the
logical conditions (up to 255) are true and a FALSE value if all the logical conditions are
false
•Syntax: OR(logical1[,logical2]...)
Lookup functions - Answers - allow you to use tables of data to find values in a table
and insert them in another worksheet location
The VLOOKUP function - Answers - always searches for a value in the first column of
the lookup table
The HLOOKUP function - Answers - always searches for a value in the first row of the
lookup table
To move between open workbooks: - Answers - -use Switch Windows button in the
Windows group on the VIEW tab lists
or
-click Excel program button on the task bar, then click the thumbnail of the workbook
The dialog box shows the following information about each link: - Answers - -Source:
indicates the file that the link points to
-Type: identifies the type of each source file
-Update: specifies the way values are updated from the source file
-Status: shows whether Excel successfully accessed the link and updated the values
from the source document (status is OK)
Scientists use computers to support research in many ways: - Answers - -observation
and discovery
ACCURATE ANSWERS
If the destination file is closed when you make a change in the ____ file, you can
choose whether to update the link to display the current values when you open the
destination file. - Answers - •Target, origin, source or key
•source
DART (Deep-ocean Assessment and Reporting of Tsunamis) - Answers - mooring
system that can warn far shores of tsunami threats
Describe the scientific method - Answers - •Observe
•Hypothesize
•Collect data
•Analyze
•test
GIS - Answers - Geographic Information System, A computer system that stores,
organizes, analyzes, and displays geographic data.
Describe the steps in the engineering process - Answers - •Research
•Plan
•Prototype
•Test-revise-retest
•Proposal-to-build-or-produce
•Build/make
Logical functions (IF, AND, and OR - Answers - determine whether a condition is true or
false
Conditions use a comparison operator (<, <=, =, <>, >, or >=) - Answers - to compare
two values
Combine two or more functions in one formula to? - Answers - create more complex
conditions
Summarize data using: - Answers - COUNTIF, SUMIF, and AVERAGEIF functions
Use conditional formatting to: - Answers - highlight some value
the IF Function - Answers - •A logical function that evaluates a single condition and
results in only one value
, •Returns one value if the condition is true and another value if the condition is false
•Syntax: IF(logical_test, value_if_true, value_if_false)
the AND Function - Answers - •A logical function that tests two or more conditions (up to
255) and determines whether all conditions are true
•Returns the value TRUE if all logical conditions are true and the value FALSE if any or
all logical conditions are false
•Syntax: AND(logical1[,logical2]...)
the OR Function - Answers - •A logical function that returns a TRUE value if any of the
logical conditions (up to 255) are true and a FALSE value if all the logical conditions are
false
•Syntax: OR(logical1[,logical2]...)
Lookup functions - Answers - allow you to use tables of data to find values in a table
and insert them in another worksheet location
The VLOOKUP function - Answers - always searches for a value in the first column of
the lookup table
The HLOOKUP function - Answers - always searches for a value in the first row of the
lookup table
To move between open workbooks: - Answers - -use Switch Windows button in the
Windows group on the VIEW tab lists
or
-click Excel program button on the task bar, then click the thumbnail of the workbook
The dialog box shows the following information about each link: - Answers - -Source:
indicates the file that the link points to
-Type: identifies the type of each source file
-Update: specifies the way values are updated from the source file
-Status: shows whether Excel successfully accessed the link and updated the values
from the source document (status is OK)
Scientists use computers to support research in many ways: - Answers - -observation
and discovery
