Hireizon Assessments - Excel 2010 Interactive Assessment

Hireizon Assessments - Excel Assessment

45:00

Enter Your Information

(Please fill out the required fields)

Question 1 / 40

What is the part that contains File, Home, and Insert for an excel document called?

Answer:

A) Header B) Cell C) Ribbon D) Label

Question 2 / 40

What symbol do most excel functions begin with?

Answer:

A) ? B) = C) ! D) (

*Note: If spreadsheet freezes or looks strange, use Reload Spreadsheet button

Question 3 / 40

In the provided Excel spreadsheet, enter the following data:
A1: Product, B1: Sales
A2: Product A, B2: 415
A3: Product B, B3: 697
A4: Product C, B4: 748
A5: Product D, B5: 910
A6: Sum
Use the =SUM() function in cell B6 to give a total cost of all sales.

What Answer Did You Get?:

A) 2670 B) 2700 C) 2740 D) 2770

Question 4 / 40

Refer to the image.
What function would you use to remove the unnecessary spaces and copy the contents from column A and then paste it to column C?:

Answer:

A) =TRIM(A2) B) =CLEAN(TRIM(A1:A8)) C) =ERROR.TYPE(A2) D) =TRIM(A2)

Question 5 / 40

What does this formula do? =Sum(Sheet1:Sheet4!D18)

Answer:

A) Add data from all D18 cells in Sheet1, Sheet2, Sheet3 and Sheet4 B) Add data from all D18 cells in Sheet1 and Sheet4 C) Add all data of Sheet1 and Sheet4 and place it in Cell D18 on Sheet 4 D) Add all data of Sheet1, Sheet2, Sheet3, and Sheet4 and place it in Cell D18 on Sheet 4

*Note: If spreadsheet freezes or looks strange, use Reload Spreadsheet button

Question 6 / 40

In the provided Excel spreadsheet, enter the following data:
A1: Product, B1: Sales
A2: Product A, B2: 392
A3: Product B, B3: 867
A4: Product C, B4: 1242
A5: Product D, B5: 1560
A6: Average
Use the =AVERAGE() function in cell B6 to give a average of all sales.

What Answer Did You Get?:

Answer:

A) 1015.25 B) 1015.50 C) 1025.50 D) 1050.15

Question 7 / 40

What type of formatting would you use to identify the top selling products in a specific color

Answer:

A) Cell Style Formatting B) Value Formatting C) Conditional Formatting D) Column Style Formatting

Question 8 / 40

Refer to the image.
Which Excel function would you use to avoid #DIV/0! errors

Answer:

A) HASERROR() B) DIVIDE() C) ISERROR() D) IFERROR()

Question 9 / 40

If cell A3 contains the text HELLO CANDIDATE, what will the function =PROPER(A3) return?

Answer:

A) hello candidate B) HELLO CANDIDATE C) hello Candidate D) Hello Candidate

Question 10 / 40

Refer to the image.
The Sum formulas in the range B11:F11 below return unexpected values. Why is this?

Answer:

A) The formulas are including the years at the top B) The formulas are creating a circular reference C) Both A and B D) None of the above

Question 11 / 40

Which formula is NOT equivalent to all of the others?

Answer:

A) =SUM(A3,A6) B) =A3+A4+A5+A6 C) =SUM(A3,A4,A5,A6) D) =SUM(A3:A6)

Question 12 / 40

Refer to the image.
Jack's Year Round Supply has a spreadsheet to count the total cost of all items, total amount of items that they sell, the total amount of seasons they sell items in, and whether or not they are inflating prices.
The Total Items (D:10) cell is giving an unexpected output.
The function being used is =COUNT(A5:A8,C5:C8,E5:E8,G5:G8).
Why is this incorrect?

Answer:

A) The cells aren't specified correctly B) It should be =COUNTA() C) It should be =COUNTBLANK() D) None of the above

*Note: If spreadsheet freezes or looks strange, use Reload Spreadsheet button

Question 13 / 40

In the provided Excel spreadsheet, solve the Total Cost of purchasing two pounds of every item.
Use the orange box to input the correct function to calculate the answer.
(Note: input = before your function)

What was the correct answer:

A) $7,100 B) $7,120 C) $7,126 D) $7,135

Question 14 / 40

Which is NOT a way to delete a row?

Answer:

A) Highlighting the whole row and pressing the delete key on your keyboard B) Right clicking the row number and clicking Delete C) Highlighting the whole row and pressing Delete on the ribbon D) Right clicking the column letter and clicking delete

