Question

Marla made a spreadsheet in Excel showing the projected costs for a concert she was putting on. What can Marla enter into cell A11 to find out how much money is left in her budget and to make sure the cell is updated whenever she changes any of the other costs?

=A2-A4-A6-A8-A10
+A2-A4-A6-A8-A10
=A4-A6-A8-A10+A2
+A4-A6-A8-A10=A2

Answer 1

Marla will use the formula to find the updated cost.

=A2-A4-A6-A8-A10

Because A2 is budget and A4, A6, A8 and A10 all are expenses. So she has to budget-all expenses.

So option A=A2-A4-A6-A8-A10 is true.

What is a spreadsheet?

A spreadsheet is a computer program that can capture, display and manipulate data arranged in rows and columns. Spreadsheets are one of the most popular tools available with personal computers.

A single spreadsheet can be used as a worksheet to compile data for a purpose, or multiple sheets can be combined to create an entire workbook.

Learn more about spreadsheet here,

https://brainly.com/question/10509036

#SPJ1