Excel Exam Modules 1-3: ISDS 1100

Insert a sparkline in E% using the data range from B5:D5

1. Click cell E5. 2. Click the Insert tab on the ribbon 3. In the Sparkline group, click the Line button 4. In the worksheet click and drag to select cells B5 through D5 (release mouse) 5. Click OK

Add a chart element. --> Add a chart title element to the chart in the default location above the cart

1. Click the chart 2. Click the Chart Tools Design tab on the ribbon 3. On the Chart Tools Design tab, in the Layouts group, click the Add Chart Element button 4. Point to Chart Title 5. Click Above Chart

Move worksheet. --> Reorder the worksheets so that the 3-Year Sales Forecast worksheet is the last worksheet In the workbook.

1. Click the 3 years Sales Forecast sheet tab (bottom by record) 2. With the mouse pointer over the 3-Year Sales Forecast sheet tab, press and hold the left mouse button until he most pointer changes to a block arrow with a page icon. 3. Drag the 3-Year Sales Forecast sheet tab to the right of the Average Sales by Month sheet tab until a small arrow appears, and then release the mouse

Edit document properties. --> by entering Income Statement as the Title document property.

1. Click the File tab. 2. In the right pane, in the Properties section, click the Title box, Edit the title by typing Income Statement in the Title box, and then press TAB.

Scale a worksheet for printing. --> Change the scale of the worksheet to 70% for printing.

1. Click Page Layout - on ribbon. 2. In the Scale to Fit group, click the Scale box, type 70, then press ENTER.

Apply a theme.

1. Click Page Layout tab. 2. Click the Themes button 3. Click the specific theme.

Apply the Currency number format. --> range of C4:C15

1. Click and drag to select range C4:C15. 2. In the Number group click the drop down arrow 3. Click Currency.

Change a row height to an approximate value -- row 2 to approximately 27 points

1. Click cell A2 2. Point to the boundary at the bottom of the row selector for row 2 until the pointer changes to a crosshair shape. Press the left mouse button as you drag the boundary down until the ScreenTip indicates 27.00 (36 pixels), and then release

Enter a formula by selecting cells. --> In cell B19, create a formula using the mouse to enter cell references, that subtracts cell B6 from B5, and then subtracts cell B18.

1. Click cell B19. 2. Type = to begin the formula. 3. Click cell B5. 4. Type - in B19 (minus sign) 5. Click cell B6. 6. Type another minus sign in B19. 7. Click Cell B18. 8. Press ENTER

Select a cell.

1. Click cell D22

Change worksheet margins. --> To the Arrow margin style

1. Click Page Layout 2. Click Margins 3. Click Narrow

Enter a number into a cell. -- Enter 491 in cell D6.

1. Click cell D6. 2. Type --> 491 in the cell then press ENTER.

Bold cell content.

1. Click cell A2. 2. In the font group click the Bold button.

Rename a worksheet. --> SALES

1. In the Cells group, click the Format button. 2. Click Rename Sheet. 3. Type Sales in the sheet tab. 4. Press Enter.

Apply a cell style. --> Apply the Bad cell style to cell B8.

1. Select cell B8. 2. In the styles group click the Cell Styles button. 3. Click Bad.

Apply a sparkline style. --> Of cell E5 to orange Spakline Style Accent 2

1. Click cell E5 2. Click Design tab. 3. In the Style group, click the More button. 4. Click Orange Accent 2

Undo an action. --> Change the font color of cell B4 to Automatic (Black Text, 1) & then undo the action.

1. Click Cell B4. 2. In the Font group, click the Font color button. 3. On the Quick Access Toolbar click the Undo button.

Create a formula using relative cell references. --> In cell B7, enter a formula using relative cell references that subtracts cell B6 from cell B5

1. Click Cell B7 2. Type =B5-B6 in B7 and Press ENTER

Create a formula using the MAX function. --> In cell D19, create a formula using the MAX function to calculate the maximum value in the range D4:D17.

1. Click Cell D19 2. On the formula bar, click the Insert Function button (fx). 3. Click the Or select a category drop down arrow. 4. Click Statistical. 5. Click MAX. 6. Click OK. 7. Type D4:D17 in the Number1 box. 8. Click OK.

Indent cell contents --> of cell A11:A19 by a single indentation level.

1. Click and drag to select the range A11:A19 2. In Alignment, click the Increase Indent button -->

