Home

What is the correct answer?

4

You can use the formula pallette to

A. format cells containing numbers

B. create and edit formula containing functions

C. enter assumptions data

D. copy a range of cells

Correct Answer :

B. create and edit formula containing functions


Related Questions

What is the correct answer?

4

How do you display current date only in MS Excel?

A. date ()

B. Today ()

C. now ()

D. time ()

What is the correct answer?

4

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

A. Label

B. Value

C. Formula

D. Text string

What is the correct answer?

4

Excel displays the current cell address in the ........

A. Formula bar

B. Status Bar

C. Name Box

D. Title Bar

What is the correct answer?

4

When a row of data is to be converted into columns

A. Copy the cells in row, select the same number of cells in row and paste

B. Copy the cells in column then choose Edit >> Paste Special, then click Transpose and OK

C. Copy the cells then go to Format >> Cells then on Alignment tab click Transpose check box and click OK

D. Select the cells then place the cell pointer on new cell and choose Edit >> Paste Special, mark Transpose check box and click OK

What is the correct answer?

4

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

What is the correct answer?

4

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

What is the correct answer?

4

Which symbol must all formula begin with?

A. =

B. +

C. (

D. @

What is the correct answer?

4

A worksheet can have a maximum of …. Number of rows

A. 256

B. 1024

C. 32000

D. 65535

What is the correct answer?

4

To copy formatting from one area in a worksheet and apply it to another area you would use:

A. The Edit > Copy Format and Edit>Paste Format commands form the menu

B. The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu

C. There is no way to copy and apply formatting in Excel You have to do it manually

D. The Format Painter button on the standard toolbar

What is the correct answer?

4

You want to set such that when you type Baishakh and drag the fill handle, Excel should produce Jestha, Aashadh and so on. What will you set to effect that?

A. Custom List

B. Auto Fill Options

C. Fill Across Worksheet

D. Fill Series

What is the correct answer?

4

Comments put in cells are called

A. Smart tip

B. Cell tip

C. Web tip

D. Soft tip

What is the correct answer?

4

To select an entire column in MS-EXCEL, press?

A. CTRL + C

B. CTRL + Arrow key

C. CTRL + S

D. None of the above

What is the correct answer?

4

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

What is the correct answer?

4

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

A. Goal seek

B. Solver

C. Scenario manager

D. Auto Outline

What is the correct answer?

4

Which of the following is not a valid data type in Excel?

A. Number

B. Character

C. Label

D. Date/Time

What is the correct answer?

4

You can convert existing excel worksheet data an charts to an HTML document by using

A. FTP wizard

B. Internet assistant wizard

C. Intranet wizard

D. Import wizard

What is the correct answer?

4

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

What is the correct answer?

4

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

What is the correct answer?

4

The Cancel and Enter buttons appear in the:

A. Title bar

B. Formula bar

C. Menu bar

D. Sheet tabs

What is the correct answer?

4

An excel workbook is a collection of

A. Workbooks

B. Worksheets

C. Charts

D. Worksheets and charts

What is the correct answer?

4

The first cell in EXCEL worksheet is labeled as

A. AA

B. A1

C. Aa

D. A0

What is the correct answer?

4

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

A. Accessing

B. Referencing

C. Updating

D. Functioning

What is the correct answer?

4

Multiple calculations can be made in a single formula using

A. standard formulas

B. array formula

C. complex formulas

D. smart formula

What is the correct answer?

4

What does COUNTA () function do?

A. counts cells having alphabets

B. counts empty cells

C. counts cells having number

D. counts non-empty cells

What is the correct answer?

4

When you copy a formula

A. Excel erases the original copy of the formula

B. Excel edits cell references in the newly copied formula

C. Excel adjusts absolute cell references

D. Excel doesnt adjust relative cell references

What is the correct answer?

4

In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?

A. AutoFill

B. Auto correct

C. Auto sum

D. Auto format

What is the correct answer?

4

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

What is the correct answer?

4

What is the correct way to refer the cell A10 on sheet3 from sheet1?

A. sheet3!A10

B. sheet1!A10

C. Sheet3.A10

D. A10

What is the correct answer?

4

Ctrl + D shortcut key in Excel will

A. Open the font dialog box

B. Apply double underline for the active cell

C. Fill down in the selection

D. None of above

What is the correct answer?

4

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

A. ( quote )

B. = ( equal )

C. _ ( underscore )

D. ( apostrophe )