Blog

How is a relative cell reference different from an absolute cell reference? Give examples of each type of cell references.

Can you use the following in Excel to calculate the average of values in cells A1, B2, C2, A4? If no, re-write it to correct it. =AVERAGE(A1:B2:C2:A4)

Is there anything wrong with the following Excel function? If yes, re-write it to correct it. =SUM(X1; Y1; X2; Y2)

The following Excel worksheet shows games scores of 10 players: Write the function to calculate the total of the game scores for Player 7.

What function in Excel do you use to find the lowest of values in a cell range? Write the Excel function that gives you the lowest of values in cells X1, Y1, X2, Y2.

Can you use the following in Excel to determine the lowest of values in cells? If no, re-write it to correct it. =LOWEST(A1; B1; C1; D1)

What function in Excel do you use to find the average of values in a cell range? Write the Excel function that gives you the average of values in cells D1, E1, D2, E2.

An emergency department nurse is administering a colloidal IV solution to a patient diagnosed with hypovolemia. Which solution, administered by the nurse, is considered a colloid solution?

Read the drug reference and determine the rate of administration for the IV push medications ordered. Order: 2100 Reglan 6 mg IVP now The rate of administration for the ordered dose is _____

A nurse is preparing to flush and lock a CVAD catheter after an intermittent infusion. A positive displacement needleless connector is attached to the midline catheter hub. Which of the following is the proper clamping sequence to use with a positive displacement connector?