Enter text in a header or footer --> Add the text Confidential to the center header section and then click cell A4 to deselect the header

1. Click View 2. In the Workbook views group click the Page Layout button 3. Click the center section which contains "Add header" 4. Type Confidential in the header 5. Click cell A4

Rotate cell contents to an exact value. --> Rotate the contents of the cells in range A3:D3 to exactly 45 degrees, which is 3 points uptimes to the left of the 0 degree marker on the arc.

1. Click and drag to select cells A3:D3. (horizontally) 2. Click Alignment, click the dialog box launcher (bottom right) 3. On the arc click the marker three points up to the left of the 0 degree marker. 4. Click OK.

Change the # of displayed decimal places --> In the range B3:B12 adjust the # of decimal places so that 2 decimal places are displayed

1. Click and drag to select cells B3:B12 and then release the mouse button. 2. In the Number group click the Increase Decimal button 3. In the Number Group, click the same button again

Create a New conditional formatting rule. --> for range B4:B15, create a new conditional formatting rule that formats the top 5 values int he range with a Blue Accent 5 cell background color.

1. Click and drag to select cells B4:B15. 2. In the Styles group click the Conditional Formatting button. 3. Click New Rule 4. In the Select a Rule type section Click format only top or bottom ranked values. 5. Select the value box and type 5 in the box 6. Click the Format button by Preview. 7. In the Format Cells dialog box click the Fill tab. 8. Click the Blue, Accent 5 option 9. Click OK 10. Click OK

Create a Highlight Cells conditional formatting rule --> Highlight cells in the range B4:B15 whose value is less than $50,000 using Yellow Fill w/ Dark Yellow Text

1. Click and drag to select range B4:B15 2. In the Styles group, click the Conditional Formatting button 3. Click High Light Cells Rules drop down button 4. Click Less Than 5. Type 50000 in the text box 6. Click the Format cells arrow 7. Click he Yellow Fill w/ Dark Yellow text option 8. Click OK

Use the Tell Me box - to change the Fill Color of cell in range B4:D4 to Black, Text 1.

1. Click and drag to select range B4:D4. 2. To the right of the last tab of the ribbon click the Tell Me box and type "Fill Color" in the box (no quotations). 3. Go to the Fill Color drop down arrow. 3. Click the Black, Text 1 option

Fill a range with formatting only using AutoFill. --> to fill range D11:D19 with only the formatting from cell D11

1. Click cell D11 2. Drag the fill handle at the bottom of cell D11 to the bottom of cell D19. 3. Release. 4. Click the AutoFIll options button (bottom right) 5. Click Fill Formatting only.

Edit a conditional formatting rule. --> Edit the conditional formatting rule for range for range B5:B16 to highlight cells whose value is less than $25,000. Use the same cell formatting as in the original rule

1. Click and drag to select range B5:B16 2. In the Styles group, click the Conditional Formatting button 3. Click Manage Rules 4. Click Edit Rule 5, In the Edit Formatting rule dialog box click the Greater than arrow 6. Click Less Than 7. Click OK 8. Click ok

Fill a series based on extrapolation. --> In the range B5:F5 using a growth trend with a step value of 1.1

1. Click and drag to select range B5:F5 2. In the Editing group, click the Fill button 3. Click Series. 4. Click the Growth option button under Type (growth trend) 5. In the Step value box, type 1.1 as the new value. 6. Click OK.

Create an X-Y scatter plot. --> Insert a Scatter chart in the worksheet based on range D4:E10

1. Click and drag to select range D4:E10 2. Click the Insert tab on the ribbon. 3. In the Charts group, click the Insert Scatter (X,Y) or Bubble Chart button. 4. In the Scatter section of the gallery, click the Scatter option, the first option in the gallery.

Insert markers into a sparkline. --> To the sparklines in range E5:E8, add a Green marker to the High Point and add a Red marker to the Low Point

1. Click and drag to select range E5:E8 2. Click the Design tab 3. In the Style group, click the Marker Color drop down arrow 4. Point to High Point 5. Click Green 6. Click the Marker Color button again 7. Hover over Low Point 8. Click Red

Clear a conditional formatting rule.

1. Click and drag to select the range B4:B15 2. In the Styles group click the Conditional Formatting group 3. Click Clear Rules 4. Click from Selected Cells

