BYSEX21C09SA
You have a worksheet in which employee names are showing in all capital letters. You can use the PROPER function to convert the names so only the first letter in each name is capitalized.
Correct!
Review the section "Changing Case."
Flash Fill is like the CONCAT function because they can both combine columns of data anywhere on a worksheet.
Correct!
Review the section "Merge and Modify Text with Functions and Flash Fill."
Sylvia wants to find the sum of salaries for all sales staff in Toronto. She can use the formula =SUMIF(H3:H90,C3:C90,"Toronto",B3:B90,"Sales") to add all salaries in the range H3:H90 that match the given criteria in columns B and C.
Correct!
Review DYS E9-D2.
Conditional formulas are useful for analyzing large amounts of data, because they allow you to search through a range and then count, add, or find an average for the data that matches certain criteria.
Correct!
Review the section "Creating Conditional Functions Using IF Criteria."
To perform more than one function, you must use more than one cell, column, or row.
Correct!
Review the section "Nested Functions."
You created a formula using a 3-D reference to find the sum of cell B5 across the four sheets in your workbook. Later you add a fifth sheet. To add the sum of cell B5 on the new sheet, you must edit the formula.
Correct!
Review the section "3-D Cell References."
What do the arrows show about the selected cell, for the total paid out?
A worksheet with the title April Totals and the two headings Description and Amount. The Description column contains five headings: Total Sales, Total Commissions, Total Bonus, Total Paid Out, and Total Paid Out as Percentage of Sales. There are various numbers in the Amount column. The Total Paid Out amount cell is selected; arrows are pointing from off the image to the Total Commissions and Total Bonus amounts, Total Bonus and Total Commissions arrows are pointing to Total Paid Out amount, and Total Paid Out has an arrow pointing to Total Paid Out as Percentage of Sales amount.
Correct!
Review the section "Trace Precedents and Dependents."
Geoff needs to fix a long list of product codes by extracting only the first seven characters and showing all capital letters. Which two functions should Geoff use to quickly accomplish his goal without manually typing each code?
Table showing two columns with the headings Old Product Code and New Product Code. The old product codes have varying numbers of characters, including numbers, uppercase letters, and lowercase letters. The new product codes are seven characters each and use numbers and uppercase letters only.
Correct!
Review the section "Using Functions to Modify Text."
You want to know how many cars in your inventory are red. Based on this image, which formula would return the correct result, 5?
Worksheet with heading rows across columns A-C (Model #, Color, Available), and rows 2-6 filled in with data.
Correct!
Review the section "Creating Conditional Functions Using IF Criteria."
You’re teaching an Excel course! It’s the end of the term and you’re reviewing student performance. You want to use a function to analyze each student’s average for the five tests. The function should return the word OVER for averages 70% or higher and UNDER for averages under 70%. Which formula will obtain the desired result in cell G2?
Worksheet showing the range A1:G5, in which column A shows the student ID for four students, columns B-F show scores for each of the five tests, and column G (heading 70% AVG) shows either OVER or UNDER. Cell G2 shows “OVER”.
Correct!
Review the section "Nested Functions."
You usually see the #VALUE! error because your formula attempts to perform a mathematical operation on a cell that:
Correct!
Review the section "Checking for Errors."
To create a formula on the Total sheet that adds cell B3 from the other sheets shown, you would use the 3-D reference:
Excel workbook with five tabs showing. From left to right the tabs read: Troy, Shirley, Brita, Abed, and Total.
Correct!
Review the section "3-D Cell References."