Download Excel 2013 Expert Part One.77-427.CertDumps.2018-03-23.12q.tqb

Vendor:	Microsoft
Exam Code:	77-427
Exam Name:	Excel 2013 Expert Part One
Date:	Mar 23, 2018
File Size:	6 MB

Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

Demo Questions

Change the numbering formats for cell ranges.

* Cell range I7:J7

Accounting

5 decimal places

$ English (United States)

* Cell range I8:J8

Accounting

5 decimal places

¥ Japanese

See the explanation

Correct answer: A

Explanation:

Step 1: Click cell I7, Shift-click cell J7, right-click in this area, and from the context menu select Format Cells. Step 2: In the Format Cells dialog box select Category Accounting, change Decimal places to: 5, and click OK. Step 3: Click cell I8, shift-click cell J8, right-click in this area, and from the context menu select Format Cells.Step 4: In the Format Cells dialog box select Category Accounting, change Decimal places to: 5, set Symbol to: ¥ Japanese, and click OK. Result will be like:

Step 1: Click cell I7, Shift-click cell J7, right-click in this area, and from the context menu select Format Cells.

Step 2: In the Format Cells dialog box select Category Accounting, change Decimal places to: 5, and click OK.

Step 3: Click cell I8, shift-click cell J8, right-click in this area, and from the context menu select Format Cells.

Step 4: In the Format Cells dialog box select Category Accounting, change Decimal places to: 5, set Symbol to: ¥ Japanese, and click OK.

Result will be like:

Conditional Formatting.

Use a formula to determine formatting of a cell.

Cell I3

Apply formatting if cell is more than three days prior to current date

Use Function TODAY()

Format with Custom solid fill color (RGB – R:255 G:59 B:59)

See the explanation

Correct answer: A

Explanation:

Step 1: Click cell I3.Step 2: In the Home tab, click Conditional Formatting, and select New Rule. Step 3: In the New Formatting Rule dialog box select Use a formula to determine which cells to format, in the Formal Values where this formula is true type: =TODAY()-I3>3, and then click the Format button. Step 4: In the Format Cells dialog box click the Fill tab, click More Colors, in the Colors Dialog box click the Custom tab, change Green to 59, change Blue to 59, click OK, click OK, and finally click OK in the New Formatting Rule dialog box.

Step 1: Click cell I3.

Step 2: In the Home tab, click Conditional Formatting, and select New Rule.

Step 3: In the New Formatting Rule dialog box select Use a formula to determine which cells to format, in the Formal Values where this formula is true type: =TODAY()-I3>3, and then click the Format button.

Step 4: In the Format Cells dialog box click the Fill tab, click More Colors, in the Colors Dialog box click the Custom tab, change Green to 59, change Blue to 59, click OK, click OK, and finally click OK in the New Formatting Rule dialog box.

Insert a comment in a cell.

Cell I3

Comment text "If red fill is present, update exchange rates"

See the explanation

Correct answer: A

Explanation:

Step 1: Right-Click in cell I3, and select Insert comment from the context menu. Step 2: Type: If red fill is present, update exchange rates Step 3: Click cell I3.You can test by hover above cell I3:

Step 1: Right-Click in cell I3, and select Insert comment from the context menu.