Enter a series of values using AutoFill. --> to fill the range A4:A15 with the names of the months, in chronological order, starting with January in cell A4.

1. Click cell A4. 2. Type January in cell A4. 3. Position the mouse pointer over the lower right corner of cell A4 until the fill handle appears denoted by a crosshair mouse pointer. 4. Press and hold the left mouse button as you drag the mouse down to include cells A5 and A15, then release the mouse button.

Wrap a text in a cell. --> cell A6

1. Click cell A6. 2. In the Alignment group, click the Wrap Text button.

Use the Format Painter. --> to apply formatting from cell B11 to the range B12:B19

1. Click cell B11 2. In the Clipboard group, click the Format Painter button 3. Click and drag to select cells B12:B19 and then release the mouse

Select non-adjacent cells. --> B11, B13, & B19

1. Click cell B11 2. Press and hold CTRL, and then click cell B13. 3. With CtRL still pressed click cell B19.

Split a worksheet into panes. --> into four panes at cell B12

1. Click cell B12 2. Click the View tab on the ribbon. 3. In the Window group, click the Split button.

Create a formula using order of operations. --> Enter a formula using arithmetic operators and parentheses in cell B14 that ass the monthly expenses in cells B9, B10, and B11, and then multiplies that result by 12.

1. Click cell B14. 2. Type =( in the cell. 3. Click cell B9. 4. Type + in cell B14. 5. Click cell B10. 6. Type + in B14. 7. Click cell B11. 8. Type ) in cell B14. 9. Type *12 in cell B14. 10. On the formula bar click the Enter button (the checkmark).

Create a formula using the SUM function. In cell B16, create a formula using the SUM function total the values in the range B4:B15.

1. Click cell B16. 2. In the editing group click the AutoSum button. 3. Press Enter.

Use the keyboard to enter a formula that uses a function. --> In cell B17, use the keyboard to enter a formula that uses the SUM function to calculate the total of the values in range B5:B16

1. Click cell B17. 2. Type =SUM(B5:B16) in cell B17, and press Enter.

Use Goal Seek. --> to calculate the changing value in cell B5 that will result in a set value in cell B20 of $10000

1. Click cell B20 2. Click the Data tab on the ribbon. 3. In the Forecast Group click the What-If Analysis Button 4. Click Goal Seek 5. Type 1000 in the To Value text box then press TAB. 6. Click cell B5. 7. Click OK. 8. Click OK.

Freeze columns and rows. --> Freeze column A and rows 1 through 3 in the worksheet

1. Click cell B4. (Click the cell one row before the last row you want to freeze, and one column to the right of the last column you want to freeze) 2. Click the View tab on the ribbon. 3. In the Window group, click the Freeze Panes button. 4. Click Freeze Panes. 5.

Align cell contents vertically. --> of cell B4 using the Bottom Align option

1. Click cell B4. 2. Click Alignment, click the Bottom Align button --> third option

Edit cell contents. --> Change the text of Aster Communications to Aston Comm in cell B6.

1. Click cell B6. 2. Type Aston Comm in cell B6, and press Enter.

Copy and paste a formula.

1. Click cell B7. 2. In the Clipboard group on the Home tab, click the Copy button. 3. Click cell C7. 4. Click the Paste button

Use the Fill handle to copy a formula. -- In cell B7 to cells C7 and D7.

1. Click cell B7. 2. Position the mouse pointer over the lower-right corner of cell B7 until the fill handle appears, denoted by a plus sign made of thick black lines. 3. Press and hold the left mouse button while you drag the mouse right, to include cells C7 and D7. 4. Release the mouse button.

Add the IFERROR function to an existing formula. IN CELL C13 enter a formula using the IFERROR function that uses the existingg VLOOKUP function in cell C13 as the value function argument, and Invalid Job Title as the customized error message for the value_if_error function argument

1. Click cell C13 2. In the formula bar, click directly after the equal sign to place insertion point, then type IFERROR( in the formula bar 3. In the formula bar, click to the right of the parenthesis to place the insertion point at the end of the text and type, "Invalid Job Title") in the formula bar. 4. Press ENTRE

Enter a # containing format symbols.--> enter the value 10% in cell C5 include %

1. Click cell C5 2. Type 10% in the cell and press ENTER

Clear cell formatting. --> from cell D12

1. Click cell D12. 2. In the Editing group, click the Clear button. 3. Click Clear Formats

