%20scale(3)'%3E%3Cpath%20id='s'%20d='M0,-30%2017.63355,24.27051%20-28.53171,-9.27051H28.53171L-17.63355,24.27051z'%20fill='%23FF0'/%3E%3C/g%3E%3Cuse%20xlink:href='%23s'%20transform='translate(300,60)%20rotate(23.036243)'/%3E%3Cuse%20xlink:href='%23s'%20transform='translate(360,120)%20rotate(45.869898)'/%3E%3Cuse%20xlink:href='%23s'%20transform='translate(360,210)%20rotate(69.945396)'/%3E%3Cuse%20xlink:href='%23s'%20transform='translate(300,270)%20rotate(20.659808)'/%3E%3C/svg%3E){kind=small}
搜索当前职位空缺：
显示过滤器
在海员简历数据库中搜索：
在线测试： Test for seafarers about how to work into Microsoft Excel (CBT)
选择测试模式：
教育
在线测试
描述
评论
问题 1 从 30
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
A cell that containing a comment is represented by:
A black border.
A small red triangle in the upper right corner.
A small green triangle in the upper left corner.
A dark square in the lower right corner.
A quick way to find and work with a subset of data in a list is:
Macro.
Filtering.
Sort.
AutoSum.
File, Edit, View, Insert, Format, Tools, Window, Help are command groups that are displayed on the:
Standard Toolbar.
Formatting Toolbar.
Menu Toolbar.
Drawing Toolbar.
How will you access Help in the MS Excel program? Several alternatives may be correct:
回答
In MS Excel, Tiled, Cascade, Horizontal are options for which command? Check all correct answers:
回答
In MS Excel, which command gives you the option to paste the formatting style of a cell to another cell?
Page Break.
Freeze Panes.
Auto Fit.
Format Painter.
In Microsoft Excel, Page breaks depend on the paper size, margin settings and scaling options:
True.
False.
In the working area of the Excel program, the whole collection or group of sheets is called the:
Cell.
Workbook.
Columns.
Worksheets.
The Find command is located in which menu?
File > Find.
Insert > Find.
Edit > Find.
Format > Find.
The Formatting of cells such as wrap text or merge cells can be done using which command?
Format > Cell > Number tab.
Format > Cell > Alignment tab.
Format > Cell > Protection tab.
Format > Cell > Pattern tab.
The Formula in Cell C3 when pasted in C4 will be:
= A4+B4.
= A3+B3.
= $A$3+$B$5.
= R1C1+R2C2.
The Formula in Cell C3 when pasted in C4 will be:
= A4+B4.
= $A$3+B3.
= $A$3+B4.
= $A$4+B4.
The feature in Excel that allows you to quickly fill cells with repetitive or sequential data is called:
Conditional Formatting.
Auto Correct.
Auto Fill.
Macros.
To add two cells (A1 and A2) together you use the following formula:
= add(A1:A2).
A1 plus A2.
= A1+A2.
= sum(A1+A2).
To arrange rows in alphabetical order based on column A, you need to use which command?
Tools > Sort.
Data > Sort.
Edit > Data > Sort.
Insert > Sort.
To view or compare two sections of a large spreadsheet you can:
Use MS Excel.
Split the screen into two panes.
Run spell check.
Divide the screen into two panes with the ruler.
True or False:
To view the hidden commands, you can click the double-headed arrow at the bottom of the Menu List.
To view the hidden commands, you need to click View > Toolbars > Visual Basic.
What are the font formatting characteristics like bold, italics and underline are called?
Fonts.
Font styles.
Formatted fonts.
Font characteristics.
What are the two types of reference styles? Check all correct answers:
回答
What is the command to set the Margins of a document?
File > Page Setup.
File > Properties.
Edit > Select All.
Insert > Break.
What is the correct option to Print a particular page from the active worksheet?
Select “All”.
Select “Current Page”.
Select “Pages”.
Select “Selection”.
What is the correct sequence of commands to add a Page Header or Page Footer?
View > Header and Footer.
Insert > Cells.
Insert > Comment.
View > Page Break Preview.
What is the default orientation for the printed page?
Portrait.
Landscape.
The last saved action.
Vertical.
What is the shortcut command for this icon?
Draw a picture.
Start the chart wizard.
Edit Colour.
Insert Column.
Which of these are the Trigonometric functions that can be used in MS Excel? Check all correct answers:
回答
Workspace can be defined as:
Chart Wizard.
A group of workbooks, which can be opened together.
Auditing of formula.
Data table.
You can exit MS Excel by:
回答
You can set the Paper Size by Clicking File > Page Setup to open the dialog box.
True.
False.
You can use the Auto Correct feature in an Excel sheet to:
回答
You can use the “Save As” command to:
回答
Тест проверяет навыки работы с программой Microsoft Excel, включая создание таблиц, управление данными и анализ информации.
只有水手才能发表评论。要发表评论，请使用您的水手帐户登录该网站。
成为第一个评论此在线测试的人！