To create a formula, you first:
Home | Discussion ForumTo create a formula, you first:
Select the cell you want to place the formula into
Type the equals sign (=) to tell Excel that you’re about to enter a formula
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
Answer : A
Free Online Test
View More Related Question
1) Which of the following action removes a sheet from workbook?
Select the sheet, then choose Edit >> Delete Sheet
Select the sheet then choose Format >> Sheet >> Hide
Both of above
None of above
View Answer
2) Each excel file is called a workbook because
It can contain text and data
It can be modified
It can contain many sheets including worksheets and chart sheets
You have to work hard to create it
View Answer
3) To drag a selected range of data to another worksheet in the same workbook, use the ?
4) Which of following is Not one of Excel’s what-if function?
5) Text formulas:
Replace cell references
Return ASCII values of characters
Concatenate and manipulate text
Show formula error value
View Answer