Fiverr Microsoft Excel Test Answers 2022 - ( Latest Updated )

fiverr-microsoft-excel-test-answers

Microsoft Excel Test Answers 2022 on Fiverr. We have shared top score answers. free basic excel test for interview candidates. excel practice test. So, Just follow this question and answers then grow your career on fiverr marketplace.


People also ask:

  1. What is usually on an Excel test?
  2. What type of questions are asked in Excel test?
  3. How many questions are on the Excel test?
  4. How do you pass a proficiency test in Excel?


Fiverr Microsoft Excel Test Answers 2022

Question: one - In Microsoft stand out 2016, that of the subsequent choices will be barred in a very worksheet?

i) Ranges
ii) Formulas

  • a. solely possibility i).
  • b. solely possibility ii).
  • c. each choice i) and ii).
  • d. Neither possibility i) nor ii).



Question: two - This question relies upon the figure shown below.

Consider the stand-out sheet given within the image. What's going to be the output if you sort the formula, =COUNTA(A1:B8), in cell B9?
  • a. 5
  • b. 6
  • c. 8
  • d. 12
  • e. it'll come back a slip as a result of the formula is inaccurate.


Question: three.  This question relies upon the figure shown below

Consider the given image for the subsequent question.
There square measure red triangles within the upper-right corner of every cell below the column titled 'Class'. What do they signify?

  • a. They represent that the cells square measure containing formatted knowledge.
  • b. They represent that some knowledge validation is related to the cells.
  • c. They represent that the comments square measure related to the cells.
  • d. They represent that the cells can not be emended.

Question: four - This question relies upon the figure shown below

Consider the info given within the image. What's going to be the output if the formula, =SKEW(A2:A11), is applied to the given content in Microsoft stand out 2016?

  • a. 0
  • b. 0.14111
  • c. -1.21111
  • d. Error


Question: five - whereas mistreatment cell references with multiple worksheets in Microsoft stand out 2016, that of the subsequent choices is that the correct absolute cell reference that has got to be used for cell B2 on a sheet named 'Sheet5'?

  • a. $Sheet$5B2
  • b. $Sheet5. B2
  • c. Sheet5! B2
  • d. $Sheet5! B2


Question: six - that of the subsequent Microsoft stand out 2016 functions is employed to come back the serial range that's used for representing the date, that is that the indicated range of months before or once a mere date?
  • a. EDATE
  • b. EOMONTH
  • c. DATEVALUE
  • d. NUMBER


Question: seven - This question relies upon the figure shown below

Which of the subsequent keyboard shortcuts is employed for achieving the strikethrough result as shown within the given image?

  • a. ALT+F9
  • b. CTRL+ALT+F10
  • c. SHIFT+F5
  • d. CTRL+5


Question: eight - In Microsoft stand out 2016, however will we tend to publish a book to Power BI?

  • a. File > choices > Publish to Power Bi
  • b. File > Save As > amendment "File as type" > Publish to Bi
  • c. File > Share > Publish to Bi > Save to Cloud
  • d. File > Publish > Publish to Power Bi


Question: nine - that of the subsequent choices will be derived mistreatment the format painter in Microsoft stand out 2016?
  • a. Alignment
  • b. Background color
  • c. Cell text
  • d. None of the on top of


Question: ten - This question relies upon the figure shown below


Consider the stand-out sheet given within the image. What's going to be the output if you enter the formula, =AVERAGE(A3:C8), in cell C9?

  • a. 7
  • b. 11.25
  • c. 13.5
  • d. it'll throw a slip.


Question: eleven - This question relies upon the figure shown below

Suppose that you just have a table in a very worksheet of Microsoft stand out 2016 book, as shown within the image. That of the subsequent output is obtained if you decide on the table and check the overall Row possibility below the planning tab?
  • a. 15
  • b. 18
  • c. 29
  • d. 79



Question: twelve - By default, what percentage worksheets square measure there in a very new Microsoft stand out 2016 workbook?
  • a. One
  • b. Two
  • c. Three
  • d. Five


Question: thirteen - This question relies upon the figure shown below

Consider the stand-out sheet given within the image. What's going to be the output if we tend to apply the formula, =AVERAGE IFS(D2:D7, A2:A7, 2016, B2:B7, ">6")?
  • a. 4
  • b. 6
  • c. 10
  • d. 16


Question: fourteen - that of the subsequent functions is employed for providing the decimal range of the time diagrammatic by a text string?
  • a. Now()
  • b. Trend()
  • c. TimeValue()
  • d. Numbervalue()



Question: fifteen - In Microsoft stand out 2016, once will we receive a "#Value!" error within the VLOOKUP function?

  • i) once the "lookup_value" argument is over 255 characters.
  • ii) once the "col_index_num" argument contains text.
  • iii) once the "col_index_num" argument is up to zero.
  • a. solely possibility i) is correct.
  • b. solely choices i) and ii) square measure correct.
  • c. solely choices ii) and iii) square measure correct.
  • d. All choices i), ii) and iii) square measure correct.


