Microsoft Excel 2010 Expert - 77-888무료 덤프문제 풀어보기
You work as an Office Assistant for Dreams Unlimited Inc. You use Microsoft Excel 2010 for creating various types of reports. You have created a report in the format given below:
In the A7 cell, you are required to put a formula so that it can fulfill the description provided
in the B7 cell.
Which of the following formulas will provide the required result?
In the A7 cell, you are required to put a formula so that it can fulfill the description provided
in the B7 cell.
Which of the following formulas will provide the required result?
정답: B,C
설명: (Fast2test 회원만 볼 수 있음)
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 other PivotTables. 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.
Each correct answer represents a part of the solution. Choose all that apply.
정답: B,C,D,E
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?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
You work as an Office Manager for Blue Well Inc. The company has a Windows-based network. You have two budget situations in which one is the worst case and the other is the best case. You want to create both situations on the same worksheet and then switch between them with the change in requirements. Which of the following will you use to accomplish the task?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
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?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
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.
정답: A,B,D
설명: (Fast2test 회원만 볼 수 있음)
You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You are
facing a problem that when you type in a function and press Enter, the cell shows the function as
you typed it, instead of returning the function's value as shown below:
Which of the following is the reason that is causing the above problem?
facing a problem that when you type in a function and press Enter, the cell shows the function as
you typed it, instead of returning the function's value as shown below:
Which of the following is the reason that is causing the above problem?
정답: D
설명: (Fast2test 회원만 볼 수 있음)