The Delete key of keyboard is assigned to which command in Excel?

Question

The Delete key of keyboard is assigned to which command in Excel?

A. Edit >> Clear >> Contents

B. Edit >> Clear >> All

C. Edit >> Delete

D. All of above

Share this question with your friends

Show all Microsoft Excel MCQ

Comment

A circular reference is

A. Geometric modeling tool

B. A cell that points to a drawing object

C. A formula that either directly or indirectly depends on itself

D. Always erroneous

Discuss this answer

You can use the format painter multiple times before you turn it off by

A. You can use the format painter button on ly one time when you click it

B. Double clicking the format painter button

C. Pressing the Ctrl key and clicking the format painter button

D. Pressing the Alt key and clicking the format painter button

Discuss this answer

Which of the cell pointer indicates you that you can make selection?

A. Doctors symbol (Big Plus)

B. small thin plus icon

C. Mouse Pointer with anchor at the tip

D. None of above

Discuss this answer

What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

A. XY Chart

B. Line Chart

C. Pie Chart

D. Column Chart

Discuss this answer

A worksheet can have a maximum of …. Number of rows

A. 256

B. 1024

C. 32000

D. 65535

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 of the following is an absolute cell reference?

A. !A!1

B. $A$1

C. #a#1

D. A1

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

In Excel, a Data Series is defined as what?

A. A type of chart

B. A cell reference

C. A collection of related data

D. A division of results

Discuss this answer

Text formulas:

A. Replace cell references

B. Return ASCII values of characters

C. Concatenate and manipulate text

D. Show formula error value

Discuss this answer

Which Chart can be created in Excel?

A. Area

B. Line

C. Pie

D. All of the above

Discuss this answer

How many worksheets can a workbook have?

A. 3

B. 8

C. 255

D. none of above

Discuss this answer

Which elements of a worksheet can be protected from accidental modification?

A. Contents

B. Objects

C. Scenarios

D. All of the above

Discuss this answer

To edit in an embedded excel worksheet object in a word document

A. Use the excel menu bar and toolbars inside the word application

B. Edit the hyperlink

C. Edit the data in a excel source application

D. Use the word menu bar and toolbars

Discuss this answer

Which of the cell pointer indicates that you can fill series?

A. Doctors symbol (Big Plus)

B. small thin plus icon

C. Mouse Pointer with anchor at the tip

D. None of above

Discuss this answer

What does `COUNTA ()` function do?

A. counts cells having alphabets

B. counts empty cells

C. counts cells having number

D. counts non-empty cells

Discuss this answer

Which of the following is not true regarding Conditional Formatting?

A. You can add more than one condition to check

B. You can set condition to look for Bold and apply Italics on them

C. You can apply Font, border and pattern formats that meets the specified conditions

D. You can delete any condition from Conditional Formatting dialog box if it is not requried

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

You can use the formula pallette to

A. format cells containing numbers

B. create and edit formula containing functions

C. enter assumptions data

D. copy a range of cells

Discuss this answer

You can use the horizontal and vertical scroll bars to

A. Split a worksheet into two panes

B. View different rows and columns edit the contents of a cell

C. Edit the contents of a cell

D. view different worksheets

Discuss this answer

Which function is not available in the Consolidate dialog box?

A. Pmt

B. Average

C. Max

D. Sum

Discuss this answer

The active cell:

A. is defined by a bold border around the cell

B. Receives the data the user enters

C. It is the formula bar

D. Only A and B

Discuss this answer

Which of following is Not one of Excels what-if function?

A. Goal seek

B. Solver

C. Scenario manager

D. Auto Outline

Discuss this answer

Multiple calculations can be made in a single formula using

A. standard formulas

B. array formula

C. complex formulas

D. smart formula

Discuss this answer

A __________ is a grid with labeled columns and rows.

A. Dialog box

B. Worksheet

C. Clipboard

D. Toolbar

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

Files created with Lotus 1-2-3 have an extension

A. DOC

B. XLS

C. 123

D. WK1

Discuss this answer

To delete an embedded objects, first

A. Double click the object

B. Select the object by clicking it

C. Press the Shift + Delete keys

D. Select it and then press the delete key

Discuss this answer

Which is used to perform what if analysis?

A. Solver

B. Goal seek

C. Scenario Manager

D. All of above

Discuss this answer

When a label is too long to fit within a worksheet cell, you typically must

A. Shorten the label

B. Increase the column width

C. Decrease the column width

D. Adjust the row height

Discuss this answer

Accepted Answer

A. Edit >> Clear >> Contents

The Delete key of keyboard is assigned to which command in Excel?

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

A circular reference is

You can use the format painter multiple times before you turn it off by

Which of the cell pointer indicates you that you can make selection?

What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

A worksheet can have a maximum of …. Number of rows

In a worksheet you can select

Which of the following is an absolute cell reference?

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

In Excel, a Data Series is defined as what?

Text formulas:

Which Chart can be created in Excel?

How many worksheets can a workbook have?

Which elements of a worksheet can be protected from accidental modification?

To edit in an embedded excel worksheet object in a word document

Which of the cell pointer indicates that you can fill series?

What does `COUNTA ()` function do?

Which of the following is not true regarding Conditional Formatting?

The autofill feature

You can use the formula pallette to

You can use the horizontal and vertical scroll bars to

Which function is not available in the Consolidate dialog box?

The active cell:

Which of following is Not one of Excels what-if function?

Multiple calculations can be made in a single formula using

A __________ is a grid with labeled columns and rows.

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

Files created with Lotus 1-2-3 have an extension

To delete an embedded objects, first

Which is used to perform what if analysis?

When a label is too long to fit within a worksheet cell, you typically must

Also checkout

The Delete key of keyboard is assigned to which command in Excel?

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

A circular reference is

You can use the format painter multiple times before you turn it off by

Which of the cell pointer indicates you that you can make selection?

What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

A worksheet can have a maximum of …. Number of rows

In a worksheet you can select

Which of the following is an absolute cell reference?

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

In Excel, a Data Series is defined as what?

Text formulas:

Which Chart can be created in Excel?

How many worksheets can a workbook have?

Which elements of a worksheet can be protected from accidental modification?

To edit in an embedded excel worksheet object in a word document

Which of the cell pointer indicates that you can fill series?

What does COUNTA () function do?

Which of the following is not true regarding Conditional Formatting?

The autofill feature

You can use the formula pallette to

You can use the horizontal and vertical scroll bars to

Which function is not available in the Consolidate dialog box?

The active cell:

Which of following is Not one of Excels what-if function?

Multiple calculations can be made in a single formula using

A __________ is a grid with labeled columns and rows.

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

Files created with Lotus 1-2-3 have an extension

To delete an embedded objects, first

Which is used to perform what if analysis?

When a label is too long to fit within a worksheet cell, you typically must

Also checkout

What does `COUNTA ()` function do?