What is the correct answer?


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

Correct Answer :

D. Value and cell references

Related Questions

Which of the following is not true about Find and Replace in Excel Which of the cell pointer indicates you that you can make selection? Which area in an Excel window allows entering values and formulas? Which of the following is invalid statement? To create a formula, you can use: By default Excel provides 3 worksheets. You need only two of them, how… To activate the previous cell in a pre-selected range, press Right clicking something in Excel: Excel probably considers the cell entry January 1, 2000 to be a To center worksheet titles across a range of cells, you must How can you update the values of formula cells if Auto Calculate mode… MS-EXCEL is based on .........? While Finding and Replacing some data in Excel, which of the following… How can you show or hide the gridlines in Excel Worksheet? When you link data maintained in an excel workbook to a word document Which menu option can be used to split windows into two? Which menu option can be sued to split windows into two B7:B9 indicates: It is acceptable to let long text flow into adjacent cells on a worksheet… Excel uniquely identifies cells within a worksheet with a cell name When a label is too long to fit within a worksheet cell, you typically… Which is not the function of Edit, Clear command? Which of the following is not true regarding Conditional Formatting? The Paste Special command lets you copy and paste: Which of the following formulas will Excel Not be able to calculate? You can select a single range of cells by Which of the following options is not located in the Page Setup dialog… Each excel file is called a workbook because Which button do you click to add up a series of numbers? What is the correct way to refer the cell A10 on sheet3 from sheet1?