Computer Applications II-excel
10 Questions
| Total Attempts: 162
Settings
This is to help you review for the Excel Portion of the Computer Applications II website.
Questions and Answers
- 1.What do you type into an exmpty cell to start a formula?
- A.
*
- B.
(
- C.
=
- 2.What is a function?
- A.
A prewritten formula
- B.
A math operator
- 3.A formula result is in cell C6. You wonder how you got the result. To see the formula, you:
- A.
Click in cell C6, and then press CTRL+SHIFT
- B.
Click in cell C6, and then press F5
- C.
Click in cell C6
- 4.Which cell reference refers to a range of cells in column B, rows 3 through 6?
- A.
(B2:B6)
- B.
(B3,B6)
- 5.Which of these is an absolute reference?
- A.
B4: B12
- B.
$A$1
- 6.If you copy the formula =c4*$D$9 from cell C4 to cell C5, what wil lthe formula be in cell C5?
- A.
=C5*$D$9
- B.
=C4*$D$9
- C.
=C5*$E$10
- 7.You can customize Excel 2007 by adding comands to the Quick Access Toolbar.
- A.
True
- B.
False
- 8.To insert a new column, you start by clicking in teh Cells group on the Home Tab.
- A.
True
- B.
False
- 9.Too add a column, click a cell in the column to the right of where you want the new column.
- A.
True
- B.
False
- 10.To add a new row, click a cell in the row immediately above where you want the new row.
- A.
True
- B.
False
Back to top