excel

Clear the print area.

In the Page Layout Ribbon Tab in the Page Setup Ribbon Group, you clicked the Print Area button. In the Print Area menu, you clicked the Clear Print Area menu item.

Set row 1 to print on every page.

In the Page Layout Ribbon Tab in the Page Setup Ribbon Group, you clicked the Print Titles button. You clicked on the row 1 header. Inside the Page Setup dialog, you clicked the OK button.

Without adjusting the column widths, guarantee that all columns will print on one page.

In the Page Layout Ribbon Tab in the Scale To Fit Ribbon Group, you clicked the Width: drop-down arrow. In the Width: menu, you clicked the 1 page menu item.

Modify the Jul 26 worksheet so gridlines will print.

In the Page Layout Ribbon Tab in the Sheet Options Ribbon Group, you checked the Print check box.

Apply the Ion theme to the workbook.

In the Page Layout Ribbon Tab in the Themes Ribbon Group, you clicked the Themes button. In the Themes menu, you selected the Ion option.

Delete this row.

On the Home tab, in the Cells group, click the Delete button arrow and select Delete Sheet Rows.

Insert a column to the left of the selected cell.

On the Home tab, in the Cells group, click the Insert button arrow and select Insert Sheet Columns.

Clear the selected Sparklines from the worksheet.

On the Sparkline Tools Design tab, in the Group group, click the Clear button.

Use AutoFill to copy the formula and formatting in cell E2 to cells E3:E6.

You clicked and dragged the cell E2 fill handle, released the mouse button on cell E6.

Select cells A5:D8.

You clicked cell A5, and selected the cell range A5:D8.

Select column B.

You clicked on column B.

Hide the column showing 2013 data and the bonus rate.

You clicked on column B. In the Home Ribbon Tab in the Cells Ribbon Group, you clicked the Format button. In the Format menu in the Hide & Unhide menu, you clicked the Hide Columns menu item.

Insert a Line chart based on the first recommended chart type.

You clicked the Quick Analysis Tool button, clicked the Charts tab header, and clicked the Line button.

Add column Sparklines to cells F2:F11 to represent the values in B2:E11.

You clicked the Quick Analysis Tool button, clicked the Sparklines tab header, and clicked the Column button.

Move the Salaries worksheet so it is positioned before the working data worksheet.

You clicked the Salaries tab, dragged the Salaries tab in front of the working data tab.

Use a single command to clear everything (content and formatting) from the selected cell.

In the Home Ribbon Tab in the Editing Ribbon Group, you clicked the Clear button. In the Clear menu, you clicked the Clear All menu item.

Merge the cells so the text appears centered across the merged cells.

In the Home Ribbon Tab in the Alignment Ribbon Group, you clicked the Merge & Center button.

Wrap the text in the selected cell.

In the Home Ribbon Tab in the Alignment Ribbon Group, you clicked the Wrap Text button.

Change the width of the selected columns to 14.

In the Home Ribbon Tab in the Cells Ribbon Group, you clicked the Format button. In the Format menu, you clicked the Column Width menu item. Inside the Column Width dialog, you typed 14 in the Column Width: input, clicked the OK button.

Enter a formula in the selected cell using the SUM function to calculate the total of cells B2 through B6.

In the Home Ribbon Tab in the Cells Ribbon Group, you clicked the Format button. In the Home Ribbon Tab in the Editing Ribbon Group, you clicked the AutoSum button arrow. In the AutoSum menu, you clicked the Sum menu item. You pressed Enter.

Add a new worksheet to the left of the Jul 26 sheet.

In the Home Ribbon Tab in the Cells Ribbon Group, you clicked the Insert button arrow. In the Insert menu, you clicked the Insert Sheet menu item.

Use Format Painter to copy the formatting from cell D1 and apply it to cell E1.

In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Format Painter button. You clicked cell E1.

In cell D15, enter a formula using a counting function to count the number of cells in the Billable? column (cells D2:D14) that are not blank.

In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the More Functions button. In the More Functions menu in the Statistical menu, you clicked the COUNTA menu item. Inside the Function Arguments dialog, you typed D2:D14 in the Value1 input, clicked the DialogHeader view, clicked the dialog undefined button, and clicked the OK button.

Cell F4 has been copied. Paste the formula only into the selected cell (cell F5). Do not include the cell formatting.

In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Paste button arrow. In the Paste menu, you clicked the Formulas (F) button.

