You can use the formula palette to

Question

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

Share this question with your friends

Show all Microsoft Excel MCQ

Comment

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

Each excel file is called a workbook because

A. It can contain text and data

B. It can be modified

C. It can contain many sheets including worksheets and chart sheets

D. You have to work hard to create it

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

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

A. Press Ctrl +Home

B. Press Home

C. Press Shift + Home

D. Press Alt + Home

Discuss this answer

Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

A. Logical

B. Math & Trigonometry

C. Statistical

D. Financial

Discuss this answer

A typical worksheet has …. Number of columns

A. 128

B. 256

C. 512

D. 1024

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

How do you rearrange the data in ascending or descending order?

A. Data, Sort

B. Data, Form

C. Data, Table

D. Data Subtotals

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

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

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

A worksheet range is a

A. A command used for data modeling

B. A range of values such as from 23 to 234

C. A group of cells

D. A group of worksheets

Discuss this answer

The command Edit >> Fill Across Worksheet is active only when

A. One sheet is selected

B. When many sheets are selected

C. When no sheet is selected

D. None of above

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

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

A. Add

B. Subtract

C. Divide

D. SQRT

Discuss this answer

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

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

You can move a sheet from one workbook into new book by

A. From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK

B. From Edit menu choose Move of Copy then choose (Move to end) and click OK

C. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK

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

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

The Name box on to the left of formula bar

A. shows the name of workbook currently working on

B. shows the name of worksheet currently working on

C. shows the name of cell or range currently working on

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

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

In a worksheet you can select

A. The entire worksheet

B. Rows

C. Columns

D. All of the above

Discuss this answer

The Paste Special command lets you copy and paste:

A. Multiply the selection by a copied value

B. Cell comments

C. Formatting options

D. The resulting values of a formula instead of the actual formula

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

Which would you choose to create a bar diagram?

A. Edit, Chart

B. Insert, Chart

C. Tools, Chart

D. Format, Chart

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

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 update the values of formula cells if Auto Calculate mode of Excel is disabled?

A. F8

B. F9

C. F10

D. F11

Discuss this answer

Accepted Answer

B. Create and edit formulas containing functions

You can use the formula palette to

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

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

Each excel file is called a workbook because

What does `COUNTA ()` function do?

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

A typical worksheet has …. Number of columns

To delete an embedded objects, first

How do you rearrange the data in ascending or descending order?

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

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

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

A worksheet range is a

The command Edit >> Fill Across Worksheet is active only when

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

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

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

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

You can move a sheet from one workbook into new book by

Which of the following is an absolute cell reference?

Text formulas:

The Name box on to the left of formula bar

You can use the drag and drop method to

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

In a worksheet you can select

The Paste Special command lets you copy and paste:

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

Which would you choose to create a bar diagram?

Excel uniquely identifies cells within a worksheet with a cell name

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 update the values of formula cells if Auto Calculate mode of Excel is disabled?

Also checkout

You can use the formula palette to

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

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

Each excel file is called a workbook because

What does COUNTA () function do?

Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?

Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?

A typical worksheet has …. Number of columns

To delete an embedded objects, first

How do you rearrange the data in ascending or descending order?

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

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

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

A worksheet range is a

The command Edit >> Fill Across Worksheet is active only when

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

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

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

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

You can move a sheet from one workbook into new book by

Which of the following is an absolute cell reference?

Text formulas:

The Name box on to the left of formula bar

You can use the drag and drop method to

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

In a worksheet you can select

The Paste Special command lets you copy and paste:

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

Which would you choose to create a bar diagram?

Excel uniquely identifies cells within a worksheet with a cell name

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 update the values of formula cells if Auto Calculate mode of Excel is disabled?

Also checkout

What does `COUNTA ()` function do?