You have a batch of data in a spreadsheet that you are going to analyze. What are some tips for working with the data set to help prevent and correct errors?
What will be an ideal response?
Maintain the data on a separate worksheet and do the analysis on another worksheet whenever possible.Keep datasets separate from other elements on a worksheet.Create a backup copy of the worksheet with the dataset within the same workbook so if errors occur the data can be restored.
2.You are chatting with a colleague who mentions that the SUBTOTAL function performs sum, average, count, or other functions, and questions why a person would use that function when the SUM, AVERAGE, and COUNT functions already exist. What is the difference when using the SUBTOTAL to sum versus the SUM function?
You might also like to view...
Which of the following statements will correctly convert the data type, if x is a float and y is a double?
a. x = float y;
b. x =
All of the following are design elements included in a presentation theme EXCEPT ________
A) colors B) fonts C) graphics D) animations
The CEO of a corporation purchases the latest mobile device and connects it to the internal network. The CEO then downloads sensitive financial documents through his email. The device is then lost in transit to a conference. The CEO notifies the company helpdesk about the lost device. A replacement device is shipped out. Then, the helpdesk ticket is closed stating the issue was resolved. A week
later, you realize that the original mobile device was never retrieved nor was a remote wipe on the device completed. You then complete a remote wipe of the lost device. You then report to management that this data breach was not properly reported due to insufficient training. Which process is responsible for this process? A. eDiscovery B. incident response C. data recovery and storage D. data handling
What is the maximum number of network adapters that can be configured for a virtual machine running in VirtualBox?
A. one B. two C. three D. four