Microsoft Excel 2013 Expert Part One - 77-427무료 덤프문제 풀어보기
Which of the following steps will you take to merge copies of a shared workbook? Each correct
answer represents a part of the solution. Choose all that apply.
answer represents a part of the solution. Choose all that apply.
정답: A,B,C,D,E
설명: (Fast2test 회원만 볼 수 있음)
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 Excel 2013. 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?
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?
정답: D
설명: (Fast2test 회원만 볼 수 있음)
You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You observe that while trying to look up or match a lookup_value within an array, Excel is not able to recognize the matching value. Which of the following are the reasons that are causing the above problem?
Each correct answer represents a complete solution. Choose all that apply.
Each correct answer represents a complete solution. Choose all that apply.
정답: B,C
설명: (Fast2test 회원만 볼 수 있음)
You work as an Office Assistant for Peach Tree Inc. Your responsibility includes creating sales incentive report of all sales managers for every quarter. You are using Microsoft Excel to create a worksheet for preparing the report. You have inserted the sales figures of all sales managers as shown in the image given below:
You have to calculate the first quarter incentives for all sales managers. The incentive percentage
(provided in cell B3) is fixed for all sales managers. The incentive will be calculated on their
total first quarter sales. You have to write a formula in the cell F8. Then you will drag the cell
border to the cell F12 to copy the formula to all the cells from F8 to F12. In the first step, you
select the F8 cell. Which of the following formulas will you insert to accomplish the task?
You have to calculate the first quarter incentives for all sales managers. The incentive percentage
(provided in cell B3) is fixed for all sales managers. The incentive will be calculated on their
total first quarter sales. You have to write a formula in the cell F8. Then you will drag the cell
border to the cell F12 to copy the formula to all the cells from F8 to F12. In the first step, you
select the F8 cell. Which of the following formulas will you insert to accomplish the task?
정답: D
설명: (Fast2test 회원만 볼 수 있음)
Which of the following is used to display a trend based on adjacent data in a clear and compact
graphical representation by taking up a small amount of space?
graphical representation by taking up a small amount of space?
정답: A
설명: (Fast2test 회원만 볼 수 있음)
HOTSPOT
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through
Microsoft
Excel 2013. 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.
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through
Microsoft
Excel 2013. 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.
정답:
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?
VLOOKUP(12, A2:C10, 3, FALSE )
Which of the following actions will be performed by the formula?
정답: C
설명: (Fast2test 회원만 볼 수 있음)