Page 34 - GE 10 Module Crim Midterm

QUIRINO STATE UNIVERSITY

COLLEGE OF PUBLIC SAFETY
Bachelor of Science in Criminology
…harmonizing ideals

Comprehension Check

Supply the correct answer to complete the thought in every item.
1. The intersection of a row and a column is called a ________.
a. Cell
b. Sum
c. Worksheet
d. Chart
2. A group of cells is called a ________.
a. Chart
b. Multicell
c. cell cluster
d. cell range
3. In this image, why does the value in
cell G1 look slightly different from
the value in the formula bar?
a. It’s using a formula
b. It’s using the Currency
number format
c. It’s using an absolute cell
reference
d. It’s using conditional formatting
4. You can click the tabs at the bottom of a workbook to switch between ________.
a. number formats
b. formulas
c. worksheets
d. permissions
5. Let’s say you’re trying to find your
average grade. What’s wrong with the
formula shown in the image?
a. It should use quotation marks
instead of parentheses
b. It should use the COUNT function
instead
c. It should have an equals sign (=)
at the beginning
d. There is nothing wrong with the
formula
6. True or False: You can view a formula by double-clicking the cell that contains
the formula.
a. True
b. False
7. – 8. Which of the formulas below are valid? Select all that apply.
a. A3+100
b. =R2*D2
c. =F2+F3+F4-53
d. =5B+6B

9. What value would Excel return for this formula? =(82-32)/5+8*2
a. 36
b. 7.69
c. 91.6
VISION MISSION
The leading center for academic and technological excellence Develop competent and morally upright professionals and generate
and prime catalyst for a progressive and sustainable Quirino appropriate knowledge and technologies to meet the needs of Quirino
Province and Southern Cagayan Valley. Province and Southern Cagayan Valley.

“Molding Minds, Shaping Future”