You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You want to change values in cells to observe the way in which those changes are affecting the outcome of formulas in the worksheet. Which of the following will you use to accomplish the task?
You work as an Office Assistant for Media Perfect Inc. You are creating a report in Microsoft Excel 2010. The report worksheet will include the sales made by all the sales managers in the month of January.In the worksheet, you are required to place a pictorial representation displaying the percentage of total sales made by each sales manager in January. Which of the following charts will you use to accomplish the task?
You work as an Office Assistant for Media Perfect Inc. You have created a report in Excel. You have inserted the following formula in a cell:VLOOKUP(12, A2:C10, 3, FALSE )Which of the following actions will be performed by the formula?
You work as an Office Assistant for Blue well Inc. The company has a Windows-based network. You are creating a hot spot on a graphic that other users can click to run a macro. Which of the following steps will you take to accomplish the task?Each correct answer represents a part of the solution. Choose all that apply.
You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook inMicrosoft Excel 2010. You want to summarize a large amount of data to analyze numerical data and to answer unexpected questions about your data in theBusiness Intelligence (BI) report that you are working with. For this purpose, you are required to create a PivotTable. Which of the following steps will you take to accomplish the task?Each correct answer represents a part of the solution. Choose all that apply.
You work as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network. You are creating a business report by using. Microsoft Excel2010. You have arranged sales data as shown below:You want to provide pictorial representation of the trend of the sales data in front of each row.Which of the following actions will you take to accomplish the task with the least amount of administrative burden?
