What does `COUNTA ()` function do?

Question

What does `COUNTA ()` function do?

A. counts cells having alphabets

B. counts empty cells

C. counts cells having number

D. counts non-empty cells

Share this question with your friends

Show all Microsoft Excel MCQ

Comment

What do you mean by a Workspace?

A. Group of Columns

B. Group of Worksheets

C. Group of Rows

D. Group of Workbooks

Discuss this answer

Which key do you press to check spelling?

A. F3

B. F5

C. F7

D. F9

Discuss this answer

The first cell in EXCEL worksheet is labeled as

A. AA

B. A1

C. Aa

D. A0

Discuss this answer

You can use drag-and-drop to embed excel worksheet data in a word document

A. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

B. By dragging a range of excel data to the word button on the taskbar while pressing Shift key

C. By dragging a range of excel data to the word button on the taskbar while pressing Alt key

D. None of above

Discuss this answer

What is represented by the small, black square in the lower-right corner of an active cell or range?

A. Copy handle

B. Fill handle

C. Insert handle

D. Border

Discuss this answer

When you insert an excel file into a word document. The data are

A. Hyperlinked placed in a word table

B. Linked

C. Embedded

D. Use the word menu bar and toolbars

Discuss this answer

To copy formatting from one area in a worksheet and apply it to another area you would use:

A. The Edit > Copy Format and Edit>Paste Format commands form the menu

B. The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu

C. There is no way to copy and apply formatting in Excel You have to do it manually

D. The Format Painter button on the standard toolbar

Discuss this answer

Which of the following formulas will Excel Not be able to calculate?

A. =SUM(Sales)-A3

B. =SUM(A1:A5)*.5

C. =SUM(A1:A5)/(10-10)

D. =SUM(A1:A5)-10

Discuss this answer

The autofill feature

A. extends a sequential series of data

B. automatically adds range of cell values

C. applies a boarder around the selected cells

D. none of the above

Discuss this answer

To save a workbook, you:

A. Click the save button on the standard toolbar from the menu

B. Press Ctrl+F5

C. Click Save on the Windows Start button

D. Select Edit>Save

Discuss this answer

Excel probably considers the cell entry January 1, 2000 to be a

A. Label

B. Value

C. Formula

D. Text string

Discuss this answer

It is acceptable to let long text flow into adjacent cells on a worksheet when

A. Data will be entered in the adjacent cells

B. No data will be entered in the adjacent cells

C. There is no suitable abbreviation of the text

D. There is not time to format the next

Discuss this answer

Which of the following is a correct order of precedence in formula calculation?

A. Multiplication and division exponentiation positive and negative values

B. Multiplication and division, positive and negative values, addition and subtraction

C. Addition and subtraction, positive and negative values, exponentiation

D. All of above

Discuss this answer

Excel uniquely identifies cells within a worksheet with a cell name

A. Cell names

B. Column numbers and row letters

C. Column letters and row numbers

D. Cell locator coordinates

Discuss this answer

Which would you choose to create a bar diagram?

A. Edit, Chart

B. Insert, Chart

C. Tools, Chart

D. Format, Chart

Discuss this answer

Which of the following format you can decide to apply or not in AutoFormat dialog box?

A. Number format

B. Border format

C. Font format

D. All of above

Discuss this answer

In a worksheet you can select

A. The entire worksheet

B. Rows

C. Columns

D. All of the above

Discuss this answer

Which area in an excel window allows entering values and formulas

A. Title bar

B. Menu bar

C. Formula bar

D. Standard toolbar

Discuss this answer

To create a formula, you can use:

A. Values but not cell references

B. Cell references but not values

C. Values or cell references although not both at the same time

D. Value and cell references

Discuss this answer

Excel files have a default extension of

A. Xls

B. Xlw

C. Wk1

D. 123

Discuss this answer

Status indicators are located on the

A. Vertical scroll bar

B. Horizontal scroll bar

C. Formula bar

D. Standard toolbar

Discuss this answer

Excel displays the current cell address in the ........

A. Formula bar

B. Status Bar

C. Name Box

D. Title Bar

Discuss this answer

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

A. Square

B. Percentage

C. Goal Seek

D. Divide

Discuss this answer

In the formula, which symbol specifies the fixed columns or rows?

A. $

B. *

C. %

D. &

Discuss this answer

Edit >> Delete command

A. Deletes the content of a cell

B. Deletes Formats of cell

C. Deletes the comment of cell

D. Deletes selected cells

Discuss this answer

How many worksheets can a workbook have?

A. 3

B. 8

C. 255

D. none of above

Discuss this answer

When a range is selected, how can you activate the previous cell?

A. Press the Alt key

B. Press Tab

C. Press Enter

D. None of above

Discuss this answer

Which Chart can be created in Excel?

A. Area

B. Line

C. Pie

D. All of the above

Discuss this answer

Hyperlinks can be

A. Text

B. Drawing objects

C. Pictures

D. All of above

Discuss this answer

An Excel Workbook is a collection of .......

A. Workbooks

B. Worksheets

C. Charts

D. Worksheets and Charts

Discuss this answer

Accepted Answer

D. counts non-empty cells

What does `COUNTA ()` function do?

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

What do you mean by a Workspace?

Which key do you press to check spelling?

The first cell in EXCEL worksheet is labeled as

You can use drag-and-drop to embed excel worksheet data in a word document

What is represented by the small, black square in the lower-right corner of an active cell or range?

When you insert an excel file into a word document. The data are

To copy formatting from one area in a worksheet and apply it to another area you would use:

Which of the following formulas will Excel Not be able to calculate?

The autofill feature

To save a workbook, you:

Excel probably considers the cell entry January 1, 2000 to be a

It is acceptable to let long text flow into adjacent cells on a worksheet when

Which of the following is a correct order of precedence in formula calculation?

Excel uniquely identifies cells within a worksheet with a cell name

Which would you choose to create a bar diagram?

Which of the following format you can decide to apply or not in AutoFormat dialog box?

In a worksheet you can select

Which area in an excel window allows entering values and formulas

To create a formula, you can use:

Excel files have a default extension of

Status indicators are located on the

Excel displays the current cell address in the ........

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

In the formula, which symbol specifies the fixed columns or rows?

Edit >> Delete command

How many worksheets can a workbook have?

When a range is selected, how can you activate the previous cell?

Which Chart can be created in Excel?

Hyperlinks can be

An Excel Workbook is a collection of .......

Also checkout

What does COUNTA () function do?

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

What do you mean by a Workspace?

Which key do you press to check spelling?

The first cell in EXCEL worksheet is labeled as

You can use drag-and-drop to embed excel worksheet data in a word document

What is represented by the small, black square in the lower-right corner of an active cell or range?

When you insert an excel file into a word document. The data are

To copy formatting from one area in a worksheet and apply it to another area you would use:

Which of the following formulas will Excel Not be able to calculate?

The autofill feature

To save a workbook, you:

Excel probably considers the cell entry January 1, 2000 to be a

It is acceptable to let long text flow into adjacent cells on a worksheet when

Which of the following is a correct order of precedence in formula calculation?

Excel uniquely identifies cells within a worksheet with a cell name

Which would you choose to create a bar diagram?

Which of the following format you can decide to apply or not in AutoFormat dialog box?

In a worksheet you can select

Which area in an excel window allows entering values and formulas

To create a formula, you can use:

Excel files have a default extension of

Status indicators are located on the

Excel displays the current cell address in the ........

Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?

In the formula, which symbol specifies the fixed columns or rows?

Edit >> Delete command

How many worksheets can a workbook have?

When a range is selected, how can you activate the previous cell?

Which Chart can be created in Excel?

Hyperlinks can be

An Excel Workbook is a collection of .......

Also checkout

What does `COUNTA ()` function do?