5 Questions
What is the default reference style used in Excel?
A1 reference style
How do you refer to a cell in Excel?
By entering the column letter followed by the row number
What is the range of cells in columns A through E and rows 10 through 20?
The range of cells in columns A through E and rows 10 through 20
What is the range of cells in row 15 and columns B through E?
The range of cells in row 15 and columns B through E
How do you refer to a cell or range of cells on another worksheet in the same workbook?
By using the appropriate worksheet name followed by an exclamation mark (!)
Test your knowledge of Excel formulas with this quiz. Learn about different ranges of cells and how to use formulas in specific columns and rows. Improve your Excel skills now!
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free