find anything here

find anything here

Upwork Test Answers | MS Excel Upwork Test Answers 2017

upwork excel test answers

Upwork Test Answers | MS Excel Upwork Test Answers 2017

Hello My Friends,

Today I am available for you with Upwork Test Answers |MS Excel Upwork Test Answers 2017. I got many requests to write an article on Upwork Test Answers – MS Excel. It’s my pleasure that I could make available this article for you guys. I hope this article will help you to crack Excel Exam. There are some questions missing here but I will update them soon. If this article helpful please comment below, It will help me to improve my articles.


  1. Which of the following options are available for auto fill, when you release the mouse button after using AutoFill, Excel not only fills in the series but also displays the Auto Fill options button ?
  • Copy Cells
  • Fill Formatting Only
  1. In the case of synchronizing changes between Table and model, a linked table is a live connection between the range or named table that contains the data values, and the Data Model that powers the report, by default. The Data Model is updated automatically if changes occur in ___________ ?
  • Tables
  1. Which among following settings is the default macro security setting by?
  • Disable all macros with notification
  1. Information Rights Management (IRM) allows individuals and administrators to specify access permissions to documents, workbooks, and presentations. This helps present sensitive information from being printed, forwarded, or copied by unauthorized people. IRM cannot help with the following though:
  • Prevent content from being copied by using third-party screen capture programs.
  1. Which of the following are advantages of range names ?
  • Names are easier to remember than range coordinates.
  • Names don’t change when you move a range to another part of the worksheet.
  • Named ranges adjust automatically whenever you insert or delete rows or columns within the range.
  1. Which of the following formulas yields the address of the last cell in a range ?
  • ADDRESS(ROW(rng)+ROWS(rng)-1,COLUMN(rng)+COLUMNS(rng)-1)
  1. Some features work differently in Excel online as compared to the Excel desktop version. Which of the following is not true for Excel online?
  • Workbooks that have Information rights management(IRM) settings applied at the workbook level cannot be viewed in a browser window.
  1. In Excel, a data list, or database table, is a table of worksheet data that utilizes a special structure, a built-in Data from which allow the users to edit records in a data list. For smaller data lists, you can use the navigation keys as well the scroll bar of the data form to locate a record which requires editing. What type of commands can be used for locating a record if we want to make changes in it while using larger data lists?
  • Filter command
  1. Excel contains a conditional formatting present that highlights top/bottom values. However, using a formula instead provides more flexibility. If you have a series of data with high & low magnitude values and you want to format only N number of high magnitude values in the series of data, which of the following formulas is valid?
  • = A1<= MAX(data,N)
  1. What is the filename extension of Excel workbooks which are saved as ‘Excel Templates’?
  • .xltx
  1. By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Names must be no more than 255 characters long. You can also use any single letter as a range name except the following ?
  • R
  • C
  1. A _________ is similar to a data bar in that it compares the relative values of cells in a range. Instead of bars in each cell, you see cell shading, where the shading color reflects the cell’s value.
  • color cell
  1. What are Information Functions in Excel?
  • ISFOMULA
  • SHEET
  • SHEETS
  1. If cell A2 has a full name (Firstname, Middle Initial and Lastname) like “Karen E. McRich” which of the following formulas will extract the lastname ?
  • =Right(a2,find(“.”,a2)-1,1)
  1. We can perform what If Analysis in Excel with the use of Data Tables in which we can see the effect of changing an input value on the result returned by a formula as soon as we enter a new input value in the cell that feeds into the formula.
    which types of Data Tables can we create to perform what- If Analysis in Excel?
  • One & Two Variable Data Tables
  1. The auto calculate feature in Excel does which of the following ?
  • Provides a quick way to view the result of an arithmetic operation on a range of cells.
  1. A Data Model integrates the tables, enabling extensive analysis using PivotTables ________ , ________
  • Power Pivot, Power View
  1. What could you do to stop the pivot table from losing the column width upon refreshing?
  • Format loss in a pivot table can be prevented simply by changing the pivot table options. under the “pivot Table Options” turn on the “Enable Preserve Formatting” and disable the “Auto Format” options.
  1. Select Home->Fill->Series. Excel displays the series dialog box. Which of the following represent the “Growth” type?
  • None of above
  1. Excel provides _______, which are labels applied to a single cell or to a range of cells.
  • Range Names
  1. An Excel workbook is a collection of?
  • Worksheets and charts
  1. Anytime when you return more than single cell, you should be using array formula. Array formulas are special formulas that work on an array of numbers and it will work effectively if you press the following keys combination?
  • Ctrl+shift+enter
  1. Which of the following formulas uses absolute references?
  • =$A$1*2
  • =D11 * $C$3
  1. In most cases the PivotTable loses the column width when it is refreshed. which of following options can be used when the PivotTable is refreshed, so as to not lose the width of column ?
  • Enabling Preserve formatting and disabling Auto Format in PivotTable Options
  1. Tables offer which of the following advantages?
  • All of the above
  1. Use_____ to visualize the relative values of cells in a range. In this case, however, Excel adds a particular icon to each cell in the range, and that icon tells you something about the cell’s value relative to the rest of the range?
  • Icon Sets
  1. All 2-D and 3-D charts have an x-axis known as the horizontal axis and a y-axis known as the vertical axis. Which of the following charts don’t have x-axis and y-axis?
  • Pie Chart
  1. To show the actual formula instead of Cell Values which of the following function    can be used?
  • FORMULATEXT(cell)
  1. A worksheet range can be defined as which of the following?
  • A Group of cells
  1. Which of the following formulas yields the work hours between dates on a custom schedule?
  • {=SUM(CHOOSE(WEEKDAY(ROW(INDIRECT(date1&”:”&date2))),1,2,3,4,5,6,7))}
  1. When you have many different PivotTables in one report, you can share a slicer that you created in one PivotTable with other PivotTables. Which of the following statements is not true?
  • Any changes that you make to a shared slicer are immediately reflected in all PivotTables that are connected to that slicer
  1. Which of the function listed will not work if you are looking for an exact value based on a right looking column?
  • VLOOKUP
  1. Which of the following can be accomplished by Creating Highlighted Cell Rules?
  • What are the top 10 values
  • Which cell values are above average, and which are below average ?
  • Which cells values are duplicate  ? 
  1. Which of the following could be true when #NAME, error appears in an Excel cell?
  • You Spelled a function name incorrectly
  • you used a string value without surrounding it with quotation marks.
  1. DGET Database Function in Excel extracts a single value from a record in the data list that matches the criteria you specify. DGET Function return error value if no record matches the specified criteria or the match criteria is greater than the specified criteria.
  2. Which of the following error values is returned if multiple records are matched?

  • #NUM
  1. Which of the following depicts a correct range?
  • B1:B30
  1. Which of the following is/are array formulas?
  • =B12:B16*E12:E16
  • =SUM(B12:B16*E12:E16)

Hello Top 10 thing's lovers ! My name is Mahommad Jamaluddin Saiyed. I'm a Entrepreneur and Content Creator at alltop10.in. A Learning blogger, story-teller, and a movie freak. Don't hesitate to connect with me on social media.

3 Comments to Upwork Test Answers | MS Excel Upwork Test Answers 2017

  1. amy parris says:

    can you give more question and answer please.. i want get a good rating in test.

Leave a Reply

Your email address will not be published. Required fields are marked *

© 2017: All Top 10 |All Rights Reserved by : www.alltop10.in
%d bloggers like this: