5&6 will upvote

Which of the following statements is incorrect? You can use the F3 key or Function F3 or Command-B on a Mac to cycle through every possible reference type (absolute, mixed, and relative). The \#NAME error occurs in Excel when the program does not recognize a function in your formula due to misspelling of the function or the older versions of Excel are not aware of the existence of new functions. All the answers are correct except one. In the new versions of Excel, the worksheet is a matrix of cells with 1,048,576 rows by 16,384 columns, and each cell can contain text, numbers, or formulas: B$6 cell representation is a mixed reference where the column is relative and the row is absolute. Which of the following statements is correct? The geometric average of numbers can be calculated in an Excel cell by using the following structure: =AVERAGE(number 1 , number 2, ). For text entries, the term "formulas" refers to the typeface, size, text color, and cell alignment used to display the text. A workbook of Excel allows several related worksheets to be contained in one file for easy access. All the answers are correct. Excel treats all cell references as absolute