Fiverr skill test answer
Fiverr English Test
The girl with the hair is Jenny.
curl
curling
curly
curled
๐๐๐Which of the following sentences is punctuated correctly?
"I can't start the meeting", said Ms. Lee, "without the entire staff present".
"I can't start the meeting, said Ms. Lee, without the entire staff present."
"I can't start the meeting," said Ms. Lee, "without the entire staff present."
"I can't start the meeting," said Ms. Lee, "Without the entire staff present."
๐๐๐Fill in the blank with the correct word or phrase. You haven't seen my car keys, ?
did you
have you
you have
you did
๐๐๐Fill in the blank with the correct word or phrase.
Do you know if Roger got he applied for week?
job, last
the job, last
job, the last
the job, a last
๐๐๐
Fill in the blank with the correct word or phrase. is broken and we need to buy new one.
Phone, the
The phone, a
The phone, the
Phone, a
๐๐๐
Fill in the blank with the correct word.
Professor Grant thought the presentation was unacceptable.
completely
complete
completing
completed
๐๐๐
Fill in the blank with the correct word or phrase.
Kim suggested at 5 p.m. to discuss our progress.
to meeting
of meeting
meeting
for meeting
๐๐๐
Fill in the blank with the correct word.
The driver was able to repair the tire, there were tools in the trunk of the car.
although
whether
as
whereas
๐๐๐
Fill in the blank with the correct word or phrase.
I haven't seen Joanna last Friday.
from
on
since
at
๐๐๐
Fill in the blank with the correct word.
The company decided logo was outdated.
it's
it
its
itself
๐๐๐
Fill in the blank with the correct word or phrase.
The pest control team will arrive 10 a.m.
on
for
in
at
๐๐๐
Fill in the blank with the correct word or phrase.
I will present first unless someone the agenda.
will change
changes
would change
will have changed
๐๐๐
Fill in the blank with the correct word(s).
James Jessie are getting promoted.
Whether, or
As much, as
Both, and
Just as, so
๐๐๐
Fill in the blank with the correct word or phrase.
The research department found that adding more oxygen to the mixture was the solution the problem.
of
in
for
to
๐๐๐
Fill in the blank with the correct word.
Aunt Ann walked for one hour.
quick
abrupt
brisk
briskly
๐๐๐
Fill in the blank with the correct word.
Tomorrow Ms. Rogers will tell us she has decided to do.
which
who
what
how
๐๐๐
Fill in the blank with the correct word or phrase.
is one of my favorite pastimes.
Reading
To read
To have read
Of reading
๐๐๐
Fill in the blank with the correct word.
A huge traffic jam prevented Lila getting to the airport on time.
from
to
for
against
๐๐๐
Fill in the blank with the correct word or phrase.
What is ocean in ?
largest, world
the largest, the world
a largest, world
an largest, a world
๐๐๐
Fill in the blank with the correct punctuation.
The event will start at 6 p.m. sharp
?
. (comma)
,
;
Fiverr Microsoft excel 2016 skill test
๐๐๐
In Microsoft Excel 2016, which of the following tabs will you click for accessing the View Macros option?
Developer
Review
View
Home
๐๐๐
Which of the following options is NOT a correct method for consolidating data in Microsoft Excel 2016?
Consolidation by position.
Consolidation by category.
Consolidation by data type.
None of the above.
๐๐๐
Which of the given types of pivot charts can be used in Microsoft Excel 2016? (Not Verified)
1. Pie chart
2. Waterfall chart
3. Treemap chart
All 1, 2, and 3
Only 1 and 2
Only 1 and 3
Only 2 and 3
๐๐๐
Which of the given page margins are available under the Page Layout tab in Excel 2016?
1. Normal
2. Wide
3. Narrow
All 1, 2, and 3
Only 1 and 2
Only 1 and 3
Only 2 and 3
๐๐๐
This question is based on the graphic shown below.
The cursor in the given image is on A3 cell. If you want to move the cursor to E8 cell, then which of the following shortcuts can be used? (Not Verified)
Ctrl + L
Shift + Z
Ctrl + end
Shift + end
๐๐๐
In Microsoft Excel 2016, which of the followings is NOT a valid option for Macro Settings under the Trust Center?
Disable all macros without notification.
Disable all macros with notification.
Disable all macros including digitally signed macros.
Enable all macros.
Disable all macros except digitally signed macros.
๐๐๐
Which of the following is the correct function of the Wrap Text in Microsoft Excel 2016?
It is used to merge multiple cells to one cell.
It is used to delete the hidden text from a cell.
It is used to convert extra-long text of a cell into multiple lines so that user can see all of it.
None of the above.
๐๐๐
In the given diagram of a Pivot chart in Microsoft Excel 2016, the "brush" symbol indicates which of the following options?
Chart Color
Chart Elements
Format Painter
Chart Style
๐๐๐
In Excel 2016, which of the following options is the correct procedure that is used for converting a table to a regular range?
Click anywhere on the table -> Click on the Design option under Table Tools -> Click on the Convert to Range option under the Tools group.
Right-click on the table -> Click on the Design option -> Select the Convert to Range option.
Click anywhere on the table -> Click on the Developer option under Table Tools -> Click on the Convert to Range option under the Tools group.
Right-click on the table -> Click on the Filter option -> Select the Convert to Range option.
๐๐๐
Which of the following keyboard shortcuts is used for moving from any cell to the beginning of a worksheet, i.e. cell A1?
Windows + Home key
Alt + 1 key
Ctrl + Home key
Windows + 1 key
๐๐๐
From the given image, which of the following options should be selected, in order to enable Page Break Preview in Microsoft Excel 2016?
1
2
3
None of the above.
๐๐๐
In Microsoft Excel 2016, which of the following values can be returned by the ISTEXT() function?
TRUE
FALSE
0
-1
๐๐๐
In Microsoft Excel 2016, the CHOOSE function can be used for selecting up to how many values based on an index number?
64
128
254
508
๐๐๐
Which of the following statements is/are correct about Track Changes in Microsoft Excel 2016?
A workbook is automatically shared when the Track Changes option is turned on.
Excel can track all types of changes in a Worksheet.
The Track Changes option can be accessed from the View tab.
All of the above statements are correct.
๐๐๐
Which of the following types of filters can be created using the AutoFilter option in Microsoft Excel 2016?
i) By list values.
ii) By format.
iii) By criteria.
Only option ii).
Only options ii) and iii).
Only options i) and iii).
All options i), ii) and iii).
๐๐๐
In Microsoft Excel 2016, which of the following options is used to access the option that is used to get data from a text file?
Click the Data tab -> Select the option "From Other Sources" from the Get External Data group-> Click "From Text"
Click the Data tab -> Select the option "Existing Connections" from the Get External Data group-> Click "From Text"
Click the Data tab -> Select the option "From Text" from the Get External Data group
Click the Formulas tab -> Select the option "From Text" under the Connections group
๐๐๐
Which of the following functions checks whether all the arguments are TRUE, and returns TRUE if all the arguments are TRUE?
AND
OR
IF
XOR
๐๐๐
In relation to building out the PivotTable, which of the following fields are added to the COLUMNS area?
Non-numeric fields
Date and time hierarchies
Numeric fields
๐๐๐
Which of the following statements is/are correct about macro naming rules in Microsoft Excel 2016?
A macro name's first character must be a letter.
A macro name can contain spaces.
An underscore cannot be used in a macro name.
A macro name cannot contain numbers.
๐๐๐
Which of the following functions can be performed on a protected worksheet if the password is not known?
We can copy and paste data from the protected sheet to a new Workbook.
Insert columns are protected, but delete columns are not protected, therefore, we can only insert columns but can't delete columns in the protected worksheet.
We can paste data into the protected worksheet.
We can de-crypt the password of the protected sheet.
๐๐๐
In order to protect your Excel data, which of the given file-level protections are available in Microsoft Excel 2016?
1. File encryption
2. Setting a password to open or modify a file
3. Digital signature
All 1, 2, and 3
Only 1 and 2
Only 1 and 3
Only 2 and 3
๐๐๐
While working in Microsoft Excel 2016, for which of the following options, if included in a worksheet, we cannot use the Track Changes option? (Not Verified)
Comment
Table
Chart
Picture
๐๐๐
In Microsoft Excel 2016, the Split command enables a user to view a worksheet in how many panes? (Not Verified)
Two
Three
Four
Five
๐๐๐
Which of the following commands is used in Microsoft Excel 2016 for totaling all the budget spreadsheets prepared by each department in an organization?
Sort
AutoSum
Filter
Consolidate
๐๐๐
In relation to the Backstage view in Microsoft Excel 2016, which of the given commands/options are available under the Info tab? (Not Verified)
1. Protect Document
2. Manage Workbook
3. Browser View Options
All 1, 2, and 3
Only 1 and 2
Only 1 and 3
Only 2 and 3
๐๐๐
Which of the following can be used to avoid users to make changes to a worksheet in Microsoft Excel 2016?
By providing Read Only access.
By password protecting a Workbook.
Restricting permissions by Information Rights Management (IRM).
All of the above.
๐๐๐
In Microsoft Excel 2016, when do we receive a "#Value!" error in the VLOOKUP function?
i) When the "lookup_value" argument is more than 255 characters.
ii) When the "col_index_num" argument contains text.
iii) When the "col_index_num" argument is equal to 0.
Only option i) is correct.
Only options i) and ii) are correct.
Only options ii) and iii) are correct.
All options i), ii) and iii) are correct.
๐๐๐
In Excel 2016, the Lookup & Reference option is available under which of the following tabs?
Insert
Page Layout
Formulas
Review
๐๐๐
How can we define a name to a cell in a Microsoft Excel 2016 Worksheet? (Not Verified)
Right-click on the cell and click on "Define Name".
Click on the "Formulas" tab and click on "Define Name" under the "Define Names" group.
Click on the "Home" tab and click on "Define Name" under the "Define Names" group.
Both options a) and b) can be used to define a name.
Both options a) and c) can be used to define a name.
๐๐๐
Which of the following keyboard shortcuts is used for achieving the strikethrough effect as shown in the given image?
ALT+F9
CTRL+ALT+F10
SHIFT+F5
CTRL+5
๐๐๐
Which of the following options is the correct keyboard shortcut for accessing the backstage view in Microsoft Excel 2016?
Ctrl + B
Alt + F
Alt + B
Tab + F
๐๐๐
In Microsoft Excel 2016, what will happen when we click on the marked triangle as shown in the given image?
It will select cell A1.
It will select the complete Worksheet.
It will select all the Worksheets available in a Workbook.
It will add a Worksheet to the file.
๐๐๐
Which of the following cell references in a formula should be used for making sure that a column value does not change when copied?
A$2
$A2
!A2
A!2
๐๐๐
This question is based on the graphic shown below.
Consider the Excel sheet given in the image. What will be the output if you enter the formula, AVERAGE(A3:C8), in cell C9?
7
11.25
13.5
It will throw an error.
๐๐๐
In Microsoft Excel 2016, Consolidate option is available under which of the following tabs?
Data
View
Formula
Insert
๐๐๐
In Microsoft Excel 2016, Record Macro option is available under which of the following tabs?
Data
Review
View
Developer
๐๐๐
This question is based on the graphic shown below.
Consider the Excel sheet given in the image. What will be the output if you type the formula, COUNTA(A1:B8), in cell B9?
5
6
8
12
It will return an error because the formula is incorrect.
๐๐๐
In Microsoft Excel 2016, which of the following options provides a user the access to options such as Share, Export, Account, Publish, etc.?
Ribbon
View tab
Backstage View
Page Layout tab
๐๐๐
How can we remove password encryption from a Microsoft Excel 2016 file?
Open the Workbook and save it again with a new password.
Copy and paste the data in another Workbook and save it.
Enter the password of the Workbook and delete the password in the Permissions - Encrypt with Password box.
Open the Workbook and from the file menu, select Protect Workbook-Decrypt the Workbook
๐๐๐
In relation to the Cube function in Excel 2016, which of the following functions returns an aggregated value from the cube?
CUBESET
CUBEMEMBERPROPERTY
CUBEVALUE
CUBEKPIMEMBER
๐๐๐
This question is based on the graphic shown below.
๐๐๐
What will happen if you enter XYZ1 in a cell and drag the fill handle down?
It will fill XYZ1 in all the cells that are dragged through.
It will fill the series with XYZ2, XYZ3, XYZ4 and so on, respectively.
It will fill the series with XYZ2, ABC3, DEF4 and so on, respectively.
None of the above.
๐๐๐
In Microsoft Excel 2016, which of the following is the correct syntax of the VLOOKUP command?
=VLOOKUP (value, table, col_index, [range_lookup))
=VLOOKUP (col_index, [range_lookup])
=VLOOKUP (table, [range_lookup)), value, col_index)
=VLKUP (value, col_index, table, [range_lookup])
๐๐๐
Which of the following logical functions doesn't return True or False as a result in Microsoft Excel 2016?
AND Function
IF Function
OR Function
XOR Function
๐๐๐
Consider the Excel sheet given in the image. If you wanted to find out the average of all the cells that meet multiple criteria which function would you use?
AVERAGEIFS
AVERAGEA
AVERAGEIF
AVERAGE
๐๐๐
Which of the following commands in Microsoft Excel 2016 allows a user to automatically create groups and use common functions such as sum, count and average for helping in summarizing data?
Group
Filter
Data Validation
Subtotal
๐๐๐
What is/are the default file extension(s) of a Microsoft Excel 2016 workbook?
.xls
xlsx
.doc
Both options a and b.
๐๐๐
Suppose that you have a table in a worksheet of Microsoft Excel 2016 workbook, as shown in the image. Which of the following output is obtained if you select the table and check the Total Row option under the Design tab? (Not verified)
ฮ 15
ฮ 18
ฮ 29
ฮ 79
๐๐๐
While editing a cell's content, if you change your mind about the changes you made before pressing the enter key, which of the following keys can be pressed to restore to the original text?
F4
Tab
Esc
Alt
๐๐๐
The IT security department of Mark's organization has decided that only digitally signed macros will be allowed in Microsoft Excel 2016. Which of the following is the correct way to restrict the unsigned macros?
Go to the File tab -> Click Info-> Click Excel Options -> Click Security-> Select Allow digitally signed macros only
Go to the File tab -> Click Info-> Click Excel Options -> Click Security-> Select Disable All macros except digitally signed macros
Go to the File tab -> Click Options -> Click Trust Center under the Excel Options dialog box-> Click Trust Center Settings - > Click Macro Settings -> Select Disable All macros except digitally signed macros
Go to the File tab -> Click Options -> Click Trust Center under the Excel Options dialog box -> Click Macros -> Select Disable All macros except digitally signed macros
๐๐๐
What happens when the Freeze Panes option is used on some of the rows and columns in Microsoft Excel 2016?
It keeps the rows and columns visible when the rest of the worksheet is scrolled.
It hides the selected rows and columns.
The selected rows and columns cannot be edited while the rest of the worksheet can be edited.
The selected rows and columns can accept only a particular type of data.
๐๐๐
Choose True or False.
With respect to Protect Workbook in Microsoft Excel 2016, the Windows option can be used for preventing users from moving, resizing or closing the workbook window. (Not Sure)
True
False
๐๐๐
Choose True or False.
If a user specifies a print area from the backstage view, then it saves the setting with the workbook. (Not Sure)
True
False
๐๐๐
Which of the given statements are correct about the slicers in Microsoft Excel 2016? (Not Sure)
1. They can be used to filter data in a table.
2. They can be used to filter data in a PivotTable.
3. They can only be connected to PivotTables that share the same data source.
Only 1 and 2
Only 1 and 3
Only 2 and 3
All 1, 2, and 3
๐๐๐
In Microsoft Excel 2016, which of the following options is used for limiting or restricting the cell entries to a certain data type?
Manage Data Model
Filter
Advanced
Data Validation
๐๐๐
John inserts a PivotTable in a worksheet, as shown in figure 1 of the given image. There are three columns in the data source: Employee, Product and Sales. Now John wants to show the list of products under the employee names as shown in figure 2 of the given image. Where should he double-click on the PivotChart in figure 1, so that he should be able to select the Product column?
On the header of the Employee column.
On the values of the Sum of Sales column.
On the values of the Employee column.
On the header of the Sum of Sales column.
๐๐๐
In Microsoft Excel 2016, the TODAY() command returns:
the current day name.
the date when the Excel file was created.
the current day and date.
the current date.
๐๐๐
What are the correct purposes of CEILING.MATH() function in Microsoft Excel 2016? (Not Sure)
It rounds a number up, to the nearest integer.
It rounds a number up, to the nearest multiple of significance.
It rounds a number down, to the nearest even integer.
It rounds a number up, to the nearest odd integer.
๐๐๐
Can we change the default font size of a new workbook in Excel 2016 from the Backstage view? (Not Sure)
Yes
No
๐๐๐
In Microsoft Excel 2016, which of the following commands should NOT be removed from the Quick Access Toolbar because these commands are NOT available on the ribbon's command tabs?
Save
Redo
Copy
Both options a) and b)
๐๐๐
This question is based on the graphic shown below.
Adobe Illustrator CC (2017) Test
In Adobe Illustrator CC (2017), which of the following keyboard shortcuts allows you to open the file information dialog box? (Not Sure)
Ctrl+I
Ctrl+Shift+I
Alt+Shift+Ctrl+I
None of the above.
๐๐๐
In Adobe Illustrator CC (2017), what is a path's outline called?
Stroke
Line
Fill
Outline Style
๐๐๐
In Adobe Illustrator CC (2017), which of the following preview modes displays a simulated, rasterized (pixelated) appearance of the content in a document?
Pixel
Overprint
Default
None of the above.
๐๐๐
Working with the Live Corners widget in Adobe Illustrator CC (2017), you can apply various corner styles in your shape, except for:
Round corner.
Curved corner.
Inverted Round corner.
Chamfer corner.
๐๐๐
In Adobe Illustrator CC (2017), you can place objects in different places in the workspace. Which of the following keyboard shortcuts is used for pasting an object in place?
Ctrl+F
Ctrl+B
Ctrl+V
Shift+Ctrl+B
๐๐๐
Which of the following options is an Adobe Illustrator CC (2017) feature that is used to convert and save vector graphics into bitmap files?
Pathfinder
Expand
Rasterize
Group
๐๐๐
Which of the following statements is incorrect about aligning an object with the pixel grid? (Not sure)
You can pixel-align particular segments of an object.
The Align selected art to pixel grid option can be found in the control panel.
Objects that do not have any vertical or horizontal segments can be modified to align with the pixel grid.
Illustrator prompts you if the art in the selection cannot be pixel-aligned.
๐๐๐
Which of the following statements are correct about importing AutoCAD files in Adobe Illustrator CC (2017)?
AutoCAD files saved in versions later than AutoCAD 2007 cannot be opened in Adobe Illustrator CC (2017).
Adobe Illustrator CC (2017) supports only the .DWG AutoCAD file format.
While importing an AutoCAD file in Adobe Illustrator CC (2017), you can scale the file and select the layout to import.
Adobe Illustrator CC (2017) supports 2d AutoCAD objects, including paths, lines, texts but not 3D objects.
๐๐๐
You want to prevent your artwork from exporting and printing. Which step should you take? (Not Sure)
Hide the corresponding items in the Layers panel.
Select Template in the Layer Options dialog box and then create the artwork.
Deselect the print option in the Layer Options dialog box.
The said feature is not possible in Illustrator.
๐๐๐
In Adobe Illustrator CC (2017), which functional key is used to show and hide the Layers panel?
F6
F7
F8
F9
๐๐๐
Which of the following tools is used to cut objects along a freehand path drawn with it, and to divide objects into component- filled faces?
Scissors
Pathfinder
Knife
Trim
๐๐๐
Which effect in Illustrator CC (2017) sharply defines a selection by clumping pixels of similar color value?
Pixelate
Sharpen
Texture
Stylize
๐๐๐
In Adobe Illustrator CC (2017), which of the following SVG events triggers an action while the mouse pointer is over an element in your imported artwork for web browser viewing?
onmouseover
onmouseout
onmousemove
onmousedown
๐๐๐
In Adobe Illustrator CC (2017), the keyboard shortcut 'Shift+Ctrl+F9' is used to show/hide which of the following panels? (Not sure)
Transform
Pathfinder
Transparency
Symbols
๐๐๐
Complete the following sentence.
While using the Live Corners feature in Adobe Illustrator CC (2017), a corner cannot be rounded beyond a point: (Not sure)
where the rounded corner reaches the end of the path.
where the rounded corner reaches an adjacent anchor point.
where the rounded corner reaches an anchor point being created while modifying an adjacent corner.
All of the above.
๐๐๐
This question is based on the graphic shown below.
Which Illustrator option will produce the same effect as shown in the given image?
Graphic Pen
Contรฉ Crayon
Bas Relief
Craquelure
๐๐๐
In Adobe Illustrator CC (2017), which of the following pathfinder effects is used to divide an object into its component line segments, or edges?
Crop
Merge
Outline
Trim
In Adobe Illustrator CC (2017), you can use which key to toggle between screen modes?
F
T
B
S
๐๐๐
In Adobe Illustrator CC (2017), which of the following types of printer's marks align different separations in a color document?
Trim Marks
Registration Marks
Color Bars
Page Information
๐๐๐
In Adobe Illustrator CC (2017), Envelopes are used to reshape or distort a selected object. They cannot be used on which of the following objects? (Not Sure)
Preset warp shape
Mesh grid
Graph
๐๐๐
What does the term "PPI" stand for?
Parts per inch
Points per inch
Pixels per inch
None of the above.
๐๐๐
Comments
Post a Comment