Create a formula using the COUNT function. --> In cell D19 create a formula using the COUNT function to count the # of values in the range D5:D18.

1. Click cell D19. 2. Type =COUNT( in cell D19. 3. Position the mouse pointer over cell D5 and drag the pointer down to cell D18 and then release the mouse. 4. Type ) to complete the formula 5. Press ENTER

Change the fill color of a cell.

1. Click cell D9 2. In the Font group click the fill color drop down arrow

Use Flash Fill. --> to fill range E4:E15 after typing [email protected] in cell E4 and Sal in cell E5.

1. Click cell E4. 2. Type [email protected] in cell E4 then press ENTER. 3. Type Sal in cell E5, then press ENTER.

Create a formula using the COUNTA function. -->In cell F19, use the COUNTA function that counts the # of cells that aren't empty in the range F5:F18.

1. Click cell F19. 2. Click the Formulas tab on the ribbon. 3. In the Function Library group click the More Functions button. 4. Click the More Functions button. 5. Point to Statistical 6. Click COUNTA 7. Type F5:F18 in the Value1 box. 8. Click OK.

Create a formula using the IF functions --> In cell F4, enter a formula using the IF function that returns a value of YES if cell E4 is greater than 100,000 and a value of NO if not

1. Click cell F4. 2. Click the Formulas tab on the ribbon 3. In the Function library group click the Insert Function button. 4. Click the Or select category drop down arrow 5. Click Logical 6. Click IF 7. Click OK 8. Type E4>100000 in the Logical Test box 9. Press TAB 10. Type YES in the value if true box 11. Press TAB 12. Type NO in the value if false box 13. CLICK OK

Create a formula using a nested IF function. --> In cell F5, enter a formula using a nest IF function, to calculate the Bonus Amount using the following function arguments: type D5=3 in the Logical test box, type E5*.1 in the Value if true box, and type IF(D5=2,E5*.05, 0) in the Value if false box

1. Click cell F5. 2. To the left of the formula bar click the Inset Function (fx) button. (at the top) 3. Click the Or Select A Category drop down arrow. 4. Click Logical 5. In the Select a Function box, click IF 6. Click ok 7. Type D5=3 in the Logical_test box 8. Press Tab 9. Type E5*.1 in the Value if true box. 10. Press TAB 11. Type IF(D5=2, E5*.05, 0) in the Value if false box 12. Click OK

Cut and paste cell contents. --> of cell I5 into cell C11.

1. Click cell I5. 2. Click Cut. 3. Click cell C11 4. Click Paste.

Enter a number as text. -- In cell J5, enter the value 77112 as text using the keyboard.

1. Click cell J5. 2. Type --> '77112 in the cell, then press ENTER.

Change the page orientation. --> Change the orientation to Landscape.

1. Click the Page Layout tab on the ribbon. 2. Click the Orientation button. 3. Click Landscape.

Change a chart type. --> Change the Pie chart to a Clustered Column chart. Choose the option with all blue data bars.

1. Click the Pie chart. 2. Click the Design tab. 3. In the Type group, click the Change Chart Type button. 4. In the left pane, click column. 5. Click ok to the default clustered column chart.

Delete a row in a query using the Power Query editor. --> Delete the first row in the NewClients query

1. Click the Query tab on the ribbon 2. In the EDIT group click the EDIT button 3. Click Reduce Rows 4. Click the Remove Rows drop down arrow 5. Click Remove Top Rows. 6. Type 1 in the Number of rows box 7. Click OK 8. In the Query Editor, In the close group, click the Close and Load button

Unfreeze columns and rows.

1. Click the View tab on the ribbon 2. In the Window group click the Freeze Panes button 3. Click Unfreeze panes

Hide worksheet gridlines. --> Hide gridlines in the current worksheet,

1. Click the View tab on the ribbon 2. In the show group click the Gridlines check box

Zoom a worksheet --> Zoom the worksheet 100%

1. Click the View tab on the ribbon. 2. In the Zoom group, click Zoom. 3. Click the 100% option. 4. Click OK

Remove worksheet panes. --> Remove the panes from the worksheet

1. Click the View tab on the ribbon. 2. In the Window group, click Split

Move a chart element. --> In the Line Chart, move the chart legend to the Right position

1. Click the chart 2. Click the Chart Elements button (+ sign) 3. Point to Legend until an arrow appears on the option, then click the arrow 4. Click Right

