Excel exam

17.

=(B4+B5+B6+B7)*12

18.

=AVERAGE(B4:B9)

19.In cell C15, create a formula using the COUNT function to count the number of values in the range C4:C13

=COUNT(C3:C14)

21.In cell B12, create a formula using the MAX function to calculate the maximum value in the range B4:B9.

=MAX(B4:B9)

22.In cell B13, create a formula using the MIN function to calculate the minimum value in the range B4:B9.

=MIN(B4:B9)

47 use relative cell reference to add

=SUM(B4:B10)

25. in cell B10 create a formula using SUM b4:B9

=SUM(B4:B9)

26.In cell B12, create a formula using the TODAY function to display the current date.

=TODAY

42 clear contents in cell E5

right click select clear contents

24.in cell B10, use the Quick Analysis tool to create a formula that uses the SUM function to total the values in the range B4:B9.

Basically you hold shift starting at B4 to B9 highlighting it then right click and select quick analysis tool and then look for the sum function which then automatically gives you the sum in Cell B10

62Using the mouse, move the contents of cell B16 to cell C5. Do not cut and paste to move cell contents.

Drag it

33

go to conditional formatting to add solid color data bars

20.Enter a formula in cell F4 using the IF function that returns a value of YES if cell E4 is greater than 2, and a value of NO if not.

EX179

27.In cell E5, create a formula using the VLOOKUP function to determine the dog type for teen Anna Morante based on the Program Code listed in cell D5. Use range G4:H7 as the lookup table and the dog type listed in column 2 of the lookup table. Do not enter a value for the optional range_lookup argument.

=VLOOKUP(D5,G4:H7,2)

71 Find and replace all instances of the formatting used in cell A10 with the Black, Text 1 font color (Theme Colors, top row, second option). Do not change any other font settings.

CTRL-H ...

16.Without using parentheses, enter a formula in cell F4 that determines the Annual Net Cash Flow for the grant by taking the value in cell B4, subtracting the product of cell B4 multiplied by cell D4, and then subtracting the value in cell E4.

EX 32 =B4-D4*B4-E4

73Insert a page break between row 14 and row 15 of the worksheet.

EX 116

31.Rotate the contents of the cells in range B3:I3 to exactly 45 degrees, which is three points up and to the left of the 0 (zero) degree marker on the Orientation arc.

Go to Ab on the home tab and go to format cells and on the right there is a degree section