BIM B EXAM QUESTIONS CORRECTLY
ANSWERED.
Read the spreadsheet formula below, then answer the question.
=SUM(C6:C9)
What does the : symbol in the formula do? - CORRECT ANSWER selects all of the cells in the range C6 to
C9
What lookup function should be used to search for values in a specific row of a table and return values
from adjacent rows? - CORRECT ANSWER HLOOKUP
What is relative referencing? - CORRECT ANSWER a system of referring to cells using letters for columns
and numbers for rows
Conditional formatting allows spreadsheet users to - CORRECT ANSWER highlight test scores of below
90% in a grade book.
Including AND in an IF statement means - CORRECT ANSWER more than one condition can be included
in the statement.
Which describes the conditions that must be met in order to use Subtotal in a spreadsheet? - CORRECT
ANSWER The data must be in adjacent cells and organized in columns using headings.
Which feature of spreadsheet software can display numerical data in a visually appealing and easily
understood format? - CORRECT ANSWER charts and graphs
Which of the following is true of operations within a spreadsheet program's built-in functions? -
CORRECT ANSWER Operations within parentheses, then multiplication and division, and then addition
and subtraction are computed.
ANSWERED.
Read the spreadsheet formula below, then answer the question.
=SUM(C6:C9)
What does the : symbol in the formula do? - CORRECT ANSWER selects all of the cells in the range C6 to
C9
What lookup function should be used to search for values in a specific row of a table and return values
from adjacent rows? - CORRECT ANSWER HLOOKUP
What is relative referencing? - CORRECT ANSWER a system of referring to cells using letters for columns
and numbers for rows
Conditional formatting allows spreadsheet users to - CORRECT ANSWER highlight test scores of below
90% in a grade book.
Including AND in an IF statement means - CORRECT ANSWER more than one condition can be included
in the statement.
Which describes the conditions that must be met in order to use Subtotal in a spreadsheet? - CORRECT
ANSWER The data must be in adjacent cells and organized in columns using headings.
Which feature of spreadsheet software can display numerical data in a visually appealing and easily
understood format? - CORRECT ANSWER charts and graphs
Which of the following is true of operations within a spreadsheet program's built-in functions? -
CORRECT ANSWER Operations within parentheses, then multiplication and division, and then addition
and subtraction are computed.
