Computer Applications II-excel
10 Questions
| Attempts: 182
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.
=
Correct Answer
C. = -
- 2.
What is a function?
- A.
A prewritten formula
- B.
A math operator
Correct Answer
A. A prewritten formula -
- 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
Correct Answer
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)
Correct Answer
A. (B2:B6) -
- 5.
Which of these is an absolute reference?
- A.
B4: B12
- B.
$A$1
Correct Answer
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
Correct Answer
A. =C5*$D$9 -
- 7.
You can customize Excel 2007 by adding comands to the Quick Access Toolbar.
- A.
True
- B.
False
Correct Answer
A. True -
- 8.
To insert a new column, you start by clicking in teh Cells group on the Home Tab.
- A.
True
- B.
False
Correct Answer
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
Correct Answer
A. True -
- 10.
To add a new row, click a cell in the row immediately above where you want the new row.
- A.
True
- B.
False
Correct Answer
A. True -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jan 15, 2013Quiz Edited by
ProProfs Editorial Team -
May 18, 2010Quiz Created by
Pattersonj
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Programming Language Quizzes
- Software Quizzes
Back to top