In cell D16, enter a formula using a counting function to count the number of blank cells in the Billable? Column (cells D2:D14).

In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the More Functions button. In the More Functions menu in the Statistical menu, you clicked the COUNTBLANK menu item. Inside the Function Arguments dialog, you clicked the DialogHeader view, clicked the dialog undefined button. You clicked cell D2. Inside the Function Arguments dialog, you typed D2:D14 in the Range input, clicked the OK button.

In cell E15, enter a formula to find the highest line item cost this month (cells A2:A14).

In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the More Functions button. In the More Functions menu in the Statistical menu, you clicked the MAX menu item. Inside the Function Arguments dialog, you typed A2:A14 in the Number1 input, clicked the OK button.

In cell B15, enter a formula to find the lowest line item cost this month (cells B2:B14).

In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the More Functions button. In the More Functions menu in the Statistical menu, you clicked the MIN menu item. Inside the Function Arguments dialog, you typed B2:B14 in the Number1 input, clicked the OK button.

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.

Double-click cell C2 to edit the formula. change the formula to be = B2+(B2^$B$9). Press enter

Apply the Monochromatic Palette 3 color scheme.

In the Design Ribbon Tab in the Chart Styles Ribbon Group, you clicked the Change Colors button. In the Change Colors menu, you selected the Monochromatic Palette 3 option.

Switch the rows and columns in the chart, so the data points are grouped into data series by year.

In the Design Ribbon Tab in the Data Ribbon Group, you clicked the Switch Row/Column button.

Add a footer that displays the page number in the center section.

In the Design Ribbon Tab in the Header & Footer Elements Ribbon Group, you clicked the Page Number button.

Change the chart type to the first stacked bar option.

In the Design Ribbon Tab in the Type Ribbon Group, you clicked the Change Chart Type button.

Hide all of the dependency tracer arrows at once.

In the Formulas Ribbon Tab in the Formula Auditing Ribbon Group, you clicked the Remove Arrows button.

Change the zoom level for the worksheet to be 110%.

You clicked the Zoom In button.

Set the print area so only the selected cells will print.

You clicked the back arrow button. In the Page Layout Ribbon Tab in the Page Setup Ribbon Group, you clicked the Print Area button. In the Print Area menu, you clicked the Set Print Area menu item.

Autofit column D to best fit the data.

You double-clicked column D's right border.

Rename Sheet1: Jul 31

You double-clicked the Sheet1 tab, clicked the Sheet1 tab, typed "Jul 31", and pressed Enter.

Move the selected chart to the empty area of the worksheet below the data.

You dragged the chart to the left (by 5 columns) and down (by 7 rows).

Display the data labels on this chart above the data markers.

You launched the Chart Elements menu. In the Mini Toolbar in the Data Labels menu, you clicked the Above menu item.

Display the data table, including the legend keys.

You launched the Chart Elements menu. In the Mini Toolbar, you checked the Data Table check box.

Move the selected chart to a new chart sheet.

Click the Chart Tools Design tab. In the Location group, click the Move Chart button. Click the New Sheet radio button. Click OK.

Change the font color of the selected cells to the Blue-Gray, Text 2 color (it is the fourth option in the first row under Theme Colors).

In the Home Ribbon Tab in the Font Ribbon Group, you clicked the Font Color button arrow. In the Font Color menu, you selected the Blue-Gray, Text 2 color option.

Hide the chart title.

You launched the Chart Elements menu. In the Mini Toolbar, you unchecked the Chart Title check box.

Filter the chart so the lines for Dr. Femur and Tibia Robinson are hidden.

You launched the Chart Filter menu. In the Mini Toolbar, you unchecked the Dr.Femur check box, unchecked the Tibia Robinson check box. You clicked the apply button.

Apply the Style 3 Quick Style to the chart.

You launched the Chart Styles menu. In the Mini Toolbar, you selected the Style 3 option.

Print the entire workbook.

You opened the backstage view, clicked the Print navigation button, and clicked the Print Selection button. In the Print Selection menu, you clicked the Print Entire Workbook menu item. You clicked the Print button.

Print this worksheet.

You opened the backstage view, clicked the Print navigation button, clicked the Print Selection button, clicked the Print Selection button, and clicked the Print button.

Copy cell F3, and paste to cell F2.

You pressed the Ctrl + C keyboard shortcut, clicked cell F2, and pressed the Ctrl + V keyboard shortcut.

Cut cell B7 and paste it to cell E12.

