GL19 U5 (Excel) CH02 Exam2024 with Approved Questions and Answers

Assume that you own a store and need to calculate the number of sales transactions that took place in one day. Which of the following functions should you use? - COUNT Because Excel follows the standard mathematical order of operations, it will calculate the formula =4+2*3 to which of the following? - 10Chapter 2 suggests that key data referenced by formulas throughout a worksheet should be placed _____ to make them more accessible. Chapter 2 suggests that key data referenced by formulas throughout a worksheet should be placed _____ to make them more accessible. - near the top of the sheet If you don't know the exact name of the function you need, you can enter a description of what you want to do using the - Insert Function dialog box. If you move a formula containing a relative reference and an absolute reference to a new location, what will happen? - The relative reference will automatically adjust, but the absolute reference will remain the same. Imagine that cells C1:C7 contain the hours an employee worked each day for one week. Cell B3 contains the employee's hourly wage. You want to insert a formula in cells D1:D7 that will calculate the employee's earnings for each day. Which of the following formulas, when entered in cell D1 and then copied down the rest of the column, will give you the correct results? - =C1*$B$3 In Excel, which of the following formulas will return a result of 33? - =(5+6)*3 Most Excel functions require that one or more arguments be surrounded by which of the following? - parentheses ( ) Press _____ to clear the scrolling marquee that surrounds a cell range you have selected and cut. - Esc Rather than type a cell reference into a formula, you can _____ to add it to the formula. - click the cell on the worksheet