Comments put in cells are called .....

Question

Comments put in cells are called .....

A. Smart Tip

B. Cell Tip

C. Web Tip

D. Soft Tip

Share this question with your friends

Show all Microsoft Excel MCQ

Comment

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 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

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

The Chart wizard term data categories refers to;

A. A chart plot area

B. A horizontal axis

C. The organization of individual values with a charts data series

D. The data range that supply chart data

Discuss this answer

Long text can be broken down into many lines within a cell. You can do this through

A. Wrap Text in Format >> Cells

B. Justify in Edit >> Cells

C. Text Wraping in Format >> Cells, Layout tab

D. All of above

Discuss this answer

You can use the drag and drop method to

A. Copy cell contents

B. Move cell contents

C. Add cell contents

D. a and b

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 Tool Bar

Discuss this answer

You can copy data or formulas

A. With the copy, paste and cut commands on the edit menu

B. With commands on the shortcut menu

C. With buttons on the standard toolbars

D. All of the above

Discuss this answer

When the formula bar is active, you can see

A. The edit formula button

B. The cancel button

C. The enter button

D. All of the above

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

Which symbol must all formula begin with?

A. =

B. +

C. (

D. @

Discuss this answer

Which is not the function of Edit, Clear command?

A. Delete contents

B. Delete notes

C. Delete cells

D. Delete formats

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

How do you display current date and time in MS Excel?

A. date ()

B. Today ()

C. now ()

D. time ()

Discuss this answer

You can use the formula palette to

A. Format cells containing numbers

B. Create and edit formulas containing functions

C. Enter assumptions data

D. Copy a range of cells

Discuss this answer

Getting data from a cell located in a different sheet is called ......

A. Accessing

B. Referencing

C. Updating

D. Functioning

Discuss this answer

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

A. An absolute cell address is created

B. Cell address will change when it is copied to another cell

C. The sheet tab is changed

D. The status bar does not display the cell address

Discuss this answer

We can save and protect the workbook by

A. Write Reservation Password

B. Protection Password

C. Read-only Recommended

D. Any of the above

Discuss this answer

To center worksheet titles across a range of cells, you must

A. Select the cells containing the title text plus the range over which the title text is to be centered

B. Widen the columns

C. Select the cells containing the title text plus the range over which the title text is to be enfettered

D. Format the cells with the comma style

Discuss this answer

Excel files have a default extension of

A. Xls

B. Xlw

C. Wk1

D. 123

Discuss this answer

How do you insert a row?

A. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu

B. Select the row heading where you want to insert the new row and select Edit >Row from the menu

C. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar

D. All of the above

Discuss this answer

You can enter which types of data into worksheet cells?

A. Labels, values, and formulas

B. Labels and values but not formulas

C. Values and formulas but not labels

D. Formulas only

Discuss this answer

What symbol is used before a number to make it a label?

A. ( quote )

B. = ( equal )

C. _ ( underscore )

D. ( apostrophe )

Discuss this answer

Which of the following is invalid statement?

A. Sheet tabs can be colored

B. Some picture can be applied as a background of a sheet

C. You can set the column width automatically fit the amount of text

D. The width of a row and be specified manually or fit automatically

Discuss this answer

To return the remainder after a number is divided by a divisor in EXCEL we use the function?

A. ROUND ( )

B. FACT ( )

C. MOD ( )

D. DIV ( )

Discuss this answer

How do you wrap the text in a cell?

A. Format, cells, font

B. Format, cells, protection

C. Format, cells, number

D. Format, cells, alignment

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

What is the short cut key to replace a data with another in sheet?

A. Ctrl + R

B. Ctrl + Shift + R

C. Ctrl + H

D. Ctrl + F

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

Which of the following option is not available in Paste Special dialog box?

A. Add

B. Subtract

C. Divide

D. SQRT

Discuss this answer

Accepted Answer

B. Cell Tip

Comments put in cells are called .....

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

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

To save a workbook, you:

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

The Chart wizard term data categories refers to;

Long text can be broken down into many lines within a cell. You can do this through

You can use the drag and drop method to

Which area in an Excel window allows entering values and formulas?

You can copy data or formulas

When the formula bar is active, you can see

Which of the following is not true regarding Conditional Formatting?

Which symbol must all formula begin with?

Which is not the function of Edit, Clear command?

What does `COUNTA ()` function do?

How do you display current date and time in MS Excel?

You can use the formula palette to

Getting data from a cell located in a different sheet is called ......

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

We can save and protect the workbook by

To center worksheet titles across a range of cells, you must

Excel files have a default extension of

How do you insert a row?

You can enter which types of data into worksheet cells?

What symbol is used before a number to make it a label?

Which of the following is invalid statement?

To return the remainder after a number is divided by a divisor in EXCEL we use the function?

How do you wrap the text in a cell?

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

What is the short cut key to replace a data with another in sheet?

Which is used to perform what if analysis?

Which of the following option is not available in Paste Special dialog box?

Also checkout

Comments put in cells are called .....

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

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

To save a workbook, you:

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

The Chart wizard term data categories refers to;

Long text can be broken down into many lines within a cell. You can do this through

You can use the drag and drop method to

Which area in an Excel window allows entering values and formulas?

You can copy data or formulas

When the formula bar is active, you can see

Which of the following is not true regarding Conditional Formatting?

Which symbol must all formula begin with?

Which is not the function of Edit, Clear command?

What does COUNTA () function do?

How do you display current date and time in MS Excel?

You can use the formula palette to

Getting data from a cell located in a different sheet is called ......

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

We can save and protect the workbook by

To center worksheet titles across a range of cells, you must

Excel files have a default extension of

How do you insert a row?

You can enter which types of data into worksheet cells?

What symbol is used before a number to make it a label?

Which of the following is invalid statement?

To return the remainder after a number is divided by a divisor in EXCEL we use the function?

How do you wrap the text in a cell?

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

What is the short cut key to replace a data with another in sheet?

Which is used to perform what if analysis?

Which of the following option is not available in Paste Special dialog box?

Also checkout

What does `COUNTA ()` function do?