Performance management study pt.2

What does the formula =IF(B1<C1,"B","C") mean? a) If cell B1 is less than cell C1, return the character B; otherwise, return the character C. b) If cell B1 is less than cell C1, return the value of cell B1; otherwise, return the value of cell C1. c) If cell B1 is less than cell C1, return the character C; otherwise, return the character B.

a) If cell B1 is less than cell C1, return the character B; otherwise, return the character C.

You have a range of values on a fees sheet and want to add the total fees to a summary sheet. What is the best way to do this? a) In a summary sheet cell, type =SUM(, highlight the range of values on the fees sheet, and type Enter. b) In a summary sheet cell, type =COUNTA(, highlight the range of values on the fees sheet, and type Enter. c) Copy the range of values from the fees sheet, paste it in the summary sheet, and reference it in a =SUM formula there.

a) In a summary sheet cell, type =SUM(, highlight the range of values on the fees sheet, and type Enter.

What does the formula =COUNTIFS(A1:A10,E1,B1:B10,F1) return? a) the number of rows between 1 and 10 in which the cell in column A matches cell E1 and the cell in column B matches F1 b) the total number of non-blank cells in range A1 to A10, cell E1, range B1 to B10, and cell F1 c) the number of cells in range A1 to A10 that match cell E1 added to the number of cells in range B1 to B10 that match cell F1

a) the number of rows between 1 and 10 in which the cell in column A matches cell E1 and the cell in column B matches F1

Nora has a sheet of a company's products from which to extract the top sellers. Why might she copy the sheet, rename it RAW, and color its tab red? a) to back up her source data and warn herself if she returns to that sheet b) to keep herself organized by showing which sheet she will work on c) to show that she is free to modify that sheet while she works

a) to back up her source data and warn herself if she returns to that sheet

Hugo has a table ranging from B5 to F50, including a header row that he wants to keep visible when scrolling vertically. Which cell should he select before selecting Freeze Panes? a) B4 b) B6 c) B5

b) B6

What does it mean when a cell contains #N/A? a) Excel locked the cell to prevent further editing. b) Excel was sent to look for something that it could not find. c) Excel knows that referenced data means discontinued items.

b) Excel was sent to look for something that it could not find.

In a column of ages, how would you prohibit entering values under 18 and over 34? a) In the Data Validation dialog, set Allow to Decimal, Data to between, Minimum to 18, and Maximum to 34. b) In the Data Validation dialog, set Allow to Whole number, Data to between, Minimum to 18, and Maximum to 34. c) In the Data Validation dialog, set Allow to Whole number, Data to between, Minimum to 17, and Maximum to 35.

b) In the Data Validation dialog, set Allow to Whole number, Data to between, Minimum to 18, and Maximum to 34.

You have five values in a row of six cells. How can you efficiently add these values and show the result on the sheet? a) Use a calculator to total the values and type the result in a cell on the sheet. b) Type =SUM( in any empty cell, highlight the range of values, and type Enter. c) Select the next cell in the row, select the AutoSum button on the Home tab, and type Enter.

b) Type =SUM( in any empty cell, highlight the range of values, and type Enter.

What will the formula =IFNA(VLOOKUP(A1,$M$1:$O$10,3,FALSE),"Not Found") return if cells A1 and M5 contain 22-7, N5 contains 15, and O5 contains LAX? a) 15 b) Not Found c) LAX

c) LAX

Audra has a data column formed like Smith, John, ORD. With the column selected in Power Query Editor, how can she create two columns formed like Smith, John and ORD? a) Split the column by left-most delimiter with a comma followed by a space as the custom delimiter. b) Split the column by right-most delimiter with a comma set as the delimiter. c) Split the column by right-most delimiter with a comma followed by a space as the custom delimiter.

c) Split the column by right-most delimiter with a comma followed by a space as the custom delimiter.

Boyd wants to highlight the cells in A1 through C5 whose value exceeds cell F2's value with a light red fill. What should he do after selecting Conditional Formatting? a) Select Highlight Cells Rules > Greater Than, select cells A1 through C5, and then choose Light Red Fill. b) Select Highlight Cells Rules > Greater Than, select cells A1 through C5, and then choose Light Red Fill. c) With the cell range selected, select Highlight Cells Rules > Greater Than, select cell F2, and then choose Light Red Fill.

c) With the cell range selected, select Highlight Cells Rules > Greater Than, select cell F2, and then choose Light Red Fill.

Which scenario is best handled with a drop-down list? a) You want to select an employee's full name and job title. b) You want to list the ages of an employee's beneficiaries. c) You want to specify which company site an employee works at.

c) You want to specify which company site an employee works at.