Which of the following is not the correct method of editing the cell content?

a$.$

Press the Alt key

b$.$

Press the F$2$ key

c$.$

Click the formula bar

d$.$

Double click the cell

Question $42$

Not yet answered

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

Not flaggedFlag question

Question text

Tab scroll buttons are place on Excel screen

a$.$

Towards the top left corner

b$.$

Towards the bottom right corner

c$.$

Towards the top right corner

d$.$

Towards the bottom left corner

Question $43$

Not yet answered

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

Not flaggedFlag question

Question text

If you have a list of numbers in cells B$2$ through B$20$ and you wanted the average of these numbers, what would be the formula?

a$.$

SUMIF$()$

b$.$

AVERAGE$($B$2$:B$20)$

c$.$

AVERAGEIF$($B$2$:B$20)$

d$.$

VLOOKUP$(($B$2$:B$20),$RANGE,$1,0)$

Question $44$

Not yet answered

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

Not flaggedFlag question

Question text

Merge & Centre can be found under:

a$.$

SUMIF$()$

b$.$

VLOOKUP$()$

c$.$

Alignment

d$.$

Formating

Question $45$

Not yet answered

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

Not flaggedFlag question

Question text

SUMIF$()$:

a$.$

Keeps cell formats standardized for all reports

b$.$

Allows users to SUM data based on defined filters

c$.$

Allows users to SUM multiple data sources at the same time

d$.$

Combines VLOOKUP$()$ with Formatting