Question 1

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

Accepted Answer

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.

Question 2

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

Accepted Answer

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

Question 3

Cut cell B7 and paste it to cell E12.

Accepted Answer

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.

Question 4

Copy cell F3, and paste to cell F2.

Accepted Answer

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.

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

Change the font for the selected cell to Cambria.

Accepted Answer

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.

Question 8

Change font size for the selected cells to 18.

Accepted Answer

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.

Question 9

Apply bold and italic formatting to the selected cell.

Accepted Answer

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

Question 10

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

Accepted Answer

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.

Question 11

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

Accepted Answer

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

Question 12

Apply the Accounting Number Format to the selected cells.

Accepted Answer

In the Home Ribbon Tab in the Number Ribbon Group, you clicked the Accounting Number Format button.

Question 13

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

Accepted Answer

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.

Question 14

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

Accepted Answer

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.

Question 15

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.

Accepted Answer

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.

Question 16

Apply the Accent1 cell style to the selected cell.

Accepted Answer

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.

Question 17

Apply the Ion theme to the workbook.

Accepted Answer

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.

Question 18

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

Accepted Answer

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.

Question 19

Autofit column D to best fit the data.

Accepted Answer

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.

Question 20

Wrap the text in the selected cell.

Accepted Answer

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

Question 21

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

Accepted Answer

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

Question 22

Delete row 5.

Accepted Answer

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.

Question 23

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

Accepted Answer

You clicked the New Sheet button.

Question 24

Delete the Sheet2 worksheet.

Accepted Answer

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

Question 25

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

Accepted Answer

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.

Question 26

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

Accepted Answer

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

Question 27

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

Accepted Answer

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

Question 28

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

Accepted Answer

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

Question 29

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

Accepted Answer

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.

Question 30

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.

Accepted Answer

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

Question 31

Hide the TimeSheets worksheet.

Accepted Answer

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

Question 32

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

Accepted Answer

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.

Question 33

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

Accepted Answer

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.

Question 34

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

Accepted Answer

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.

Question 35

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

Accepted Answer

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.

Question 36

Modify this worksheet so gridlines will print.

Accepted Answer

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

Question 37

Set row 1 to print on every page.

Accepted Answer

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.

Question 38

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

Accepted Answer

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.

Question 39

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

Accepted Answer

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.

Question 40

Clear the print area.

Accepted Answer

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.

Question 41

Print this worksheet.

Accepted Answer

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

Question 42

Print the entire workbook.

Accepted Answer

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.

CS EXCEL CHAP1 PRACTICE

Unlock all answers in this set

Haven't found what you need?