I need answers for this excel sheet

Excel does not permit making reference to cells in Yes a workbook that is not open. Yes or No? You want cell E4 on sheet2 to contain whatever is in cell E1 on sheet1. What would be the correct entry for sheet2 cell E4 to do this? Select Answer Excel recognizes three data types: text, value and formula. Which of the following is not recognized as text by Excel? Select Answer After you enter a formula in a cell, it displays #VALUE! It means that: A name in the formula is not recognized by Excel Suppose you are interested in copying and pasting the result of a formula and not the formula itself. What option would you select for this from the Paste button option menu? What is the positional value of A in hexadecimal number BA2? Paste Special Select Answer How many cells are being referenced by the cell range B2:D5? Select