Change a chart layout. --> Change the layout of the Column chart to Layout 2 (top row, second option in Quick Layout gallery)

1. Click the chart, 2. Click Design on the ribbon. 3. Click the Quick Layout button 4. Click the Layout 2 option, second option of top row.

Add axis title to a chart. --> On the Bar chart add the title Dollars to the Horizontal axis and the title Client Name to the vertical axis, then click on the chart

1. Click the chart. 2. Click the Chart Elements button. 3. Click the Axis Title checkbox. 4. Type Dollars in the horizontal axis text box. 5. Click the Vertical Axis title text box. 6. Type Client Name in the text box. 7. Click Cell C3.

Apply a chart style. -- Style 5

1. Click the chart. 2. Click the Chart Tools Design tab. 3. In the Chart Styles group, click the More button. 4. In the gallery click Style 5.

Move a chart to a chart sheet.

1. Click the chart. 2. Click the Design tab. 3. In the Location group, click the Move Chart button. 4. Click the New Sheet option bubble. 5. Click OK.

Delete a chart element. --> Delete the legend form the pie chart

1. Click the chart. 2. Click the chart elements button (+) 3. Click the Legend check box (it will dissect)

Change the Horizontal Axis Label val.. --> In the Clustered Column chart, define range A5:A8 as the Horizontal Axis Label values. Use the mouse to enter the range in the Axis Labels text box.

1. Click the chart. 2. Click the chart tools Design tab on the ribbon 3. In the Data drop down arrow group, click the Select Data button. 4. In the Horizontal Category Axis Labels Box, click the Edit button. 5. In the worksheet, click and drag to select range A5 through A8 6. Click OK. 7. Click OK.

Change the # format of a chart axis. --> Apply the Currency number format to values on the vertical axis. Use default setting for decimal places, symbol, format code, and links

1. Click the chart. 2. In the chart, right click the Vertical (value) axis. 3. Click Format Axis (at bottom) 4. Click the Number arrow. 5. Click the Category arrow. 6. Click Currency. 7. In the upper right corner of the pane, click the close button (the x)

Change a column width to an exact value. --> Column C to exactly 15 characters.

1. Click the column heading for C. 2. In the Cells group, click the Format button. 3. Click Column Width. 4. Type 15 in the column width box then press OK.

Hide a column --> F

1. Click the column heading for column F 2. In the Cells group, click the Format button 3. Point to Hide and Unhide 4. Click Hide Columns

Change the bounds of a chart axis. --> On the vertical axis of the line chart, define 20000 as the Minimum bounds and 140000 as the Max bounds. Do not include a currency symbol when entering values.

1. Click the vertical axis on the chart. (with all the numbers) 2. Right click the vertical axis 3. Click Format Axis. 3. Under bounds, in the Min box type 20000 and press ENTER 4. In the Maximum box, type 140000 and press Enter

Edit placeholder text in a chart element. --> Enter the text Sales To Date in the Bar Chart title placeholder.

1. In the chart click the Chart Title Placeholder (text box) 2. Type Sales to Date in the chart title placeholder (under Styles) 3. Click cell A18

Change worksheet views. --> Change the view of the Current Clients worksheet to Page Layout view.

1. On the status bar (at the bottom of the page), click the Page Layout button (next to the magnifier; middle option).

Apply the Percentage number format. --> over C4:C15

1. Position he mouse pointer over cell C4; drag it until it's over C15 2. In the Number group, click the Percent Style button

Add a border to cells. --> Apply Thick Outside Borders to the range A8:D8

1. Position the mouse over cell A8 press and hold until it's over D8 (horizontally) 2. In the Font group click the Border drop down arrow 3. Click the Thick Outside borders option 4. Click cell D10

Insert a Clustered Column chart. --> a 3-D clustered column chart in the worksheet based on range A4:D8

1. Position the mouse pointer over cell A4, press and hold the left mouse button as you drag the pointer down and to the right until it's over cell D8. Release 2. Click the Insert tab on the ribbon 3. In the Charts group, click the Insert Column or Bar Chart button 4. Click the 3-D Clustered column chart type.

Apply the accounting number format. --> to cell range B5:B16

1. Position the mouse pointer over cell B5. Press and hold the left mouse button as you drag the mouse pointer down until it is over cell B16, then release the mouse button. 2. In the Number group click the Accounting Number format ($).

