Question 1

Worksheets can be renamed,deleted,and moved.

Accepted Answer

A) True 
 B)False

Question 2

Of the following,which makes up the smallest element in a workbook?

Accepted Answer

A)  cell 
B)  row 
C)  worksheet 
D)  column 
A)  cell 
B)  row 
C)  worksheet 
D)  column

Question 3

________ are lettered in ascending sequence from left to right.

Accepted Answer

The answer of ________ are lettered in ascending sequence from...

Question 4

A3 and E9 are examples of cell ________.

Accepted Answer

The answer of A3 and E9 are examples of cell...

Question 5

A(n)________ is another word for a spreadsheet.

Accepted Answer

The answer of A(n)________ is another word for a spreadsheet....

Question 6

Excel 2010 workbooks are saved with a default file extension of ________.

Accepted Answer

A)  .wbk 
B)  .exc 
C)  .accdb 
D)  .xlsx 
A)  .wbk 
B)  .exc 
C)  .accdb 
D)  .xlsx

Question 7

The selected cell (with a thick,black line border)is also known as the ________ cell.

Accepted Answer

The answer of The selected cell (with a thick,black line...

Question 8

Moving the location of the current cell is known as worksheet ________.

Accepted Answer

The answer of Moving the location of the current cell...

Question 9

A cell in the third row and fourth column has the cell reference ________.

Accepted Answer

A)  C4 
B)  3D 
C)  4C 
D)  D3 
A)  C4 
B)  3D 
C)  4C 
D)  D3

Question 10

A cell in the second row and fifth column would be referred to by the cell reference ________.

Accepted Answer

The answer of A cell in the second row and...

Question 11

There are more rows in an Excel spreadsheet than there are cells.

Accepted Answer

A) True 
 B)False

Question 12

J42 is an example of a cell reference.

Accepted Answer

A) True 
 B)False

Question 13

Excel includes common functions such as SUM and AVERAGE.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following statements is FALSE?

Accepted Answer

A)  Excel 2010 workbooks have xls as their file extension. 
B)  A spreadsheet is a powerful computer program. 
C)  Spreadsheets are a grid of rows and columns. 
D)  Spreadsheets are commonly used to perform what-if analysis. 
A)  Excel 2010 workbooks have xls as their file extension. 
B)  A spreadsheet is a powerful computer program. 
C)  Spreadsheets are a grid of rows and columns. 
D)  Spreadsheets are commonly used to perform what-if analysis.

Question 15

What-if analysis allows users to ________.

Accepted Answer

A)  create graphs and charts of existing data. 
B)  insert built-in programs that perform tasks like SUM and AVERAGE. 
C)  change values in spreadsheet cells to investigate the effects on calculated values of interest. 
D)  create an equation that produces a result. 
A)  create graphs and charts of existing data. 
B)  insert built-in programs that perform tasks like SUM and AVERAGE. 
C)  change values in spreadsheet cells to investigate the effects on calculated values of interest. 
D)  create an equation that produces a result.

Worksheets can be renamed,deleted,and moved.

Of the following,which makes up the smallest element in a workbook?

________ are lettered in ascending sequence from left to right.

A3 and E9 are examples of cell ________.

A(n)________ is another word for a spreadsheet.

Excel 2010 workbooks are saved with a default file extension of ________.

The selected cell (with a thick,black line border)is also known as the ________ cell.

Moving the location of the current cell is known as worksheet ________.

A cell in the third row and fourth column has the cell reference ________.

A cell in the second row and fifth column would be referred to by the cell reference ________.

There are more rows in an Excel spreadsheet than there are cells.

J42 is an example of a cell reference.

Excel includes common functions such as SUM and AVERAGE.

Which of the following statements is FALSE?

What-if analysis allows users to ________.

Integrated Projects, workshop 1: Integrating Word and Excel

Integrated Projects, workshop 2: Integrating Word, excel, and Access

Integrated Projects, workshop 3: Integrating Word, excel, access, and Powerpoint

Integrated Projects, workshop 4: Integrating Word, powerpoint, access, excel, and Outlook

Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects

Microsoft Access 2010,workshop 2: Gathering Data Into a Database

Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