You pressed the Ctrl + X keyboard shortcut, clicked cell E12, and pressed the Ctrl + V keyboard shortcut.

Resize the selected chart so it is approximately 7 rows tall.

You resized the chart.

Change the color of the sheet tab for the Jul 26 worksheet to Green, Accent 6, Lighter 80%

You right clicked the Jul 26 tab. In the Tab Right Click menu in the Tab Color menu, you selected the Green, Accent 6, Lighter 80% color option.

Add a Blue, Accent 5 (in the top row of theme colors, the second color from the right) bottom border to the selected cells. Use the thickest single line style available.

On the Home tab, in the Font group, click the Fill Color button arrow to display the color palette. Click the Blue, Accent 5 color, the second color from the right in the first row of theme colors.

Delete the Timesheets worksheet.

You right clicked the TimeSheets tab. In the Tab Right Click menu, you clicked the Delete Sheet menu item. Inside the Microsoft Excel dialog, you clicked the Delete button.

Enter the number 6745 in cell C7.

You typed 6745 in cell C7, pressed Enter.

On the Year3 sheet, in cell B8, enter a formula to display the value of cell B7 from the Expenses sheet.

You typed = in cell B8, clicked the Expenses tab, clicked cell B7, and pressed Enter.

Enter a formula in the selected cell to display the owner's draw percentage (cell B6).

You typed = in cell D2, clicked cell B6, and pressed Enter.

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).

You typed = in cell F6, clicked cell F4, typed =F4- in cell F6, clicked cell F5, and pressed Enter.

Use the Create from Selection command to create named ranges for the selected data table in cells B2:E6 using the labels in row 1 as the basis for the names.

In the Formulas Ribbon Tab in the Defined Names Ribbon Group, you clicked the Define Name button arrow, clicked the Define Name button arrow, and clicked the Create from Selection button. Inside the Create from Selection dialog, you clicked the OK button.

Show the tracer arrows from cell E7 to the cells that are dependent on it.

In the Formulas Ribbon Tab in the Formula Auditing Ribbon Group, you clicked the Trace Dependents button.

Show the tracer arrows from the precedent cells to cell C7.

In the Formulas Ribbon Tab in the Formula Auditing Ribbon Group, you clicked the Trace Precedents button.

Insert the current date and time in cell B1.

In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Date & Time button. In the Date & Time menu, you clicked the NOW menu item. Inside the Function Arguments dialog, you clicked the OK button.

Insert the current date in cell A1. Do not include the current time.

In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Date & Time button. In the Date & Time menu, you clicked the TODAY menu item. Inside the Function Arguments dialog, you clicked the OK button.

Center the content in the selected cells horizontally.

In the Home Ribbon Tab in the Alignment Ribbon Group, you clicked the Align Center button.

Create a 3-D pie chart from the selected data.

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.

Apply the Accent1 cell style to the selected cell.

In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Cell Styles button. In the Cell Styles menu, you selected the Accent 1 option.

Using cell references, enter a formula in cell B6 to calculate monthly payments for the loan described in this worksheet. Omit the optional arguments. Use a negative value for the Pv argument.

In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Financial button. In the Financial menu, you clicked the PMT menu item. Inside the Function Arguments dialog, you clicked the DialogHeader view, clicked the dialog undefined button. You clicked cell B3. Inside the Function Arguments dialog, you typed B3/12 in the Rate input, pressed the Tab key, and pressed Tab. You clicked cell B4. Inside the Function Arguments dialog, you typed - in the Pv input. You clicked cell B2. Inside the Function Arguments dialog, you clicked the OK button.

Enter a formula in cell B10 to return a value of 56000 if the Net Profit After Tax (cell B9) is greater than or equal to 471000 or 345 if it is not.

In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Logical button. In the Logical menu, you clicked the IF menu item. Inside the Function Arguments dialog, you clicked the DialogHeader view, clicked the dialog undefined button. You clicked cell B9. Inside the Function Arguments dialog, you typed B9>=471000 in the Logical_test input, typed 56000 in the Value_if_true input, typed 345 in the Value_if_false input, and clicked the OK button.

Enter a formula in cell B3 using the VLOOKUP function to find the meaning for the medical abbreviation listed in cell A3. Use the named range Abbreviation for the lookup table. The item names are located in column 2 of the lookup table. Be sure to require an exact match.

