Site categories
1/ Help

Crew Evaluation System CBT test online for seamans about how to work into Microsoft Excel

Welcome to the website where you can pass online the Computer Based Test (CBT) also known as Crew Evaluation System (CES) on the subject «Microsoft Excel». Practice like this will help you as a marine specialist improve your knowledge with the help of online studying and appraisal practice. CES/CBT based on practical information and marine specialists experience.

CES & CBT tests developed for evaluating seaman basic knowledge by Seagull Company (rebranded as «OTG»), is an evaluating online-tool, used for revealing any professional preparation needed in specific fields of knowledge, defined by STCW.

CES tests have proven themselves as good tools for the selection and recruitment process, as well as advancing the level of knowledge of the current officers and crew. Ocean Technologies Group use various subjects for question creation, which includes:

  • Crowd and Crisis Management;
  • Integrated Navigation System (INS);
  • Ballast water management;
  • Handling and Stowage;
  • Vessel operation management and safety;
  • Marine engineering;
  • Maintenance and repair, etc.

Current test contains Seagull CES questions on subject «Microsoft Excel». Those questions can be used for competence verification specialist capable of preventing accidental situations related with transporting safety, or also for self-examination.

«Microsoft Excel» subject includes theoretical and practical information about working with the Microsoft Excel program. Knowledge of this information directly shows employee’s competence who holds a relevant post on a vessel, provides creating and formatting text documents, creating charts and graphs using Microsoft services, print up-to-date information and much more.

On this site Crew Evaluation System Test on the subject «Microsoft Excel» contains 30 questions you need to answer with no possibility to go back to previous question. Therefore, we recommend carefully reading each question and making decision with no hurry. In case you have some difficulty answering, you have also possibility to request a hint.

Choose mode in which you want take CES test:

Practice - CES test
Exam - CES test
Start test
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.
Next question
A quick way to find and work with a subset of data in a list is:
Next question
File, Edit, View, Insert, Format, Tools, Window, Help are command groups that are displayed on the:
Standard Toolbar.
Formatting Toolbar.
Menu Toolbar.
Drawing Toolbar.
Next question
How will you access Help in the MS Excel program? Several alternatives may be correct:
Right Click to shortcut Menu > Help.
Click File > Properties.
Click Help > Microsoft Excel Help.
Click Help > About Microsoft Excel.
Next question
In MS Excel, Tiled, Cascade, Horizontal are options for which command? Check all correct answers:
Page Break.
Freeze Panes.
Split Window.
Arrange Window.
Next question
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.
Next question
In Microsoft Excel, Page breaks depend on the paper size, margin settings and scaling options:
Next question
In the working area of the Excel program, the whole collection or group of sheets is called the:
Next question
The Find command is located in which menu?
File > Find.
Insert > Find.
Edit > Find.
Format > Find.
Next question
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.
Next question
The Formula in Cell C3 when pasted in C4 will be:
= A4+B4.
= A3+B3.
= $A$3+$B$5.
= R1C1+R2C2.
Next question
The Formula in Cell C3 when pasted in C4 will be:
= A4+B4.
= $A$3+B3.
= $A$3+B4.
= $A$4+B4.
Next question
The feature in Excel that allows you to quickly fill cells with repetitive or sequential data is called:
Conditional Formatting.
Auto Correct.
Auto Fill.
Next question
To add two cells (A1 and A2) together you use the following formula:
= add(A1:A2).
A1 plus A2.
= A1+A2.
= sum(A1+A2).
Next question
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.
Next question
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.
Next question
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.
Next question
What are the font formatting characteristics like bold, italics and underline are called?
Font styles.
Formatted fonts.
Font characteristics.
Next question
What are the two types of reference styles? Check all correct answers:
Next question
What is the command to set the Margins of a document?
File > Page Setup.
File > Properties.
Edit > Select All.
Insert > Break.
Next question
What is the correct option to Print a particular page from the active worksheet?
Select “All”.
Select “Current Page”.
Select “Pages”.
Select “Selection”.
Next question
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.
Next question
What is the default orientation for the printed page?
The last saved action.
Next question
What is the shortcut command for this icon?

Excel - Chart Wizard

Draw a picture.
Start the chart wizard.
Edit Colour.
Insert Column.
Next question
Which of these are the Trigonometric functions that can be used in MS Excel? Check all correct answers:
Next question
Workspace can be defined as:
Chart Wizard.
A group of workbooks, which can be opened together.
Auditing of formula.
Data table.
Next question
You can exit MS Excel by:
Clicking the lower “X” icon on the top-right corner of the Window screen.
Clicking the upper “X” icon on the top-right corner of the Window screen.
Clicking File > Close from the Menu Bar.
Clicking Edit > Go to from the Menu Bar.
Next question
You can set the Paper Size by Clicking File > Page Setup to open the dialog box.
Next question
You can use the Auto Correct feature in an Excel sheet to:
Correct two initial capitals.
Clear all comments.
Capitalise names of days.
Cancel mathematical functions.
Next question
You can use the “Save As” command to:
Change the formatting of the file.
Rename a document as a backup copy.
Save a file in another folder.
Rename the table in the document.
Show result
* In some questions may be more, than one right answer.
“CES test” finished! Your result:

Did you find mistake? Highlight and press CTRL+Enter

Июль, 09, 2022 1160 0
Добавить комментарий