QUESTION NO: 1
You work in the Sales office at ABC.com. You are using Microsoft Office Excel 2010 to prepare a financial report.
The report is a complicated analysis of the company financial performance over the last year and projected growth for the next year based on the figures. The report will be sent to ABC.com board members.
You have used subtotals throughout the report to make it easier for you to verify the accuracy of the figures. After completing the report and verifying the totals, you want to remove the subtotals before you send the report to the board members.
Which combination of the following steps describes how to remove the subtotals from a worksheet? Choose two.
You work in the Sales office at ABC.com. You are using Microsoft Office Excel 2010 to prepare a financial report.
The report is a complicated analysis of the company financial performance over the last year and projected growth for the next year based on the figures. The report will be sent to ABC.com board members.
You have used subtotals throughout the report to make it easier for you to verify the accuracy of the figures. After completing the report and verifying the totals, you want to remove the subtotals before you send the report to the board members.
Which combination of the following steps describes how to remove the subtotals from a worksheet? Choose two.
Correct Answer: A,C
Vote an answer
QUESTION NO: 2
Your work as a Sales Administrator in the ABC.com Sales office includes the production of workbooks using Microsoft Office Excel 2010.
You are working on a Sales report for the last week. You enter the name of each sales person in cells B2 to B10. You want to enter "Monday" in each of the cells from C2 to C10. You type Monday into cell C2 and drag the fill handle down to cell C10. You find the AutoFill function increments the weekdays to Tuesday, Wednesday, Thursday.... down to cell C10.
You drag the fill handle again and this time you click the AutoFill button.
Which AutoFill option should you select to have Monday entered in cells C2 to C10?
Your work as a Sales Administrator in the ABC.com Sales office includes the production of workbooks using Microsoft Office Excel 2010.
You are working on a Sales report for the last week. You enter the name of each sales person in cells B2 to B10. You want to enter "Monday" in each of the cells from C2 to C10. You type Monday into cell C2 and drag the fill handle down to cell C10. You find the AutoFill function increments the weekdays to Tuesday, Wednesday, Thursday.... down to cell C10.
You drag the fill handle again and this time you click the AutoFill button.
Which AutoFill option should you select to have Monday entered in cells C2 to C10?
Correct Answer: E
Vote an answer
QUESTION NO: 3
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft
Excel 2010. He wants to fill the active cell with the content of the adjacent cell. Mark the option
that he will choose to accomplish the task.
Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft
Excel 2010. He wants to fill the active cell with the content of the adjacent cell. Mark the option
that he will choose to accomplish the task.
Correct Answer:
Explanation:
The Fill command is used to fill the active cell with the content of the adjacent cell. The Fill
command is run through Home tab > Editing group > Fill.
Click the Down, Right, Up, Left, or Series option to fill cells.
Reference:
Microsoft Excel Help, Contents: "Fill data automatically in worksheet cells"
QUESTION NO: 4
You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report.
The columns in a table in the worksheet are set to the default width. This causes some of the text in some cells to not be displayed. You want to increase the column width so that the text in the cells is displayed. You also want to ensure that all columns in the table are the same width.
Which combination of the following actions is the easiest way to accomplish the task? Choose two.
You are employed as a financial administrator at ABC.com. You are using Microsoft Office Excel 2010 to create a financial report.
The columns in a table in the worksheet are set to the default width. This causes some of the text in some cells to not be displayed. You want to increase the column width so that the text in the cells is displayed. You also want to ensure that all columns in the table are the same width.
Which combination of the following actions is the easiest way to accomplish the task? Choose two.
Correct Answer: B,C
Vote an answer
QUESTION NO: 5
You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a sales report.
The report contains the table shown below.
You want to include a chart in the report to display a graphical comparison of the sales figures for the sales staff listed in the table.
Which type of chart would best illustrate a comparison of the sales figures?
You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a sales report.
The report contains the table shown below.
You want to include a chart in the report to display a graphical comparison of the sales figures for the sales staff listed in the table.
Which type of chart would best illustrate a comparison of the sales figures?
Correct Answer: D
Vote an answer
QUESTION NO: 6
You work in the Sales office at ABC.com. You use Microsoft Office Excel 2010 to create and edit workbooks.
Your workbook has multiple worksheets and each worksheet has many rows of information.
You want to make several formatting changes to every cell in the workbook. You need to ensure that every cell has the same formatting.
What is the easiest way to apply several formats to the cells throughout a workbook?
You work in the Sales office at ABC.com. You use Microsoft Office Excel 2010 to create and edit workbooks.
Your workbook has multiple worksheets and each worksheet has many rows of information.
You want to make several formatting changes to every cell in the workbook. You need to ensure that every cell has the same formatting.
What is the easiest way to apply several formats to the cells throughout a workbook?
Correct Answer: D
Vote an answer
QUESTION NO: 7
Your work as a Sales Administrator in the ABC.com Sales office includes the production of workbooks using Microsoft Office Excel 2010.
You have a formula in a spreadsheet that reads data from an external source and performs a calculation to calculate current Sales figures. You want to include a function in the spreadsheet to display the current time whenever the spreadsheet is opened or when the spreadsheet is calculated.
Which Excel function should you make use of in your spreadsheet?
Your work as a Sales Administrator in the ABC.com Sales office includes the production of workbooks using Microsoft Office Excel 2010.
You have a formula in a spreadsheet that reads data from an external source and performs a calculation to calculate current Sales figures. You want to include a function in the spreadsheet to display the current time whenever the spreadsheet is opened or when the spreadsheet is calculated.
Which Excel function should you make use of in your spreadsheet?
Correct Answer: C
Vote an answer
QUESTION NO: 8
You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report
of the Sales department. You use Microsoft Excel 2010 to prepare sales reports. You have created
a quarterly sales report of the department. After entering required data and inserting charts, you
want to give a professional look to the document. You want to produce the document with
soothing graphic effects, soft fonts, and light colors. Which of the following steps will you take to
accomplish the task with least administrative burden?
You work as a Sales Manager for Rainbow Inc. Your responsibility includes preparing sales report
of the Sales department. You use Microsoft Excel 2010 to prepare sales reports. You have created
a quarterly sales report of the department. After entering required data and inserting charts, you
want to give a professional look to the document. You want to produce the document with
soothing graphic effects, soft fonts, and light colors. Which of the following steps will you take to
accomplish the task with least administrative burden?
Correct Answer: A
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 9
You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a Sales Report.
The sales report contains a table that lists the sales figures for each month for each of the Sales Account Managers. A column in the table uses the SUM() function to provide a value for the total annual sales for each of the Sales Account Managers.
The cell that contains the annual total sales for one of the Sales Account Managers displays the formula as shown below whereas the totals for all the other Sales Account Managers are displayed as values.
How can you display the formula as a value?
You work as the Sales Manager at ABC.com. You are using Microsoft Office Excel 2010 to create a Sales Report.
The sales report contains a table that lists the sales figures for each month for each of the Sales Account Managers. A column in the table uses the SUM() function to provide a value for the total annual sales for each of the Sales Account Managers.
The cell that contains the annual total sales for one of the Sales Account Managers displays the formula as shown below whereas the totals for all the other Sales Account Managers are displayed as values.
How can you display the formula as a value?
Correct Answer: B
Vote an answer