What is the shortcut key to replace a data with another in sheet?

a$.$

Ctrl $+$ Shift $+$ R

b$.$

Ctrl $+$ H

c$.$

Ctrl $+$ F

d$.$

Ctrl $+$ R

Question $22$

Not yet answered

Marked out of $2\mathrm{.}00$

Not flaggedFlag question

Question text

What will be the value of the following formula?$=$average$(5,4,4,3,6)$

a$.$

N$/$A

b$.$

$5$

c$.$

$4\mathrm{.}4$

d$.$

$3\mathrm{.}72$

Question $23$

Not yet answered

Marked out of $2\mathrm{.}00$

Not flaggedFlag question

Question text

Which command is used to close the window of Excel?

a$.$

Ctrl $+$R

b$.$

Ctrl$+$ C

c$.$

Alt$+$ F$4$

d$.$

Ctrl $+$ W

Question $24$

Not yet answered

Marked out of $2\mathrm{.}00$

Not flaggedFlag question

Question text

Which command will you choose to convert a column of data into row?

a$.$

Both of above

b$.$

None of above

c$.$

Paste Special $>$ Transpose

d$.$

Cut and Paste

Question $25$

Not yet answered

Marked out of $2\mathrm{.}00$

Not flaggedFlag question

Question text

Which function is not available in the Consolidate dialog box?

a$.$

Max

b$.$

Average

c$.$

Pmt

d$.$

Sum