Question: sixteen - that of the subsequent keyboard shortcuts is employed to show or hide the ribbon in Microsoft stand out 2016?
  • a. Alt+F1
  • b. Alt+Shift+F1
  • c. Ctrl+F1
  • d. F1



Question: seventeen - By default, all cell references in Microsoft stand out 2016 are:
  • a. Relatives.
  • b. Absolute.
  • c. none of the on top of.


Question: eighteen - what is going to happen if you enter XYZ1 during a cell and drag the fill handle down?


  • a. it'll fill XYZ1 all told the cells that area unit dragged through.
  • b. it'll fill the series with XYZ2, XYZ3, XYZ4 so on, severally.
  • c. it'll fill the series with XYZ2, ABC3, DEF4 so on, severally.
  • d. None of the on top of.



Question: nineteen - that of the subsequent choices is that the correct keyboard cutoff for accessing the backstage read in Microsoft stand out 2016?

  • a. Ctrl + B
  • b. Alt + F
  • c. Alt + B
  • d. Tab + F



Question: twenty - In Microsoft stand out 2016, that of the subsequent tabs can you click for accessing the read Macros option?
  • a. Developer
  • b. Review
  • c. View
  • d. Home


Question: twenty-one - This question is predicated upon the figure shown below

Consider the info given within the image. What is going to be the output if the formula, =PROPER(A1), is applied to cell A2?
  • a. this is often a Book
  • b. this is often A Book
  • c. this is often a book
  • d. it'll throw a slip-up as a result of the formula cannot contain cell reference.


Question: twenty-two - This question is predicated upon the figure shown below

In Microsoft stand out 2016, what is going to happen after we click on the marked triangle as shown within the given image?
  • a. it'll choose cell A1.
  • b. it'll choose the entire Worksheet.
  • c. it'll choose all the Worksheets obtainable during a book.
  • d. it'll add a Worksheet to the file.


Question: twenty-three - that of the subsequent logical functions does not come True or False as a lead to Microsoft stand out 2016?

  • a. and performance
  • b. IF operate
  • c. OR operate
  • d. XOR operate



Question: twenty-four - This question is predicated upon the figure shown below

Consider the info given within the image. What is going to be the output if the formula, =SKEW(A2:A11), is applied to the given content in Microsoft stand out 2016?

  • a. 0
  • b. 0.14111
  • c. -1.21111
  • d. Error


Question: twenty-five - What is/are the default file extension(s) of a Microsoft stand out 2016 workbook?
  • a. . XLS
  • b. . XLSX
  • c. . Doc
  • d. each choice's a and b.


Question: twenty-six - that of the subsequent choices may be used for checking the protection standing of a go in Microsoft stand out 2016?

  • a. Click on the Review tab > choose New > Click on shield book
  • b. Click on the File tab > choose choices > Click on shield book
  • c. Click on the File tab > choose data > Click on shield book
  • d. Click on the Review tab > choose Account > Click on shield book


Question: twenty-seven - The IT section of Mark's organization has determined that solely digitally signed macros are going to be allowed in Microsoft stand out 2016. That of the subsequent is that the correct thanks to prohibit the unsigned macros?

  • a. move to the File tab -> Click data -> Click stand out choices -> Click Security-> choose to enable digitally signed macros solely
  • b. move to the File tab -> Click data -> Click stand out choices -> Click Security-> choose Disable All macros except digitally signed macros
  • c. move to the File tab -> Click choices -> Click Trust Center underneath the stand-out choices dialog box-> Click Trust Center Settings -> Click Macro Settings -> choose Disable All macros except digitally signed macros
  • d. move to the File tab -> Click choices -> Click Trust Center underneath the stand-out choices dialog box -> Click Macros -> choose Disable All macros except digitally signed macros

Question: twenty-eight - In Microsoft stand out 2016, that of the subsequent choices provides a user the access to choices like Share, Export, Account, Publish, etc.?

  • a. Ribbon
  • b. View tab
  • c. Backstage read
  • d. Page Layout tab


Question: twenty-nine opt for True or False.

If a user specifies a print space from the backstage read, then it saves the setting with the book.

  • a. True
  • b. False


Question: thirty - This question is predicated upon the figure shown below


From the given image, that of the subsequent choices ought to be selected, to modify Page Break Preview in Microsoft stand out 2016?

  • a. 1
  • b. 2
  • c. 3
  • d. None of the on top of.


Question: thirty-one - In Microsoft stand out 2016, that of the subsequent isn't a sound choice for Macro Settings underneath the Trust Center?

  • a. Disable all macros while not notification.
  • b. Disable all macros with notification.
  • c. Disable all macros as well as digitally signed macros.
  • d. modify all macros.
  • e. Disable all macros except digitally signed macros.


Question: thirty-two - In Microsoft stand out 2016, the opt for operate may be used for choosing up to what number values supported associate degree index number?
  • a. 64
  • b. 128
  • c. 254
  • d. 508


