MS Excel Cell Reference Range Quiz 8

by
Post Views: 200

This test will check your understanding of MS Excel Cell Reference Ranges, which are used to select and work with multiple cells in a spreadsheet. You will encounter questions related to MS Excel on how to define, use, and apply ranges in formulas, functions, and data operations. Whether you are a beginner or looking to refresh your skills, this quiz “MS Excel Cell Reference Range” will help you master the concept of cell reference ranges in Excel! Let us start with the MS Excel Cell Reference Range Quiz now.

Online MS Excel Cell Reference Range Quiz Questions

Online MS Excel Cell Reference and Range Quiz

1. Column B contains the named range, sales_price Column C contains the named range, shipping_cost. The formula: =SUM(sales_price)+SUM(shipping_cost) is typed into cell D2. What will be the result?

 
 
 
 

2. Which of the following does the name manager not allow us to do?

 
 
 
 

3. When using Define Name you should select both data and labels.

 
 

4. A named range, arrivals, has been created for cells N2 to N82. No other named ranges have been created. What will the Name Box display when clicking on cell N3?

 
 
 
 

5. We want to name each of the cells in column B using the labels in column A, which would be the fastest option?

 
 
 
 

6. When using Create from Selection you should select both data and labels.

 
 

7. Sara wants to create a name for the range for the tax rate of 15%. She types in Tax15, what is the problem?

 
 
 
 

8. On which Tab of the ribbon are the Name tools located?

 
 
 
 

9. Instead of using absolute cell referencing, another way to refer to a tax rate of 15% which is cell G2, would be to:

 
 
 
 

10. Cell F2 contains the following formula: =B2+C2+D2. If we drag the fill handle down, what would be the resulting formula in cell F3?

 
 
 
 

11. What can you do if you forget the Named Ranges that apply to your spreadsheet?

 
 
 
 

12. The tax rate, 15%, is in cell G2. Which cell references will allow us to use this value in a formula that appears down an entire column?

 
 
 
 

13. Which shortcut will select a range of cells from the first selected cell to the end of a column (i.e., the first empty cell in that column)?

 
 
 
 

14. Which of the following are valid characteristics of names for a named range?

 
 
 
 
 
 
 

15. It is possible for the same range to have multiple names.

 
 

16. A named range, arrivals, has been created for cells N2 to N82. What does Scope mean?

 
 
 
 

17. Sara accidentally deleted a named range. What will happen?

 
 
 
 

18. Named ranges are more efficient than using cell references when performing calculations because of the following reasons:

 
 
 
 

19. What is the quickest way to obtain a list of all the named ranges and the cells they refer to, for documentation purposes, in Excel or a word processing document?

 
 
 
 

20. When sharing files with colleagues, the named ranges will revert to relevant cell references.

 
 

Online MS Excel Cell Reference Range Quiz

  • Cell F2 contains the following formula: =B2+C2+D2. If we drag the fill handle down, what would be the resulting formula in cell F3?
  • The tax rate, 15%, is in cell G2. Which cell references will allow us to use this value in a formula that appears down an entire column?
  • Instead of using absolute cell referencing, another way to refer to a tax rate of 15% which is cell G2, would be to:
  • Sara wants to create a name for the range for the tax rate of 15%. She types in Tax15, what is the problem?
  • Which of the following are valid characteristics of names for a named range?
  • When using Create from Selection you should select both data and labels.
  • When using Define Name you should select both data and labels.
  • We want to name each of the cells in column B using the labels in column A, which would be the fastest option?
  • Which shortcut will select a range of cells from the first selected cell to the end of a column (i.e., the first empty cell in that column)?
  • On which Tab of the ribbon are the Name tools located?
  • A named range, arrivals, has been created for cells N2 to N82. No other named ranges have been created. What will the Name Box display when clicking on cell N3?
  • A named range, arrivals, has been created for cells N2 to N82. What does Scope mean?
  • Which of the following does the name manager not allow us to do?
  • It is possible for the same range to have multiple names.
  • What is the quickest way to obtain a list of all the named ranges and the cells they refer to, for documentation purposes, in Excel or a word processing document?
  • Sara accidentally deleted a named range. What will happen?
  • When sharing files with colleagues, the named ranges will revert to relevant cell references.
  • What can you do if you forget the Named Ranges that apply to your spreadsheet?
  • Named ranges are more efficient than using cell references when performing calculations because of the following reasons:
  • Column B contains the named range, sales_price Column C contains the named range, shipping_cost. The formula: =SUM(sales_price)+SUM(shipping_cost) is typed into cell D2. What will be the result?

General Knowledge Quiz with Answers

summer() function in R Language

Leave a Comment

Discover more from Statistics for Data Analyst

Subscribe now to keep reading and get access to the full archive.

Continue reading