Question

Sidney works in the accounting department. His boss just assigned him a task that involves creating budget formulas for the company's payroll expense reports. Sidney will be using Excel spreadsheets to calculate the company's payroll expense reports. In Excel, what does Sidney need to consider when creating formulas? A. Excel has predefined formulas, so you don't have to create any formulas from scratch. B. Excel performs operations based on the order of precedence. C. Excel has third-party formulas you can purchase from Microsoft. D. Excel has limited capabilities, so it would be easier to use payroll software for this application.

Answer 1

In excel spreadsheets, Sidney need to consider specifying relationships between the information you have stored in your spreadsheets when creating formulas. The elements that will help you understand using spreadsheet are the constants, operators, references and functions. This will enable her to use the formulas, without hassle in spreadsheets.