DIT Semester 2 Review Exam Questions and Answers.
=AVERAGE(B1:B35) - ANS Adds the values of a range of cells and divides that total by
the number of cells in the range
=SUM(B1:B35) - ANS Add the values in a range of cells
Range - ANS In a function the cells in which we perform calculations on. I.e., (B1:B35)
Number - ANS To do math calculations cells must be formatted as a ...
=B2 - ANS Will transfer the value from the second row, second column where ever this
formula is typed
C3 - ANS Identifies the cell at the third row, third column
Pie Chart - ANS Visually compares the partial values to the values in total
Bar Chart - ANS Compares several values in relation to each other
Line Graph - ANS Compares values, typically used to show changes over time
$B1 - ANS When filling across the column will stay absolute
B$1 - ANS When filling down the row will stay absolute
= - ANS All formulas and functions start with this character
Argument - ANS In a function, this is a term for the values used to make a calculation.
Fill Series - ANS You want to continue numbering sequentially so you enter the first two
numbers and ...
Formula (Function) - ANS Mathematical equation used in Excel to perform calculations
Merge Cells (Merge and Center) - ANS Although not recommended, often done to
create titles of spreadsheets - Use Header instead
Problem with Merged Cells - ANS ... is they cannot be used in calculations without
causing an error
Conditional Formatting - ANS Makes a visual indicator, like coloring cells, based on a
criteria we specify
Column Width - ANS Move the cursor between the column letters. When you see a
double arrow click and drag to change...
Page 1|4
=AVERAGE(B1:B35) - ANS Adds the values of a range of cells and divides that total by
the number of cells in the range
=SUM(B1:B35) - ANS Add the values in a range of cells
Range - ANS In a function the cells in which we perform calculations on. I.e., (B1:B35)
Number - ANS To do math calculations cells must be formatted as a ...
=B2 - ANS Will transfer the value from the second row, second column where ever this
formula is typed
C3 - ANS Identifies the cell at the third row, third column
Pie Chart - ANS Visually compares the partial values to the values in total
Bar Chart - ANS Compares several values in relation to each other
Line Graph - ANS Compares values, typically used to show changes over time
$B1 - ANS When filling across the column will stay absolute
B$1 - ANS When filling down the row will stay absolute
= - ANS All formulas and functions start with this character
Argument - ANS In a function, this is a term for the values used to make a calculation.
Fill Series - ANS You want to continue numbering sequentially so you enter the first two
numbers and ...
Formula (Function) - ANS Mathematical equation used in Excel to perform calculations
Merge Cells (Merge and Center) - ANS Although not recommended, often done to
create titles of spreadsheets - Use Header instead
Problem with Merged Cells - ANS ... is they cannot be used in calculations without
causing an error
Conditional Formatting - ANS Makes a visual indicator, like coloring cells, based on a
criteria we specify
Column Width - ANS Move the cursor between the column letters. When you see a
double arrow click and drag to change...
Page 1|4
