Review Questions and Answers Functions and Data ... - Weebly



Review Questions and Answers Functions and Data OrganizationDescribe how to insert a column between column A and column B.2.a)What formatting does a newly inserted row contain?b)What formatting does a newly inserted column contain?List the step required to delete row 8.4.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 deleted cell is no longer in the range?5.a)What is a function?b)What does a function require to perform a calculation?6.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.7.What is the difference between a relative cell reference and an absolute cell reference?8.List the steps required to create a formula in cell G5 that multiplies the value in cell F5 with the value in cell B1 so that when the formula is copied, the cell reference to B1 remains constant.9.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.10.Why is it important to check the range placed in the SUM function when using Formulas > AutoSum?11.Describe two common error values.12.a)Describe two common formula errors.b)List the steps required to remove the green triangle from a cell that displays a result and the formula does not contain an error.13.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.14.a)List the steps required to sort the data in a workbook in descending order based on the data in column C.17.a)List the steps required to print a worksheet across the widest part of the paper.b)What can be decreased in order to fit more rows and columns on a printout?c)What can be used to control how a worksheet is divided into pages?d)List the steps required to print only the values displayed in the cell range A3:D17.e)List the steps required to print the entire worksheet after a print area was previously set.19.Briefly explain what an amortization table is and the terminology associated with it.20.a)How much interest is paid in the first month of a loan of $5,000 borrowed for 5 years at 12% per year interest?b)Write the PMT function used to calculate the monthly payments on the above loan.21.a)How is a sheet made active?b)List the steps required to rename Sheet1 to Jan Sales.c)Explain how to add a new sheet to a workbook.d)How is the sheet order changed?22.List the steps required to print all the sheets in a workbook at one time.23.List the steps required to print Sheet1 in landscape orientation and Sheet2 in portrait orientation.24.Explain why it would be a good idea to change sheet names from Sheet1, Sheet2, and so forth in a 25.List the steps required to copy or move data between sheets in a workbook.26.List the steps required to reference cell B5 on Sheet1 and multiply its value by 3.6 in a formula stored in cell C4 on Sheet2.27.a)What is the difference between pasting data and linking data?b)List the steps required to link cell A25 on Sheet2 to cell A20 on Sheet1.31.Determine if each of the following are true or false. If false, explain why.a)A new cell style can be added to the Cell Styles gallery.b)A modified cell style is accessible to all new workbooks.c)When rows are inserted, Excel automatically changes the cell references in any affected formulas.d)The SUM function ignores cells that contain text when their cell references are included as arguments.e)An absolute cell reference changes when copied.f)The range placed in the SUM function when AutoSum is clicked is always correct.g)A #### error value indicates the formula is trying to divide by zero.h)When a formula produces a result and a green triangle in the cell, this indicates a correct formula.i)There is no difference between formatting and rounding.The key sort column can be any column with data on the worksheet.The location of page breaks in a worksheet can be changed.Clearing a print area sets the entire worksheet as the print area.The principal of a loan decreases each time a payment is made.True.Sheet1 can print a different header than Sheet2.True.A new workbook contains three sheets.True.Linked data will automatically update if the source cell is changed.True. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download