ScienceComputer ScienceComputer SkillsExcel Exam
Please enter something

Excel Exam

Sienna Garcia avatar Sienna Garcia
11 September 2022
4.7 (114 reviews)
18 test answers

Unlock all answers in this set

Unlock answers (14)
question
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.
answer
EX 32 =B4-D4*B4-E4
question
17.
answer
=(B4+B5+B6+B7)*12
question
18.
answer
=AVERAGE(B4:B9)
question
19.In cell C15, create a formula using the COUNT function to count the number of values in the range C4:C13
answer
=COUNT(C3:C14)
question
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.
answer
EX179
question
21.In cell B12, create a formula using the MAX function to calculate the maximum value in the range B4:B9.
answer
=MAX(B4:B9)
question
22.In cell B13, create a formula using the MIN function to calculate the minimum value in the range B4:B9.
answer
=MIN(B4:B9)
question
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.
answer
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
question
25. in cell B10 create a formula using SUM b4:B9
answer
=SUM(B4:B9)
question
26.In cell B12, create a formula using the TODAY function to display the current date.
answer
=TODAY
question
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.
answer
=VLOOKUP(D5,G4:H7,2)
question
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.
answer
Go to Ab on the home tab and go to format cells and on the right there is a degree section
question
33
answer
go to conditional formatting to add solid color data bars
question
42 clear contents in cell E5
answer
right click select clear contents
question
47 use relative cell reference to add
answer
=SUM(B4:B10)
question
62Using the mouse, move the contents of cell B16 to cell C5. Do not cut and paste to move cell contents.
answer
Drag it
question
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.
answer
CTRL-H ...
question
73Insert a page break between row 14 and row 15 of the worksheet.
answer
EX 116