$1.$ Which function in Excel is used to find the highest value in a range?

a$)$ MAX

b$)$ MIN

c$)$ AVG

d$)$ SUM

$2.$ What does the formula $"=$A$1+$B$1"$ do in Excel?

a$)$ Multiplies the values in cells A$1$ and B$1$

b$)$ Adds the values in cells A$1$ and B$1$

c$)$ Subtracts the value in cell B$1$ from A$1$

d$)$ Divides the value in cell A$1$ by B$1$

$3.$ Which symbol is used to denote an absolute cell reference in Excel?

a$)$ $

b$)\%$

c$)$ #

d$)$ &

$4.$ What function in Excel is used to count the number of cells that contain numerical data within a specified range?

a$)$ COUNT

b$)$ SUM

c$)$ AVERAGE

d$)$ MAX

$5.$ Which Excel feature allows you to apply a predefined format to a cell or range with one click?

a$)$ AutoFormat

b$)$ Conditional Formatting

c$)$ AutoSum

d$)$ AutoFill