D100 INTRO TO SPREADSHEETS
1. What advances in technology have become increasingly important for man-
agers in their decision-making?
Answer Mobile computing technology
2. The building blocks of excel
Answer 1. the workbook
2. the worksheet
3. 2 dimensional table
3. Which Excel features can be found in the File menu tab?
Answer Options for opening and saving workbook files
4. What is a collection of cells arranged in columns and rows?
Answer a worksheet
5. When it appears as the first character in a cell, which character signals to Excel
that the contents of the cell should be treated as a calculation?
1/7
, Answer the equals (=) character
6. The result of a function changes as the values in the other cells referenced by
that function change in what kind of function?
Answer dynamic
7. Which Excel feature(s) are used to reuse a formula from one cell to another?-
Answer copy and paste
8. A spreadsheet template .
Answer can be used repeatedly with changing inputs
9. What is the process of analyzing a calculation in a spreadsheet to ensure it is
correct?
Answer Formula Auditing
10. What kind of calculation contains an error caused by poor input?
Answer A calculation that includes inaccurate or incomplete data
11. What kind of calculation contains an error caused by poor logic?
2/7
1. What advances in technology have become increasingly important for man-
agers in their decision-making?
Answer Mobile computing technology
2. The building blocks of excel
Answer 1. the workbook
2. the worksheet
3. 2 dimensional table
3. Which Excel features can be found in the File menu tab?
Answer Options for opening and saving workbook files
4. What is a collection of cells arranged in columns and rows?
Answer a worksheet
5. When it appears as the first character in a cell, which character signals to Excel
that the contents of the cell should be treated as a calculation?
1/7
, Answer the equals (=) character
6. The result of a function changes as the values in the other cells referenced by
that function change in what kind of function?
Answer dynamic
7. Which Excel feature(s) are used to reuse a formula from one cell to another?-
Answer copy and paste
8. A spreadsheet template .
Answer can be used repeatedly with changing inputs
9. What is the process of analyzing a calculation in a spreadsheet to ensure it is
correct?
Answer Formula Auditing
10. What kind of calculation contains an error caused by poor input?
Answer A calculation that includes inaccurate or incomplete data
11. What kind of calculation contains an error caused by poor logic?
2/7
