Top Mark Questions and Correct Verified Answers
GL19 U5 (Excel) CH02 Concepts Exam
Questions and Correct Verified 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 what?
✓ 10
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?
Top Mark !!!
, Top Mark Questions and Correct Verified Answers
✓ 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. What formula, 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, what formula will return a result of 33?
✓ =(5+6)*3
Most Excel functions require that one or more arguments be surrounded by what?
✓ 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.
Top Mark !!!
GL19 U5 (Excel) CH02 Concepts Exam
Questions and Correct Verified 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 what?
✓ 10
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?
Top Mark !!!
, Top Mark Questions and Correct Verified Answers
✓ 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. What formula, 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, what formula will return a result of 33?
✓ =(5+6)*3
Most Excel functions require that one or more arguments be surrounded by what?
✓ 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.
Top Mark !!!