In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Lookup & Reference button. In the Lookup & Reference menu, you clicked the VLOOKUP menu item. You clicked cell A3. Inside the Function Arguments dialog, you typed Abbreviation in the Table_array input, typed 2 in the Col_index_num input, pressed the Tab key, typed false in the Range_lookup input, and clicked the OK button.

Enter a formula in cell G7 to calculate the average value of cells G2:G6.

In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the More Functions button. In the More Functions menu in the Statistical menu, you clicked the AVERAGE menu item. Inside the Function Arguments dialog, you typed G2 in the Number1 input, pressed the Tab key, pressed Backspace, typed G2:G6 in the Number1 input, and clicked the OK button.

In cell E15, enter a formula using a counting function to count the numbers in the Cost column (cells E2:E14).

In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the More Functions button. In the More Functions menu in the Statistical menu, you clicked the COUNT menu item. Inside the Function Arguments dialog, you clicked the DialogHeader view, clicked the dialog undefined button. You clicked cell E2, clicked cell E14. Inside the Function Arguments dialog, you pressed Backspace, typed E2: in the Value1 input. You clicked cell E14. Inside the Function Arguments dialog, you pressed Backspace. You clicked cell E2. Inside the Function Arguments dialog, you typed E2:E14 in the Value1 input, clicked the OK button.

Use AutoSum to enter a formula in the selected cell to calculate the total of all the contiguous cells above.

In the Home Ribbon Tab in the Editing Ribbon Group, you clicked the AutoSum button arrow. In the AutoSum menu, you clicked the Sum menu item. You pressed Enter.

Apply the Top and Bottom Border to the selected cells with a single command.

In the Home Ribbon Tab in the Font Ribbon Group, you clicked the Borders button arrow. In the Borders menu, you clicked the Top and Bottom Border menu item.

Change font size for the selected cells to 18.

In the Home Ribbon Tab in the Font Ribbon Group, you clicked the Font Size drop-down arrow. In the Font Size menu, you selected the 18pt font size.

Change the font for the selected cell to Cambria.

In the Home Ribbon Tab in the Font Ribbon Group, you clicked the Font drop-down arrow. In the Font menu, you clicked the Cambria font.

Apply bold and italic formatting to the selected cell.

In the Home Ribbon Tab in the Font Ribbon Group, you clicked the Italic button, clicked the Bold button.

Modify the number format so no decimal places are visible after the decimal point.

In the Home Ribbon Tab in the Number Ribbon Group, you clicked the Decrease Decimal button, clicked the Decrease Decimal button.

Apply the Accounting Number Format to the selected cells.

In the Home Ribbon Tab in the Number Ribbon Group, you clicked the Number Format drop-down arrow. In the Number Format menu, you selected the Accounting option.

From Page Break Preview view, insert a page break immediately above the selected cell.

In the Page Layout Ribbon Tab in the Page Setup Ribbon Group, you clicked the Breaks button. In the Breaks menu, you clicked the Insert Page Break menu item.

Apply the preset margin option that will add the least amount of white space around the edges of the printed page.

In the Page Layout Ribbon Tab in the Page Setup Ribbon Group, you clicked the Margins button. In the Margins menu, you selected the Narrow option.

Use the spelling checker to find and change all instances of any misspelled words.

In the Review Ribbon Tab in the Proofing Ribbon Group, you clicked the Spelling button. Inside the Spelling: English (United States) dialog, you clicked the Change button. Inside the Microsoft Excel dialog, you clicked the OK button.

Arrange all open workbooks in a single window so they overlap in a staggered, diagonal pattern.

In the View Ribbon Tab in the Window Ribbon Group, you clicked the Arrange All button. Inside the Arrange Windows dialog, you selected the Cascade Radio Button, clicked the OK button.

Modify the worksheet so the first row is always visible when you scroll the worksheet down.

In the View Ribbon Tab in the Window Ribbon Group, you clicked the Freeze Panes button. In the Freeze Panes menu, you clicked the Freeze Top Row menu item.

Modify the worksheet so you can see four different areas of the worksheet at the same time and scroll each area independently of the others.

In the View Ribbon Tab in the Window Ribbon Group, you clicked the Split button.

Switch to the view that shows all the worksheet elements as they will print, including headers and footers.

In the application footer, you clicked the Page Layout button.

Add an element to the center section of the header to display the current date.

In the application footer, you clicked the Page Layout button. You clicked in the center section of the header. In the Design Ribbon Tab in the Header & Footer Elements Ribbon Group, you clicked the Current Date button.