Naming Cells In Spread Sheets

Q1 Naming cells in spreadsheets (4 marks) See support.office.com/en-us/article/Define-and-use-names-in-formulas-4D0F13AC-53B7-422E-AFD2-ABD7FF379C64 Why replace cell references with names? Create a simple spreadsheet and paste Sales less Expenses = Net Profit. Q2 Negative numbers (3 marks) Why do accountants display negative numbers in brackets? How can negative numbers be displayed in brackets? Paste a simple spreadsheet example. See: support.office.com/en-us/article/change-the-way-negative-numbers-are-displayed-104b47a6-8ae2-471f-8f73-c4b96e7bb146 Q3 Separation of data and…...