Question

A. In cell a6, enter a formula without using a function that references cell a6 in the washington worksheet.

Answer 1

The formula to use without using a function is 'Washington worksheet'a6!

What is Cell Referencing?

In Microsoft Excel, A cell reference is the referencing of a cell or a group of cells on a worksheet that can be used in computation to discover the data values that you want to calculate.

So, suppose we have a cell a6 on the worksheet and we want to go to the Washington worksheet.

We need to follow these  procedures:

• Take the name of the Washington worksheet
• Enclose it in single quotation marks.
• Use an exclamation point. i.e. 'Washington worksheet'a6!

This will take the value from cell a6 and place it in our cell.

Learn more about cell referencing here:

https://brainly.com/question/5850309

Answer 2

Answer:=‘Consolidated Sales’!A6

Explanation:

i saw that someone else typed something similar but it wouldn’t work on excel but this one seems to work! I don’t really understand but seems to work