Home › Practice › Digital Skills Digital Skills Medium
When creating a spreadsheet application to process employee attendance data, which formula approach ensures both data accuracy and security while complying with EU data protection regulations? A Implement a formula that references employee personal data in the calculation, store the file in a cloud service with default sharing settings, and use a formula that does not include any data validation or access controls B Develop a complex formula that includes all employee personal data within the calculation cells, save the file in a public folder accessible to all staff members, and apply a basic password to the spreadsheet file C Create a formula that directly references employee personal identification numbers in calculations, store the spreadsheet in a shared cloud storage service with open access, and use a simple formula without any data validation D Use a simple formula that does not validate data inputs, store the spreadsheet in a shared network drive without access restrictions, and include employee identification numbers in the calculation formula E Use a formula that automatically calculates overtime based on standard working hours, with data validation rules to prevent incorrect entries, and ensure all employee data is stored in a password-protected file with restricted access permissions
Select an option first More Digital Skills questions