Microsoft Access 2010,workshop 4: Maintaining and Presenting Data

Microsoft Excel 2010, workshop 2: Formatting, formulas, and Functions

Microsoft Excel 2010,workshop 3: Conducting Excel Analysis Through Functions and Charts

Microsoft Excel 2010,workshop 4: Using Charts

Microsoft Office Outlook 2010, workshop 1: Communicating With E-Mail, and Managing Contacts, calendars, and Tasks

Microsoft Powerpoint 2010 workshop 1: Communicating With Presentations

Microsoft Powerpoint 2010,workshop 2: Applying and Modifying Text and Graphics

Microsoft Powerpoint 2010,workshop 3: Applying and Modifying Multimedia

Microsoft Powerpoint 2010, workshop 4: Customizing, Collaborating, and Presenting

Microsoft Word 2010,workshop 1: Reviewing and Modifying a Document

Microsoft Word 2010,workshop 2: Creating and Editing a Document

Microsoft Word 2010,workshop 3: Including Tables and Objects

Microsoft Word 2010,workshop 4: Formatting Special Documents and Using Mail Merge

Appendix: Microsoft Windows 8: Understanding the Windows 8 Interface

Common Features,workshop 1: Understanding the Common Features of Microsoft Office

Windows 7, workshop 1: Understanding the Windows 7 Desktop and Managing Windows

Filters

Exam 9: Microsoft Excel 2010,workshop 1: Understanding and Manipulating Microsoft Excel 2010

Worksheets can be renamed,deleted,and moved.

Of the following,which makes up the smallest element in a workbook?

________ are lettered in ascending sequence from left to right.

A3 and E9 are examples of cell ________.

A(n)________ is another word for a spreadsheet.

Excel 2010 workbooks are saved with a default file extension of ________.

The selected cell (with a thick,black line border)is also known as the ________ cell.

Moving the location of the current cell is known as worksheet ________.

A cell in the third row and fourth column has the cell reference ________.

A cell in the second row and fifth column would be referred to by the cell reference ________.

There are more rows in an Excel spreadsheet than there are cells.

J42 is an example of a cell reference.

Excel includes common functions such as SUM and AVERAGE.

Which of the following statements is FALSE?

What-if analysis allows users to ________.

Integrated Projects, workshop 1: Integrating Word and Excel

Integrated Projects, workshop 2: Integrating Word, excel, and Access

Integrated Projects, workshop 3: Integrating Word, excel, access, and Powerpoint

Integrated Projects, workshop 4: Integrating Word, powerpoint, access, excel, and Outlook

Microsoft Access 2010,workshop 1: Understanding the Four Main Database Objects

Microsoft Access 2010,workshop 2: Gathering Data Into a Database

Microsoft Access 2010,workshop 3: Accessing Information From an Access Database

Microsoft Access 2010,workshop 4: Maintaining and Presenting Data

Microsoft Excel 2010, workshop 2: Formatting, formulas, and Functions

Microsoft Excel 2010,workshop 3: Conducting Excel Analysis Through Functions and Charts

Microsoft Excel 2010,workshop 4: Using Charts

Microsoft Office Outlook 2010, workshop 1: Communicating With E-Mail, and Managing Contacts, calendars, and Tasks

Microsoft Powerpoint 2010 workshop 1: Communicating With Presentations

Microsoft Powerpoint 2010,workshop 2: Applying and Modifying Text and Graphics

Microsoft Powerpoint 2010,workshop 3: Applying and Modifying Multimedia

Microsoft Powerpoint 2010, workshop 4: Customizing, Collaborating, and Presenting

Microsoft Word 2010,workshop 1: Reviewing and Modifying a Document

Microsoft Word 2010,workshop 2: Creating and Editing a Document

Microsoft Word 2010,workshop 3: Including Tables and Objects

Microsoft Word 2010,workshop 4: Formatting Special Documents and Using Mail Merge

Appendix: Microsoft Windows 8: Understanding the Windows 8 Interface

Common Features,workshop 1: Understanding the Common Features of Microsoft Office

Windows 7, workshop 1: Understanding the Windows 7 Desktop and Managing Windows

Filters