To create a formula, you can use:
Values but not cell references
Cell references but not values
Values or cell references although not both at the same time
Value and cell references
Answer : D
Free Online Test
View More Related Question
1) Rounding errors can occur
When you use multiplication, division, or exponentiation in a formula
When you use addition and subtraction in a formula
Because excel uses hidden decimal places in computation
When you show the results of formulas with different decimal places that the calculated results
View Answer
2) With which of the following all formulas in excel starts ?
3) What is the correct way to refer the cell A10 on sheet3 from sheet1?
4) To convert a column of data into row, which command will you choose
5) To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Unfreeze panes command on the window menu
Freeze panes command on the window menu
Hold titles command on the edit menu
Split command on the window menu
View Answer
