Question 1

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

Accepted Answer

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

Question 2

Apply bold and italic formatting to the selected cell.

Accepted Answer

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

Question 3

Enter the number 6745 in cell C7.

Accepted Answer

You typed 6745 in cell C7, pressed Enter.

Question 4

Cut cell B7 and paste it to cell E12.

Accepted Answer

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

Question 5

Apply the Accounting Number Format to the selected cells.

Accepted Answer

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

Question 6

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 7

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 8

Select cells A5:D8.

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

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 11

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 12

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 arrow. In the AutoSum menu, you clicked the Sum menu item. You pressed Enter.

Question 13

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 14

Autofit column D to best fit the data.

Accepted Answer

You double-clicked column D's right border.

Question 15

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 16

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 17

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

Accepted Answer

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

Question 18

Select column B.

Accepted Answer

You clicked on column B.

Question 19

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

Accepted Answer

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

Question 20

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 21

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 drop-down arrow. In the Font menu, you clicked the Cambria font.

Question 22

Change the width of the selected columns 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 23

Copy cell F3, and paste to cell F2.

Accepted Answer

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

Question 24

Center the content in the selected cells horizontally.

Accepted Answer

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

Question 25

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 Cells Ribbon Group, you clicked the Format button. In the Home Ribbon Tab in the Editing Ribbon Group, you clicked the AutoSum button arrow. In the AutoSum menu, you clicked the Sum menu item. You pressed Enter.

Question 26

Delete this row.

Accepted Answer

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

Question 27

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 28

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

Accepted Answer

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

Question 29

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

Accepted Answer

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

Question 30

Modify the Jul 26 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 31

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 32

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 33

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

Accepted Answer

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

Question 34

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

Accepted Answer

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

Question 35

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

Accepted Answer

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

Question 36

Delete the Timesheets worksheet.

Accepted Answer

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.

Question 37

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.

Question 38

Insert a column to the left of the selected cell.

Accepted Answer

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

Question 39

Hide the column showing 2013 data and the bonus rate.

Accepted Answer

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

Question 40

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 41

Rename Sheet1: Jul 31

Accepted Answer

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

Question 42

Set row 1 to print on every page.

Accepted Answer

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.

Question 43

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 44

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 45

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

Accepted Answer

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

Question 46

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

Accepted Answer

You clicked the Zoom In button.

Question 47

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 48

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

Accepted Answer

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

Question 49

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

Accepted Answer

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.

Question 50

Print this worksheet.

Accepted Answer

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

Question 51

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

Accepted Answer

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.

Question 52

Hide all of the dependency tracer arrows at once.

Accepted Answer

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

Question 53

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.

Accepted Answer

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

Question 54

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

Accepted Answer

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

Question 55

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

Accepted Answer

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.

Question 56

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

Accepted Answer

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

Question 57

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.

Accepted Answer

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

Question 58

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

Accepted Answer

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

Question 59

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

Accepted Answer

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

Question 60

Insert the current date and time in cell B1.

Accepted Answer

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

Question 61

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

Accepted Answer

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

Question 62

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

Accepted Answer

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

Question 63

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

Accepted Answer

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

Question 64

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

Accepted Answer

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

Excel

Unlock all answers in this set

Haven't found what you need?