When the formula bar is active, you can see

Question

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

Share this question with your friends

Show all Microsoft Excel MCQ

Comment

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

To create a formula, you first:

A. Select the cell you want to place the formula into

B. Type the equals sign (=) to tell Excel that youre about to enter a formula

C. Enter the formula using any input values and the appropriate mathematical operators that make up your formula

D. Choose the new command from the file menu

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

MS-EXCEL is based on .........?

A. WINDOWS

B. DOS

C. UNIX

D. OS/2

Discuss this answer

Data can be arranged in a worksheet in a easy to understand manner using

A. auto formatting

B. applying styles

C. changing fonts

D. all of 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

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 would you choose to create a bar diagram?

A. Edit, Chart

B. Insert, Chart

C. Tools, Chart

D. Format, Chart

Discuss this answer

Which menu option can be used to split windows into two?

A. Format -> Window

B. View -> Window-> Split

C. Window -> Split

D. View > Split

Discuss this answer

Which of the following methods cannot be used to enter data in a cell

A. Pressing an arrow key

B. Pressing the Tab key

C. Pressing the Esc key

D. Clicking on the formula bar

Discuss this answer

To view a cell comment

A. click the edit comment command on the insert menu

B. click the display comment command on the window menu

C. position the mouse pointer over the cell

D. click the comment command on the view menu

Discuss this answer

When you link data maintained in an excel workbook to a word document

A. The word document cannot be edit

B. The word document contains a reference to the original source application

C. The word document must contain a hyperlink

D. The word document contains a copy of the actual data

Discuss this answer

Hyperlinks can be

A. Text

B. Drawing objects

C. Pictures

D. All of above

Discuss this answer

B7:B9 indicates:

A. Cells B7 and cell B9 only

B. Cells B7 through B9

C. Cell B8 only

D. None of the above

Discuss this answer

A numeric value can be treated as a label value if it precedes with

A. Apostrophe (&lsquo

B. Exclamation (!)

C. Hash (#)

D. Ampersand (&

Discuss this answer

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

A. work sheet

B. chart sheet

C. module sheet

D. data sheet

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

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

The short cut key Ctrl + R is used in Excel to

A. Right align the content of cell

B. Remove the cell contents of selected cells

C. Fill the selection with active cells to the right

D. None 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

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

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

A. ( quote )

B. = ( equal )

C. _ ( underscore )

D. ( apostrophe )

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

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 Excel screen components can NOT be turned on or off?

A. Formula Bar

B. Status Bar

C. Tool Bar

D. None of above

Discuss this answer

Which setting you must modify to print a worksheet using letterhead?

A. Paper

B. Margin

C. Layout

D. Orientation

Discuss this answer

Which of the following options is not located in the Page Setup dialog box?

A. Page Break Preview

B. Page Orientation

C. Margins

D. Headers and Footers

Discuss this answer

To record a sequence of keystrokes and mouse actions to play back later we use:

A. Media player

B. Sound Recorder

C. Calculator

D. Macro Recorder

Discuss this answer

Accepted Answer

D. All of the above

When the formula bar is active, you can see

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

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

To create a formula, you first:

Multiple calculations can be made in a single formula using

MS-EXCEL is based on .........?

Data can be arranged in a worksheet in a easy to understand manner using

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

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

Which would you choose to create a bar diagram?

Which menu option can be used to split windows into two?

Which of the following methods cannot be used to enter data in a cell

To view a cell comment

When you link data maintained in an excel workbook to a word document

Hyperlinks can be

B7:B9 indicates:

A numeric value can be treated as a label value if it precedes with

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

The autofill feature

To delete an embedded objects, first

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

In Excel, a Data Series is defined as what?

The short cut key Ctrl + R is used in Excel to

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

Multiple calculations can be made in a single formula using .......

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

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

What does `COUNTA ()` function do?

Which of the following Excel screen components can NOT be turned on or off?

Which setting you must modify to print a worksheet using letterhead?

Which of the following options is not located in the Page Setup dialog box?

To record a sequence of keystrokes and mouse actions to play back later we use:

Also checkout

When the formula bar is active, you can see

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

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

To create a formula, you first:

Multiple calculations can be made in a single formula using

MS-EXCEL is based on .........?

Data can be arranged in a worksheet in a easy to understand manner using

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

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

Which would you choose to create a bar diagram?

Which menu option can be used to split windows into two?

Which of the following methods cannot be used to enter data in a cell

To view a cell comment

When you link data maintained in an excel workbook to a word document

Hyperlinks can be

B7:B9 indicates:

A numeric value can be treated as a label value if it precedes with

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

The autofill feature

To delete an embedded objects, first

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

In Excel, a Data Series is defined as what?

The short cut key Ctrl + R is used in Excel to

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

Multiple calculations can be made in a single formula using .......

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

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

What does COUNTA () function do?

Which of the following Excel screen components can NOT be turned on or off?

Which setting you must modify to print a worksheet using letterhead?

Which of the following options is not located in the Page Setup dialog box?

To record a sequence of keystrokes and mouse actions to play back later we use:

Also checkout

What does `COUNTA ()` function do?