BIM B Q&A GRADE A
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.
An employer uses the spreadsheet below to determine the average hourly salary of
her four employees. She begins by determining the hourly salary of each person and
displaying that in column D. Which formula can she then use to determine the
average hourly salary? - (CORRECT ANSWER)=average(D2:D5)
Seth, a zoologist, has a spreadsheet containing data on all the animals in a zoo. He
wants to sort the column that contains the weights of all of the animals. Which sort
tool could he use to reorganize the numbers so they are listed from smallest to
largest? - (CORRECT ANSWER)sort ascending
What is the main difference between using the ROUND function and using number
formatting to make all values appear as whole numbers without decimal places? -
(CORRECT ANSWER)Using the ROUND function changes the value so that the
rounded value is used in other calculations, but when cells are formatted as whole
numbers, all digits after the decimal are still used in other calculations.
The spreadsheet below shows the age, grade level, major, and minor of four
students in college. A purple background in the Major column indicates that a
student has previously changed his or her major.
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.
An employer uses the spreadsheet below to determine the average hourly salary of
her four employees. She begins by determining the hourly salary of each person and
displaying that in column D. Which formula can she then use to determine the
average hourly salary? - (CORRECT ANSWER)=average(D2:D5)
Seth, a zoologist, has a spreadsheet containing data on all the animals in a zoo. He
wants to sort the column that contains the weights of all of the animals. Which sort
tool could he use to reorganize the numbers so they are listed from smallest to
largest? - (CORRECT ANSWER)sort ascending
What is the main difference between using the ROUND function and using number
formatting to make all values appear as whole numbers without decimal places? -
(CORRECT ANSWER)Using the ROUND function changes the value so that the
rounded value is used in other calculations, but when cells are formatted as whole
numbers, all digits after the decimal are still used in other calculations.
The spreadsheet below shows the age, grade level, major, and minor of four
students in college. A purple background in the Major column indicates that a
student has previously changed his or her major.
