Placement Exam: Microsoft Excel $2019($ITM $105)-$

sim$5.$pegasus.pearsoncmg.com$/$SIM$5$Services$/$SIM$5$Frame.aspx?resLinkID$=4000002687968740$&resultID$=$&nonce$=142$f$2942-293$a$-477$c$-80$b$3-9$f$419$c$1$bdbac&launchCode$=$qe&

Rounds a number to a specified number of digits.

Identifies the highest value in a range.

Identifies the midpoint value in a set of values.

Tallies the number of cells in a range that contain values.

Contains both an absolute and a relative cell reference in a formula; the absolute part does not change but the relative part does when you copy the formula.

Displays the current date and time.

a Syntax

b TODAY function

C Absolute cell reference

Argument

MAX function

COUNT function

$5\mathrm{.}00$ Points: exp$2019\_$xl$\_$matching$2\mathrm{.}01$: Match the key terms with their definitions.