What are the different tools available within Microsoft Suite?
The MS Suite includes mainly include Word (word processor), Outlook (email), Excel (spreadsheet), Access (database), OneNote (note-taking software) and PowerPoint (presentation slides). There are other tools which are specific to Business/Individual needs.
What is an "IF" function in Excel?
To perform the logic test, IF function is performed. It checks whether a condition is true or false. If the condition is true, then it will give result accordingly, if the condition is false then the result or output will be different based on the given input in syntax. Example: If a numerical cell has different values (ranging between 1 to 10) and we want to show whether the values are “Greater than five” or “less than five" in a separate cell then we will use below formula: Syntax => "=IF (Logical test, value if true, value if false)" Example =IF (A1>5, “Greater than five, “Less than five”) Note that Greater than five is written within the parenthesis so that excel treats the string as TEXT.
What are the different types of data relationships that can be formed in MS Access?
The table that contains data can build three types of relationships: a) One-to-one relationships: A single data in one table is linked with a single data in another table. b) One-to-many relationship: A single data in a table is linked to several data points in another table c) Many-to-many relationship: Where several data points in one table are related to several other data points in another table.