The shortcut key Ctrl $+$ R is used in Excel to

a$.$

Right align the content of cell

b$.$

Fill the selection with active cells to the right

c$.$

None of above

d$.$

Remove the cell contents of selected cells

Question $47$

Not yet answered

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

Not flaggedFlag question

Question text

The tool called "Remove Duplicates":

a$.$

Is no longer available in excel $2016$

b$.$

Centers data

c$.$

None of the above

d$.$

Can be found under the Data menu

Question $48$

Not yet answered

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

Not flaggedFlag question

Question text

VLOOKUP$()$:

a$.$

Cannot be combined with any other formula

b$.$

Is no longer in excel

c$.$

Use to cross$-$reference different datasets

d$.$

Is the best tool to find averages

Question $49$

Not yet answered

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

Not flaggedFlag question

Question text

What does the ZERO stands for in VLOOKUP?

a$.$

FALSE

b$.$

All of the above

c$.$

TRUE

d$.$

None

Question $50$

Not yet answered

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

Not flaggedFlag question

Question text

Where can you set the shading color for a range of cells in Excel?

a$.$

All of above

b$.$

Choose required color on Fill Color tool in Drawing toolbar

c$.$

Choose required color form Patterns tab of Format Cells dialog box

d$.$

Choose required color on Fill Color tool in Formatting toolbar