Question 11

The financial analyst is updating the formula for the Office Supplies account and needs to incorporate the full year office supplies expenses from the previous fiscal year. What formula should the analyst implement to retrieve last year's value?
  • Question 12

    Scenario: A financial planner is responsible for ensuring the accuracy and structure of the Adaptive Planning model. This includes maintaining formulaic accounts on the Income Statement and establishing a logical hierarchy for the General Ledger accounts to facilitate effective financial reporting and analysis.
    The planner needs to display the profit margin ratio on the Income Statement, calculated as Operating Income divided by Revenue and presented as a percentage. What type of account should the planner create and configure?
  • Question 13

    The planning team decided that no user should be able to edit the Office Supplies general ledger account, since the planning team will do the estimates for all levels. What setting in a standard sheet do you use to make an account read-only for all levels?
  • Question 14

    You have a Personnel sheet that calculates a cell phone allowance paid each month unless an employee has earned over a certain salary threshold for the year. What is an accurate logic expression for the IF statement?
  • Question 15

    You need to create a sub-version. For what kind of version do you create the sub-version?