MS Excel Test

MS Excel Test

 

Note:  All questions are posted and answers of MS Excel Test will be updated soon stay with us.


Excel contain a conditional formatting preset that highlights top/bottom values. However, using a formula instead provides more flexibility. If you have series of data with high & low magnitude values and you want to format only N number of high magnitude values in series of data, Which of the following Generic formula is valid?

a. =A1>=TOP(data,N)
b. =A1<=MAX(data,N)
c. =A1>=LARGE(data,N)
d. None of them


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?

Note: There may be more than one right answer.

a. Radar Charts
b. Pareto Charts
c. Pie Charts
d. Pyramid Charts


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?

a. Icon Scale
b. Icon Sets
c. Icon Range
d. Icon Values


Which of the following statements is True Using PivotTables and Charts?

Note: There may be more than one right answer.

a. PivotTables are extremely powerful tools for data analysis and pivot charts allow the visualization of that analysis
b. You will create a pivot table and chart of the data collected from a web survey.
c. This will allow you to find useful information about the patterns in the data and communicate those findings through a graphical means
d. Extremely powerful tools for data analysis and pivot tabel won’t the visualization of that analysis


In Excel, a data list, or database table, is a table of worksheet data that utilizes a special structure, a built-in Data Form allow the users to edit records in a data list. For smaller data list, you can use the navigation keys as well the scroll bar of the data form to locate record require editing. What type of commands can be used for locating a record if we want to make changes in it while using larger data list?

a. Search Command
b. Query Command
c. Criteria Command
d. Filter Command


Is it possible to make Pivot table using multiple sources of data?

a. If the multiple sources are different worksheets, from same workbook, then it is possible to make Pivot table using multiple sources of data.
b. If the multiple sources are different context, from same hiding, then it is possible to make Pivot table using multiple sources of data.
c. If the multiple sources are different formulas, from same handbook, then it is possible to make Pivot table using multiple sources of data.
d. None of the above


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 statement is not true?

a. Any changes that you make to a shared slicer are immediately reflected in all PivotTables that are connected to that slicer
b. When you share a slicer, you are creating a connection to another PivotTable that contains the slicer that you want to use
c. A PivotTable can have both local and shared slicers, you can enable this option under Slicer Settings
d. Any changes that you make to a shared slicer are immediately reflected in all PivotTables that are connected to that slicer


A Data Model integrates the tables, enabling extensive analysis using PivotTables __ , ___?

a. Data Mode, Power Pivot
b. Power View, Data Pivot
c. Power Pivot, Power View
d. Power Viewer, Data Viewer


In most cases the PivotTable loss the column width when it is refreshed. Which of following option is true when The PivotTable is refreshed, not to lose the width of column when it is refreshed?

a. Disabling Auto Format in PivotTable options & protect Auto Reset width
b. Only Enabling Auto Format in PivotTable options
c. Enabling preserve formatting, disabling Auto Format in PivotTable options
d. Disabling Auto Reset option on PivotTable fields


What you could do to stop the pivot table from loosing the column width upon refreshing?

a. Format loss in pivot table can be stopped simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Disable Preserve Formatting” and disable “ Auto Format” option.
b. Format loss in pivot table can be stopped simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Disable Preserve Formatting” and enable “ Auto Format” option.
c. Format loss in pivot table can be stopped simply by changing the pivot table options. Under the “Pivot Table Options” turn on the “Enable Preserve Formatting” and disable “ Auto Format” option.
d. All of the above


Prev1 of 4

Share This Post