Exploring Microsoft Office 2010 Volume 1
(Grauer/Poatsy/Hulett/Krebs/Mast/Mulbery/Hogan)
Excel Chapter 1
1) A spreadsheet
A) is the core of a slide presentation.
B) is an electronic file that is used to write text and graphics on the web.
C) is an electronic file that contains a grid of columns and rows for related data.
D) is another word for a letter written on a computer.
Answer: C
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel
2) A spreadsheet PROGRAM is defined as
A) a software application used to create and modify spreadsheets.
B) a software application used to create and modify text-based documents.
C) a software application used to create and modify video presentations.
D) a software application used to create and modify a database.
Answer: A
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel
,3) A worksheet is defined as
A) the background color of a cell.
B) the current cell location of the insertion point as indicated by a dark border.
C) a single spreadsheet that often contains formulas, functions, values, text, and visual
aids.
D) an unfinished project.
Answer: C
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel
,4) A workbook is defined as
A) similar to a spreadsheet but bound rather than electronic.
B) an un-editable "picture" of data.
C) the address of the current cell.
D) a file containing related worksheets.
Answer: D
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel
5) An Input Area (as it applies to Excel 2010) is defined as
A) a range of cells containing results based on the output area.
B) displays the name of a worksheet within a workbook.
C) a range of cells containing values for variables used in formulas.
D) displays the content of the active cell.
Answer: C
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel
6) An Output Area (as it applies to Excel 2010)is defined as
A) a range of cells containing results based upon manipulation of the variables in the
input area.
B) displays the name of a worksheet within a workbook.
, C) a range of cells containing values for variables used in formulas.
D) displays the content of the active cell.
Answer: A
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel
7) The Name Box (as it applies to Excel 2010)
A) is located at the intersection of a column and a row.
B) displays the name of a worksheet within a workbook.
C) identifies the address of the current cell.
D) displays the content of the active cell.
Answer: C
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 2
AppChap: Excel 1: Introduction to Excel
(Grauer/Poatsy/Hulett/Krebs/Mast/Mulbery/Hogan)
Excel Chapter 1
1) A spreadsheet
A) is the core of a slide presentation.
B) is an electronic file that is used to write text and graphics on the web.
C) is an electronic file that contains a grid of columns and rows for related data.
D) is another word for a letter written on a computer.
Answer: C
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel
2) A spreadsheet PROGRAM is defined as
A) a software application used to create and modify spreadsheets.
B) a software application used to create and modify text-based documents.
C) a software application used to create and modify video presentations.
D) a software application used to create and modify a database.
Answer: A
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel
,3) A worksheet is defined as
A) the background color of a cell.
B) the current cell location of the insertion point as indicated by a dark border.
C) a single spreadsheet that often contains formulas, functions, values, text, and visual
aids.
D) an unfinished project.
Answer: C
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel
,4) A workbook is defined as
A) similar to a spreadsheet but bound rather than electronic.
B) an un-editable "picture" of data.
C) the address of the current cell.
D) a file containing related worksheets.
Answer: D
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel
5) An Input Area (as it applies to Excel 2010) is defined as
A) a range of cells containing results based on the output area.
B) displays the name of a worksheet within a workbook.
C) a range of cells containing values for variables used in formulas.
D) displays the content of the active cell.
Answer: C
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel
6) An Output Area (as it applies to Excel 2010)is defined as
A) a range of cells containing results based upon manipulation of the variables in the
input area.
B) displays the name of a worksheet within a workbook.
, C) a range of cells containing values for variables used in formulas.
D) displays the content of the active cell.
Answer: A
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel
7) The Name Box (as it applies to Excel 2010)
A) is located at the intersection of a column and a row.
B) displays the name of a worksheet within a workbook.
C) identifies the address of the current cell.
D) displays the content of the active cell.
Answer: C
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 2
AppChap: Excel 1: Introduction to Excel