Apply the Comma number format. --> C5:C18

1. Position the mouse pointer over cell C5. Press and hold the left mouse button as you drag the mouse pointer down until it is over cell C18, then release the mouse button. 2. In the Number group click the Comma style button.

Move a chart on a worksheet --> Move the clustered Column chart so that the upper left corner of the chart border is over cell F1.

1. Position the mouse pointer over the chart border so that the pointer changes to a block arrow with a four-headed arrow. 2. Press and hold the left mouse button and drag the chart so that the upper-left corner of the chart border is over cell F1. 3. Release the mouse button

Merger and Center cell contents. --> range A2:D2

1. Position your mouse over cell A2. Press and hold the left mouse button, drag the mouse to the right until it is over cell D2, and then release the mouse button. 2. In the alignment group, click the Merge and Center button.

Change text direction of an axis title. --> of the vertical axis title Client Name to Horizontal

1. Right click the Vertical Axis title. 2. Click Format Axis Title 3. Click the Size and Properties button (box w/ two lines) 4. Click the Alignment arrow 5. Click the text direction arrow 6. Click Horizontal 7. Int he Format Axis Title pane, click the Close button.

Change the units of a chart axis. --> On the vertical axis of the line chart, define 20000 as the Major units and 5000 as the Minor units

1. Right click the vertical acmes (with all the numbers) 2. Click Format Axis 3. In the Units section of the Format Axis pane, select the value in the Major text box, type 20000, and then press ENTER 4. Select the value in the Minor text box and type 5000, then press ENTER

Change the color of a worksheet tab. --> Change the Sales by Branh sheet tab to Green.

1. Right-click the Sales By Branch sheet tab. 2. Point to Tab Color. 3. Click Green

Create a formula using arithmetic operators. --> Without using parentheses, enter a formula in cell G4 that determines the Projected 2021 salary, less Healthcare, for the employee by adding the value in Cell C4 to the product of cell C4 multiplied by cell E4, and then subtracting the value in cell F4.

1. Select Cell G4. 2. Type = in cell G4 to start the formula. 3. Click cell C4. 4. Type + in cell G4. 5. Click cell C4 6. Type * in G4. 7. Click Cell E4. 8. Type - in cell G4. 9. Click Cell F4 10. On the formula bar, click the Enter button (checkmark underneath "font")

Add a border with a line to color a cell.

1. Select D19. 2. In the Font group on the Home tab click the Border drop down arrow 3. On the Border menu click More Borders. 4. In the Line section click the Color drop down arrow 5. Click Blue Accent 5 6. In the Presets section of the dialog box, click the Outline button. 7. Click OK

Clear cell contents.

1. Select cell A17. 2. In the Editing group on the top tab, click the Clear button. 3. Click Clear Contents

Change the font of the cell content.

1. Select cell A2. 2. In the Font group click the drop down arrow. 3. Click Cambria.

Create a formula using the AVERAGE function. --> In cell B18, create a formula using the AVERAGE function to calculate the average values in the range B5:B16

1. Select cell B18. 2. Type =AV in cell B18. 3. Double-click AVERAGE. 4. Position the mouse over cell B5. Press and hold the left mouse button as you drag the pointer downward until it is over cell B16, and then release the mouse button. 5. Type ) in cell B18 to complete the formula. 6. Press Enter.

Align cell contents horizontally. --> Contents of cell C3

1. Select cell C3 2. Press Alignment on the home tab. 3. Click the center button

Create a formula using absolute cell references.

1. Select cell C6 2. Type = in the cell 3. Click B6 4. Type the / after the b6 reference 5. Click cell B18 6. Press the F4 key (I think $????// I don't have an F4 key) 7. Press ENTER

Create a formula using the MIN function. --> In cell D18, create a formula using the MIN function to calculate the minimum value in the range D4:D17.

1. Select cell D18. 2. In the editing group click the AutoSum drop down arrow. 3. Click Min. 4. Press Enter.

Apply the Date number format.

1. Select cell D4 2. In the Number group on the ribbon, click the Dialog Box Launcher 3. In the type list local 03/14/12 to select a new Date number format 4. click OK

Format a column using Autofit. --> Column D

1. Select the column heading (D). 2. In the Cells group on the Styles tab, click the Format button 3. Click AutoFit Column Width