CS EXCEL CHAP1 PRACTICE

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

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.

Autofit column D to best fit the data.

In the Home Ribbon Tab in the Cells Ribbon Group, you clicked the Format button. In the Format menu, you clicked the AutoFit Column Width menu item.

Change the width of the columns C:H to 14.

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

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

In the Home Ribbon Tab in the Cells Ribbon Group, you clicked the Format button. In the Format menu, you clicked the Format Cells menu item. Inside the Format Cells dialog from the Category list, you selected Number. Inside the Format Cells dialog, you changed the Decimal places input to 0 and clicked the OK button.

Cut cell B7 and paste it to cell E12.

In the Home Ribbon Tab in the Clipboard Ribbon Group, you clicked the Cut button. You clicked cell E12. 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.

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 a single command to clear everything (content and formatting) from the selected cell.

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

Apply bold and italic formatting to the selected cell.

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

Add a Blue (in the row of standard colors, the third color from the right) bottom border to the selected cells. Use the thickest single line style available.

In the Home Ribbon Tab in the Font Ribbon Group, you clicked the Borders button arrow. In the Borders menu, you clicked the More Borders... menu item. Inside the Format Cells dialog from the Style: list, you clicked the Double Thick Underline item. In the Line Color menu, you selected the Blue color option. Inside the Format Cells dialog from the Style: list, you clicked the Double Thick Underline item. Inside the Format Cells dialog, you clicked the Bottom Border Border Designer, clicked the OK 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.

Change the font color of the selected cells to the Blue standard color (it is the third option from the right in the row of standard colors).

In the Home Ribbon Tab in the Font Ribbon Group, you clicked the Font Color button arrow, clicked the Fill Color button arrow, and clicked the Font Color button arrow. In the Font Color menu, you selected the Blue color option.

Change font size for the selected cells to 18.

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

Change the font for the selected cell to Cambria.

In the Home Ribbon Tab in the Font Ribbon Group, you clicked the Font dialog launcher. Inside the Format Cells dialog from the Font list, you selected Cambria. Inside the Format Cells dialog, you clicked the OK button.

Apply the Accounting Number Format to the selected cells.

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

From Page Break Preview view, insert a page break immediately above the row 12.

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

Clear the print area.

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

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

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

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

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

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

Modify 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 View Ribbon Tab in the Window Ribbon Group, you clicked the Split button.

Switch to the view where you can manipulate where page breaks occur.

In the View Ribbon Tab in the Workbook Views Ribbon Group, you clicked the Page Break Preview button.

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

In the application footer, you dragged the zoom slider from 100% to 110%.

Set row 1 to print on every page.

On the Page Layout tab, in the Page Setup group, click the Print Titles button. In the Page Setup dialog, on the Sheet tab, click on the Rows to repeat at top box. Click the row selector for row 1. Click OK in the dialog.

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.

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

You clicked the Desktop view, clicked the Desktop view, clicked the Desktop view, clicked the ex19_01_18 Salaries - assess - 1 - Excel t, and clicked the ex19_01_18 Salaries - assess - 1 - Excel t. Inside the Arrange Windows dialog, you selected the Cascade Radio Button, clicked the OK button.

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

You clicked the New Sheet button.

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

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

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

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

Print the entire workbook.

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

Print this worksheet.

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

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

You opened the backstage view, clicked the Print navigation button, clicked the Print Selection button, and clicked the Scaling button. In the Scaling menu, you clicked the Fit All Columns on One Page menu item.

Copy cell F3, and paste to cell F2.

You right clicked cell F3. In the Right-Click menu, you clicked the Copy menu item. You clicked cell F2, right clicked cell F2. In the Cell right click menu, you clicked the Paste button.

Change the color of the sheet tab for the Dec 9 worksheet to Dark Red (the first option at the left in the row of standard colors).

You right clicked the Dec 9 tab. In the Tab Right Click menu, you clicked the Tab Color menu item. You right clicked the Dec 9 tab. In the Tab Right Click menu in the Tab Color menu, you selected the Dark Red color option.

Delete the Sheet2 worksheet.

You right clicked the Sheet2 tab. In the Tab Right Click menu, you clicked the Delete Sheet menu item.

Hide the TimeSheets worksheet.

You right clicked the TimeSheets tab. In the Tab Right Click menu, you clicked the Hide menu item.