Page 35 - GE 10 Module Crim Midterm

QUIRINO STATE UNIVERSITY

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

d. 26

10. What feature did we use to
quickly apply the formatting
shown in this image?
a. PivotTables
b. What-if analysis
c. Data scenario formatting
d. Conditional formatting

Answers:

1. A. The intersection of a row and a column is called a Cell.
2. D. A group of cells is called a cell range.
3. B. The value of the cell is using a currency number format because of the dollar
sign and the decimals.
4. C. You can click the tabs at the bottom of a workbook to switch between
worksheets.
5. C. All formulas should have an equal sign at the beginning.
6. A. Double clicking a cell shows the formula used.
7. – 8. B. & C. All formulas should have an equals sign at the beginning and all
cell names start with a letter then a number.
9. D. =(82-32)/5+8*2 By using the PEMDAS order of operations, the computation
should start by the parenthesis followed by multiplication, then division then
lastly addition.
10. D. Conditional formatting allows you to automatically apply formatting—such
as colors, icons, and data bars—to one or more cells based on the cell value. In
this case, all values that exceed $4,000 is highlighted with green fill.

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”