HOTSPOT -You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You want to create a VBA procedure for the open event of a workbook. You are required to set the security level temporarily for enabling all macros. Mark the option that you will choose first to accomplish the task.Hot Area:
HOTSPOT -Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft Excel 2010. He wants to fill the active cell with the content of the adjacent cell. Mark the option that he will choose to accomplish the task.Hot Area:
You work as an Office Assistant for Media Perfect Inc. You have created a spreadsheet in Excel 2010 and shared it with the other employees of the company. You want to select password protection and select options to prevent other employees from changing, moving, and deleting important data.Which of the following options will you choose to accomplish the task?
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft Excel 2010. Rick wants to trace the project with the actual requirements. For this purpose, he is required to compare month to month, actual v budget, quarter to quarter, year to year variances.Which of the following will Rick use to accomplish the task?
You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You have a formula that uses one or two variables or multiple formulas that all use one common variable. You want to examine a range of possibilities at a glance. Which of the following will you use to accomplish the task?
Rick works as a Sales Manager for Tech Perfect Inc. He is creating a report in Excel 2010. He has entered data in five worksheets in a workbook. He wants to enter a disclaimer message in the A1 cell of each sheet in the workbook as shown in the image given below:Which of the following is the easiest way to accomplish the task?
