Question one:

Logical functions are used widely in excel; you have to search and explore five logical functions in excel and present the following:

– Create a workbook named TMA.

– Explain the uses and description of each function on the first sheet named “Logical functions – Uses & Description”.

– Providing example on each function (each example contains numbers on a separate sheet that have the name of the function).

Question Two:

You have to select one manufacturing company listed in Saudi Exchange (Tadawul) and upload the recent four years’ financial statements (statements).

Requirements

– Create a new sheet named financial analysis in the TMA workbook and list the income statement and balance sheet for the recent four years.

– Create a new sheet named vertical analysis in the TMA workbook and insert the necessary equations or functions in related cells to calculate vertical analysis for the income statement and balance sheet.

– Create a new sheet named horizontal analysis in the TMA workbook and insert the necessary equations or functions in related cells to calculate horizontal analysis for the income statement and balance sheet.