Provide an explanation of why a table formula that sums row data does not include data from a newly added row. Explain what can be done to cause the sum to be correct.
What will be an ideal response?
A table formula does not automatically update when new data is added that affects the formula. If a formula sums row data, and new data is added in the row, you must force the formula to update by selecting Update Field in a shortcut menu.
You might also like to view...
Which of the following is not true about protecting your electronic profile?
A) Every time you provide information to a company, that company may enter the information into a database. B) If nothing else, your name, address, and telephone number are available online for others to see. C) One way to keep yourself safe is to set up an alternate e-mail that you only use when you sign up for promotions or website access. D) Filling out forms online gives the recipient more information than you intend.
A table style controls the fill color of the header row, columns, and records in a table
Indicate whether the statement is true or false