Question: thirty-three - that of the subsequent commands in Microsoft stand out 2016 permits a user to mechanically produce teams and use common functions like add, count and average for serving to in summarizing data?

  • a. Group
  • b. Filter
  • c. information Validation
  • d. Subtotal


Question: thirty-four - In Microsoft stand out 2016, that of the subsequent arguments of the YEARFRAC perform is/are optional?


  • i) begin date.
  • ii) finish date.
  • iii) the kind of day count basis to use.
  • a. solely choice ii).
  • b. solely choices i) and ii).
  • c. solely choice iii).
  • d. solely choices ii) and iii).


Question: thirty-five - In Microsoft stand out 2016, the Save As choice is accessed from that of the subsequent tabs?

  • a. File
  • b. Home
  • c. Review
  • d. View


Question: thirty-six - In Microsoft stand out 2016, what's the proper perform of the Format Painter option?

  • a. To edit fonts.
  • b. To insert functions.
  • c. to repeat and paste the data format of 1 cell to a different during a Worksheet.
  • d. To kind and filter information.



Question: thirty-seven - that of the subsequent statements is correct concerning subtotal and total fields during a Microsoft stand out 2016 PivotTable report?

  • a. If a calculated item is contained by a field, then the subtotal outline perform can't be modified.
  • b. Sum, count, and average functions is used as a subtotal.
  • c. volt-ampere and Varp functions can't be used as a subtotal.
  • d. None of the higher than.


Question: thirty-eight - however will we tend to outline a reputation to a cell during a Microsoft stand out 2016 Worksheet?

  • a. Right-click on the cell and click on "Define Name".
  • b. Click on the "Formulas" tab and click on "Define Name" underneath the "Define Names" cluster.
  • c. Click on the "Home" tab and click on "Format" underneath the "Cells" cluster.
  • d. Click on the "Home" tab and click on "Define Name" underneath the "Define Names" cluster.


Question: thirty-nine - This question is predicated upon the figure shown below

Suppose that you just conducted a flair take a look at during a schoolroom to ascertain if the scholars' area unit prepared for competitive exams. Currently you would like to calculate the typical of the entire marks obtained by the scholars within the take a look at. That of the subsequent formulas is accustomed calculate the typical of the "Marks Obtained" within the cell "I4"?

  • a. =AVERAGE(B4:G4)
  • b. =AVG(B4 C4 D4 E4 F4 G4)
  • c. =(SUM(B4:G4)/COUNT(B4:G4))
  • d. each choice's a and c.
  • e. each choice's a and b.


Question: forty - that of the subsequent keyboard shortcuts is employed for moving from any cell to the start of a worksheet, i.e. cell A1?

  • a. Windows + tonality
  • b. altitude + one key
  • c. Ctrl + tonality
  • d. Windows + one key


Question: forty-one - This question is predicated upon the figure shown below

Consider the stand-out sheet given within the image. What's going to be the output if you sort the formula, =COUNTA(A1:B8), in cell B9?

  • a. 5
  • b. 6
  • c. 8
  • d. 12
  • e. it'll come a blunder as a result of the formula is inaccurate.


Question: forty-two - that of the subsequent cell references during a formula ought to be used for creating positive that a column worth doesn't amendment once copied?

  • a. A$2
  • b. $A2
  • c. ! A2
  • d. A!2



Question: forty-three - opt for True or False.

A PivotChart could be a graphical illustration for an outline of knowledge displayed during a Pivot table.

  • a. True
  • b. False


Question: forty-four - The IT department of Irvin's organization decides that the workplace information association Files should be opened during a protected read. That of the subsequent procedures ought to be opted by Irvin?

  • a. visit the read tab -> Click on Security -> Click on Protected File sorts -> Check the workplace information association Files check box
  • b. visit the File tab -> Click on choices -> Click on stand out choices -> Click on Security -> Check the Block workplace information association Files check box
  • c. visit the File tab -> Click on choices -> Click on Trust Center underneath the stand-out choices panel -> Click on File Block Settings -> Check the workplace information association Files check box
  • d. None of the higher than.



Question: forty-five - This question is predicated upon the figure shown below

Consider the given image for the subsequent question.

What will the blue triangle and border-color imply in cell B4?

  • a. They imply that a comment is related to cell B4.
  • b. They imply that a filter has been applied to cell B4.
  • c. They imply that the Goal request choice of What-if Analysis is applied to cell B4.
  • d. They imply that Track Changes has been enabled and cell B4 is emended.


Question: forty-six - whereas getting into information in associate stand out 2016 worksheet, what happens if you press the key during a cell?

  • a. you may move to succeeding column.
  • b. you may move to the primary column.
  • c. you may move to the last column.
  • d. you may move to the previous column.

Related searches:
  • microsoft excel 2016 skills test fiverr
  • fiverr microsoft excel test answers 2020
  • fiverr microsoft excel skill test answers 2021
  • fiverr computer skills test answers 2021
  • fiverr excel test answers 2022
  • fiverr microsoft word test answers
  • microsoft excel 2016 test answers
  • test gorilla excel answers