click below
click below
Normal Size Small Size show me how
MOAC Excel Lesson
Question | Answer |
---|---|
How is a cell reference in a formula and its corresponding location in a worksheet identified? | Cell reference and cell location are outlined in matching colors |
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create? | =$B$1+25 |
Jennifer is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry? | formulas |
What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area? | Absolute |
Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use? | =B4*C4 |
Tyler created a monthly sales workbook that contains the formula =SUM(Sales). "Sales" is an example of a(n): | named range. |
What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously? | Copy using the Fill Handle |
Tyler created a monthly sales workbook that contains the formula =(January!B3). "January" is an example of a(n): | external reference |
Joshua created a budget workbook that contains the formula =(Summary!B3). "Summary" is an example of a(n): | external reference. |
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location? | Relative reference |
What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address? | Worksheet Reference |
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use? | =B4-C4 |
Which command on the Home Tab displays the total of the selected cells directly after the selected cells? | AutoSum |
Gabriel needs to create a shortcut formula in cell B40 to calculate total sales located in cells B1 through B39. Which function should he create? | =SUM(B1:B39) |
Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date in cell A1? | TODAY |
What is a prewritten formula that is built into Microsoft Excel called? | Function |
Which function do you use to insert today’s date in a worksheet so that it automatically updates each time the worksheet is opened? | Today |
Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next test? | AVERAGE |
Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date and time in cell A1? | NOW |
What function adds all of the numbers in a range of cells? | Sum |
Where can you find the Insert Function button in Microsoft Excel? | Formula bar |
Which group on the Formulas Ribbon enables a user to specify when a formula is computed? | Calculation |
Angie is calculating her average sales for the past four months. If she uses "=AVERAGE(B1:B4)", this is an example of which type of entry? | functions |
Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula? | Formula Auditing |
Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula? | Defined Names |
Which of the following are valid Microsoft Excel functions? | AVERAGE, MAX, and MIN |
Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade? | MAX |