Upwork Test Answers | MS Excel Upwork Test Answers 2019
- 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
- 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 ___________ ?
- Which among following settings is the default macro security setting by?
- Disable all macros with notification
- 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.
- 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.
- 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)
- 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.
- 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?
- 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?
- What is the filename extension of Excel workbooks which are saved as ‘Excel Templates’?
- 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 ?
- 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.
- What are Information Functions in Excel?
- 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)
- 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
- 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.
- A Data Model integrates the tables, enabling extensive analysis using PivotTables ________ , ________
- 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.
- Select Home->Fill->Series. Excel displays the series dialog box. Which of the following represent the “Growth” type?
- Excel provides _______, which are labels applied to a single cell or to a range of cells.
- An Excel workbook is a collection of?
- 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?
- Which of the following formulas uses absolute references?
- 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
- Tables offer which of the following advantages?
- 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?
- 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?
- To show the actual formula instead of Cell Values which of the following function can be used?
- A worksheet range can be defined as which of the following?
- 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))}
- 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
- Which of the function listed will not work if you are looking for an exact value based on a right looking column?
- 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 � ?
- 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.
- 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.
Which of the following error values is returned if multiple records are matched?
- Which of the following depicts a correct range?
- Which of the following is/are array formulas?
- =B12:B16*E12:E16
- =SUM(B12:B16*E12:E16)
No comments:
Post a Comment