- Right-click column C, select Format Cells, and then select Best-Fit.
- Right-click column C and select Best-Fit.
- Double-click column C.
- Double-click the vertical boundary between columns C and D.

- ISNUMBER and ISTEXT
- ISNUMBER and ISALPHA
- ISVALUE AND ISNUMBER
- ISVALUE and ISTEXT

- Jan, Jan, Jan
- Feb, Mar, blank cell
- Feb, Mar, Apr
- FEB, MAB, APR

- the death of chivalry
- The death of Chivalry
- THE DEATH OF CHIVALRY
- The Death Of Chivalry

- Sort by the data in Column E.
- Format the data in Column D.
- Sort by the data in Column D.
- Format the data in Column E.

- Alt+F4 (Windows) or Option+F4 (Mac)
- Alt+Shift+4 (Windows) or Option+Shift+4 (Mac)
- Ctrl+Shift+4 (Windows) or Command+Shift+4 (Mac)
- the F4 (Windows) or Command+T (Mac)

- Add an image of the chart to a comment.
- Add a hyperlink to another worksheet that displays a chart when clicked.
- Add an image of the chart to the worksheet.
- Add a sparkline, a graphic that summarizes data visually within a single worksheet cell.

- Right-click anywhere and select Help.
- Press F1 or click the Help tab in the ribbon.
- Press F10.
- all of these answers.

- ##,###,,
- ###.0,,
- 999.9,,
- ###,###.0,

- three inputs
- four inputs
- two inputs
- one input

- Show in Tabular Form
- Show in Compact Form
- Show in Compact For or Show in Outline Form
- Show in Tabular Form or Show in Outline Form

- Use the ROUND() function.
- Click the Decrease Decimal button twice.
- In the cells group on the Home tab, click Format > Format Cells. Then click the Alignment tab and select Right Indent.
- Click the Decrease Decimal button once.

- =A3+A4+A5+A6
- =SUM(A3:A6)
- =SUM(A3,A6)
- =SUM(A3,A4,A5,A6)

- MMM-YYYY
- MMMM-YYYY
- MMMM&”-“&YYYY
- M-YYYY

- OFFSET
- VLOOKUP
- INDEX
- MATCH

- Sparklines
- Wrap Text
- Fill Handle
- Centered Alignment

- pie chart
- line chart
- XY scatter chart
- bar chart

- The AutoSum formulas refer to the column to the left of their cells.
- The AutoSum formulas exclude the bottom row of data.
- The AutoSum formulas include the year at the top of each column in the calculation.
`The formula bar clearly shows it's the dates (top row) included, along with the total (bottom) row. Thus, the bottom row of data is not excluded.`

- The AutoSum formulas include their own cells, creating a circular reference.

- The second character in the cell is 9.
- The number 9 appears one or more times within the cell.
- The cell is comprised of 9 characters.
- The number 9 appears once and only once within the cell.

- Align Middle
- Distribute Horizontally
- Distribute Vertically
- Align Center

- a 3D model
- SmartArt
- a Treemap chart
- a drawing object

- Protect Worksheet
- Conditional Formatting
- Allow Users to Edit Ranges
- Data Validation

- ROUNDUP
- MAX
- ROUND
- CEILING

- =MAX(H2:H30)
- =MAXIMUM(H2:H30)
- =LARGE(H2:H30,29)
- =UPPER(H2:H30,1)

- XY chart
- clustered column
- bubble chart
- combo chart

- Hides or shows the formula bar.
- Selects all.
- Hides or shows the ribbon.
- Selects objects.

- =MySheet!A1
- =MySheet_A1
- =MySheet&A1
- =MySheet@A1

- B
- C
- A
- D

- =COUNT(B4:E4&G4:I4)
- =COUNT(B4:E4,G4:I4)
- =COUNT(B4:E4 G4:I4)
- =COUNT(B4:I4)

- In the Format group, select Trendline from the Insert Shapes list.
- Click outside the plot area and select Add Trendline
- Click inside the plot and select Forecast.
- Right-click a data series and select Add Trendline.

- Goal Seek
- Power Pivot
- Data Analysis
- Solver

- Protect Workbook
- Watch Window
- Data Validation
- Filter

- Format the data in column E.
- Format the data in column D.
- Sort the data in column D.
- Sort the data in column E.

- mode
- modulus
- average
- median

- Cell style
- Fill color
- Pattern style
- Font color

- :
- =
- (
- -

A | B | C | |
---|---|---|---|

1 | 8.5% | 2018 Commission | |

2 | Sales Rep | 2018 Sales | Commission Earned |

3 | Jordan Hinton | $123,938.00 | |

4 | Lilah Douglas | $5594,810.00 | |

5 | Karyn Reese | $235,954.00 | |

6 | Chiquita Walsh | $684,760.00 |

- =$A1*B3
- =$A$1*B3
- =A1*$B3
- =A1*B3

- a series of consecutive days following the initial date
- a series of days exactly one month apart
- a series of days identical to the initial date
- a series of days exactly one year apart

- COUNT
- SUMIFS
- COUNTA
- COUNTIF

- 4
- 1
- 5
- 3

- OR(B3=>15,B3<=20)
- AND (B3>=15,B3<=20)
- OR(B3>15,B3<20)
- AND(B3>15, B3<20)

- Fill color
- Font Color
- Pattern Style
- Cell Style

- Move Chart
- Switch Row/Column
- Quick Layout
- Change Chart Type

- Value Formatting
- Cell Style Formatting
- Conditional Formatting
- Tabular format

`=Sum(Sheet1:Sheet4!D18)`

- It adds data from cell D18 of Sheet1 and cell D18 of Sheet4
- It adds data from cell A1 of Sheet1 and cell D18 of sheet4
- It adds all data in the range A1:D18 in Sheet1, Sheet2, Sheet3 and Sheet4
- It adds data from all D18 cells in Sheet1, Sheet2, Sheet3 and Sheet4

- function
- argument
- formula
- contents

- In a worksheet cell, array formulas have a small blue triangle in the cell’s upper-right corner.
- A heavy border appears around the range that is occupied by the array formula.
- In the formula bar, an array formula appears surrounded by curly brackets.
- When a cell that contains an array formula is selected, range finders appear on the worksheet around the formula’s precedent cells.

- Concatenation
- Columns to Text
- Flash Fill
- AutoFill

- =’Budget Variances’!A10
- =’Budget Variances!A10’
- =”BudgetVariances!A10”
- =”BudgetVariances”!A10

- =FIND(A1,1,5)
- =SEARCH(A1,5)
- =LEFT(A1,5)
- =A1-RIGHT(A1,LEN(A1)-5)

- =ISALPHA(A1)
- =ISCHAR(A1)
- =ISSTRING(A1)
- =ISTEXT(A1)

- =UPPER(H2:30,1)
- =MAXIMUM(H2:H30)
- =MAX(H2:H30)
- =LARGE(H2:H30,29)

- Cut and Fill
- Cut and Paste
- Copy and Transpose
- Copy and Paste

- Add a new PivotTable field.
- Add a calculated item
- Add a new Summarize Value By field.
- Add a calculated field.

- =A1*$B3
- =A1*B3
- =$A$1*B3
- =$A1*B3

- 6652
- 43740.665218
- 43740
- 665218