You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet as shown below:You want to use Excel Transpose Function for copying the contents of cells B1:B3 into cells A5:C5.You simply type '=TRANSPOSE( B1:B3 )' into the cells A5:C5. It displays the Excel #VALUE! error message because the cells are working independently and the function will not work for each individual cell. Therefore, it is required to make the cells A5:C5 work together as an ARRAY. For this purpose, you are required to use an array formula. Which of the following steps will you take to input Excel array formulas in the spreadsheet?Each correct answer represents a part of the solution. Choose all that apply.
HOTSPOT -You work as a technician in Tech Perfect Inc. The Network Administrator of the company installs the Microsoft Excel 2010 application on the network. You open the application and see various changes in Excel 2010. You have to open an existing worksheet through the application. You are unable to find the Office button.Mark the option that you will click to accomplish the task.Hot Area:
You work as an Office Assistant for Tech Tree Inc. You have created a report in a workbook in Microsoft Excel 2010. You have a number of PivotTables in a single report. You want to apply the same filter to all of those PivotTables. For this purpose, you are required to create a slicer in one PivotTable and share it with otherPivotTables. 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.
Jack wants the rows containing the name Tom and product Jam. There are thousands of entries in the log. Plowing through all the records will be time taking.Which option can be used to view only the relevant records?
Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network. He is creating a form through Microsoft Excel 2010. He wants to enable worksheet forms to satisfy the flexible design requirements and to customize their appearance, behavior, fonts, and other characteristics. Which of the following will Rick use to accomplish the task?
HOTSPOT -You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to insert a signature line that specifies the individual who must sign. Mark the option that you will choose to accomplish the task.Hot Area:
