Final Exam: Business Analyst Study
Guide Exam And Actual Answers 2025.
You have created a Line Sparkline with a data column that has 15 different values. After creating
the Line Sparkline, you need to change the value of one of the cells. If you change the value,
what is likely to happen to the Line Sparkline? - Answer Line Sparkline will be updated
automatically
Which of the following in a bar chart is a symbol that represents a single value in a spreadsheet?
- Answer Data Marker
You have a value of 75 in the C2 cell. You need to multiply this value with a series of cells from
C5 to C10. The output of their value is placed in cells from D5 to D10. Which of the following is
the absolute reference? - Answer C2
In an Excel worksheet, you have copied a cell that contains a formula. You want to paste the
contents of this cell to another cell but only the numbers. You do not want to copy the formula.
Which of the following option of Paste Special should you use? - Answer Values
You are customizing the ribbon in Excel. Your current selection is the Home tab. You have
created a new tab and renamed it to Fonts. You also create a new group and add commands to
it. Once the new tab is created, which of the following is going to be its default location? -
Answer After the currently selected tab
In a worksheet, you have a table that contains Usernames and their date of birth. You want to
display only the names that start with letter A. The rest of the usernames you want to hide.
What should you do? - Answer Use the filter feature
You ran an ANOVA test on three sets of data. Which of the following action should you perform
if the p-value that is generated from ANOVA is less than your significance level, which is 0.05? -
Answer Reject the hypotheses
You have configured the Analysis Toolpak. You want to use Analysis Toolpak add-in to generate
correlation coefficients between multiple variables. To be able to do this, which of the function
should you use? - Answer CORREL
, You have to draw a lottery from a set of given numbers. You should be able to select any
number randomly. To be able to do this, which of the following tool should you use? - Answer
Random Number Generation
In the D5 cell, you have entered to the following function: =ROW(D5) What is likely to be the
outcome of this function? - Answer It will return 5 as the value
In a worksheet, you have a table with several rows and columns. You need to change some
values to see the impact on the other values in the table. You want to do this by using a cause-
and-effect scenario. Which of the following Excel tool can help you in this situation? - Answer
Goal Seek
You have a set of values in cells ranging from A2 to A20. You want to highlight the values if they
are higher than 50. If a value is changed to less than 50, then the cell should not remain
highlighted. Which of the following task should you perform to achieve this with minimum
administrative efforts? - Answer Use conditional formatting
You are trying to import a CSV file into an existing worksheet in Excel. Using the preview feature,
you notice that Excel is not able to parse the data from the CSV file correctly. Which of the
following options can help you in importing the data? - Answer Change the delimiter in the
text import wizard
You have created an Excel workbook and want to save it as a template. Which of the following
extension type should you choose? - Answer .xltx
You have been advised to use Solver to perform optimization in the What-If Analysis. However,
you do not find the Solver command on the Data tab. What should you do? - Answer
Download and install the add-in
You need to create a bar chart with a table of data points, which are the number of cars sold in
the last 12 months. You also want to display the average sale per month. Which of the following
chart should you create to meet this goal?"` - Answer Combo
You want to generate descriptive statistics in a worksheet that contains a table with several
columns. To be able to do this, which of the following add-in should you configure in Excel? -
Answer Analysis Toolpak
Guide Exam And Actual Answers 2025.
You have created a Line Sparkline with a data column that has 15 different values. After creating
the Line Sparkline, you need to change the value of one of the cells. If you change the value,
what is likely to happen to the Line Sparkline? - Answer Line Sparkline will be updated
automatically
Which of the following in a bar chart is a symbol that represents a single value in a spreadsheet?
- Answer Data Marker
You have a value of 75 in the C2 cell. You need to multiply this value with a series of cells from
C5 to C10. The output of their value is placed in cells from D5 to D10. Which of the following is
the absolute reference? - Answer C2
In an Excel worksheet, you have copied a cell that contains a formula. You want to paste the
contents of this cell to another cell but only the numbers. You do not want to copy the formula.
Which of the following option of Paste Special should you use? - Answer Values
You are customizing the ribbon in Excel. Your current selection is the Home tab. You have
created a new tab and renamed it to Fonts. You also create a new group and add commands to
it. Once the new tab is created, which of the following is going to be its default location? -
Answer After the currently selected tab
In a worksheet, you have a table that contains Usernames and their date of birth. You want to
display only the names that start with letter A. The rest of the usernames you want to hide.
What should you do? - Answer Use the filter feature
You ran an ANOVA test on three sets of data. Which of the following action should you perform
if the p-value that is generated from ANOVA is less than your significance level, which is 0.05? -
Answer Reject the hypotheses
You have configured the Analysis Toolpak. You want to use Analysis Toolpak add-in to generate
correlation coefficients between multiple variables. To be able to do this, which of the function
should you use? - Answer CORREL
, You have to draw a lottery from a set of given numbers. You should be able to select any
number randomly. To be able to do this, which of the following tool should you use? - Answer
Random Number Generation
In the D5 cell, you have entered to the following function: =ROW(D5) What is likely to be the
outcome of this function? - Answer It will return 5 as the value
In a worksheet, you have a table with several rows and columns. You need to change some
values to see the impact on the other values in the table. You want to do this by using a cause-
and-effect scenario. Which of the following Excel tool can help you in this situation? - Answer
Goal Seek
You have a set of values in cells ranging from A2 to A20. You want to highlight the values if they
are higher than 50. If a value is changed to less than 50, then the cell should not remain
highlighted. Which of the following task should you perform to achieve this with minimum
administrative efforts? - Answer Use conditional formatting
You are trying to import a CSV file into an existing worksheet in Excel. Using the preview feature,
you notice that Excel is not able to parse the data from the CSV file correctly. Which of the
following options can help you in importing the data? - Answer Change the delimiter in the
text import wizard
You have created an Excel workbook and want to save it as a template. Which of the following
extension type should you choose? - Answer .xltx
You have been advised to use Solver to perform optimization in the What-If Analysis. However,
you do not find the Solver command on the Data tab. What should you do? - Answer
Download and install the add-in
You need to create a bar chart with a table of data points, which are the number of cars sold in
the last 12 months. You also want to display the average sale per month. Which of the following
chart should you create to meet this goal?"` - Answer Combo
You want to generate descriptive statistics in a worksheet that contains a table with several
columns. To be able to do this, which of the following add-in should you configure in Excel? -
Answer Analysis Toolpak
