Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network.Rick has to perform the following tasks:Summarize large amounts of data. Analyze numeric data.Answer unexpected questions about data.Which of the following actions will Rick take to accomplish the task?
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a user form through Microsoft Excel 2010. While creating forms for a number of users, he is required to repeat some of the actions multiple times. It is a very time consuming process. To resolve this issue, he wants to record the sequence of actions to perform a certain task and to play them back in the same order.Which of the following actions will Rick take to accomplish the task?
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 select the Encrypt with Password option as a protection measure for the document you are sharing. Now, you have to specify a password in the Password box in the Encrypt Document dialog box appeared for editing the document. But you have forgotten the password. What will happen in this situation?
Which of the following can be defined as easy-to-use filtering components containing a set of buttons that enable users to quickly filter data in a PivotTable report, without opening drop-down lists to find the items to filter?
You work as an Office Assistant for Blue well Inc. You want to record a macro and save it with the name "Auto_Open" so that the macro will run whenever you open the workbook containing the macro.While doing so, you observe that the Auto_Open macro fails every time. Which of the following are the causes of this?Each correct answer represents a complete solution. Choose all that apply.
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You are creating a chart in Excel 2010. You want to show the slope of data points in the chart to know the trend of the Business Intelligence data range. Which of the following will you use to accomplish the task?
