Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Which of the following formulas from the spreadsheet shown below will result in a circular reference error? Select all that apply. begin { tabular

Which of the following formulas from the spreadsheet shown below will result in a circular reference error? Select all that apply.
\begin{tabular}{|c|c|c|c|c|c|c|c|c|}
\hline 4 & A & B & C & D & E & F & G & \\
\hline 1 & & & & & & & & \\
\hline 2 & & Per unit cost of goods sold & 25 & & & & & \\
\hline 3 & & & & & & & & \\
\hline 4 & & Unit price & 49 & & & & & \\
\hline 5 & & & & & & & & \\
\hline 6 & & & Jan & Feb & Mar & Apr & May & Jun \\
\hline 7 & & Product a & 34 & 30 & 24 & 34 & 22 & 22\\
\hline 8 & & Product b & 24 & 26 & 32 & 31 & 11 & 27\\
\hline 9 & & Product c & 26 & 10 & 23 & 16 & 26 & 32\\
\hline 10 & & Total & 84 & 66 & 79 & 81 & 59 & 81\\
\hline 11 & & & & & & & & \\
\hline 12 & & Total COGS & 2100 & 1650 & 1975 & 2025 & 1475 & 2025\\
\hline 13 & & Total revenue & 4116 & 3234 & 3871 & 3969 & 2891 & 3969\\
\hline 14 & & Profit after COGS & 2016 & 1584 & 1896 & 1944 & 1416 & 1944\\
\hline 15 & & & & & & & & \\
\hline
\end{tabular}
Formula in cell \(\mathrm{C10}=\) sumproduct(C5:H7, C2)
All of these will result in a circular reference error
Formula in cell \(\mathrm{C}14=\mathrm{C}10^{*}\mathrm{C}4-\mathrm{C}10^{*}\mathrm{C}2\)
Formula in cell C10=sum(C7:C10)*\$C\$2
Formula in cell \(\mathrm{H}10=\operatorname{sum}(\mathrm{H}5: \mathrm{H}10)\)
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting concepts and applications

Authors: Albrecht Stice, Stice Swain

11th Edition

978-0538750196, 538745487, 538750197, 978-0538745482

More Books

Students also viewed these Accounting questions

Question

Confirm that the CEV model formulas satisfy put-call parity.

Answered: 1 week ago