CIS-110 - Chapter 14 Definitions
What is a border?
A border is a line you add along an edge of a cell.
Why would you use a cell style?
A cell style lets you apply the same collection of formatting options to multiple cells within the workbook, ensuring consistency throughout the workbook.
What is a date function?
A date function is a function that inserts or calculates dates and times.
What is a fill color? When would you use fill colors?
A fill color is a background color that is added to worksheet cells. Fill colors are useful for differentiating parts of a worksheet or highlighting data.
Explain the difference between a relative reference, an absolute reference, and a mixed reference.
A relative reference is a cell reference that is interpreted in relation to the location of the cell containing the formula. An absolute reference is a cell reference that remains fixed when copied to a new location; it includes $ in front of both the column letter and row number. A mixed reference is a cell reference that contains an absolute row reference or an absolute column reference, such as $A2 or A$2.
How do you use the fill handle?
After you select a cell or range, the fill handle appears in the lower-right corner of the selection. When you drag the fill handle over an adjacent range, AutoFill copies the content and formats from the original cell into the adjacent range.
AutoFill
An Excel feature that copies content and formats from a cell or range into an adjacent cell or range
What is AutoFill?
AutoFill is an Excel feature that copies content and formats from a cell or range into an adjacent cell or range. AutoFill can also extend a series of numbers, patterned text, and dates into the adjacent selection.
Write the formula to determine the monthly payment for a $50,000 loan with an annual interest rate of 4 percent that will be repaid in three years.
The formula to determine the monthly payment for a $50,000 loan with an annual interest rate of 4% that will be repaid in three years is: =PMT(0.04/12,3*12,50000)
What is the general syntax of all Excel functions?
The general syntax of all Excel functions is FUNCTION(argument1,argument2,...) where FUNCTION is the name of the function, and argument1, argument2, and so forth are arguments.
Describe how to type a function directly in a cell.
To type a function directly in a cell, first type an equal sign. As you begin to type a function name, a list of functions that begin with the letters you typed appears. To insert a function in the active cell, press the Tab key or double-click its function name. You can then either select a cell or range or type the appropriate reference or argument. When the function is complete, you enter it into the cell as usual.
Unless you change the alignment, how is text aligned within a cell, and how are values aligned within a cell?
Unless you change the alignment, text is aligned with the left and bottom borders of a cell and values are aligned with the right and bottom borders of a cell.
Where can you access all of the formatting options for worksheet cells?
You can access all the formatting options for worksheet cells in the Format Cells dialog box.
Which of the following is true of borders in Excel?
You can specify the thickness of and the number of lines in borders.
fill handle
a box in the lower-right corner of a selected cell or range that you drag over an adjacent cell or range to copy the content and formatting from the original cells into the adjacent range
mixed reference
a cell reference that contains both an absolute reference and a relative reference
relative reference
a cell reference that is interpreted in relation to the location of the cell containing the formula
absolute reference
a cell reference that remains fixed when copied to a new location
fill color
a color added to cells or shapes
PMT function
a financial function that calculates the payment schedule required to repay a loan
financial function
a function related to monetary calculations, such as loans and payments
date function
a function that inserts or calculates dates and times
border
a line added along an edge of a cell
syntax
a set of rules
optional argument
an argument that is not required for the function to return a value but provides more control over how the returned value is calculated
what-if analysis
an examination of how changing values entered directly in a worksheet affect calculated values
The DAY(date) function is used to _____.
extract the day of the month from the date value
gridlines
in a worksheet, lines that divide columns and rows in a worksheet and define the structure of the worksheet
Functions that return true or false values are called _____.
logical functions
The formula =SUM(A7:A9) is an example of a(n) _____ reference.
relative
interest
the amount added to the principal by the lender
principal
the amount of money being loaned
payment period (period)
the length of time between each loan payment
argument
the numbers, text, or cell references used by a function to return a value
In Microsoft Excel 2016, some styles are based on the workbook's current _____.
theme
merge
to combine two or more cells into one cell
The general syntax of Excel functions is _____.
FUNCTION(argument1,argument2,...)
Which of the following functions is used to calculate the day of the week from the date value?
WEEKDAY(date[,return_type])
While referencing cells on a worksheet in other workbook, if the worksheet name contains spaces, _____.
single quotation mark appears to the left of the first square bracket and after the sheet name
Which of the following step should be followed to edit the range reference to a cell when you have double-clicked the cell containing the formula or function?
Select the range again and drag a handle on the border of the shading
After selecting a function from the list, press the _____ key to insert it into the active cell.
Tab
What is the PMT function?
The PMT function is a financial function that calculates the monthly payment required to repay a loan.
Why does the PMT function return a negative value?
The PMT function returns a negative value because the payment is an expense to the borrower.
Which date function returns the current date?
The TODAY function returns the current date.
Which of the following is true of parenthesis in Microsoft Excel 2016?
Excel uses parenthesis in formulas to interpret them correctly.
A cell background can be formatted by using the _____ button.
Fill Color
Asher, a high school student, is learning how to use Excel. He enters a sequence of numbers, 1.0, 1.25, 1.5, ..., as data in the first column. Which of the following features of AutoFill should Asher use to continue the pattern of data?
Fill Series
Which of the following AutoFill features copies the content but not the pattern?
Fill Without Formatting
The Fill Color button arrow is located in the _____ group on the Home tab.
Font
What are the relative, absolute, and mixed cell references for cell H9?
For cell H9, the relative reference is H9, the absolute reference is $H$9, and the mixed reference is either $H9 or H$9.
If the range A1:C5 is merged into a single cell, what is the cell reference of this merged cell?
If the range A1:C5 is merged into a single cell, the cell reference of this merged cell is A1.
In a function, what is an argument?
In a function, arguments are the numbers, text, or cell references used by the function to return a value.
The _____ button can be used to see a more precise interest rate per period for loans.
Increase Decimal
Which of the following is true of the COUNTA(value1[,value2, value3,...]) function?
It calculates the number of cells that are not empty in ranges.
Which of the following buttons in Microsoft Excel 2016 can be used to combine two or more cells into one cell?
Merge & Center button
Most interest rates are presented as an annual interest rate. How do you determine the interest rate per month?
To determine the interest rate per month, divide the annual interest rate by 12.
Which of the following is true of optional arguments?
They are not required for a function to return a value.
The _____ command on the Paste button menu is used to control how content is pasted from the Clipboard in Excel.
Paste Special
Describe how to use AutoFill to create a series of numbers.
To create a series of numbers with AutoFill, you enter the initial values in the series, such as the first few consecutive integers, in a selected range to establish the pattern for AutoFill to use, select the range, and then drag the fill handle over the cells where you want the pattern continued.
What is the syntax of the PMT function?
The syntax of the PMT function is PMT(rate, nper,pv[,fv=0][,type=0]) where rate is the interest rate for each payment period, nper is the total number of payment periods required to repay the loan, pv is the present value of the loan or the amount that needs to be borrowed, fv is the future value of the loan, and type specifies when the interest is charged on the loan.
