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

Question

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

A. Goal seek

B. Solver

C. Scenario manager

D. Auto Outline

Share this question with your friends

Show all Microsoft Excel MCQ

Comment

Which of the following is not a worksheet design criterion?

A. Efficiency

B. Aditibility

C. Description

D. Clarity

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

What will be the output if you format the cell containing 5436.8 as #,##0.00'?

A. 5430

B. 5436.80

C. 5436.8

D. 6.8

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

The auto calculate feature

A. Can only add values in a range of cells

B. Provides a quick way to view the result of an arithmetic operation on a range of cells

C. Automatically creates formulas and adds them to a worksheet

D. A and c

Discuss this answer

Which of the following series type is not valid for Fill Series dialog box?

A. Linear

B. Growth

C. Autofill

D. Time

Discuss this answer

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

A. From Edit menu choose Clear and then Formats

B. From Edit menu choose Delete

C. Click on Remove Formatting tool on Standard Toolbar

D. Double click the Format Painter and then press Esc key in keyboard

Discuss this answer

You can check the conditions against __________ when applying conditional formatting

A. Cell value

B. Formula

C. Both of above

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

Which would you choose to create a bar diagram?

A. Edit, Chart

B. Insert, Chart

C. Tools, Chart

D. Format, Chart

Discuss this answer

You can edit a cell by

A. Clicking the formula button

B. Double clicking the cell to edit it in-place

C. Selecting Edit>Edit Cell from the menu

D. None of above

Discuss this answer

If you begin typing an entry into a cell and then realize that you dont want your entry placed into a cell, you:

A. Press the Erase key

B. Press Esc

C. Press the Enter button

D. Press the Edit Formula button

Discuss this answer

Which elements of worksheet can be protected from accidental modification

A. Contents

B. Objects

C. Scenarios

D. All of above

Discuss this answer

Which function is not available in the Consolidate dialog box?

A. Pmt

B. Average

C. Max

D. Sum

Discuss this answer

Which of the following is not an example of a value?

A. 350

B. May 10, 2001

C. 0.57

D. Serial Number 50771

Discuss this answer

The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

A. None of these

B. Select Format > Money from the menu

C. Click the Currency Style button on the formatting toolbar

D. You have to retype everything and manually add the dollar signs, commas, and decimals

Discuss this answer

How can you show or hide the gridlines in Excel Worksheet?

A. Go to Tools >> Options >> View tab and mark or remove the check box named Gridline

B. Click Gridline tool on Forms toolbar

C. Both of above

D. None of above

Discuss this answer

Concatenation of text can be done using

A. Apostrophe (&lsquo

B. Exclamation (!)

C. Hash (#)

D. Ampersand (&

Discuss this answer

Which language is used to create macros in Excel?

A. Visual Basic

B. C

C. Visual C++

D. Java

Discuss this answer

You can activate a cell by

A. Pressing the Tab key

B. Clicking the cell

C. Pressing an arrow key

D. All of the above

Discuss this answer

Which of the following is not a basic step in creating a worksheet?

A. Save workbook

B. Modifiy the worksheet

C. Enter text and data

D. Copy the worksheet

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

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

A. Paper

B. Margin

C. Layout

D. Orientation

Discuss this answer

To activate the previous cell in a pre-selected range, press

A. The Alt key

B. The Tab key

C. The Enter key

D. None of the above

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

The spelling dialog box can be involved by choosing spelling from ________ menu.

A. insert

B. file

C. tools

D. view

Discuss this answer

In help menu of Excel, which of the following tabs are found?

A. Contents tab

B. Answer Wizard tab

C. Index tab

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

Tab scroll buttons are place on Excel screen

A. towards the bottom right corner

B. towards the bottom left corner

C. towards the top right corner

D. towards the top left corner

Discuss this answer

Which key do you press to check spelling?

A. F3

B. F5

C. F7

D. F9

Discuss this answer

Accepted Answer

D. Auto Outline

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

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

Which of the following is not a worksheet design criterion?

What does `COUNTA ()` function do?

What will be the output if you format the cell containing 5436.8 as #,##0.00'?

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

The auto calculate feature

Which of the following series type is not valid for Fill Series dialog box?

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

You can check the conditions against __________ when applying conditional formatting

Which area in an excel window allows entering values and formulas

Which would you choose to create a bar diagram?

You can edit a cell by

If you begin typing an entry into a cell and then realize that you dont want your entry placed into a cell, you:

Which elements of worksheet can be protected from accidental modification

Which function is not available in the Consolidate dialog box?

Which of the following is not an example of a value?

The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

How can you show or hide the gridlines in Excel Worksheet?

Concatenation of text can be done using

Which language is used to create macros in Excel?

You can activate a cell by

Which of the following is not a basic step in creating a worksheet?

Edit >> Delete command

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

To activate the previous cell in a pre-selected range, press

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

The spelling dialog box can be involved by choosing spelling from ________ menu.

In help menu of Excel, which of the following tabs are found?

Excel uniquely identifies cells within a worksheet with a cell name

Tab scroll buttons are place on Excel screen

Which key do you press to check spelling?

Also checkout

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

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

Which of the following is not a worksheet design criterion?

What does COUNTA () function do?

What will be the output if you format the cell containing 5436.8 as #,##0.00'?

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

The auto calculate feature

Which of the following series type is not valid for Fill Series dialog box?

If you need to remove only the formatting done in a range (numbers and formula typed there should not be removed), you must

You can check the conditions against __________ when applying conditional formatting

Which area in an excel window allows entering values and formulas

Which would you choose to create a bar diagram?

You can edit a cell by

If you begin typing an entry into a cell and then realize that you dont want your entry placed into a cell, you:

Which elements of worksheet can be protected from accidental modification

Which function is not available in the Consolidate dialog box?

Which of the following is not an example of a value?

The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

How can you show or hide the gridlines in Excel Worksheet?

Concatenation of text can be done using

Which language is used to create macros in Excel?

You can activate a cell by

Which of the following is not a basic step in creating a worksheet?

Edit >> Delete command

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

To activate the previous cell in a pre-selected range, press

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

The spelling dialog box can be involved by choosing spelling from ________ menu.

In help menu of Excel, which of the following tabs are found?

Excel uniquely identifies cells within a worksheet with a cell name

Tab scroll buttons are place on Excel screen

Which key do you press to check spelling?

Also checkout

What does `COUNTA ()` function do?