Question 15 / 40

Refer to the image.
Which of the following functions was used to get the largest value in cell B13 from the group of cells B3:B12.

Answer:

A) =MAX() B) =LARGE() C) =LARGEST() D) None of the above

Question 16 / 40

What does the TRANSPOSE() function do?

Answer:

A) Return a vertical range of cells as a horizontal range, or vice versa B) Swap two cells with each other C) Return an array to be swapped with another array D) None of the above

*Note: If spreadsheet freezes or looks strange, use Reload Spreadsheet button

Question 17 / 40

In the provided Excel spreadsheet, use a SUMIF function in the blank textbox next to Total Price Of Approved to sum the values in Price for only those rows where Price Approval contains 'Approved.' What is the correct function and result?

Answer:

A) =SUMIF(E3:F14, "Approved", C3:D14) | Result: $780.00 B) =SUMIF(E3:F14, "Approved", C3:D14) | Result: $820.00 C) =SUMIF(C3:D14, "Approved", E3:F14) | Result: $820.00 D) =SUMIF(C3:D14, "Approved", E3:F14) | Result: $840.00

*Note: If spreadsheet freezes or looks strange, use Reload Spreadsheet button

Question 18 / 40

Using the provided Excel spreadsheet, input the correct function to list the total service tickets where their status is Completed into cell E17.

What is the correct function?

A) =COUNTWHEN(E8:F19, "Completed") B) =COUNT(E8:F19, "Completed") C) =COUNTIF(E8:F19, "Completed") D) =COUNTFOR(E8:F19, "Completed")

Question 19 / 40

When using the =FIND("@", A2) formula, what is returned?

Answer:

A) The length up to "@" in A2 B) The index of "@" in A2 C) The number of "@" symbols in A2 D) None of the above

Question 20 / 40

Which one will format the date in cell A2 as 4 digit Year - 2 digit Month - 2 digit Day

Answer:

A) =TEXT(A2, "YYYY-MM-DD") B) =TEXT(A2, "YY-MM-DD") C) =TEXT(A2, "MM-DD-YYYY") D) =TEXT(A2, "YYYY-DD-MM")

Question 21 / 40

Refer to the image. Which of the following functions will yield the correct result in cell C10 where it will Pass at 70 and above; and Fail at 69 or lower?

Answer:

A) =IF(B10<70,"Fail") B) =IF(B10!=70,"Fail") C) =IF(B10<=70,"Pass","Fail") D) =IF(B10>=70,"Pass","Fail")

Question 22 / 40

Which function would you use to solve the length of a string in a cell?

Answer:

A) =LENGTHOF() B) =LENGTH() C) =LEN() D) =LENOF()

Question 23 / 40

What function would you use to round to two decimal points based on the number's value?

Answer:

A) =TRUNCATE() B) =ROUND() C) =ROUNDDOWN() D) =ROUNDUP()

Question 24 / 40

Which function will concatenate two words together?

Answer:

A) =CONCATSTRING() B) =CONCATFOR() C) =CONCATENATE() D) =CONCAT()

Question 25 / 40

Which of the following will protect the worksheet?

Answer:

A) Protect Sheet B) Protect Workbook C) Protect Cells D) Lock Sheet

Question 26 / 40

Refer to the image. Which complex VLOOKUP formula is being used to get the value in the merged Lookup output cell (D24)?

Answer:

A) =CONCAT(VLOOKUP(1018,A2:E22,2,FALSE), VLOOKUP(1018,A2:E22,3,FALSE), VLOOKUP(1018,A2:E22,5,FALSE)) B) =CONCAT(VLOOKUP(1018,A2:E22,2,FALSE), VLOOKUP(1018,A2:E22,3,FALSE), " (", VLOOKUP(1018,A2:E22,5,FALSE), ")") C) =CONCAT(VLOOKUP(1018,A2:E22,2,FALSE), " ", VLOOKUP(1018,A2:E22,3,FALSE), " (", VLOOKUP(1018,A2:E22,5,FALSE), ")") D) =CONCAT(VLOOKUP(1018,A2:E22,2,FALSE), " ", VLOOKUP(1018,A2:E22,3,FALSE), VLOOKUP(1018,A2:E22,5,FALSE))

*Note: If spreadsheet freezes or looks strange, use Reload Spreadsheet button

Question 27 / 40

In the provided Excel spreadsheet, input Miles S. into cell A21 and 11 into cell B21. Where does the data go in the chart?

Answer:

A) At the bottom of the chart B) At the top of the chart C) Mixed in with the other data D) It doesn't appear

Question 28 / 40

Refer to the image. Based off of what is shown in the image, what would you do to format cells N5:N19 to match what cell N4 says everything below it should be?

Answer:

A) Click the % symbol in the Number section of the ribbon B) Click Cell Styles in the Styles section of the ribbon C) Click the , symbol in the Number section of the ribbon D) Click the dropdown textbox titled "General" and select Number

Question 29 / 40

Which of the following is used to merge cells together?

Answer:

A) Marge & Center B) Merge Cells C) Merge Across D) All of the above

*Note: If spreadsheet freezes or looks strange, use Reload Spreadsheet button

Question 30 / 40

In the provided Excel spreadsheet, enter the following data:
A3: Breakfast, B3: 20
A4: Brunch, B4: 4
A5: Lunch, B5: 16
A6: Snacks, B6: 24
A7: Dinner, B7: 12
A8: Dessert, B8: 22

What is wrong with this data in the pie chart?

Answer:

A) It doesn't sum to 100% B) It is excluding Dessert from the pie chart C) Both A and B D) None of the above

Question 31 / 40

Which function will give you the current date?

Answer:

A) =TODAY() B) =TODAYDATE() C) =DATE() D) =DATETODAY()

Question 32 / 40

Which function is used to find the smallest number in a range?

Answer:

A) =MIN() B) =MINIMUM() C) =MINOF() D) =MINNUM()

Question 33 / 40

Refer to the image. This spreadsheet requires checkboxes in cells B4:B11, which ribbon tab will let you achieve this?

Answer:

A) Home B) Page Layout C) Data D) Insert

Question 34 / 40

Which conditional formatting method would you use to have icons as identifiers?

Answer:

A) Icon Indicators B) Icon Formatting C) Icon Sets D) Icon Conditions

Question 35 / 40

What is a macro in Excel?

Answer:

A) A set of instructions that you run one time and one time only B) A recording of data in a table C) An action or a set of actions that you can run as many times as you want D) A set of items that will fill a table in a sequence

Question 36 / 40

A pivot chart allows you to...

Answer:

A) Pivot data around a chart to organize it B) Analyze data using graphs and layouts C) Set a range of values to be calulated later D) None of the above

Question 37 / 40

Which one is the correct way to wrap text?

Answer:

A) Highlighting the cell and clicking Wrap Text in the ribbon B) Highlighting then cell and pressing Alt + H + W C) Right clicking the cell and clicking Format Cells, Alignment, Wrap Text D) All of the above

Question 38 / 40

Refer to the image The spreadsheet has a various amount of unsorted names. How would you sort columns A, B, C, and D in alphabetical descending?

Answer:

A) Highlight all content in column A, click the Data tab and click the Sort A to Z button under the Sort & Filter section. Repeat for columns B, C, and D B) Highlight all contents in column A, right click, click Sort, and click Sort A to Z. Repeat for columns B, C, and D C) Highlight column A and press Alt + A + S + A. Repeat for columns B, C, and D D) All of the above

Question 39 / 40

Which one is the correct way to align content in a cell?

Answer:

A) Highlight the cell and click any of the horizontal or vertical alignment options in the ribbon B) Right click the cell and click format celles, then click alignment and select options under Right-to-left C) Highlight the cell and click Wrap Text in the ribbon D) Highlight the cell and click Cell Styles in the ribbon

Question 40 / 40

What is it called when you put If functions inside of each other?

Answer:

A) Duplicating B) Inserting C) Nesting D) Chambering

Hireizon Assessments - Excel Assessment

Enter Your Information

Question 1 / 40

Question 2 / 40

Question 3 / 40

Question 4 / 40

Question 5 / 40

Question 6 / 40

Question 7 / 40

Question 8 / 40

Question 9 / 40

Question 10 / 40

Question 11 / 40

Question 12 / 40

Question 13 / 40

Question 14 / 40

Question 15 / 40

Question 16 / 40

Question 17 / 40

Question 18 / 40

Question 19 / 40

Question 20 / 40

Question 21 / 40

Question 22 / 40

Question 23 / 40

Question 24 / 40

Question 25 / 40

Question 26 / 40

Question 27 / 40

Question 28 / 40

Question 29 / 40

Question 30 / 40

Question 31 / 40

Question 32 / 40

Question 33 / 40

Question 34 / 40

Question 35 / 40

Question 36 / 40

Question 37 / 40

Question 38 / 40

Question 39 / 40

Question 40 / 40

Results