1.

Right-click column C, select Format Cells, and then select Best-Fit.

2.

Right-click column C and select Best-Fit.

3.

Double-click column C.

4.

Double-click the vertical boundary between columns C and D.

1.

ISNUMBER and ISTEXT

2.

ISNUMBER and ISALPHA

3.

ISVALUE AND ISNUMBER

4.

ISVALUE and ISTEXT

1.

Jan, Jan, Jan

2.

Feb, Mar, blank cell

3.

Feb, Mar, Apr

4.

FEB, MAB, APR

1.

the death of chivalry

2.

The death of Chivalry

3.

THE DEATH OF CHIVALRY

4.

The Death Of Chivalry

1.

Sort by the data in Column E.

2.

Format the data in Column D.

3.

Sort by the data in Column D.

4.

Format the data in Column E.

1.

Alt+F4 (Windows) or Option+F4 (Mac)

2.

Alt+Shift+4 (Windows) or Option+Shift+4 (Mac)

3.

Ctrl+Shift+4 (Windows) or Command+Shift+4 (Mac)

4.

the F4 (Windows) or Command+T (Mac)

1.

Add an image of the chart to a comment.

2.

Add a hyperlink to another worksheet that displays a chart when clicked.

3.

Add an image of the chart to the worksheet.

4.

Add a sparkline, a graphic that summarizes data visually within a single worksheet cell.

1.

Right-click anywhere and select Help.

2.

Press F1 or click the Help tab in the ribbon.

3.

Press F10.

4.

all of these answers.

1.

##,###,,

2.

###.0,,

3.

999.9,,

4.

###,###.0,

1.

three inputs

2.

four inputs

3.

two inputs

4.

one input

1.

Show in Tabular Form

2.

Show in Compact Form

3.

Show in Compact For or Show in Outline Form

4.

Show in Tabular Form or Show in Outline Form

1.

Use the ROUND() function.

2.

Click the Decrease Decimal button twice.

3.

In the cells group on the Home tab, click Format > Format Cells. Then click the Alignment tab and select Right Indent.

4.

Click the Decrease Decimal button once.

1.

=A3+A4+A5+A6

2.

=SUM(A3:A6)

3.

=SUM(A3,A6)

4.

=SUM(A3,A4,A5,A6)

1.

MMM-YYYY

2.

MMMM-YYYY

3.

MMMM&"-"&YYYY

4.

M-YYYY

1.

OFFSET

2.

VLOOKUP

3.

INDEX

4.

MATCH

1.

Sparklines

2.

Wrap Text

3.

Fill Handle

4.

Centered Alignment

1.

pie chart

2.

line chart

3.

XY scatter chart

4.

bar chart

1.

The AutoSum formulas refer to the column to the left of their cells.

2.

The AutoSum formulas exclude the bottom row of data.

3.

The AutoSum formulas include the year at the top of each column in the calculation.

4.

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

1.

The second character in the cell is 9.

2.

The number 9 appears one or more times within the cell.

3.

The cell is comprised of 9 characters.

4.

The number 9 appears once and only once within the cell.

1.

Align Middle

2.

Distribute Horizontally

3.

Distribute Vertically

4.

Align Center

1.

a 3D model

2.

SmartArt

3.

a Treemap chart

4.

a drawing object

1.

Protect Worksheet

2.

Conditional Formatting

3.

Allow Users to Edit Ranges

4.

Data Validation

1.

ROUNDUP

2.

MAX

3.

ROUND

4.

CEILING

1.

=MAX(H2:H30)

2.

=MAXIMUM(H2:H30)

3.

=LARGE(H2:H30,29)

4.

=UPPER(H2:H30,1)

1.

XY chart

2.

clustered column

3.

bubble chart

4.

combo chart

1.

Hides or shows the formula bar.

2.

Selects all.

3.

Hides or shows the ribbon.

4.

Selects objects.

1.

=MySheet!A1

2.

=MySheet_A1

3.

=MySheet&A1

4.

=MySheet@A1

1.

B

2.

C

3.

A

4.

D

1.

=COUNT(B4:E4&G4:I4)

2.

=COUNT(B4:E4,G4:I4)

3.

=COUNT(B4:E4 G4:I4)

4.

=COUNT(B4:I4)

1.

In the Format group, select Trendline from the Insert Shapes list.

2.

Click outside the plot area and select Add Trendline

3.

Click inside the plot and select Forecast.

4.

Right-click a data series and select Add Trendline.

1.

Goal Seek

2.

Power Pivot

3.

Data Analysis

4.

Solver

1.

Protect Workbook

2.

Watch Window

3.

Data Validation

4.

Filter

1.

Format the data in column E.

2.

Format the data in column D.

3.

Sort the data in column D.

4.

Sort the data in column E.

1.

mode

2.

modulus

3.

average

4.

median

1.

Cell style

2.

Fill color

3.

Pattern style

4.

Font color

1.

:

2.

=

3.

(

4.

-

1.

=$A1*B3

2.

=$A$1*B3

3.

=A1*$B3

4.

=A1*B3

1.

a series of consecutive days following the initial date

2.

a series of days exactly one month apart

3.

a series of days identical to the initial date

4.

a series of days exactly one year apart

1.

COUNT

2.

SUMIFS

3.

COUNTA

4.

COUNTIF

1.

4

2.

1

3.

5

4.

3

1.

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

2.

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

3.

OR(B3>15,B3<20)

4.

AND(B3>15, B3<20)

1.

Fill color

2.

Font Color

3.

Pattern Style

4.

Cell Style

1.

Move Chart

2.

Switch Row/Column

3.

Quick Layout

4.

Change Chart Type

1.

Value Formatting

2.

Cell Style Formatting

3.

Conditional Formatting

4.

Tabular format

1.

It adds data from cell D18 of Sheet1 and cell D18 of Sheet4

2.

It adds data from cell A1 of Sheet1 and cell D18 of sheet4

3.

It adds all data in the range A1:D18 in Sheet1, Sheet2, Sheet3 and Sheet4

4.

It adds data from all D18 cells in Sheet1, Sheet2, Sheet3 and Sheet4

1.

function

2.

argument

3.

formula

4.

contents

1.

In a worksheet cell, array formulas have a small blue triangle in the cell's upper-right corner.

2.

A heavy border appears around the range that is occupied by the array formula.

3.

In the formula bar, an array formula appears surrounded by curly brackets.

4.

When a cell that contains an array formula is selected, range finders appear on the worksheet around the formula's precedent cells.

1.

Concatenation

2.

Columns to Text

3.

Flash Fill

4.

AutoFill

1.

='Budget Variances'!A10

2.

='Budget Variances!A10'

3.

="BudgetVariances!A10"

4.

="BudgetVariances"!A10

1.

=FIND(A1,1,5)

2.

=SEARCH(A1,5)

3.

=LEFT(A1,5)

4.

=A1-RIGHT(A1,LEN(A1)-5)

1.

=ISALPHA(A1)

2.

=ISCHAR(A1)

3.

=ISSTRING(A1)

4.

=ISTEXT(A1)

1.

=UPPER(H2:30,1)

2.

=MAXIMUM(H2:H30)

3.

=MAX(H2:H30)

4.

=LARGE(H2:H30,29)

1.

Cut and Fill

2.

Cut and Paste

3.

Copy and Transpose

4.

Copy and Paste

1.

Add a new PivotTable field.

2.

Add a calculated item

3.

Add a new Summarize Value By field.

4.

Add a calculated field.

1.

=A1*$B3

2.

=A1*B3

3.

=$A$1*B3

4.

=$A1*B3

1.

6652

2.

43740.665218

3.

43740

4.

665218

1.

Both values are lost.

2.

Cell A2 contains the value 8 and cell B2 is empty.

3.

Cell A2 contains the value 8 and cell B2 contains the value 9.

4.

Cell A2 contains the value 17 and cell B2 is empty.

1.

column D

2.

columns D through H

3.

column H

4.

column F

1.

cell values only

2.

cell values and formats

3.

cell values and formulas

4.

cell value, formats, and formulas

1.

`=SUMIF(G2:G6,">17",F2:F6)`

2.

`=SUM(G2:G6,">=18,F2:F6)`

3.

`=SUMIF(F2:F6,">=18",G2:G6)`

4.

`=SUM(F2:F6,"18+",G2:G6)`

1.

`=RIGHT(E2,LEN(E2)-27)`

2.

`=LEN(E2,MID(E2)-27)`

3.

`=LEFT(E2,LEN(E2)-27)`

4.

`=RIGHT(E2,MID(E2)-27)`

1.

the Inventory worksheet in the Colors workbook

2.

the Inventory column in the Colors table

3.

the Colors worksheet in the Inventory workbook

4.

the named range Colors[Inventory], which does not use Format as Table Feature

1.

`=VLOOKUP(A2,J2:L5,1,FALSE)`

2.

`=VLOOKUP(J2,A$2:C$7,1,FALSE)`

3.

`=VLOOKUP(J2,A$2:C$7,3,FALSE)`

4.

`=VLOOKUP(J2,A2:C7,3,FALSE)`

1.

`=SUBTOTAL(C1:Y15)`

2.

`=SUM(15L:15Z)`

3.

`=SUM(C15:Y15)`

4.

`=SUM(C11:C35)`

1.

4

2.

5

3.

3

4.

2

1.

Select `Paste Special > Values.`

2.

Select `Paste Special > Transpose.`

3.

Use the `TRANSPOSE` function

4.

Click `Switch Rows & Columns`

1.

`=RIGHT(A1)-LEFT(A1)+1`

2.

`=LEN(A1)`

3.

`=EXACT(A1)`

4.

`=CHARS(A1)`

1.

`=B$2*C$2`

2.

`=$C$2/$B$2`

3.

`=C2/B2`

4.

`=B2*C2`

1.

On the PivotTable itself, drag each `Average` field into the row fields area.

2.

Right-click a cell in the PivotTable and select `PivotTable Options > Classic PivotTable layout`.

3.

In the `PivotTable Fields` pane, drag `Sum Values` from the `Columns` section to a location below the field in the `Rows` section.

4.

In the `PivotTable Fields` pane, drag each field from the `Sum Values` section to the `Rows` section.

5.

grouping

6.

filtering

7.

hiding

8.

cut and paste

1.

`=SUMIF($B$2:$M$2,"COLUMN($B$2:$M$2)<=COLUMN())")`

2.

`=SUM($B2:B2)`

3.

`=SUM(OFFSET($A1,0,0,1,COLUMN()))`

4.

`=B2+B3`

1.

4

2.

1

3.

5

4.

3

1.

rows:event, donor / values: Sum of amount

2.

columns: event / row:donor / values: Sum of amount

3.

rows:donor, event / values: Sum of amount

4.

filter: event / row:donor / values: Sum of amount

1.

The absolute/relative cell references in the formula are wrong

2.

Cell A6 is not actualy text its a formula that need to be copied and pasted as a value

3.

Column C in the lookup range is not sorted properly

4.

A trailing space probably exist in cell A6 or F7

1.

deletes removes the entire column or row. Clear removes the content from the column or row

2.

deletes removes formulas, values and hyperlinks. clear removes formulas, values, hyperlinks, formats, comments and notes

3.

Delete removes the cell itself, shifting cells either up or to the left. Clear removes content and properties but does not muves cells

4.

Delete removes formulas and values. clear removes formulas, values, hyperlinks, formats, comments and notes

1.

cell

2.

selection

3.

element

4.

scalar

1.

Use weight as a filter field as well as a row field in the PivotTable.

2.

Use `IF()` to show weight by categories instead of by pounds.

3.

Click the _Row Labels_ arrow and select _Group_.

4.

Right-click any row field value in the PivotTable and select _Group_.

1.

Select the cell into which you want to drill down, right-click, and select _Show Summary_.

2.

Select the cell into which you want to drill down, right-click and select _Drill-down_.

3.

Select the cell into which you want to drill down and double-click.

4.

Select the cell into which you want to drill down, right-click and select _Show Details > Summary Page_

1.

0

2.

1

3.

FALSE

4.

TRUE

1.

Right-click D2 and select _Fill Down_.

2.

Click D2's fill handle and drag it down to D501.

3.

On the ribbon's _Data_ tab, select _Flash fill_.

4.

Double-click D2's fill handle.

1.

A

2.

B

3.

C

4.

D

1.

A

2.

B

3.

C

4.

D

1.

`=(A5+B5)*B7`

2.

`=A3-7(B3:B5+4)`

3.

`=(A5+B5)B7`

4.

`=B3^[2*/3]`

1.

Select column G, then right-click and select `Unhide`.

2.

Select column C, then right-click and select `Unhide`.

3.

On the Page Layout tab, in the `Rows` and `Columns` section, select `Unhide`.

4.

Click and drag to select columns C and G, then right-click and select `Unhide`.

1.

Check Accessibility

2.

Check Compatibility

3.

Protect Document

4.

Inspect Document

1.

Select the image and, on the `Picture Tools Format` tab, use the `Compress Picture` feature.

2.

Select the image and, on the `Design` tab, use the `Format Background` feature.

3.

On the `Drawing Tools Format` tab, select `Graphics Fill` > `Remove Background`.

4.

Select the image and, on the `Picture Tools Format` tab, click the Remove Background button.

1.

Create an outline in the outline view and rearrange slides.

2.

Add a table of contents slide and link the remaining slides to it.

3.

Add sections and move the slides into the appropriate sections.

4.

Create custom shows and add the slides into the shows.

1.

43

2.

12

3.

#VALUE!

4.

7

1.

Select the cell. On the Home tab, click Clear.

2.

Select the cell and press Delete.

3.

Right-click the cell and select Delete.

4.

Select the cell. On the Home tab, click Clear > Clear All.

1.

An Excel file is a workbook. A workbook contains one or more worksheets.

2.

Nothing-these two terms mean the same thing.

3.

A workbook contains only data. A worksheet contains both data and formulas.

4.

An Excel file is a worksheet. A worksheet contains one or more workbooks.

1.

You cannot use one slicer for two PivotTables.

2.

Right-click the slicer and select Slicer Settings.

3.

Merge the two PivotTables, right-click the merged PivotTable, and select Combine Slicer.

4.

Right-click the slicer and select Report Connections, or click Report Connections on the Slicer tab.

1.

`=B7*$G$3`

2.

`=(B7)*G3`

3.

`=B7*$[G3]`

4.

`=B7$*G3`

1.

AutoSum shows the total in the bottom-right of the page

2.

AutoSum will total the numbers in cells B4:G8

3.

AutoSum will total the numbers in cells B4:G4

4.

AutoSum will return a **#VALUE!** error.

1.

Total Sales This Year; Total Sales This Year

2.

Total Sales This Year; Market Region

3.

Representative ID Number; Total Sales This Year

4.

Market Region; Total Sales This Year

5.

undefined

1.

`=SELECT(A1, "Banana", "Orange", "Apple", "Mango")`

2.

`=CHOOSE(A1, "Banana", "Orange", "Apple", "Mango")`

3.

`=CHOOSE(A1,"Banana","Orange","Apple","Mango")`

4.

`=MATCH(A1,{"Banana","Orange","Apple","Mango"})`

1.

average number of minutes per call

2.

average annual sales per minute

3.

average number sales

4.

average annual sales per call

1.

On the **Home** tab, click **Find & Select > Find > Options** (Windows) or **Find & Select > Find** (Mac). Change the **Within** drop-down to **Workbook**.

2.

On the **Home** tab, click **Find & Select > Find > Options** (Windows) or **Find & Select > Find** (Mac). Change the **Look in** drop-down to **Workbook**.

3.

On the **Home** tab, click **Find & Select > Find > Options** (Windows) or **Find & Select > Find** (Mac). Change the **Search** drop-down to **All**.

4.

You cannot search an entire workbook - you must search the worksheets individually.

1.

map chart

2.

color scales (within conditional formatting)

3.

manual highlighting

4.

data bars (within conditional formatting)

1.

Text control > Merge cells

2.

Horizontal > Center across selection

3.

Vertical > Center across selection

4.

Data tab > Text to columns

1.

The dates are erroneous, such as October 39, 2015.

2.

The columns aren't wide enough to show the full date.

3.

The time are incorrectly formatted as dates.

4.

The text is incorrectly formatted as dates.

1.

IFERROR

2.

ROUND

3.

ISERROR

4.

DIVIDE

1.

Use Print Titles on the Page Layout tab.

2.

Use Page Setup from the Backstage View.

3.

Use Freeze Panes on the View tab.

4.

Format your data as a table; the header prints automatically.

1.

Too Many Tardy Days

2.

#NUM!

3.

No Tardiness Issue

4.

#REF!

1.

Conditional Formatting

2.

Format

3.

Cell Styles

4.

Fill

1.

Cells A2:D2 are comments relating to the formula in cell C4.

2.

Cells A2:D2 are the source of an error in the formula in cell C4.

3.

Cells A2:D2 are precedents of the formula in cell C4.

4.

Cells A2:D2 are dependents of the formula in cell C4.

1.

data table

2.

data numbers

3.

data labels

4.

data values

1.

radar chart

2.

box and whisker chart

3.

XY scatter chart

4.

combo chart

1.

Distribute Horizontally

2.

Align Center

3.

Distribute Vertically

4.

Align Middle