Thi đi thi lại môn Excel 2007 –> đáp áp đây

You want to change the definition of a named range.

Incorrect

Your Answer >

a. Select the cell range.

a. Select the cell range.

a. Select the cell range.

a. Select the cell range.

I don’t know

 

An erroneous formula in a Microsoft Office Excel 2007 worksheet cell uses values from cells in other worksheets. You want to view the updated results of the formula as you change the values in the other cells.

Incorrect

Your Answer >

The Changes group on the Review tab

Your Answer >

The Function Library group on the Formulas tab

The Formula Auditing group on the Formulas tab

The Data Tools group on the Data tab

I don’t know

 

You want a Microsoft Office Excel 2007 worksheet to display arrows that connect the formula source cells to the formula target cell where the calculated value is displayed. .

Incorrect

Your Answer >

Use the Evaluate Formula option.

Use the Error Checking dialog box.

Use the Watch Window toolbar.

Use the Trace Precedents command.

I don’t know

 

You create a formula in a Microsoft Office Excel 2007 worksheet. The formula contains an error. You want to examine each part of the formula to correct the error.

Incorrect

On the Formulas tab, in the Formula Auditing group, click Evaluate Formula.

On the Formulas tab, in the Formula Auditing group, click Trace Precedents.

Your Answer >

On the Formulas tab, in the Formula Auditing group, click Show Formulas.

Your Answer >

On the Formulas tab, in the Formula Auditing group, click Trace Dependents.

I don’t know

 

You want to find the average of data in a table in a Microsoft Office Excel 2007 worksheet.

Incorrect

The Styles group on the Home tab

The Table Style Options group on the Design contextual tab

Your Answer >

The Properties group on the Design contextual tab

Your Answer >

The Number group on the Home tab

I don’t know

 

You want to find the largest value in the cells C1:C10.

Incorrect

Your Answer >

The Number group on the Home tab.

The Function Library group on the Formulas tab.

Your Answer >

The Formula Auditing group on the Formulas tab.

Your Answer >

The Data Tools group on the Data tab.

I don’t know

Gửi phản hồi

Mời bạn điền thông tin vào ô dưới đây hoặc kích vào một biểu tượng để đăng nhập:

WordPress.com Logo

Bạn đang bình luận bằng tài khoản WordPress.com Log Out / Thay đổi )

Twitter picture

Bạn đang bình luận bằng tài khoản Twitter Log Out / Thay đổi )

Facebook photo

Bạn đang bình luận bằng tài khoản Facebook Log Out / Thay đổi )

Google+ photo

Bạn đang bình luận bằng tài khoản Google+ Log Out / Thay đổi )

Connecting to %s

%d bloggers like this: