Cis 103 SImPaths

Tara just drafted an email to send to her coworkers. Can you identify the parts of the email that should be changed before she sends it out to the company? Click the image(s) to select the answer. When you are finished, click Done.

I don't know, good luck :)

Which of the following PCs are used for web-based tasks and light applications on the go? Click all that apply. When you are finished, click Done.

I don't know, good luck :)

Change the animation effects to have the image enter from the right.

In the Animations Ribbon Tab in the Animation Ribbon Group, you clicked the Effect Options button. In the Effect Options menu, you selected the Fly In From Right option.

Apply the Grow & Turn animation to the image.

In the Animations Ribbon Tab in the Animation Ribbon Group, you expanded the Animations Gallery. In the Animations Ribbon Tab in the Animation Ribbon Group in the Animations menu, you clicked the Grow & Turn (Entrance) gallery option.

Start a new query without using one of the query wizards.

In the Create Ribbon Tab in the Queries Ribbon Group, you clicked the Query Design 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.

Move the selected chart to a new chart sheet.

In the Design Ribbon Tab in the Location Ribbon Group, you clicked the Move Chart button. Inside the Move Chart dialog, you selected the New sheet: Radio Button, clicked the OK button.

Add markers for just the highest values in this Sparkline group.

In the Design Ribbon Tab in the Show Ribbon Group, you checked the High Point check box.

Display the Total row for this query.

In the Design Ribbon Tab in the Show/Hide Ribbon Group, you clicked the Totals button.

Create a new query in Design view using the following fields in this order: From the Students table, add the LastName, FirstName, Classification, and ResidenceHall fields. From the ResidenceHalls table, add the ResidenceName and FreshmenOnly fields. Run the query.

In the Create Ribbon Tab in the Queries Ribbon Group, you clicked the Query Design button. Inside the Show Table dialog from the Table list, you double-clicked the Students list item, double-clicked the ResidenceHalls list item. Inside the Show Table dialog, you clicked the Add button, clicked the Close button. You double-clicked the LastName field in the Students table, double-clicked the FirstName field in the Students table, double-clicked the Classification field in the Students table, double-clicked the ResidenceHall field in the Students table, double-clicked the ResidenceName field in the ResidenceHalls table, and double-clicked the FreshmenOnly field in the ResidenceHalls table. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Use the Simple Query Wizard to create a select query for a single table. Include these fields in this order: LastName, FirstName, Classification, and Credits fields from the Students table. Include every record in the results. Select the option to open the query to view information. Name the query Tuition and view the query results.

In the Create Ribbon Tab in the Queries Ribbon Group, you clicked the Query Wizard button. Inside the New Query dialog, you clicked the OK button. Inside the Simple Query Wizard dialog in the Table: Students drop-down, you selected Table: Students. Inside the Simple Query Wizard dialog from the Available Fields list, you double-clicked the LastName list item, double-clicked the FirstName list item, double-clicked the Classification list item, and double-clicked the Credits list item. Inside the Simple Query Wizard dialog, you clicked the Next > button, clicked the Next > button, typed Tuition in the What title do you want for your query? input, and clicked the Finish button.

Import data from the StudentGPA text file into a table in a new worksheet.

In the Data Ribbon Tab in the Get & Transform Data Ribbon Group, you clicked the From Text/CSV button. You double-clicked the StudentGPA item. Inside the StudentGPA.txt dialog, you clicked the Load button.

Import data from ClassSchedule table in the Registration Access database into a new worksheet.

In the Data Ribbon Tab in the Get & Transform Data Ribbon Group, you clicked the Get Data button. In the Get Data menu in the From Database menu, you clicked the From Microsoft Access Database menu item. You double-clicked the Registration item. Inside the Navigator dialog from the Display Options list from the Registration.accdb list, you selected ClassSchedule. Inside the Navigator dialog, you clicked the Load button.

The total row for each expense category uses a SUM function to total the costs. Create an automatic outline from the rows in this data range.

In the Data Ribbon Tab in the Outline Ribbon Group, you clicked the Group button arrow. In the Group menu, you clicked the Auto Outline menu item.

Create automatic subtotals to sum the cost for each change in the Category column. The data have been sorted for you.

In the Data Ribbon Tab in the Outline Ribbon Group, you clicked the Subtotal button. Inside the Subtotal dialog in the At each change in drop-down, you selected Category. Inside the Subtotal dialog, you clicked the OK button.

Enable filtering.

In the Data Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Filter button.

Use a custom text filter to show only rows where the expense category (Category column) contains the word server.

In the Data Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Filter button. You clicked cell B1, clicked the Quick Sort dropdown. In the Table Filter menu in the Text Filters menu, you clicked the Contains... menu item. Inside the Custom AutoFilter dialog, you typed server in the second filter input, clicked the OK button.

Filter the Category column so only rows with Coffee are shown.

In the Data Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Filter button. You clicked cell B1, clicked the Quick Sort dropdown. In the Table Filter menu, you clicked the (Select All) checkbox, clicked the Coffee checkbox, and clicked the OK button.

Sort the data first alphabetically by the values in the Category column and then by the dates in the Date column with the oldest dates first.

In the Data Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Sort button. Inside the Sort dialog in the Sort By drop-down, you selected Category. Inside the Sort dialog, you clicked the Add level button. Inside the Sort dialog in the Sort By2 drop-down, you selected Date. Inside the Sort dialog, you clicked the OK button.

Sort the data so cells with the red down arrow icon in the Cost Level column appear on top.

In the Data Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Sort button. Inside the Sort dialog in the Sort By drop-down, you selected Cost Level. Inside the Sort dialog in the Sort On drop-down, you selected Cell Icon. Inside the Sort dialog, you clicked the Order Icon button. In the exCustomSortByArrowIconMenu menu, you selected the red arrow option. Inside the Sort dialog, you clicked the OK button.

Use a single command on the Ribbon apply inside horizontal borders to the table.

In the Design Ribbon Tab in the Borders Ribbon Group, you clicked the Borders button arrow. In the Borders menu, you clicked the Inside Horizontal Border menu item.

Apply the Monochromatic Palette 1 color scheme (the first option in the Monochromatic section) to the chart.

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 1 option.

Apply the Style 7 Quick Style to the chart.

In the Design Ribbon Tab in the Chart Styles Ribbon Group, you expanded the Chart Styles Gallery. In the Design Ribbon Tab in the Chart Styles Ribbon Group in the Chart Styles menu, you clicked the Style 7 gallery 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.

Apply the Integral theme to the document.

In the Design Ribbon Tab in the Document Formatting Ribbon Group, you clicked the Themes button. In the Themes menu, you selected the Integral option.

Clear the selected Sparklines from the worksheet.

In the Design Ribbon Tab in the Group Ribbon Group, you clicked the Clear button.

Modify this query so results are grouped by values in the DeptName field and values in the Credits field are summarized with the Sum function. Run the query.

In the Design Ribbon Tab in the Show/Hide Ribbon Group, you clicked the Totals button. You clicked the Credits field's Total row, expanded the Total row's Group by list, and selected the Sum option. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Apply the Colorful - Accent Colors color variation to the diagram. It is the first option in the Colorful section of the gallery.

In the Design Ribbon Tab in the SmartArt Styles Ribbon Group, you clicked the Change Color button. In the Change Color menu, you selected the Colorful - Accent Colors option.

Apply the Moderate Effect SmartArt style to the diagram. It is the fourth option in the gallery.

In the Design Ribbon Tab in the SmartArt Styles Ribbon Group, you expanded the SmartArt Styles Gallery, expanded the SmartArt Styles Gallery. In the Design Ribbon Tab in the SmartArt Styles Ribbon Group in the SmartArt Styles menu, you selected the Moderate Effect option.

Add a total row to this table.

In the Design Ribbon Tab in the Table Style Options Ribbon Group, you checked the Total Row check box.

Add a total row to this table and display the average for the Cost column instead of the sum of all the values.

In the Design Ribbon Tab in the Table Style Options Ribbon Group, you checked the Total Row check box. You clicked cell C21, clicked the Total Row arrow. In the Total Row menu, you clicked the Average menu item.

Change the Quick Style gallery display so formats with first column and banded row formatting do not display. Only Header row should be selected.

In the Design Ribbon Tab in the Table Style Options Ribbon Group, you unchecked the First Column check box, unchecked the Banded Rows check box.

Apply the Table Style Light 14 Quick Style (the last style in the second row under Light styles) to this table.

In the Design Ribbon Tab in the Table Styles Ribbon Group, you expanded the Quick Styles Gallery. In the Design Ribbon Tab in the Table Styles Ribbon Group in the Quick Styles menu, you selected the Table Style Light 14 option.

Apply the Grid Table 4-Accent 1 Quick Style to the table (it is in the Grid Tables section of the gallery).

In the Design Ribbon Tab in the Table Styles Ribbon Group, you expanded the Table Styles Gallery. In the Design Ribbon Tab in the Table Styles Ribbon Group in the Table Styles menu, you selected the Grid Table 4 - Accent 1 option.

Apply the Light Style 1, Accent 2 Quick Style to the table. It is the third option in the first row of the Light styles.

In the Design Ribbon Tab in the Table Styles Ribbon Group, you expanded the Table Styles Gallery. In the Design Ribbon Tab in the Table Styles Ribbon Group in the Table Styles menu, you selected the Light Style 1 - Accent 2 option.

Apply the Facet theme to the presentation. It is the second option in the gallery.

In the Design Ribbon Tab in the Themes Ribbon Group in the Themes Gallery menu, you clicked the Facet gallery option.

Convert the table to a normal range.

In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Convert to Range button. Inside the Microsoft Excel dialog, you clicked the Yes button.

Use a slicer to filter the data in this table to show only rows where the Category value is Coffee.

In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Insert Slicer button. Inside the Insert Slicer dialog, you checked the Category check box, clicked the OK button. You dragged the slicer, clicked the Multi-select button, clicked the Books button, clicked the Charitable Contributions button, clicked the Equipment button, clicked the Internet Access button, clicked the Meals button, clicked the Office Supplies button, clicked the Parking button, clicked the Restaurant button, clicked the Software button, and clicked the Training button.

Use a slicer to filter the data in this table to show only rows where the Category value is Coffee or Meals.

In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Insert Slicer button. Inside the Insert Slicer dialog, you checked the Category check box, clicked the OK button. You dragged the slicer, clicked the multi-select button, clicked the Books button, clicked the Charitable Contributions button, clicked the Equipment button, clicked the Internet Access button, clicked the Office Supplies button, clicked the Parking button, clicked the Restaurant button, clicked the Software button, and clicked the Training button.

Add slicers to filter the data in this table by Date.

In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Insert Slicer button. Inside the Insert Slicer dialog, you checked the Date check box, clicked the OK button.

Remove duplicate rows where data in all the columns are identical.

In the Design Ribbon Tab in the Tools Ribbon Group, you clicked the Remove Duplicates button. Inside the Remove Duplicates dialog, you clicked the OK button. Inside the Microsoft Excel dialog, you clicked the OK button.

Change the chart type to the first stacked bar option (the second option along the top of the right pane).

In the Design Ribbon Tab in the Type Ribbon Group, you clicked the Change Chart Type button. Inside the Change Chart Type dialog from the Column list, you clicked the Stacked Column item. Inside the Change Chart Type dialog from the Chart Type list, you selected Bar. Inside the Change Chart Type dialog from the Bar Chart list, you clicked the Stacked Bar item. Inside the Change Chart Type dialog, you clicked the OK button.

Create a new presentation based on the Ion template. Use the red color scheme (the fourth option in the Ion dialog).

In the Design Ribbon Tab in the Variants Ribbon Group, you expanded the Variants Gallery. In the Design Ribbon Tab in the Variants Ribbon Group in the Variants Gallery menu in the Colors menu, you clicked the Customize Colors... menu item. Inside the Create New Theme Colors dialog, you clicked the dialog Close button. In the Design Ribbon Tab in the Themes Ribbon Group, you expanded the Themes Gallery. You opened the backstage view, clicked the New navigation button, and clicked the Blank Presentation template.

Change the color theme for the presentation to Blue Warm.

In the Design Ribbon Tab in the Variants Ribbon Group, you expanded the Variants Gallery. In the Design Ribbon Tab in the Variants Ribbon Group in the Variants Gallery menu in the Colors menu, you selected the Blue Warm option.

Change the alignment on the selected objects to be aligned along the left side.

In the Format Ribbon Tab in the Arrange Ribbon Group, you clicked the Align button. In the Align menu, you clicked the Align Left menu item.

Change the text wrap option of the picture to Square.

In the Format Ribbon Tab in the Arrange Ribbon Group, you clicked the Wrap Text button. In the Wrap Text menu, you clicked the Square menu item.

Apply the Drop Shadow Rectangle Quick Style to the picture.

In the Format Ribbon Tab in the Picture Styles Ribbon Group in the Picture Styles Gallery menu, you clicked the Drop Shadow Rectangle gallery option.

Apply the Drop Shadow Rectangle picture style to the image. It is the fourth option style in the first row of the Picture Quick Styles gallery.

In the Format Ribbon Tab in the Picture Styles Ribbon Group in the Picture Styles Gallery menu, you clicked the Drop Shadow Rectangle gallery option.

Apply the Preset 5 picture effects to the picture. It is the fifth option under Presets.

In the Format Ribbon Tab in the Picture Styles Ribbon Group, you clicked the Picture Effects button. In the Picture Effects menu in the Preset menu, you selected the Preset 5 option.

Using the Eyedropper, change the fill color of the shape to the orange color used in the dotted line under Overview.

In the Format Ribbon Tab in the Shape Styles Ribbon Group, you clicked the Shape Fill button arrow. In the Shape Fill menu, you clicked the Eyedropper menu item. You selected the orange color from the orange dotted line using the EyeDropper Tool.

Apply the Blue, Accent 1 fill color to the selected shape. It is the fifth option in the first row under Theme Colors.

In the Format Ribbon Tab in the Shape Styles Ribbon Group, you clicked the Shape Fill button arrow. In the Shape Fill menu, you selected the Blue, Accent 1 color option.

Change the weight of the outline on the selected text box to 3 pt.

In the Format Ribbon Tab in the Shape Styles Ribbon Group, you clicked the Shape Outline button arrow. In the Shape Outline menu in the Weight menu, you selected the 3 pt option.

Change the outline color for the selected text box to Gold, Accent 4 (it is the eighth option in the first row under Theme Colors).

In the Format Ribbon Tab in the Shape Styles Ribbon Group, you clicked the Shape Outline button arrow. In the Shape Outline menu, you selected the Gold, Accent 4 color option.

Using the Ribbon, resize the image to be 1.7 inches tall and and 2.5 inches wide.

In the Format Ribbon Tab in the Size Ribbon Group, you set the Height to 1.7, set the Width to 2.5.

Using the ribbon, resize the picture to be 3 inches wide and let PowerPoint automatically resize the height to keep the aspect ratio the same.

In the Format Ribbon Tab in the Size Ribbon Group, you set the Width: to 3.

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 Create from Selection button. Inside the Create from Selection dialog, you clicked the OK button.

Edit the CurrentSalaries named range so it refers to cells B2:B6 on the Salaries worksheet. Close the Name Manager when you are finished.

In the Formulas Ribbon Tab in the Defined Names Ribbon Group, you clicked the Name Manager button. You clicked CurrentSalaries, clicked cell B2. Inside the Name Manager dialog, you clicked the checkmark item, clicked the Close 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.

Display the formulas in this worksheet.

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

Preview how this worksheet would print with formulas showing instead of calculated values.

In the Formulas Ribbon Tab in the Formula Auditing Ribbon Group, you clicked the Show Formulas button. You opened the backstage view, clicked the Print navigation button.

Show the tracer arrows from cell C2 to the cells that are dependent on it (cells containing formulas that reference the value or formula in cell C2).

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

Enter a formula in cell B10 to return a value of 35000 if the Net Profit After Tax (cell B9) is greater than or equal to 470000 or 1000 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. You clicked cell B9. Inside the Function Arguments dialog, you typed B9>=470000 in the Logical_test input, typed 35000 in the Value_if_true input, typed 1000 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 pressed Backspace, typed 2 in the Col_index_num input, typed FALSE in the Range_lookup input, and clicked the OK button.

Text has been copied to the clipboard. Without opening the Clipboard task pane, paste the text above the text electric nerve stimulation.

In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Paste button.

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 Math & Trig button, clicked the Financial button. In the Financial menu, you clicked the PMT menu item. You clicked cell B3. Inside the Function Arguments dialog, you typed B3/12 in the Rate input. You clicked cell B4, clicked cell B4. Inside the Function Arguments dialog, you typed - in the Pv input. You clicked cell B3, clicked cell B2. Inside the Function Arguments dialog, you clicked the OK button.

Use the Function Arguments dialog to enter a SUM function in cell B7 to calculate the total of cells B2:B6.

In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the Math & Trig button. In the Math & Trig menu, you clicked the SUM menu item. You selected the cell range B2:B6. Inside the Function Arguments dialog, you clicked the OK button.

Enter a formula in cell B7 to calculate the average value of cells B2:B6.

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. You selected the cell range B2:B6. Inside the Function Arguments dialog, you 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. You selected the cell range E2:E14. Inside the Function Arguments dialog, you clicked the OK button.

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. You selected the cell range D2:D14. Inside the Function Arguments dialog, you clicked the OK 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. You selected the cell range D2:D14. Inside the Function Arguments dialog, you clicked the OK button.

In cell E15, enter a formula to find the highest line item cost this month (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 MAX menu item. Inside the Function Arguments dialog, you clicked the dialog undefined button. You selected the cell range E2:E14. 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.

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.

Delete this row.

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

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

In the Home Ribbon Tab in the Cells Ribbon Group, you clicked the Delete button arrow. 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.

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

In the Home Ribbon Tab in the Cells Ribbon Group, you clicked the Format button. 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.

Insert a column to the left of the selected cell.

In the Home Ribbon Tab in the Cells Ribbon Group, you clicked the Insert button arrow. You right clicked cell D5. In the Right-Click menu, you clicked the Insert... menu item. Inside the Insert Cells dialog, you selected the Entire column Radio Button, clicked the OK button.

Display the task pane where you can view copied items and then paste them into a document.

In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Clipboard Group Dialog Launcher dialog launcher.

Copy the selected text to the clipboard.

In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Copy button.

Copy the selected text and paste it below the text www.mdsclinic.com.

In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Copy button. You clicked the text. In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Paste button.

Cut the selected text.

In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Cut button.

Cut the selected text and paste it below the text Call for a free medical evaluation.

In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Cut button. You clicked into the word the , clicked the text. In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Paste button.

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.

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 Paste (P) button. You clicked the Paste Options button. In the Paste menu, you clicked the Formulas (F) 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 Editing Ribbon Group, you clicked the AutoSum button. You pressed Enter.

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. You pressed Enter.

Use the Navigation task pane to find all instances of the word flight in the document.

In the Home Ribbon Tab in the Editing Ribbon Group, you clicked the Find button. Inside the Navigation dialog, you typed flight in the Search input.

Replace all instances of the word flight with level.

In the Home Ribbon Tab in the Editing Ribbon Group, you clicked the Replace button. Inside the Find and Replace dialog, you typed flight in the Find What input, typed level in the Replace with input, and clicked the Replace All button. Inside the Microsoft Word dialog, you clicked the OK button.

Apply the bold character effect to the selected text.

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

Apply the bold effect to the text.

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

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.

Use the change case command to change the text from lowercase to all capital letters.

In the Home Ribbon Tab in the Font Ribbon Group, you clicked the Change Case button. In the Change Case menu, you clicked the UPPERCASE menu item.

Clear the formatting from the selected text.

In the Home Ribbon Tab in the Font Ribbon Group, you clicked the Clear All Formatting button.

Change the font color of the selected text to the Red Standard color (the second option under Standard Colors).

In the Home Ribbon Tab in the Font Ribbon Group, you clicked the Font Color Picker button arrow. In the Font Color Selection menu, you selected the Red color option.

Change the font size for the selected text to 11 pt.

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 11pt font size.

Change the font for the selected text to Calibri.

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

Apply the italic character effect to the selected text.

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

Apply the italic effect to the selected text.

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

Apply the single underline character effect to the selected text.

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

Apply the underline effect to the selected text.

In the Home Ribbon Tab in the Font Ribbon Group, you clicked the Underline 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 Short Date 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 Short Date option.

Apply the Accounting Number Format to the selected cells.

In the Home Ribbon Tab in the Number Ribbon Group, you clicked the Number group dialog launcher. Inside the Format Cells dialog from the Category list, you selected Accounting. Inside the Format Cells dialog, you clicked the OK button.

Change the number format for the selected cell to the Currency number format.

In the Home Ribbon Tab in the Number Ribbon Group, you clicked the Number group dialog launcher. Inside the Format Cells dialog from the Category list, you selected Currency. Inside the Format Cells dialog, you clicked the OK button.

Change the text so it is aligned to the left.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Align Left button.

Change the text so it is left aligned.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Align Left button.

Change the text so it is vertically aligned in the middle.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Align Text button. In the Align Text menu, you selected the Middle option.

Change the slide size for the presentation to Standard (4:3). Ensure the content will fit the slides.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Align Text button. In the Slide Show Ribbon Tab in the Set Up Ribbon Group, you clicked the Record Slide Show button arrow. In the Slide Show Ribbon Tab in the Start Slide Show Ribbon Group, you clicked the Custom Slide Show button. You clicked the presentation. In the Design Ribbon Tab in the Customize Ribbon Group, you clicked the Slide Size button. In the Slide Size menu, you selected the Standard (4:3) option. Inside the Microsoft PowerPoint dialog, you clicked the Ensure Fit item.

Open the Borders and Shading dialog with the Page Border tab displayed. Add a Shadow border to the document. The border should be 1 pt wide and use the Blue-Gray, Text 2 color (it is the fourth color in the first row under Theme Colors).

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Borders button arrow. In the Border menu, you clicked the Borders and Shading... menu item. You clicked the Page Border tab. Inside the Borders and Shading dialog from the Apply to list, you selected the Shadow Image Button. Inside the Borders and Shading dialog in the Width drop-down, you clicked the 1 pt item. In the Border Color menu, you selected the Blue-Gray, Text 2 color option. Inside the Borders and Shading dialog, you clicked the DialogHeader view, clicked the dialog undefined button, and clicked the OK button.

Apply a top border and bottom border to the paragraph.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Borders button arrow. In the Border menu, you clicked the Top Border menu item. You selected the text beginning with: The MediSport Clinic was founded. In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Borders button arrow. In the Border menu, you clicked the Bottom Border menu item.

Change the selected text to the open circle bullet style.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Bullets button arrow. In the Bullets menu, you selected the Bullet Open Circle option.

Convert the text to a bulleted list using the Star Bullets style.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Bullets button arrow. In the Bullets menu, you selected the Star Bullets option.

Change the alignment of the text so it is center-aligned and aligned along the top of the placeholder.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Center button, clicked the Align Text button. In the Align Text menu, you selected the Top option.

Decrease the indent for the text by one level.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Decrease Indent button.

Increase the indent for the text by one level.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Increase Indent button.

Change the text so it is justified.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Justify button.

Change the line spacing to be 1.5 spacing.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Line Spacing button. In the Line Spacing menu, you clicked the 1.5 menu item.

Change the selected text to a numbered list using the 1., 2., 3. format.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Numbering button arrow. In the Numbered List Selection menu, you selected the 1. 2. 3. option.

Apply the 1. 2. 3. numbered list style to the items.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Numbering button arrow. In the Numbering menu, you selected the 1. 2. 3. option.

Change the document's top and bottom margins to 1" and the right and left margins to 0.7".

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Paragraph dialog launcher. Inside the Paragraph dialog, you clicked the DialogHeader view, clicked the dialog undefined button, and clicked the dialog Close button. In the Layout Ribbon Tab in the Page Setup Ribbon Group, you clicked the Margins button. In the Margins menu, you clicked the Custom Margins... menu item. Inside the Page Setup dialog, you clicked the DialogHeader view, clicked the dialog undefined button, typed 1" in the Top input, typed 1" in the Bottom input, typed .7 in the Left input, typed .7 in the Right input, clicked the DialogHeader view, clicked the dialog undefined button, and clicked the OK button.

Open the Tabs dialog and add a solid line tab leader to the text (option 4 in the Leader section of the Tabs dialog).

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Paragraph dialog launcher. Inside the Paragraph dialog, you clicked the Tabs... button. Inside the Tabs dialog, you selected the 4 ____ Radio Button, clicked the OK button.

Open the Tabs dialog and set a left tab stop at .2".

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Paragraph dialog launcher. Inside the Paragraph dialog, you clicked the Tabs... button. Inside the Tabs dialog, you typed .2 in the Tab stop position box, clicked the Set button, and clicked the OK button.

Add a right tab stop at the 6 inch mark on the ruler.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Paragraph dialog launcher. Inside the Paragraph dialog, you clicked the Tabs... button. Inside the Tabs dialog, you typed 6 in the Tab stop position box, selected the Right Radio Button, clicked the Set button, and clicked the OK button.

Add shading to the paragraph using the Light Gray, Background 2 color (the third color in the first row under Theme Colors).

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Shading button arrow, clicked the Shading button arrow. In the Shading Color Selection menu, you selected the Light Gray, Background 2 color option.

Show the formatting marks in the document.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Show/Hide ¶ button.

Sort the table in ascending order based on the content of the first column.

In the Home Ribbon Tab in the Paragraph Ribbon Group, you clicked the Sort button. Inside the Sort dialog, you clicked the OK button.

Change the layout of the selected slide to use the Two Content layout.

In the Home Ribbon Tab in the Slides Ribbon Group, you clicked the Layout button. In the Gallery Layout menu, you selected the Two Content option.

Apply the Heading 1 style to the selected text.

In the Home Ribbon Tab in the Styles Ribbon Group in the Styles menu, you clicked the Heading 1 gallery option.

Modify this 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 Home Ribbon Tab in the Styles Ribbon Group, you clicked the Cell Styles button, clicked the Format as Table button, and clicked the Conditional Formatting button. In the View Ribbon Tab in the Window Ribbon Group, you clicked the Split button.

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.

Apply the Total cell style to the selected cells.

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

Clear the conditional formatting rules from the worksheet.

In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Conditional Formatting button. In the Conditional Formatting menu in the Clear Rules menu, you clicked the Clear Rules from Entire Sheet menu item.

Apply conditional formatting to the selected cells using the red gradient fill data bar.

In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Conditional Formatting button. In the Conditional Formatting menu in the Data Bars menu, you selected the Red Data Bar (Gradient) option.

Apply conditional formatting to the selected cells so cells with a value greater than 400 are formatted using a light red fill.

In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Conditional Formatting button. In the Conditional Formatting menu in the Highlight Cells Rules menu, you clicked the Greater Than... menu item. Inside the Greater Than dialog, you typed 400 in the Format cells that are GREATER THAN: input. Inside the Greater Than dialog in the with drop-down, you selected Light Red Fill. Inside the Greater Than dialog, you clicked the OK button.

Apply conditional formatting to the selected cells using the Three Traffic Lights (Unrimmed) icon set (the first icon set in the Shapes section).

In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Conditional Formatting button. In the Conditional Formatting menu in the Icon Sets menu, you selected the 3 Traffic Lights (Unrimmed) option.

Apply conditional formatting to the selected cells so cells with the 10 lowest values are formatted with green fill and dark green text.

In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Conditional Formatting button. In the Conditional Formatting menu in the Top/Bottom Rules menu, you clicked the Bottom 10 Items... menu item. Inside the Bottom 10 Items dialog in the format selector box drop-down, you selected Green Fill with Dark Green Text. Inside the Bottom 10 Items dialog, you clicked the OK button.

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.

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.

Clear only the formatting from the selected cell (leaving the content).

In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Format as Table button. In the Home Ribbon Tab in the Editing Ribbon Group, you clicked the Clear button. In the Clear menu, you clicked the Clear Formats menu item.

Add a footer to the document using the Facet (Even Page) format. Add the author Sue Chur to the footer. When you are finished, close the footer.

In the Insert Ribbon Tab in the Header & Footer Ribbon Group, you clicked the Footer button. In the Footer menu, you selected the Facet (Even Page) option. You clicked the Author text input, typed Sue chur in the Author text input. In the Design Ribbon Tab in the Close Ribbon Group, you clicked the Close Header and Footer button.

Change the document so the first page has a different header from the rest of the document.

In the Insert Ribbon Tab in the Header & Footer Ribbon Group, you clicked the Header button. In the Header menu, you clicked the Edit Header menu item. In the Design Ribbon Tab in the Options Ribbon Group, you checked the Different First Page check box.

Using the Date and Time dialog box, add an automatic date stamp to the header of the document. Use the 1/01/2017 format.

In the Insert Ribbon Tab in the Header & Footer Ribbon Group, you clicked the Header button. You clicked the undefined Object, clicked the undefined Object, and clicked the undefined Object. In the Insert Ribbon Tab in the Header & Footer Ribbon Group, you clicked the Footer button, clicked the Header button. You clicked the undefined Object, clicked the undefined Object, and double-clicked the document header. In the Design Ribbon Tab in the Insert Ribbon Group, you clicked the Date & Time button. Inside the Date and Time dialog from the Available formats list, you double-clicked the 8/20/2017 list item. Inside the Date and Time dialog, you clicked the OK button.

Add a page number to the margin of the page using the Accent Bar, Left building block.

In the Insert Ribbon Tab in the Header & Footer Ribbon Group, you clicked the Page Number button. In the Page Number menu in the Page Margins menu, you selected the Accent Bar, Left option.

Remove the page numbers from the document.

In the Insert Ribbon Tab in the Header & Footer Ribbon Group, you clicked the Page Number button. In the Page Number menu, you clicked the Remove Page Numbers menu item.

Insert a Stacked Bar chart to the slide (it is the second option in the Bar category).

In the Insert Ribbon Tab in the Illustrations Ribbon Group, you clicked the Chart button. Inside the Insert Chart dialog from the Chart Type list, you clicked the Bar item. Inside the Insert Chart dialog from the Bar list, you clicked the Stacked Bar item. Inside the Insert Chart dialog, you clicked the OK button.

Open the Online Pictures dialog and search for pictures using the key terms health club using the Bing search engine. Insert the first picture in the results.

In the Insert Ribbon Tab in the Illustrations Ribbon Group, you clicked the Online Pictures button. Inside the Online Pictures dialog, you clicked the Search Box item, double-clicked the Weight room image.

Insert the weight machine picture into the document from the Pictures folder on your computer.

In the Insert Ribbon Tab in the Illustrations Ribbon Group, you clicked the Pictures button. You double-clicked the weight machine item.

Insert an Up Arrow block arrow shape on top of the 2020 column in the chart.

In the Insert Ribbon Tab in the Illustrations Ribbon Group, you clicked the Shapes button. In the Shapes menu, you selected the Up Arrow option. You clicked the chart.

Insert a Repeating Bending Process SmartArt diagram (it is the fourth option in the eighth row in the Process category in the dialog). Type Evaluate in the first shape in the diagram. Type Treat in the second shape. Type Evaluate in the third shape. Type Treat in the fourth shape. Type Release in the fifth shape. When you are finished, click outside the SmartArt diagram.

In the Insert Ribbon Tab in the Illustrations Ribbon Group, you clicked the SmartArt button. Inside the Choose a SmartArt Graphic dialog from the SmartArt Category list, you clicked the Process item. Inside the Choose a SmartArt Graphic dialog, you clicked the Repeating Bending Process image, clicked the OK button. You clicked the first smartart box, typed , clicked the second smartart box, typed , clicked the third smartart box, typed , clicked the fourth smartart box, typed , clicked the fifth smartart box, typed , clicked the smartArt view, and clicked the document text .

Add a Step Up Process SmartArt diagram to the slide.

In the Insert Ribbon Tab in the Illustrations Ribbon Group, you clicked the SmartArt button. Inside the Choose a SmartArt Graphic dialog from the SmartArt Category list, you clicked the Process item. Inside the Choose a SmartArt Graphic dialog, you clicked the Step Up Process image, clicked the OK button.

Open the Online Pictures dialog and search for pictures of physical therapy using the Bing search engine. Insert the photograph of the man with crutches.

In the Insert Ribbon Tab in the Images Ribbon Group, you clicked the Online Pictures button. Inside the Online Pictures dialog, you clicked the Search Box item, clicked the Search Box item, and double-clicked the Therapy assistance - healing recovery image.

Insert the rehab picture into the presentation.

In the Insert Ribbon Tab in the Images Ribbon Group, you clicked the Pictures button. You double-clicked the rehab item.

Add a cover page to the document using the Retrospect style. Add MediSport, Inc. as the company name.

In the Insert Ribbon Tab in the Pages Ribbon Group, you clicked the Cover Page button. In the Cover Page menu, you selected the Retrospect option. You clicked the Company text input, clicked the Company text input, and typed MediSport, Inc in the Company text input.

Insert a hard page break.

In the Insert Ribbon Tab in the Pages Ribbon Group, you clicked the Page Break button.

Add a new slide to the presentation that will include only a title for the slide.

In the Insert Ribbon Tab in the Slides Ribbon Group, you clicked the New Slide button arrow. In the New Slide menu, you selected the Title Only option.

Add a table with three columns and seven rows to the slide.

In the Insert Ribbon Tab in the Tables Ribbon Group, you clicked the Table button. In the Table menu, you clicked the Insert Table... menu item. Inside the Insert Table dialog, you typed 3 in the Number of columns input, typed 7 in the Number of rows input, and clicked the OK button.

Insert a table that has four columns and four rows.

In the Insert Ribbon Tab in the Tables Ribbon Group, you clicked the Table button. In the Table menu, you selected the 4x4 Table option.

Add an element to the center section of the header to display the current date (not Dec 18, which is the worksheet name).

In the Insert Ribbon Tab in the Text Ribbon Group, you clicked the Header & Footer button. In the Design Ribbon Tab in the Header & Footer Elements Ribbon Group, you clicked the Current Date button.

Add a footer to every slide in the presentation except the title slide that reads MediSport Clinic.

In the Insert Ribbon Tab in the Text Ribbon Group, you clicked the Header & Footer button. Inside the Header and Footer dialog, you checked the Footer check box, checked the Don't show on title slide check box, and clicked the Apply to All button.

Add a text box below the photographs. Add the text Pro-tech clothing. When you are done, click anywhere on the slide.

In the Insert Ribbon Tab in the Text Ribbon Group, you clicked the Text Box button. You clicked the text box Text, clicked the text box, typed Pro-tech Clothing, and clicked the slide.

Add a curved right arrow (the first option in the second row in the Block Arrows section) above the arrow on the slide.

In the Insert Ribbon Tab in the Text Ribbon Group, you clicked the WordArt button. In the Insert Ribbon Tab in the Illustrations Ribbon Group, you clicked the Shapes button. In the Insert Shapes menu, you selected the Curved Right Arrow option. You clicked the active slide.

Add WordArt above the photograph in the brochure that reads A new approach to healing. Insert the WordArt using the first option in the WordArt gallery.

In the Insert Ribbon Tab in the Text Ribbon Group, you clicked the WordArt button. In the WordArt menu, you selected the Fill: Black, Text color 1; Shadow option. You selected the text beginning with: Your text here, typed A new approach to healing.

Add WordArt to the presentation that reads Pro-Tech Clothing. Use the fourth option in the second row of the gallery. When you are done, click outside the text box.

In the Insert Ribbon Tab in the Text Ribbon Group, you clicked the WordArt button. In the WordArt menu, you selected the Fill: White; Outline: Blue, Accent color 1; Glow: Blue, Accent color 1 option. You typed Pro-Tech Clothing, clicked the slide.

Use the AutoFit command on the Ribbon to resize the table so it fits the contents of the table.

In the Layout Ribbon Tab in the Cell Size Ribbon Group, you clicked the AutoFit button. In the AutoFit menu, you clicked the AutoFit Contents menu item.

Use the distribute command to change all the columns to the same width.

In the Layout Ribbon Tab in the Cell Size Ribbon Group, you clicked the Distribute Columns button.

Use the distribute command to change all the rows to the same height.

In the Layout Ribbon Tab in the Cell Size Ribbon Group, you clicked the Distribute Rows button.

Change the row height of the current row to .4".

In the Layout Ribbon Tab in the Cell Size Ribbon Group, you set the Height: to .4.

Change the column width of the Scarsdale column to 1.25".

In the Layout Ribbon Tab in the Cell Size Ribbon Group, you set the Width: to 1.25.

Merge the three selected cells back into a single cell.

In the Layout Ribbon Tab in the Merge Ribbon Group, you clicked the Merge Cells button.

Split the current cell of the table into three columns and one row.

In the Layout Ribbon Tab in the Merge Ribbon Group, you clicked the Split Cells button. Inside the Split Cells dialog, you typed 3 in the Number of columns input, clicked the OK button.

Insert a column break.

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

Insert a hard page break that will insert a new section on the next page.

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

Use one of Word's preset margins settings to change the document's margins so that the top and bottom borders are 1" and the left and right margins are 2".

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

Format the text into two columns with the left column narrower than the right column. Use a column preset.

In the Layout Ribbon Tab in the Page Setup Ribbon Group, you clicked the Size button, clicked the Columns button. In the Columns menu, you clicked the More Columns menu item. Inside the Columns dialog from the Presets list, you selected the Two Image Button, selected the Left Image Button, and selected the Left Image Button. Inside the Columns dialog, you clicked the OK button.

Change the spacing before the paragraph to 12 pt. and the spacing after the paragraph to 12 pt.

In the Layout Ribbon Tab in the Paragraph Ribbon Group, you set the Before: to 12, set the After: to 12.

Insert a new row below the second row in the table.

In the Layout Ribbon Tab in the Rows & Columns Ribbon Group, you clicked the Insert Below button.

Insert a new column to the left of the selected column.

In the Layout Ribbon Tab in the Rows & Columns Ribbon Group, you clicked the Insert Left button.

Select the third column in the table.

In the Layout Ribbon Tab in the Table Ribbon Group, you clicked the Select button. In the Select menu, you clicked the Select Column menu item.

Select the third row in the table.

In the Layout Ribbon Tab in the Table Ribbon Group, you clicked the Select button. In the Select menu, you clicked the Select Row menu item.

Use a single command on the Ribbon to show the gridlines for the table.

In the Layout Ribbon Tab in the Table Ribbon Group, you clicked the View Gridlines button.

Delete the second column in the table.

In the Mini Toolbar, you clicked the Delete button. In the Delete menu, you clicked the Delete Columns menu item.

Delete the third row in the table.

In the Mini Toolbar, you clicked the Delete button. In the Delete menu, you clicked the Delete Rows menu item.

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

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.

Change the width of the selected columns to 14.

In the Page Layout Ribbon Tab in the Scale To Fit Ribbon Group, you clicked the Width: drop-down arrow, clicked the Width: drop-down arrow. 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.

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 Dec 18 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.

Add a caption to display above the chart. The caption should read Figure 1: Financial Overview 2014 - 2018 .

In the References Ribbon Tab in the Captions Ribbon Group, you clicked the Insert Caption button. Inside the Caption dialog, you typed Figure 1: Financial Overview 2014 - 2018 in the captionInput input. Inside the Caption dialog in the Position drop-down, you selected Above selected item. Inside the Caption dialog, you clicked the OK button.

Add a bibliography using the Bibliography style.

In the References Ribbon Tab in the Citations & Bibliography Ribbon Group, you clicked the Insert Citation button, clicked the Bibliography button. In the Bibliography menu, you selected the Bibliography option.

From the Source Manager add the Neil Patella source from the Master List to the Current List and add the Celia Woods source from the Current List to the Master List. When you are finished, close the Source Manager.

In the References Ribbon Tab in the Citations & Bibliography Ribbon Group, you clicked the Insert Citation button, clicked the Manage Sources button. Inside the Source Manager dialog from the Master List list, you selected Patella, Neil; Sports Massage for Emotional Well-Being (2016). Inside the Source Manager dialog, you clicked the Copy -> button. Inside the Source Manager dialog from the Current List list, you selected Woods, Celia; Wrap it Up (2016). Inside the Source Manager dialog, you clicked the <- Copy button, clicked the Close button.

Add a new source for a bibliography. Enter the following information for the source - Type of Source: Article in a Periodical, Author: Celia Woods, Title: Wrap It Up, Periodical Title: Spa Lovers Magazine, Year: 2016, Month: August, Day: 23, Pages: 32.

In the References Ribbon Tab in the Citations & Bibliography Ribbon Group, you clicked the Insert Citation button. In the Insert Citation menu, you clicked the Add New Source... menu item. Inside the Create Source dialog in the Type of Source drop-down, you selected Article in a Periodical. Inside the Create Source dialog, you clicked the OK button.

Add a citation that references the Celia Woods source.

In the References Ribbon Tab in the Citations & Bibliography Ribbon Group, you clicked the Insert Citation button. In the Insert Citation menu, you clicked the Woods, Celia menu item.

Change the reference style for the document to use the MLA style.

In the References Ribbon Tab in the Citations & Bibliography Ribbon Group, you clicked the Style drop-down arrow. In the Style: menu, you clicked the MLA menu item.

Convert the endnotes back to footnotes.

In the References Ribbon Tab in the Footnotes Ribbon Group, you clicked the Footnotes dialog launcher. Inside the Footnote and Endnote dialog, you selected the Endnotes: Radio Button, clicked the Convert... button. Inside the Convert Notes dialog, you clicked the OK button.

Convert the footnotes in the document into endnotes.

In the References Ribbon Tab in the Footnotes Ribbon Group, you clicked the Footnotes dialog launcher. Inside the Footnote and Endnote dialog, you selected the Endnotes: Radio Button, clicked the Convert... button. Inside the Convert Notes dialog, you clicked the OK button.

Add a footnote that reads: Testimonials from professional athletes available upon request. When you are finished, press Enter.

In the References Ribbon Tab in the Footnotes Ribbon Group, you clicked the Insert Footnote button. You typed Testimonials from professional athletes available upon request, pressed the Enter key.

Use the Smart Lookup task pane to look up information about the selected text.

In the References Ribbon Tab in the Research Ribbon Group, you clicked the Smart Lookup button.

Insert a table of contents based on the Automatic Table 1 format.

In the References Ribbon Tab in the Table of Contents Ribbon Group, you clicked the Table of Contents button. In the Table of Contents menu, you selected the Automatic Table 1 option.

Accept all the changes in the document.

In the Review Ribbon Tab in the Changes Ribbon Group, you clicked the Accept button arrow. In the Accept menu, you clicked the Accept All Changes menu item.

Accept the selected change.

In the Review Ribbon Tab in the Changes Ribbon Group, you clicked the Accept button arrow. In the Accept menu, you clicked the Accept This Change menu item.

Accept the current change and move to the next one.

In the Review Ribbon Tab in the Changes Ribbon Group, you clicked the Accept button arrow. In the Accept menu, you clicked the Accept and Move to Next menu item.

Move to the next change in the document.

In the Review Ribbon Tab in the Changes Ribbon Group, you clicked the Next button.

Reject the current change.

In the Review Ribbon Tab in the Changes Ribbon Group, you clicked the Reject button arrow. In the Reject menu, you clicked the Reject Change menu item.

Reject the current change and move to the next one.

In the Review Ribbon Tab in the Changes Ribbon Group, you clicked the Reject button arrow. In the Reject menu, you clicked the Reject and Move to Next menu item.

Delete the selected comment.

In the Review Ribbon Tab in the Comments Ribbon Group, you clicked the Delete button.

Add the comment and therapists to the selected text.

In the Review Ribbon Tab in the Comments Ribbon Group, you clicked the New Comment button. You selected the text beginning with: doctors, commented and therapists.

Move to the next comment in the document.

In the Review Ribbon Tab in the Comments Ribbon Group, you clicked the Next button.

Move to the previous comment in the document.

In the Review Ribbon Tab in the Comments Ribbon Group, you clicked the Previous button.

Check the document for spelling and grammar errors. Fix the grammar error that is found.

In the Review Ribbon Tab in the Proofing Ribbon Group, you clicked the Spelling & Grammar button. Inside the Editor dialog from the Spelling Corrections List list, you clicked hurt?. Inside the Microsoft Word dialog, you clicked the OK button.

Using the Spelling and Grammar task pane, check the document for spelling errors. Replace the misspelled word sraff with staff.

In the Review Ribbon Tab in the Proofing Ribbon Group, you clicked the Spelling & Grammar button. Inside the Editor dialog from the Spelling Corrections List list, you clicked staff. Inside the Microsoft Word dialog, you clicked the OK button.

Check the document for spelling errors, and change all instances of the word athleets to athletes using a single command.

In the Review Ribbon Tab in the Proofing Ribbon Group, you clicked the Spelling & Grammar button. Inside the Editor dialog from the Spelling Corrections List list, you opened the Spelling Error Suggestions Context Menu. In the Spelling Error Suggestions menu, you clicked the Change All menu item. Inside the Microsoft Word dialog, you clicked the OK button.

Using the Spelling Checker, correct any misspellings found in the presentation.

In the Review Ribbon Tab in the Proofing Ribbon Group, you clicked the Spelling button. Inside the Spelling dialog, you clicked the Change button. Inside the Spelling dialog from the Spelling Corrections list, you selected Braces. Inside the Spelling dialog, you clicked the Change button. Inside the Microsoft PowerPoint dialog, you clicked the OK button.

Using the Thesaurus, replace the selected word (founded) with the synonym established.

In the Review Ribbon Tab in the Proofing Ribbon Group, you clicked the Thesaurus button. Inside the Thesaurus dialog from the Thesaurus Suggestions list from the originated (v.) list, you double-clicked the established list item, selected established, and clicked the arrow next to the word established. In the Thesaurus Insert Item menu, you clicked the Insert menu item.

Open the dialog where you can review the number of words in the document.

In the Review Ribbon Tab in the Proofing Ribbon Group, you clicked the Word Count button.

Change the track changes option to display no markup in the document.

In the Review Ribbon Tab in the Tracking Ribbon Group, you clicked the Display Review drop-down arrow. In the Display Review menu, you clicked the No Markup menu item.

Change the track changes option to show simple markup in the document.

In the Review Ribbon Tab in the Tracking Ribbon Group, you clicked the Display Review drop-down arrow. In the Display Review menu, you clicked the Simple Markup menu item.

Turn on Track Changes and delete the selected text.

In the Review Ribbon Tab in the Tracking Ribbon Group, you clicked the Track Changes button, clicked the Track Changes button arrow. You clicked the alongside the clinics and text, clicked into the word the to sell their products. , clicked the document text , clicked the alongside the clinics and text, clicked into the word the alongside the clinics and , clicked the alongside the clinics and text, clicked into the word the alongside the clinics and , clicked the to sell their products. text, clicked into the word the to sell their products. , clicked the document text , selected the text beginning with: alongside the clinics and health, right-clicked the alongside the clinics and text, clicked the alongside the clinics and text, clicked the alongside the clinics and text, double-clicked the alongside the clinics and text, and pressed the Delete key.

Turn off Track Changes.

In the Review Ribbon Tab in the Tracking Ribbon Group, you clicked the Track Changes button.

Record the slide show using narration and timings.

In the Slide Show Ribbon Tab in the Set Up Ribbon Group, you clicked the Record Slide Show button. Inside the Record Slide Show dialog, you clicked the Start Recording button.

Start the Rehearse Timings feature.

In the Slide Show Ribbon Tab in the Set Up Ribbon Group, you clicked the Rehearse Timings button.

Start the slide show from the first slide.

In the Slide Show Ribbon Tab in the Start Slide Show Ribbon Group, you clicked the From Beginning button.

Start the slide show from the current slide.

In the Slide Show Ribbon Tab in the Start Slide Show Ribbon Group, you clicked the From Current Slide button.

With one command, apply the transition to all the slides in the presentation.

In the Transitions Ribbon Tab in the Timing Ribbon Group, you clicked the Apply To All button.

Apply the Cover transition to the first slide and then apply the Breeze sound to the slide. After the sound has been applied, apply the transition to all the slides in the presentation with a single command.

In the Transitions Ribbon Tab in the Transition to This Slide Ribbon Group in the Transition menu, you clicked the Cover gallery option. In the Transitions Ribbon Tab in the Timing Ribbon Group, you clicked the Sound drop-down arrow. In the Sound menu, you clicked the Breeze menu item. In the Transitions Ribbon Tab in the Timing Ribbon Group, you clicked the Apply To All button.

Apply the Cut transition to the selected slide.

In the Transitions Ribbon Tab in the Transition to This Slide Ribbon Group in the Transition menu, you clicked the Cut gallery option.

Display the view where you can view how your notes will print.

In the View Ribbon Tab in the Presentation Views Ribbon Group, you clicked the Notes Page button.

Display the Ruler.

In the View Ribbon Tab in the Show Ribbon Group, you checked the Ruler check box.

Hide the Ruler.

In the View Ribbon Tab in the Show Ribbon Group, you unchecked the Ruler check box.

Display the pane where you can add speaker notes for the slide.

In the application footer, you clicked the Notes button.

Display the Notes pane and add the note Give specific release date for each product to Slide 2. When you are finished switch to Notes Page view.

In the application footer, you clicked the Notes button. You clicked the text box, clicked the text box, typed Click to add notes Give specific release date for each product, and pressed the ArrowDown keyboard shortcut. In the View Ribbon Tab in the Presentation Views Ribbon Group, you clicked the Notes Page button.

Switch to Reading view.

In the application footer, you clicked the Reading View button.

Switch to Slide Show view.

In the application footer, you clicked the Slide Show button.

Switch to Slide Sorter view.

In the application footer, you clicked the Slide Sorter button.

Switch to Slide Sorter view and then move Slide 3 so it appears between Slide 1 and Slide 2.

In the application footer, you clicked the Slide Sorter button. You clicked the Slide3 slide in the Slides tab, moved Slide 3 to its new position as Slide 2.

Use the Redo command to redo the last action taken.

In the application header, you clicked the Redo button.

Use the Undo command to undo the last action taken.

In the application header, you clicked the Undo button.

Use the Office Clipboard to paste the MediSport Clinic text to the document.

Inside the Clipboard dialog from the Item to Paste list, you clicked the MediSport Clinic item.

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

You resized the chart.

Modify this query to show only students who are freshmen. Add criteria to the Classification field to return only records where the classification is FR. Run the query.

You changed the Classification field's criteria to FR. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Add criteria to this query to return only the records where the value in the Credits field is >124 and the value in the Classification field is Sr Run the query to view the results.

You changed the Credits field's criteria to >124, changed the Classification field's criteria to Sr . In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Add criteria to this summary query to include only records where the value in the Days field is TTh. Do not include the Days field in the query groups. Run the query.

You changed the Days field's criteria to TTh, clicked the Days field's Total row, expanded the Total row's Group by list, and selected the Where option. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Add criteria to this query to return only the records where the value in the DeptCode field is ENG or CIS. Run the query to view the results.

You changed the DeptCode field's criteria to ENG , clicked the DeptCode field's criteria row, clicked the DeptCode field's criteria row, changed the DeptCode field's criteria to ENG, changed the deptCode field's or row to CIS, clicked the deptCode field's or row, clicked the deptCode field's or row, and clicked the deptCode field's or row. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Create a parameter query where the user will enter a value to use as the criterion for the DeptCode field. Use the prompt Enter Department Code. Run the query using the Department Code FIN.

You changed the DeptCode field's criteria to Enter Department Code, clicked the DeptCode field's criteria row, and changed the DeptCode field's criteria to [Enter Department Code]. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button. Inside the Enter Parameter Value dialog, you clicked the OK button.

Add criteria to this query to return records where the student LastName field begins with the letter A. Run the query.

You changed the LastName field's criteria to Like A*, clicked the lastName field's or row, clicked the LastName field's criteria row, and clicked the lastName field's or row. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Which types of computers have all of the hardware integrated with the monitor? Select your answer, then click Done. [Test Bank Question]

You chose All-in-one computers, clicked the Done button.

Although Google owns _________ and manages the Google Play Store for apps, they allow any manufacturer to use and modify this operating system for their devices. Select your answer, then click Done. [Test Bank Question]

You chose Android, clicked the Done button.

Which of the following is NOT a web browser? Select your answer, then click Done. [Test Bank Question]

You chose Bing, clicked the Done button.

As the main processor of a computer, the _________ is responsible for organizing and carrying out instructions in order to produce a desired output. Select your answer, then click Done. [Test Bank Question]

You chose CPU, clicked the Done button.

Which of the following is an example of spreadsheet software? Select your answer, then click Done. [Test Bank Question]

You chose Excel, clicked the Done button.

The _________ language, which was used in the first web page ever created, is still in use today. Select your answer, then click Done. [Test Bank Question]

You chose HTML, clicked the Done button.

Every type of Internet service requires a connection to a(n) _______. Select your answer, then click Done. [Test Bank Question]

You chose ISP, clicked the Done button.

The largest network in the world is known as the _________, which connects billions of people and organizations throughout the world. Select your answer, then click Done. [Test Bank Question]

You chose Internet, clicked the Done button.

In which of the following social networking sites are you most likely to find professionals who seek to make business-related connections?. Select your answer, then click Done. [Test Bank Question]

You chose LinkedIn, clicked the Done button.

_________, such as Windows or Mac OS, exist primarily to help the computer run and manage its resources. Select your answer, then click Done. [Test Bank Question]

You chose Operating systems, clicked the Done button.

Which of the following is NOT a cloud storage service? Select your answer, then click Done. [Test Bank Question]

You chose Skype, clicked the Done button.

The _________ language, which was used in the first web page ever created, is still in use today. Select your answer, then click Done. [Test Bank Question]

You chose TCP/IP, chose HTML, and clicked the Done button.

_________ is a program that disguises itself as an interesting, useful, or desirable program in order to gain access to your system. Select your answer, then click Done. [Test Bank Question]

You chose Trojan horse, clicked the Done button.

Web pages have a standard addressing system known as a(n) _________, which allows them to be located on the Internet. Select your answer, then click Done. [Test Bank Question]

You chose URL, clicked the Done button.

The most popular plug on a computer is the small, rectangular _________ port, which is used to connect almost all of today's external devices. Select your answer, then click Done. [Test Bank Question]

You chose USB, clicked the Done button.

Because it increases the security of a network connection, a _________ is often required for users who wish to access a company's private network over an Internet connection. Select your answer, then click Done. [Test Bank Question]

You chose VPN, clicked the Done button.

_________ can run mobile-style apps in the area known as the Start screen, while running traditional software in the more familiar desktop. Select your answer, then click Done. [Test Bank Question]

You chose Windows 8 or Windows 10, clicked the Done button.

Which of the following is an example of word processing software? Select your answer, then click Done. [Test Bank Question]

You chose Word, clicked the Done button.

Which of the following is the most popular video sharing site, offering millions of different videos that have been uploaded by users? Select your answer, then click Done. [Test Bank Question]

You chose YouTube, clicked the Done button.

_________ printers combine either inkjet or laser printing capabilities with scanning, photocopying, and faxing capabilities. Select your answer, then click Done. [Test Bank Question]

You chose all-in-one, clicked the Done button.

_________ software, which is made for the user, allows individuals to complete a variety of work and school-related tasks. Select your answer, then click Done. [Test Bank Question]

You chose application, clicked the Done button.

The term _________ refers to the set of online behaviors that are considered polite and proper. Select your answer, then click Done. [Test Bank Question]

You chose attribution, chose netiquette, chose attribution, chose netiquette, and clicked the Done button.

A _________ is a copy of one or more files (or entire storage devices) that is made in case the originals become lost or damaged. Select your answer, then click Done. [Test Bank Question]

You chose backup, clicked the Done button.

To view web pages, you need special software known as a web _______. Select your answer, then click Done. [Test Bank Question]

You chose browser, clicked the Done button.

With _________ storage services, your files can be stored online and accessed from any Internet-connected device. Select your answer, then click Done. [Test Bank Question]

You chose cloud, clicked the Done button.

_________ are small data files that are created by websites in order to remember users and their preferences the next time they visit the site. Select your answer, then click Done. [Test Bank Question]

You chose cookies, clicked the Done button.

Operating systems typically contain a disk _________ or optimization utility, which will reorganize files and fragments to place related ones nearer to each other. Select your answer, then click Done. [Test Bank Question]

You chose defragmentation, clicked the Done button.

_________ means doing business online, such as when a consumer buys a product over the Web instead of going to a store to buy it. Select your answer, then click Done. [Test Bank Question]

You chose e-commerce, clicked the Done button.

_________ allows messages to be sent to electronic mailboxes in an instant. Select your answer, then click Done. [Test Bank Question]

You chose email, clicked the Done button.

A software-based _________ is dedicated to examining and blocking Internet traffic. Select your answer, then click Done. [Test Bank Question]

You chose firewall, clicked the Done button.

The _________ is the primary storage device of a personal computer. Select your answer, then click Done. [Test Bank Question]

You chose hard drive, clicked the Done button.

The starting page for your web browser is known as the _________ page. Select your answer, then click Done. [Test Bank Question]

You chose home, clicked the Done button.

You will often find _________ on a web document that, when clicked, act as connectors to another document on the World Wide Web. Select your answer, then click Done. [Test Bank Question]

You chose hyperlinks, clicked the Done button.

_________ printers create an image directly on the paper by spraying ink through tiny nozzles. Select your answer, then click Done. [Test Bank Question]

You chose inkjet, clicked the Done button.

_________ is the act of having an online, text-based conversation with one or more individuals that occurs in real time. Select your answer, then click Done. [Test Bank Question]

You chose instant messaging, clicked the Done button.

Because of their sharp quality text output and fast printing speeds, _________ printers are often preferred by businesses. Select your answer, then click Done. [Test Bank Question]

You chose laser, clicked the Done button.

A(n) _________ allows users to communicate and share information between computers. Select your answer, then click Done. [Test Bank Question]

You chose network, clicked the Done button.

_________ involves luring individuals into entering personal information into a website controlled by the hacker. Select your answer, then click Done. [Test Bank Question]

You chose phishing, clicked the Done button.

In the world of computing, _________ means acquiring or exchanging copies of protected digital creations without payment or permission from their creator. Select your answer, then click Done. [Test Bank Question]

You chose piracy, clicked the Done button.

A monitor's screen is divided up into millions of tiny dots, called _______. Select your answer, then click Done. [Test Bank Question]

You chose pixels, clicked the Done button.

Turning in the work of another as if it were your own or failing to cite the source of your work in known as ________. Select your answer, then click Done. [Test Bank Question]

You chose plagiarism, clicked the Done button.

The _________ of a monitor refers to the number of pixels that it can display on the screen. Select your answer, then click Done. [Test Bank Question]

You chose resolution, clicked the Done button.

_________ are sophisticated services that store the URL of millions of web pages and most of the content on those pages. Select your answer, then click Done. [Test Bank Question]

You chose search engines, clicked the Done button.

A(n) _________ is a combination of mobile phone and handheld computer. Select your answer, then click Done. [Test Bank Question]

You chose smartphone, clicked the Done button.

_________ networking services make it easy for friends and family to share updates and special events with each other. Select your answer, then click Done. [Test Bank Question]

You chose social, clicked the Done button.

Which of the following is NOT one of the typical navigation button/features of a web browser? Select your answer, then click Done. [Test Bank Question]

You chose start, clicked the Done button.

A _________ is a mobile device that typically ranges from seven to ten inches in size. Select your answer, then click Done. [Test Bank Question]

You chose tablet, clicked the Done button.

Which technology has become the primary way in which we interact with our tablets and smartphones? Select your answer, then click Done. [Test Bank Question]

You chose touchscreen, clicked the Done button.

A _________ is a type of malware that is attached to a host file and has the ability to replicate, or copy, itself. Select your answer, then click Done. [Test Bank Question]

You chose virus, clicked the Done button.

_________ is a fully-contained program that self-replicates and spreads through computers and networks. Select your answer, then click Done. [Test Bank Question]

You chose worm, clicked the Done button.

Use AutoFill to complete the series from cell B7 through cell E7.

You clicked and dragged the cell B7 fill handle, released the mouse button on cell E7.

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.

Sort the Date column so the oldest dates are listed first.

You clicked cell A1, clicked the Quick Sort dropdown. In the Table Filter menu, you clicked the Sort A to Z menu item.

Select cells A5:D8.

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

Sort this data alphabetically from A to Z by values in the Category column.

You clicked cell B1, clicked the Quick Sort dropdown. In the Table Filter menu, you clicked the Sort A to Z menu item.

Sort this data by values in the Cost column so the most expensive items are listed first.

You clicked cell C1, clicked the Quick Sort dropdown, clicked cell C1, clicked the Quick Sort dropdown, clicked cell C1, and clicked the Quick Sort dropdown. In the Table Filter menu, you clicked the Sort Z to A menu item.

Cells J2:M6 have been copied. Paste the copied cells into the selected worksheet location (cell N2) so the formulas, formatting, and source cell widths are pasted.

You clicked cell N2. In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Paste button arrow. In the Paste menu, you clicked the Paste (P) button. You clicked the Paste Options button. In the Paste menu, you clicked the Paste (P) button. You clicked the Paste Options button. In the Paste menu, you clicked the Keep Source Column Widths (W) button.

Apply a gradient as the background for the slide. First apply the Bottom Spotlight - Accent 3 preset (the third option in the fourth row) and then change the type to Rectangular and then change the direction to From Top Right Corner (the fourth option). Apply the gradient to all the slides in the presentation.

You clicked in the textBox, right-clicked the slide0SlideContent1 TextBox, clicked in the textBox, right-clicked the slide0SlideContent1 TextBox, clicked in the textBox, right-clicked the text, selected the color from slide0SlideContent1 using the EyeDropper Tool, clicked in the textBox, right-clicked the slide0SlideContent1 TextBox, and right-clicked the slide. In the Right-Click menu, you clicked the Format Background menu item. Inside the Format Background dialog from the Fill list, you selected the Gradient Fill Radio Button, clicked the Preset gradients button. In the Preset Gradients menu, you selected the Bottom Spotlight - Accent 3 option. Inside the Format Background dialog from the Fill list, you clicked the Fill list item. Inside the Format Background dialog from the Fill list in the Type drop-down, you selected Rectangular. Inside the Format Background dialog from the Fill list, you clicked the Gradient Fill Direction Gallery button. In the Direction menu, you selected the Linear Diagonal - Bottom Left to Top Right option. Inside the Format Background dialog, you clicked the Apply to All button.

Select the second paragraph in the letter.

You clicked into the word the We are still located one , selected the text beginning with: We are still located one.

Select column B.

You clicked on column B.

Using the Slides tab (Thumbnails), navigate to the fourth slide in the presentation.

You clicked on the Slide4 thumbnail.

Collapse the entire outline to show just the subtotals.

You clicked the 2 outline symbol.

Click any of the data markers to select the entire Gross Profit data series.

You clicked the 2019 Gross Profit data marker.

Hide the chart's data table.

You clicked the Chart Elements button. In the Mini Toolbar, you unchecked the Data Table check box.

Add criteria to this query to return only the records where the value in the Credits field is less than 90 and the value in the Classification field is Jr or Sr (without punctuation). Run the query to view the results.

You clicked the Credits field's criteria row, changed the Credits field's criteria to <90, clicked the credits field's or row, changed the credits field's or row to <90, clicked the Classification field's criteria row, changed the Classification field's criteria to Jr, clicked the classification field's or row, and changed the classification field's or row to Sr. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

What do you need to access the Internet at home? Click the button(s) to select the answer. When you are finished, click Done.

You selected the ISP option, clicked the Done button.

Add criteria to this query to return only the records where the value in the Credits field is greater than 120 and less than 130. Run the query to view the results.

You clicked the Credits field's criteria row, changed the Credits field's criteria to >120 and <130. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Limit the query results to records where the value in the Credits field is greater than 120. Run the query to view the results.

You clicked the Credits field's criteria row, changed the Credits field's criteria to >120. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Set the sort order so the results will display records with the highest number of credits first. Run the query and review the results.

You clicked the Credits field's sort row, expanded the Credits field's sort options list, and selected the Descending option. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Modify this query so the DeptCode field is hidden in the query results, and then run the query.

You clicked the DeptCode column's Show box. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Add a new calculated field named Tuition in the first empty column to the right of the Credits field. The new field should calculate the value in the Credits field multiplied by 150. Run the query to view the results.

You clicked the Drop-Down Menu, right-clicked the Drop-Down Menu. In the Right-Click menu, you clicked the Zoom... menu item. Inside the Zoom dialog, you typed Tuition:[Credits]*150 in the Zoom Value Input input, clicked the Query Zoom Ok Button button. In the Design Ribbon Tab in the Results Ribbon Group, you clicked the Run button.

Insert a 3-D pie chart to the document. Replace Sales with Projected Sales 2017. Replace 8.2 with 83,250. Replace 3.2 with 42,120. Replace 1.4 with 96,150. Replace 1.2 with 118,120. When you are done, close the Chart in Microsoft PowerPoint dialog.

You clicked the Insert Chart icon. Inside the Insert Chart dialog from the Chart Type list, you selected Pie. Inside the Insert Chart dialog from the Pie list, you clicked the 3-D Pie item. Inside the Insert Chart dialog, you clicked the OK button. You clicked the formula bar, typed "Projected Sales 2017" in the formula bar, clicked cell B2, typed 83250 in cell B2, clicked cell B3, typed 42120 in cell B3, pressed the ArrowDown keyboard shortcut, typed 42120 in cell B3, pressed the ArrowDown keyboard shortcut, typed 42120 in cell B3, clicked cell B4, typed 96150 in cell B4, clicked cell B5, typed 118120 in cell B5, and clicked the Close button in the chart dialog.

Add a Vertical Box List SmartArt diagram to the slide. Add the text Equipment to the top shape. When you are done, click outside the diagram to deselect it.

You clicked the Insert a SmartArt Graphic icon. Inside the Choose a SmartArt Graphic dialog from the SmartArt Category list, you selected List. Inside the Choose a SmartArt Graphic dialog, you clicked the Vertical Box List image, clicked the OK button. You clicked the Equipment, typed Equipment, and clicked the active slide.

Name cell B9 as follows: COLA

You clicked the Name Box, typed COLA, and pressed Enter.

Click the Name Box.

You clicked the Name Box.

Change the pointer in the presentation to a highlighter.

You clicked the Pointer Options button. In the Pointer Options menu, you clicked the Highlighter menu item.

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

You clicked the Print Selection button, 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.

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

You clicked the Quick Analysis Tool button, clicked the Charts tab header, clicked the More... button, and clicked the All Charts tab. Inside the Insert Chart dialog from the Chart Type list, you selected Pie. Inside the Insert Chart dialog from the Pie Chart list, you clicked the 3-D Pie item. Inside the Insert Chart dialog, you clicked the OK button.

Use the Quick Analysis tool to apply the Data Bars conditional formatting option to the selected cells.

You clicked the Quick Analysis Tool button, clicked the Data Bars 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.

Reply to the comment with the following: Will include in final draft.

You clicked the Reply button, commented Will include in final draft.

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.

Rename Sheet1: Dec 26

You clicked the Sheet1 tab, double-clicked the Sheet1 tab, typed "Dec 26", and pressed Enter.

Open Presenter View.

You clicked the Slide Show Options button. In the Slide Show menu, you clicked the Show Presenter View menu item.

Select the table.

You clicked the Table Move Handle.

Click the x axis.

You clicked the X axis.

Select the y axis.

You clicked the Y axis.

Click the chart legend.

You clicked the chart legend.

Use the right-click method to correct the misspelling of the word controol with the correction control. Do not open the Spelling and Grammar task pane.

You clicked the document text , right-clicked the controol text. In the Spell Check: Right Click Menu menu in the Spelling menu, you clicked the control menu item.

Using the right-click method, fix the spacing error in the second paragraph. Do not open the Spelling and Grammar task pane.

You clicked the document text , right-clicked the still located text. In the Spell Check: Right Click Menu menu in the Grammar menu, you clicked the still located menu item.

Open the Insert Hyperlink dialog to add a hyperlink that reads See the Appendix to the document. The link should take the reader to the Appendix section in the same document.

You clicked the document text , right-clicked the text. In the Paragraph Right Click menu, you clicked the Link menu item. Inside the Insert Hyperlink dialog, you typed See the Appendix in the insertHyperlinkTextToDisplayInput input. Inside the Insert Hyperlink dialog from the insertHyperlinkLinkToTabList list, you clicked the Place in This Document item. Inside the Insert Hyperlink dialog from the placeInDocHyperlinkSelectAPlaceTreeList list from the placeInDocHyperlinkHeadingsTreeList list, you double-clicked the Appendix list item. Inside the Insert Hyperlink dialog, you clicked the OK button.

Text has been copied to the Clipboard. Without opening the Clipboard task pane, paste the text using the paste option that will match style of the pasted text with the surrounding text.

You clicked the document text , right-clicked the text. In the specialPasteRightClickMenu menu, you clicked the Merge Formatting (M) button.

Select the word circumstances in the first sentence of the first paragraph of the letter.

You clicked the document text , selected the text beginning with: circumstances.

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.

You clicked the formula bar, pressed the F4 keyboard shortcut, pressed the F4 keyboard shortcut, pressed Enter, clicked cell D2, clicked and dragged the cell D2 fill handle, and released the mouse button on cell D6.

Click the formula bar.

You clicked the formula bar.

Using the drag method, make the picture smaller.

You clicked the image view, clicked the document text .

Using the Format Painter, copy the formatting from the phrase no elevator access and apply the formatting to the word unable (it is in the last sentence of the second paragraph of the letter).

You clicked the no elevator access text. In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Format Painter button. You clicked into the word the unable text, clicked the document text , and selected the text beginning with: unable.

Go to the preceding slide in the slide show.

You clicked the presentation, clicked the presentation, and clicked the Previous Slide button.

Add the text Overview as the title text for the slide. When you are done, click outside the text placeholder.

You clicked the title placeholder, typed Overview, and clicked the slide.

The Anne Cole data point has been selected for you. Explode the Anne Cole data point by exactly 50% to move it away from the rest of the pie chart.

You correctly performed the required steps

Autofit column D to best fit the data.

You double-clicked column D's right border.

Connor Pewter has several external storage options, but doesn't know much about them. Can you help him identify each storage type? Drag and drop the images to the correct locations. When you are finished, click Done.

You dragged Cloud Storage into the Cloud Storage container, dragged Thumb Drive into the Thumb Drive container, dragged External Hard Drive into the External Hard Drive container, dragged Flash Card into the Flash Card container, dragged CD/DVD into the CD/DVD container, and clicked the Done button.

Connor Pewter wants to sign up for an email account so that he can put it on his resume. He has a few ideas for a username and password. Which should he select? Drag and drop the best username and password to the create account screen. When you are finished, click Done.

You dragged ConnorPewter username into the Username container, dragged #1St@t3Fan!039 password into the Password container, and clicked the Done button.

Jay Peg is trying to learn the key differences between a Solid State Drive and a normal Hard Drive. Can you help him identify some differences? Drag and drop the items to the appropriate location on the chart. When you are finished, click Done.

You dragged Expensive into the SSD Cost container, dragged Inexpensive into the Hard Drive Cost container, dragged More Data Storage into the Hard Drive Data Storage container, dragged Less Data Storage into the SSD Data Storage container, and clicked the Done button.

Can you label the parts of a browser? Drag and drop the text to the appropriate box. When you are finished, click Done.

You dragged Home into the Home container, dragged Back/Forward into the Back/Forward container, dragged Status text into the Status text container, dragged Favorites into the Favorites container, and clicked the Done button.

In which order does a computer connect to websites? Drag the text to the appropriate boxes. When you are finished, click Done.

You dragged ISP into the ISP container, dragged Servers into the Servers container, and clicked the Done button.

Meg needs to email her coworkers about changing the time for their meeting. Which subject line is the best choice? Drag the text to the subject line. When you are finished, click Done.

You dragged Meeting change into the Subject line container, clicked the Done button.

Which of the icons are desktop applications? Click and drag the icons to the grey boxes on the monitor. Be sure to select all desktop applications. When you are finished, click Done.

You dragged Photo Editor into the Desktop Apps container, dragged Game into the Desktop Apps container, dragged Media Player into the Desktop Apps container, dragged Spreadsheet Editor into the Desktop Apps container, and clicked the Done button.

Jay Peg doesn't know much about researching online. Can you match the information to each of the research sites? Drag and drop the description to the site. When you are finished, click Done.

You dragged Popular Search Engine into the Google container, dragged Academic Research into the College Online Library container, dragged Videos related to the search topic into the YouTube container, dragged Government-funded health studies into the National Institutes of Health container, and clicked the Done button.

What does an operating system do? Drag and drop the image to the computer. When you are finished, click Done.

You dragged Runs Applications into the Computer monitor container, clicked the Done button.

Can you match the security issue to the description? Drag and drop the icon to the appropriate space. When you are finished, click Done.

You dragged Worm into the Worm description container, dragged Trojan Horse into the Trojan Horse description container, dragged Phishing into the Phishing description container, and clicked the Done button.

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

Filter the chart so the lines for Dr. Patella and John Patterson are hidden.

You launched the Chart Elements menu, launched the Chart Filter menu. In the Mini Toolbar, you unchecked the Dr. Patella check box, unchecked the John Patterson check box. You clicked the Apply button.

Hide the primary vertical axis.

You launched the Chart Elements menu. In the Mini Toolbar in the Axes menu, you checked the Primary Vertical checkbox.

Display the data table, including the legend keys.

You launched the Chart Elements menu. In the Mini Toolbar in the Data Table menu, you clicked the With Legend Keys menu item.

Add a linear trendline to this chart. Use the default trendline formatting.

You launched the Chart Elements menu. In the Mini Toolbar in the Trendline menu, you clicked the Linear menu item.

Hide the chart title.

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

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

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

Share the document with [email protected] and include the message Let me know your thoughts. The recipient should be able to edit the document.

You launched the Share Dialog. Inside the Share dialog, you clicked the Share button.

Package the presentation to a folder using the Package for CD feature. Name the folder New Products Presentation and save it to the Documents folder. Be sure to include link files in the presentation.

You opened the backstage view, clicked the Export navigation button, clicked the Package Presentation for CD button, and clicked the Package for CD button. Inside the Package for CD dialog, you clicked the Copy to Folder... button. Inside the Copy to Folder dialog, you typed in the Folder name input, clicked the OK button. Inside the Microsoft PowerPoint dialog, you clicked the Yes button. Inside the Package for CD dialog, you clicked the Close button.

Create a new blank file.

You opened the backstage view, clicked the New navigation button, and clicked the Blank document template.

Open the MediSportBusinessPlan file located in the Documents folder.

You opened the backstage view, clicked the Open navigation button, clicked the This PC button, clicked the Documents button, and clicked MediSportBusinessPlan. Inside the Open dialog, you clicked the Open button.

Create an AutoCorrect entry to change ligamant to ligament when typed.

You opened the backstage view, clicked the Options navigation button, and clicked the Proofing tab. Inside the Word Options dialog, you clicked the AutoCorrect Options ... button. Inside the AutoCorrect: English (United States) dialog, you typed ligamant in the autoCorrectReplaceInput input, typed ligament in the autoCorrectReplaceWithInput input, clicked the Add button, and clicked the OK button. Inside the Word Options dialog, you clicked the OK button.

Print the presentation in shades of gray.

You opened the backstage view, clicked the Print navigation button, and clicked the Color button. In the Color menu, you clicked the Grayscale menu item. You clicked the Print button.

Print handouts of the presentation that display four slides in a horizontal layout.

You opened the backstage view, clicked the Print navigation button, and clicked the Print Layout button. In the Print Layout menu, you selected the 4 Slides Horizontal option. You clicked the Print button.

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 the presentation.

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

Add a company property control to the document that reads MediSport Clinic.

You opened the backstage view, clicked the Properties button, clicked the Properties button, clicked the Properties button, clicked the Show Fewer Properties link, clicked the MediSport Clinic field, clicked the MediSport Clinic field, changed the MediSport Clinic field, and clicked the back arrow button. In the Insert Ribbon Tab in the Text Ribbon Group, you clicked the Quick Parts button. In the Quick Parts menu in the Document Property menu, you clicked the Company menu item.

Save the document to the Documents folder in OneDrive with the name BusinessPlan Shared.

You opened the backstage view, clicked the Save As navigation button, changed the undefined view, and clicked More Options....

Save the file to a new folder inside the Documents folder on the computer. Name the new folder Marketing. Name the file BusinessPlanUpdated.

You opened the backstage view, clicked the Save navigation button, and clicked More Options.... Inside the Save As dialog from the explorerSaveAsTreeList list from the explorerSaveAsQuickAccessTreeList list, you selected Documents. Inside the Save As dialog, you clicked the Create a new folder. button, renamed the folder to Marketing. You double-clicked the Marketing item. Inside the Save As dialog, you typed BusinessPlanUpdated in the File name input, clicked the Save button.

Add a tag that reads marketing to the metadata for this document, and then return to the document.

You opened the backstage view, clicked the marketing field, changed the marketing field, and clicked the back arrow button.

Advance to the next slide in the slide show.

You pressed the Enter keyboard shortcut.

Cut cell B7 and paste it to cell E12.

You right clicked cell B7. In the Right-Click menu, you clicked the Cut menu item. You clicked cell E12, right clicked cell E12. In the Cell right click menu, you clicked the Paste button.

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

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

Change the color of the sheet tab for the Dec 18 worksheet to Green, Accent 6, Lighter 80% (the last option in the second row of theme colors).

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

Add a new worksheet to the left of the Dec 18 sheet.

You right clicked the Dec 18 tab. In the Tab Right Click menu, you clicked the Insert... menu item. Inside the Insert dialog, you double-clicked the Worksheet image.

Copy the Salaries worksheet to a new workbook.

You right clicked the Salaries tab. In the Tab Right Click menu, you clicked the Move or Copy... menu item. Inside the Move Or Copy dialog, you checked the Create a copy check box. Inside the Move Or Copy dialog in the To book drop-down, you clicked the (new book) list item. Inside the Move Or Copy dialog, you clicked the OK button.

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.

Hide the column showing 2016 data and the bonus rate.

You right clicked the column B header. In the Col Header Right-Click menu, you clicked the Hide menu item.

Add another data series to the chart to represent gross profit. Use the value of cell A2 as the series name and cells B2:D2 as the series values. Do not rebuild the chart from scratch.

You right clicked the undefined chart. In the Design Ribbon Tab in the Data Ribbon Group, you clicked the Select Data button. Inside the Select Data Source dialog, you clicked the Add button. You clicked cell A2, clicked cell B2. Inside the Edit Series dialog, you clicked the OK button. Inside the Select Data Source dialog, you clicked the OK button.

Copy the third slide and paste it after the fourth slide. Do not paste the slide as a picture.

You right-clicked the Slide3 slide in the Slides tab. In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Copy button. You clicked the slide divider after slide 4. In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Paste button.

Delete the third slide in the presentation.

You right-clicked the Slide3 slide in the Slides tab. In the Layout Gallery menu, you clicked the Delete Slide menu item.

Hide the fourth slide in the presentation.

You right-clicked the Slide4 slide in the Slides tab. In the Layout Gallery menu, you clicked the Hide Slide menu item.

Apply a pattern as the background for the slide using the Large Confetti pattern (the sixth option in the fifth row). Change the foreground color to Blue, Accent 1 (the fifth option in the first row under Theme Colors). Change the background color to Gray 25%, Background 2, Darker 10% (the third option in the second row under Theme Colors). When you are finished, apply the background to all the slides in the presentation.

You right-clicked the slide. In the Right-Click menu, you clicked the Format Background menu item. Inside the Format Background dialog from the Fill list, you selected the Pattern Fill Radio Button, clicked the Large confetti image, and clicked the Foreground button. In the Foreground Color menu, you selected the Blue, Accent 1 color option. Inside the Format Background dialog from the Fill list, you clicked the Background button. In the Background Color menu, you selected the Gray-25%, Background 2, Darker 10% color option. Inside the Format Background dialog, you clicked the Apply to All button.

Which screen will display a sharper image? Click the image to select it and then click Done.

You selected the 19.5 inches, 1920 x 1080 option, clicked the Done button.

Meg wants to purchase some new headphones. She's not sure which website to purchase from. Which site would you choose to buy headphones from? Click an image to select it. When you are finished, click Done.

You selected the Amazon.com $59.99 Headphones option, clicked the Done button.

Abby has a research paper to write and doesn't know which sites provide quality information. Which of the following sites is the best site for a research paper? Click the image(s) to select the answer. When you are finished, click Done.

You selected the College Online Library option, deselected the College Online Library option, selected the College Online Library option, and clicked the Done button.

Meg likes to shop online. She added a dress to her shopping cart. When she revisits the site, the item is still in her shopping cart. Which of the following items save this information? Click the image(s) to select them. When you are finished, click Done.

You selected the Cookies option, clicked the Done button.

What are some types of technology that your ISP might use to provide an Internet connection? Click the button(s) to select the answer. When you are finished, click Done.

You selected the DSL option, selected the Cable option, selected the Fiber Optic option, and clicked the Done button.

Which of the following logos represent cloud based services? Click the appropriate image(s) to select them. When you are finished, click Done.

You selected the Dropbox option, selected the OneDrive option, and clicked the Done button.

Which of the following icons represent uses for the Internet? Click the image(s) to select the answer. When you are finished, click Done.

You selected the E-learning option, selected the Email option, selected the Sharing Photos option, selected the Shopping option, selected the Chatting option, selected the Playing Games option, and clicked the Done button.

Meg Hertz wants to share photos from her graduation with her friends and family, as well as post updates on her post-graduation plans. Which social media site is the best option? Click the image(s) to select the answer. When you are finished, click Done.

You selected the Facebook option, clicked the Done button.

Meg is using an older computer. She noticed there is a disk defragmentation program. What does the disk defrag do for her computer? Click the image(s) to select the answer. When you are finished, click Done.

You selected the Increases speed and efficiency option, selected the Rearranges like files to the same location option, and clicked the Done button.

Cam Pewter needs to print a few papers for his English class this semester. He doesn't need to print photos or scan any documents. He is on a budget. Which type of printer should he purchase?

You selected the Inkjet Printer option, clicked the Done button.

Which of the following are types of browsers? Click the button(s) to select the answer. When you are finished, click Done.

You selected the Internet Explorer option, selected the Apple Safari option, and clicked the Done button.

Jay Peg is looking for a job. Which social media site is the best for professional networking? Click the image(s) to select the answer. When you are finished, click Done.

You selected the LinkedIn option, clicked the Done button.

Meg Abyte is designing some graphics on her older laptop. Which of the items would make it easier for her to click on and edit the graphics?

You selected the Mouse option, clicked the Done button.

Click to select all of the input devices located at Tara Byte's workstation. Click the image(s) to select them. When you are finished, click Done.

You selected the Mouse option, selected the Keyboard option, selected the Digital Camera option, and clicked the Done button.

Abby found a website online where she can download expensive programs and different media files without paying for them. Which of the following items are okay for Abby to download? Click the image(s) to select the answer. When you are finished, click Done.

You selected the None option, clicked the Done button.

Which of the following sites would be most appropriate to visit during work hours? Click the image(s) to select the answer. When you are finished, click Done.

You selected the Professional Organization's Website option, selected the Company's website option, and clicked the Done button.

Professor Processor told Meg that sites frequently save cookies to a computer's hard drive. Meg cannot remember what cookies are for. What do cookies do? Click the image(s) to select your answer. When you are finished, click Done.

You selected the Remembers Web site preferences option, selected the Tracks items saved in shopping cart option, and clicked the Done button.

Cam's work computer has been crashing lately. He's on a deadline and has been losing important work when he saves it to his laptop. Where should Cam save his data? Click the image(s) to select the answer. When you are finished, click Done.

You selected the Server option, clicked the Done button.

Connor is thinking about opening a food truck. What types of technology would he likely use in his food truck? Click the image(s) to select the answer. When you are finished, click Done.

You selected the Tablet option, selected the Smartphone option, and clicked the Done button.

Meg knows there are many viruses out there. What are some good practices to follow to prevent viruses on her computer? Click the image(s) to select the answer. When you are finished, click Done.

You selected the Update antivirus software regularly option, selected the Ignore emails from unknown senders option, selected the Don't open attachments from unknown senders option, and clicked the Done button.

Connor has been skipping some software updates on his computer. Help Connor by deciding which software to update and which to ignore. Click the button(s) to select the answer. When you are finished, click Done.

You selected the Update security option, selected the Update web browser option, selected the Update antivirus option, and clicked the Done button.

You have a job interview coming up in a few days. What can you do to manage your online presence? Click the image(s) to select the answer. When you are finished, click Done.

You selected the Update your LinkedIn option, selected the Google yourself option, and clicked the Done button.

Meg uses Bank of America, but thinks this email is a phishing scam. Click the parts of the email that are suspicious. When you are finished, click Done.

You selected the email: [email protected] option, deselected the email: [email protected] option, selected the email: [email protected] option, selected the Bank of Americaaa option, selected the Click link to login option, selected the We'll deposit $500 into your account. option, selected the Link address: http://bankamerican.robot.loginnow.com option, selected the Send your account information option, and clicked the Done button.

Ken Pewter was shopping online and found a new game controller he'd like to purchase. Which site should he purchase from? Click the image(s) to select the answer. When you are finished, click Done.

You selected the https:// game controller $39.99 option, clicked the Done button.

Meg Abyte wants to sign up for a new email account. She will be using this email on her resume. She wants a web based email application. Select one answer for each step in the process. Click Done when you are finished.

You selected the meg.abyte option, selected the $h0pp!ng98FaN option, selected the Microsoft Outlook option, and clicked the Done button.

Select the greeting line of the letter Dear Mr. Sakura:

You selected the text beginning with: Dear Mr. Sakura:.

Enter the number 530 in cell C7.

You typed 530 in cell C7, pressed Enter.

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

You typed = in cell B8, clicked the Salaries 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.

In cell E15, enter a formula to find the lowest line item cost this month (cells E2:E14).

You typed =m in cell E15, clicked the =MIN(E2:E14) view, double-clicked MIN in the Formula AutoComplete list, selected the cell range E2:E14, typed =MIN(E2:E14) in cell E15, and pressed Enter.

Insert the current date and time in cell A1.

You typed =now in cell A1, double-clicked NOW in the Formula AutoComplete list, and pressed Enter.

Type Justin Fine in cell D2 and press Enter. Begin typing Julie Smith, and when Flash Fill suggests a pattern for the remaining cells, accept it.

You typed Justin Fine in cell D2, pressed Enter, typed J in cell D3, and pressed Enter.

Add the text We will make every effort to work with your schedule. Thank you for your patience. We are very sorry. to the end of the last paragraph (the paragraph starting with Currently). Press Enter when you are finished.

You typed We will make every effort to work with your schedule. Thank you for your patience. We are very sorry., pressed the Enter key.

Enter a formula in cell C2 to calculate next year's salary increase by multiplying the previous year's salary (cell B2) times the Cost of Living Adjustment (cell named COLA). Use the cell name in the formula.

You typed in cell C2. In the Formulas Ribbon Tab in the Function Library Ribbon Group, you clicked the More Functions button, clicked the Math & Trig button. In the Math & Trig menu, you clicked the SUM menu item. Inside the Function Arguments dialog, you clicked the dialog Close button. You clicked cell B2, clicked cell C2, typed = in cell C2, clicked cell B2, typed =(B2*c in cell C2, double-clicked COLA in the Formula AutoComplete list, typed =(B2*COLA) in cell C2, and pressed Enter.