To create a formula, you first:...

MCQ

To create a formula, you first:

Select the cell you want to place the formula into

Type the equals sign (=) to tell Excel that you

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

Choose the new command from the file menu

Community Discussion

No discussions yet. Be the first to start!

You must be logged in to participate in the discussion.

Similar Questions

MCQ

You can auto fit the width of column by

Double clicking on the column name on column header

Double click on the cell pointer in worksheet

Double clicking on column right border on column header

Double clicking on the column left border of column header

Discussion

MCQ

Which of the following is not true regarding Conditional Formatting?

You can add more than one condition to check

You can set condition to look for Bold and apply Italics on them

You can apply Font, border and pattern formats that meets the specified conditions

You can delete any condition from Conditional Formatting dialog box if it is not requried

Discussion

MCQ

Which is used to perform what if analysis?

Solver

Goal seek

Scenario Manager

All of above

Discussion

MCQ

When a row of data is to be converted into columns

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

Copy the cells in column then choose Paste Special, then click Transpose and OK

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

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

Discussion

MCQ

How do you wrap the text in a cell?

Format, cells, font

Format, cells, protection

Format, cells, number

Format, cells, alignment

Discussion

Banking

Engineering

General

Medical

Question Discussion & Solution

Report Error

Community Discussion

Similar Questions

Report Error

Report Error

Report Error

Report Error

Report Error

More Microsoft Office Topics

Microsoft Power Point

Microsoft Excel

Microsoft Word

Microsoft Access

Banking

Engineering

General

Medical

Question Discussion & Solution

report Report Error

forum Community Discussion

auto_awesome Similar Questions

report Report Error

report Report Error

report Report Error

report Report Error

report Report Error

category More Microsoft Office Topics

Microsoft Power Point

Microsoft Excel

Microsoft Word

Microsoft Access

Report Error

Community Discussion

Similar Questions

Report Error

Report Error

Report Error

Report Error

Report Error

More Microsoft Office Topics