edit the formula in cell C2 so that references to cell B2 will update when the formula is copied, and the reference to cell B9 will remain constant
answer
Double-click cell C2 to edit the formula. change the formula to be = B2+(B2^$B$9). Press enter
question
Enter a formula in cell B4 using the VLOOKUP function to find the meaning for the medical abbreviation listed in cell A4. Use the name abbreviation for the look up table. The item names are located in column 2 of the lookup table. be sure to require an exact match
answer
On the formulas tab, in the function library group, click the lookup & reference button, and select VLOOKUP. type A4 in the lookup value agreement box. type abbreviation in the table array argument box. type 2 in the col num argument box. type false in the range lookup box. click okay
question
enter a formula in the selected cell using SUMIF to calculate the total expenses for the category office expense. Use the range name category for the range argument, the text string "office expense" for the criteria argument, and cost for the sum range argument
answer
on the formula tab, in the function library group, click the Math & Trig button. click SUMIF. in the range argument box, type category. in the criteria box, type "office expense". in the sum range argument box, type cost. click ok
question
add a blue, accent 1 color, bottom border to the selected cells, use the thickest single line style available
answer
on the home tab, in the font group, click the borders button arrow, and select more borders. in the format cells dialog, border tab, click the thickest line available in the style section. expand the color pallet and select blue accent 1. in the border section, click the button represent a bottom border
question
modify the worksheet so the first row is always visible when you scroll the worksheet
answer
on the view tab, in the window group, click the freeze panes button, click freeze top row
question
show the tracer arrows for the selected cell to display arrows to the cells containing formulas that reference the value or formula in the selected cell
answer
on the formulas tab, in the formula auditing group, click the trace dependents button
question
preview how this worksheet would print with formulas showing instead of calculated values
answer
on the formulas tab in the formula auditing group, click the show formulas button. click the file tab. click print
question
using cell references, enter a formula in cell B6 to calculate monthly payments for the lan described in this worksheet. the annual interest rate is stored in cell B3, the number of payments in cell B4, and the loan amount in cell B2. omit the optional arguments. the result of the formula should be a negative number
answer
on the formulas tab, in the function library group, click the financial button, and click PMT. enter B3/12 in the rate argument box. enter b4 in the Nper argument box. enter B2 in the argument box. click ok.
question
clear only the formatting from the selected cell (leaving content)
answer
on the home tab, in the editing group, click the clear button, select clear formats
question
change the angle of rotation for the selected cells to 45 degrees
answer
on the home tab, in the alignment group, click te orientation button, and deleted angle counterclockwise
question
use autofill to copy the formula and formatting in cell B7 to cells C7:E7
answer
click in cell B7, click the fill handle tool and drag across to cell E7. release the mouse button
question
cell F2 has been copied. paste the formula only into the selected cell (cell F3). Do not include the cell formatting
answer
click the paste button arrow, and then click the formulas option
question
use format painter to copy the formatting from cell D1 and apply it to cell E1
answer
on the home tab, in the clipboard group, click the format painter button. clicl cell E`
question
modify the number format so no decimal places are visible after the decimal point
answer
on the home tab, in the number group, click the decrease decimal button twice
question
the selected column is too narrow to display all the values. auto fit the column to best fit the data
answer
double-click the right column boundary for column E
question
wrap the text in the selected cell
answer
on the home tab, in the alignment group, click the wrap text button
question
switch to the view that shows all the worksheet elements as they will print, including headers and footers
answer
click the page layout button at the lower right corner of the status bar, to the left of the zoom cider
question
this worksheet has been split into four panes. return the worksheet to a single view
answer
on the view tab, in the window group, click the split button
question
without adjusting the column widths, guarantee that all columns will print on one page
answer
on the page layout tab, in the scale to fit group, click the width arrow. click page 1
question
add an element to the center section of the header that will always display the current date
answer
click the page layout button on the status bar. click in the center section of the header area above the worksheet grid. on the header & footer tools design tab, in the header & footer elements group, click the current date button
question
enter a formula in cell B28 to return a value of 25,000 if the net profit after tax (cell B27) is greater than or equal to 250,000 or 1,000 if cell B27 is less than 250,000
answer
on the formulas tab, in the function library group, click the logical button, select IF from the list. enter B27>=250000 in the logical test box. enter 25000 in the value if true box, and 1000 in the value if false box. click ok
question
enter a formula in the selected cell using the SUMPRODUCT function to calculate the total value of the current leases by multiplying the current month rents by the remaining months on each lease. use the range names rents and leases
answer
on the formulas tab, in the function library group, click the math & trig button. click SUMPRODUCT. in the Array1 argument box, type rents. in the Array2 argument box, type leases. click ok
question
use the create from selection command to create named ranges for the data table B2:E6 using the labels in row 1 as the basis for the names
answer
on the formulas tab, in the defined names group, click the create from selection button. the top row check box is checked by default. click ok
question
name cell B9 as follows: COLA
answer
type COLA in the name box to the left of the formula bar. press enter
question
in cell D14, enter a formula using a counting function to count the number of cells in the billable? column that are not black (Cells D2:D13)
answer
on the formulas tab, in the function library group, click the more functions button. point to statistical and select COUNTA from the list. type D2:D13 in the value 1 box. click ok
question
in cell E15, enter a formula to find the lowest line item cost this month (cells E2:E14)
answer
on the formulas tab, in the function library group, click the autism arrow, and click min. press enter
Haven't found what you need?
Search for quizzes and test answers now
Quizzes.studymoose.com uses cookies. By continuing you agree to our cookie policy
