To create a formula, you can use:

Question

To create a formula, you can use:

A. Values but not cell references

B. Cell references but not values

C. Values or cell references although not both at the same time

D. Value and cell references

Share this question with your friends

Show all Microsoft Excel MCQ

Comment

Which symbol must all formula begin with?

A. =

B. +

C. (

D. @

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

Which of the following action removes a sheet from workbook?

A. Select the sheet, then choose Edit >> Delete Sheet

B. Select the sheet then choose Format >> Sheet >> Hide

C. Both of above

D. None of above

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

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

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 integrating word and excel, word is usually the

A. Server

B. Destination

C. Client

D. Both b and c

Discuss this answer

You can select a single range of cells by

A. Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells

B. Pressing the Ctrl key while dragging over the desired cells

C. Pressing the Shift key and an arrow key

D. Dragging over the desired cells

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

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

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

A. Paper

B. Margin

C. Layout

D. Orientation

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

Which menu option can be sued to split windows into two

A. Format > window

B. View > window > split

C. Window > split

D. View > split

Discuss this answer

Comments can be added to cells using ......

A. Edit -> Comments

B. Insert -> Comment

C. File -> Comments

D. View > Comments

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

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 of the following methods can not be used to edit the contents of a cell?

A. Press the Alt key

B. Clicking the formula bar

C. Pressing the F2 key

D. Double clicking the cell

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

Comments put in cells are called

A. Smart tip

B. Cell tip

C. Web tip

D. Soft tip

Discuss this answer

Concatenation of text can be done using

A. Apostrophe (&lsquo

B. Exclamation (!)

C. Hash (#)

D. Ampersand (&

Discuss this answer

Which of the following is the oldest spreadsheet package?

A. VisiCalc

B. Lotus 1-2-3

C. Excel

D. StarCalc

Discuss this answer

The name box

A. Shows the location of the previously active cell

B. Appears to the left of the formula bar

C. Appears below the status bar

D. Appears below the menu bar

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

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

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

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 key do you press to check spelling?

A. F3

B. F5

C. F7

D. F9

Discuss this answer

Concatenation of text can be done using

A. Apostrophe ( )

B. Exclamation ( ! )

C. Hash ( # )

D. Ampersand ( & )

Discuss this answer

Which command will you choose to convert a column of data into row?

A. Cut and Paste

B. Edit >> Paste Special >> Transpose

C. Both of above

D. None of above

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

Accepted Answer

D. Value and cell references

To create a formula, you can use:

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

Which symbol must all formula begin with?

The Chart wizard term data categories refers to;

Which of the following action removes a sheet from workbook?

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

The auto calculate feature

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

When integrating word and excel, word is usually the

You can select a single range of cells by

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

Multiple calculations can be made in a single formula using

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

The autofill feature

Which menu option can be sued to split windows into two

Comments can be added to cells using ......

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

You can check the conditions against __________ when applying conditional formatting

Which of the following methods can not be used to edit the contents of a cell?

What does `COUNTA ()` function do?

Comments put in cells are called

Concatenation of text can be done using

Which of the following is the oldest spreadsheet package?

The name box

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

You can copy data or formulas

You can use the drag and drop method to

The Paste Special command lets you copy and paste:

Which key do you press to check spelling?

Concatenation of text can be done using

Which command will you choose to convert a column of data into row?

To create a formula, you first:

Also checkout

To create a formula, you can use:

Correct Answer :

Show all Microsoft Excel MCQ

Related Questions

Which symbol must all formula begin with?

The Chart wizard term data categories refers to;

Which of the following action removes a sheet from workbook?

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

The auto calculate feature

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

When integrating word and excel, word is usually the

You can select a single range of cells by

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

Multiple calculations can be made in a single formula using

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

The autofill feature

Which menu option can be sued to split windows into two

Comments can be added to cells using ......

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

You can check the conditions against __________ when applying conditional formatting

Which of the following methods can not be used to edit the contents of a cell?

What does COUNTA () function do?

Comments put in cells are called

Concatenation of text can be done using

Which of the following is the oldest spreadsheet package?

The name box

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

You can copy data or formulas

You can use the drag and drop method to

The Paste Special command lets you copy and paste:

Which key do you press to check spelling?

Concatenation of text can be done using

Which command will you choose to convert a column of data into row?

To create a formula, you first:

Also checkout

What does `COUNTA ()` function do?