ITSCM 280 EXAM 1 UPDATED ACTUAL QUESTIONS AND
CORRECT ANSWERS
Question:
1. Bandwidth
Answer:
The capacity of a communications channel
Question:
2. Imagine that your worksheet appears with a reduced view of each page and dotted blue dividers where
the new pages begin, what view are you in?
Answer:
Page Break View
Question:
3. Bohdan wants to cut the range A1:A5 and paste it into the range C1:C5. Which of the following
statements are true?
Answer:
Before he pastes it, he needs to select only cell 1. After he pastes it, the information is deleted from the
original location. After he pastes it, the information is deleted from the clipboard. Before he pastes it, he
must select the range C1:C5.
Question:
4. Zaida stored the formula =SUM(E12:G12) into cell A12. She then copied and pasted the formula to the
cell 3 rows directly below A12. Which of the following depicts the change to the cell references in the cell
that contains the pasted contents?
Answer:
SUM(E15:G15)
Question:
5. TLS is used to protect consumers and businesses from which of the following threats when conducting
e-commerce?
Answer:
Identity theft and Fraud
Question:
6. After you have selected one or more cells, which of the following keys do you press while dragging and
dropping to place a copy of the cells in a new location?
Answer:
CTRL
Question:
7. Software processes information into meaningful data, True or False?
Answer:
False, software processes data into meaningful information.
CORRECT ANSWERS
Question:
1. Bandwidth
Answer:
The capacity of a communications channel
Question:
2. Imagine that your worksheet appears with a reduced view of each page and dotted blue dividers where
the new pages begin, what view are you in?
Answer:
Page Break View
Question:
3. Bohdan wants to cut the range A1:A5 and paste it into the range C1:C5. Which of the following
statements are true?
Answer:
Before he pastes it, he needs to select only cell 1. After he pastes it, the information is deleted from the
original location. After he pastes it, the information is deleted from the clipboard. Before he pastes it, he
must select the range C1:C5.
Question:
4. Zaida stored the formula =SUM(E12:G12) into cell A12. She then copied and pasted the formula to the
cell 3 rows directly below A12. Which of the following depicts the change to the cell references in the cell
that contains the pasted contents?
Answer:
SUM(E15:G15)
Question:
5. TLS is used to protect consumers and businesses from which of the following threats when conducting
e-commerce?
Answer:
Identity theft and Fraud
Question:
6. After you have selected one or more cells, which of the following keys do you press while dragging and
dropping to place a copy of the cells in a new location?
Answer:
CTRL
Question:
7. Software processes information into meaningful data, True or False?
Answer:
False, software processes data into meaningful information.