BYSEX21C03SA
You must type functions directly into a cell.
Correct!
Review the section "Using Functions in Formulas."
Selecting a blank cell at the bottom of a column and clicking AutoSum inserts the SUM function, which adds all adjacent numbers in that column.
Correct!
Review the section “The AutoSum Feature."
You enter =A3 in a cell and tap [F4] twice. Your screen now matches this image, showing an absolute cell reference.
Correct!
Review the section “Mixed Cell References."
When entering a formula, if you type the first few letters of a cell name, AutoFill will show a list of suggested names.
Correct!
Review the section “Use a Cell Name in a Formula."
Cell names CANNOT contain spaces.
Correct!
Review the section “Define Names for Cells and Ranges."
The SUM function can add two numbers, two hundred numbers, or two thousand numbers just as quickly.
Correct!
Review the section “Sum, Average, Count, Max, and Min."
Which of these is an absolute cell reference?
Correct!
Review the section “Absolute Cell References."
Noella is calculating her employees’ pay (multiplying hours by the rate). What type of cell reference should Noella use for the hourly rates in column C?
Portion of an Excel worksheet with columns A–D and 12 rows showing. Column A lists employee names, column B lists the hours worked by each employee, and column C lists the hourly rate for each employee; these columns are fully populated with data. Column D is blank and where the pay amounts will be added.
Correct!
Review the section “Understanding Relative and Absolute Cell References."
What is the result of the formula in cell A4?
Cell A1 = 5, cell A2 = 5, cell A3 = 4, cell A4 = =SUM(A1,A3)
Correct!
Review the section “Using Functions in Formulas."
Which formula will appear in cell E6 if the formula in cell E5 is copied to cell E6?
Text in cell A1 is Commission Rate and refers to the 10% showing in cell C1. Three sales reps are showing in the range A5:A7, with monthly sales displayed in the range B5:D7 for the months of January, February, and March. Column E calculates the total commission using the monthly sales data. The formula in cell E5 is: =SUM(B5:D5)*$C$1.
Correct!
Review the section “Absolute Cell References."
Which statement best describes what will occur in cell E5 if the rate in cell C1 is changed to 15%?
Text in cell A1 is Commission Rate and refers to the 10% showing in cell C1. Three sales reps are showing in the range A5:A7, with monthly sales displayed in the range B5:D7 for the months of January, February, and March. Column E calculates the total commission using the monthly sales data. The formula in cell E5 is: =SUM(B5:D5)*$C$1.
Correct!
Review the section “Cell References."
After selecting a cell, how can you create a name for it?
Correct!
Review the section “Define Names for Cells and Ranges."