Get ahead with a $300 test prep scholarship
| Enter to win by Tuesday 9/24
computer apps ch6
Terms in this set (30)
what formatting does a newly inserted row contain?
a newly inserted column?
same formatting as the cells in the row above
same formatting as the cells in the column to the left
the formula =SUM(C3:C22) is entered in cell C24 and used to sum the values in cells C3 through C22
a.) if a row is inserted directly above row 20, what must be done in order to include the new cell in the sum?
b.) if a row is inserted directly above row 24, what must be done to include the new cell in the sum?
c.) if row 20 is deleted, what must be done to the formula so that the detected cell is no longer in the range?
a.) nothing must be done in order to include the new cell in the sum
b.) the sum formula must be edited to include the new cell. the formula must be changed from =SUM(C3:C22) to =SUM(C3:C24)
c.) nothing must be done to the formula because the deleted cell is no longer in the range
Using functions, write a formula to calculate:
a.) the sum of the values stored in cells B4, B5, B6, and B7
b.) the sum of the values stored in cells B4, C4, D4, and E4
c.) the average of the values stored in the column of cells D7 through D35
d.) the average of the values stored in the row of cells F3 through J3
e.) the maximum value stored in the range of cells D4 through Y5
f.) the minimum value stored in the range of cells C1 through C9
what is the difference between a relative cell reference and an absolute cell reference?
a relative cell reference automatically changes when copied, an absolute does not change when copied. and absolute cell reference contains a dollar sign in front of both the column letter and the row number, such as $A$1
list two advantages of using the insert function dialog box to insert the name of a function in a formula instead of typing the formula
less chance of typing errors and arguments are specified
why is it important to check the range placed in the SUM function when using FORMULAS>AutoSum?
the range placed in the SUM function when using the AutoSum button should be double checked since Excel guesses the range
using functions, write a formula to calculate:
a.) the sum of the values in cells C5, C6, C7, C8, and C9 rounded to 2 decimal places
b.) the sum of the values in cells B5, C5, D5, and E5 rounded to the nearest integer
c.) the average of the values in cells A1, A2, A3, B1, B2, and B3 rounded to 1 decimal place
what will be displayed by the following formulas if cell D4 stores a value of 30 and cell E7 stores a value of -12?
a.) =IF(D4<=E7, 10, 20)
b.) =IF(E7*D4<-5, E7, D4)
c.) =IF(D4-42=E7, D4
using functions, write a formula to:
a.) display 50 if the value stored in D20 equals the value in C70, or 25 if they are not equal
=IF(D20=C70, 50, 25)
b.) display the value in B40 if the sum of the range of cells C20 to c30 exceeds 1000, otherwise display a 0
=IF(SUM(C20:C30)>1000, B40, 0)
display the value of R20*10 if R20 is less than 30, otherwise display the value in R20
=IF(R20<30, R20*10, R20)
write formulas using the IF function for each of the following:
a.) if B3 is less than or equal to C12 display Low; if greater than display High
=IF(B3<=C12, "Low", "High")
b.) if A5 is equal to Z47 display Jonathon; if not equal to, display Judith
=IF(A5=Z47, "Jonathon", "Judith")
explain why it would be a good idea to change sheet names from sheet1, sheet2 and so on in a workbook with multiple data sheets
it would be a good idea to change the sheet names to a name that is descriptive of the sheet contents so that the user knows what data is stored on each sheet
list two other "what if?" questions that can be answered using the Charity Fundraiser workbook
"what if ticket prices are raised? how will that impact the price?" and
"what if the auditorium rental was lowered? how will that impact the profit?"
a modified cell style is accessible to all new workbooks
false. a modified cell style is only accessible in the active workbook
when rows are inserted, Excel automatically change the cell references in any affected formulas
the SUM function ignores cells that contain text when their cell references are included as arguments
an absolute cell reference changes when copied
false. an absolute cell reference does not change when copied
a #### error value indicates the formula is trying to divide by 0
false. a #### error value indicates that the result of the formula is too wide to fit in the column or the result is a negative time or date value
when a formula produces a result and a green triangle is in the cell, this indicates a correct formula
false. this indicates a possible formula error
there is no difference between formatting and rounding
false. the ROUND function changes the value stored in a cell and formatting only changes the way the data is displayed
linked data will automatically update if the source cell is changed