What are the basic rectangular building blocks of a spreadsheet?

a$.$

Zoom slider

b$.$

All of these

c$.$

Help button

d$.$

Cell

Question $17$

Not yet answered

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

Not flaggedFlag question

Question text

What does COUNTA $()$ function do$?$

a$.$

Counts non$-$empty cells

b$.$

Counts cells having alphabets

c$.$

Counts empty cells

d$.$

Counts cells having number

Question $18$

Not yet answered

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

Not flaggedFlag question

Question text

What happens when dollar signs $($$$)$ are entered in a cell address? $($e$B$$2$:$B$$10)$

a$.$

A fixed cell$/$range address is created

b$.$

The sheet tab is changed

c$.$

Cell address will change when it is copied to another cell

d$.$

The status bar does not display the cell address

Question $19$

Not yet answered

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

Not flaggedFlag question

Question text

What is the correct way to refer the cell A$10$ on sheet$3$ from sheet$1?$

a$.$

Sheet$1!$A$10$

b$.$

Sheet$3!$A$10$

c$.$

A$10$

d$.$

Sheet$3.$A$10$

Question $20$

Not yet answered

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

Not flaggedFlag question

Question text

What is the short cut to highlight the entire column?

a$.$

Ctrl$+$Page Up

b$.$

Ctrl$+$C

c$.$

Ctrl$+$Enter

d$.$

Ctrl$+$Space Bar

only answers please