BSAD 125 Excel - Pretest

10 September 2022
4.7 (114 reviews)
15 test answers

Unlock all answers in this set

Unlock answers (11)
question
Apply the Style 7 Quick Style to the chart.
answer
You launched the Chart Styles menu. In the Mini Toolbar, you selected the Style 7 option.
question
Create a 3-D pie chart from the selected data.
answer
In the Insert Ribbon Tab in the Charts Ribbon Group, you clicked the Insert Pie or Doughnut Chart button. In the Insert Pie or Doughnut Chart menu, you selected the 3-D Pie option.
question
Edit the formula in cell D2 so the references to cell C2 will update when the formula is copied, and the reference to cell B9 will remain constant. Use AutoFill to copy the formula to cells D3:D6.
answer
You clicked the formula bar, clicked the formula bar, typed "=C2+(C2*$B9)" in the formula bar, clicked the formula bar, typed "=C2+(C2*$B$9)" in the formula bar, clicked the Accept Function button, clicked and dragged the cell D2 fill handle, released the mouse button on cell D4, clicked and dragged the cell D2 fill handle, and released the mouse button on cell D6.
question
Use the Quick Analysis tool to apply the Data Bars conditional formatting option to the selected cells.
answer
1. Select the cells to which you want to apply conditional formatting. 2. Click the Quick Analysis tool button at the lower right corner of the selection. 3. Notice that Live Preview displays the effect of the conditional formatting on your data as you hover the mouse pointer over each of the formatting options. Review each formatting option before making your selection. 4. Click the button for the type of conditional formatting you want to apply.
question
Insert a Line chart based on the first recommended chart type.
answer
1. Select the data for the chart. 2. Click the Quick Analysis Tool button. 3. Click the Charts tab, and then click the More Charts button to open the Insert Chart dialog. You can also open the Insert Chart dialog from the Insert tab, Charts group, by clicking the Recommended Charts button. 4. The first tab in the Insert Chart dialog, Recommended Charts, displays the same chart options as the Charts tab in the Quick Analysis tool, plus a few more. When you select a chart type, a preview of the chart appears in the right pane of the dialog. 5. Click OK to insert the selected chart into the worksheet.
question
Add column Sparklines to cells F2:F11 to represent the values in B2:E11.
answer
1. Select the data you want to visualize as Sparklines. If you want the Sparklines to appear in empty cells, ensure that there are empty cells to the right of your selection 2. The Quick Analysis Tool button appears near the lower right corner of the selected range. Click the Quick Analysis Tool button, and then click the Sparklines tab. 3. Click the button for the Sparkline type you want. OR 1. Select the data range with the data points for the Sparklines. 2. On the Insert tab, in the Sparklines group, click the button for the type of Sparkline you want to insert: Line, Column, or Win/Loss. 3. The Create Sparklines dialog opens with the selected range added to the Data Range box. 4. In the Location Range box, enter the cell range where you want the Sparklines to appear. You can type the cell range or click and drag in the worksheet to select the cells. 5. Click OK to insert the Sparklines.
question
Convert the cell range to a table using table style Table Style Light 8 (the first style in the second row under the Light styles). The table should include headers.
answer
You clicked cell A2, clicked cell A2, clicked cell C2, and right clicked cell A2. In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Conditional Formatting button. In the Insert Ribbon Tab in the Tables Ribbon Group, you clicked the Table button. Inside the Create Table dialog, you clicked the Cancel button. In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Format as Table button. In the Format as Table menu, you selected the Table Style Light 8 option. Inside the Format As Table dialog, you clicked the OK button.
question
Use AutoSum to enter a formula in the selected cell to calculate the total of all the contiguous cells above.
answer
In the Home Ribbon Tab in the Editing Ribbon Group, you clicked the AutoSum button. You pressed Enter.
question
Apply the Accounting Number Format to the selected cells.
answer
You right clicked cell B8. In the Right-Click menu, you clicked the Format Cells menu item. Inside the Format Cells dialog from the Category list, you selected Accounting. Inside the Format Cells dialog, you clicked the OK button.
question
In cell E15, enter a formula to find the highest line item cost this month (cells E2:E14).
answer
=MAX(E2:E14)
question
Select cells A5:D8.
answer
You selected the cell range A1:D15, pressed the Enter key, selected the cell range A4:D15, pressed the Enter key, selected the cell range A5:D15, pressed the Enter key, selected the cell range A5:D15, clicked the Name Box, clicked the Quick Analysis Tool button, clicked cell C10, and selected the cell range A5:D8.
question
Enter the number 530 in cell C7.
answer
You typed 530 in cell C7, pressed Enter.
question
Enter a formula in the selected cell to calculate the profit projection for 2017: total sales (cell F4) minus the cost of goods sold (cell F5).
answer
You typed = in cell F6, clicked cell F4, typed =F4- in cell F6, clicked cell F5, and clicked the Accept Function button.
question
Select column B.
answer
You selected the cell range B1:B15, clicked on column B.
question
Add the Profit-Sharing field to the PivotTable.
answer
Inside the PivotTable Fields dialog from the PivotTable Fields list, you checked the Profit-Sharing check box.