Download Excel 2010.certkiller.77-882.2020-01-15.1e.10q.vcex


Download Exam

File Info

Exam Excel 2010
Number 77-882
File Name Excel 2010.certkiller.77-882.2020-01-15.1e.10q.vcex
Size 569 Kb
Posted January 15, 2020
Downloads 6



How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%


 
 



Demo Questions

Question 1
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?

  • A: All filter
  • B: Sort
  • C: Find
  • D: Auto filter



Question 2
You are creating a business report by using Microsoft Excel 2010. You have arranged sales data as shown below: 

  
  
You want to provide pictorial representation of the trend of these sales data in front of each row. Which of the following steps will you choose to accomplish the task involving the least amount of administrative burden?

  • A: Use charts.
  • B: Use illustrations.
  • C: Use conditional formatting.
  • D: Use spark lines.



Question 3
You work as an Office Assistant for Media Perfect Inc. You are creating a report in Excel. You have selected all worksheets available in the workbook as shown below: 

  

Now, you want to cancel the selection. Which of the following steps will you take to accomplish the task with least administrative effort?

  • A: Double-click on one of the selected sheets.
  • B: Click on one of the selected sheets.
  • C: Click any unselected sheet.
  • D: Click the Single Sheet options in the Sheet Options group on the Page Layout tab.
  • E: Right-click the selected sheets. Click the Ungroup Sheets option from the shortcut menu.



Question 4
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?

  • A: =B3/100 * $E$8
  • B: =$B$3/100 * E8
  • C: =B3/100 * E8
  • D: =B3/100 * &E&8
  • E: =&B&3/100 * E8



Question 5
You work as an Office Assistant for Tech Perfect Inc. Your responsibility includes preparing sales reports of the company. You have created a sales report in a workbook of Excel 2010. Your workbook includes several worksheets as shown in the image given below: 
  
  
  
You want the sheet tabs of the sheets containing charts to appear in red color. Which of the following steps will you take to accomplish the task?

  • A: Select the sheets containing charts. 
    Select the Effects option in the Themes group on the Page Layout page.
  • B: Select the sheets containing charts. 
    Select the Colors option in the Themes group on the Page Layout page.
  • C: Select the sheets containing charts. 
    Right-click on the sheet tabs.   
    Choose the Tab Color option from the shortcut menu.
  • D: Select the sheets containing charts. 
    Right-click on the sheet tabs.   
    Choose the Sheet Color option from the shortcut menu.








ProfExam
PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount..

Get Now!


HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen



HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset