MOS Excel 2016_v1

Quan sát hình bên và đưa ra lựa chọn:

• tạo mới workbook trống

• tạo mới workbook từ một mẫu có sẵn

• chèn hình

• tạo bảng

to create a new blank workbook?

• File > New > Blank Workbook

• home > New > Blank Workbook

• View > New > Blank Workbook

• Layout > New > Blank Workbook

To insert a new worksheet?

• On the View tab, in the Cells group, click the Insert arrow, and then click Insert Sheet.

• On the Home tab, in the Cells group, click the Insert arrow, and then click Insert Sheet.

• On the Insert tab, in the Cells group, click the Insert arrow, and then click Insert Sheet.

• On the Layout tab, in the Cells group, click the Insert arrow, and then click Insert Sheet.

To open the Move Or Copy dialog box?

• 3

• 4

• 5

• 6

Look at the picture and anwser?

• insert worksheet

• insert table

• insert workbook

• insert picture

To import the contents of a text (.txt) or comma-separated values (.csv) file

• On the Data tab, in the Get External Data group, click From Text.

• On the Insert tab, in the Get External Data group, click From Text.

• On the View tab, in the Get External Data group, click From Text.

• On the Layout tab, in the Get External Data group, click From Text.

search for data within a workbook?

• Home > Find & select > Find

• Home > Find & select > Goto

• Home > Find & select > Replace

• Home > Find & select > Comments

To move to a named cell, range, or workbook element

• Open the Go To dialog box. Click a named element in the Go to list, and then click OK.

• Open the Find dialog box.

• Open the Replace dialog box.

• không xác định được hướng đi

look at the picture and anwser.

• link to internal and external locations and files

• link to internal and external picture

• link to internal and external shapes

• link to internal and external symbols

To create a hyperlink to a webpage

• insert> hyperlink

• Home > hyperlink

• Layout > hyperlink

• Formula > hyperlink