FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Solution: Correct the typo in the syntax and retry the formula. Tip: Instead of manually entering defined names in formulas, you can have Excel do it automatically for you. To do that, go to the Formulas tab, in Defined Names group, click Use in Formula, and then select the defined name you want to add.

Detailed explanation-2: -The default name of a workbook in excel is Book1, Book2, Book3 etc. A workbook in Microsoft Excel is a single file that contains one or more spreadsheets, commonly known as worksheets. A workbook is a document that contains one or more worksheets to aid with data organisation.

Detailed explanation-3: -Select a blank cell, type =GetBook() into the cell, then press the Enter key. You can see the workbook name is populated on the selected cell.

Detailed explanation-4: -A name must always be unique within its scope. Excel prevents you from defining a name that already exists within its scope. However, you can use the same name in different scopes. For example, you can define a name, such as GrossProfit, that is scoped to Sheet1, Sheet2, and Sheet3 in the same workbook.