Home › Practice › Digital Skills Digital Skills Hard
While creating a financial report in a spreadsheet application, you need to calculate the total sales for each product category. You have a large dataset with multiple rows and columns. Which approach ensures both accuracy and security when handling this data? A Create a SUMIF formula directly in the original spreadsheet and save it to a shared network drive that all employees can access, making the calculation results available to everyone in the organization. B Copy and paste the data into a new spreadsheet, then use a SUMIF formula to calculate totals for each category, ensuring to save the new file in a secure cloud storage service with restricted access permissions. C Apply a SUMIF formula to the original dataset and store the results in a new sheet within the same spreadsheet, then distribute the file via email to all team members with a note that they should not modify the original data. D Manually calculate the totals for each category using basic arithmetic operations, then store the results in a separate file that is password-protected and only accessible to the finance manager. E Use a complex nested formula that combines multiple functions to calculate totals in a single cell, then share the entire spreadsheet with all team members without any access restrictions.
Select an option first More Digital Skills questions