Question
The formula =SUM(B4:F4) in cell G4 is copied down the Total column. If I delete the Monday column (column B), how will this affect the
The formula =SUM(B4:F4) in cell G4 is copied down the Total column. If I delete the Monday column (column B), how will this affect the formulas in the Total column?
Select one answer.
The formulas will be incorrect. But if I re-enter the first formula in the Total column, Excel will automatically correct the other formulas in the column.
The formulas will return the error #REF!.
The formulas in the Total column will be automatically corrected.
Excel will not allow a column to be deleted because of the pre-existing formulas in the Total column.
The formulas will return the error #VALUE!.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Modern Management Concepts And Skills
Authors: Samuel Certo, S Certo
15th global Edition
978-1292265193, 1292265191
