Question 1

A4:B5 is an example of a cell ________.

Accepted Answer

The answer of A4:B5 is an example of a cell...

Question 2

A group of selected cells is also known as a cell ________.

Accepted Answer

A)  cluster 
B)  range 
C)  block 
D)  field 
A)  cluster 
B)  range 
C)  block 
D)  field

Question 3

Scrolling in a worksheet moves the active cell.

Accepted Answer

A) True 
 B)False

Question 4

Match between columns
                        Premises: field
formula
record
range
cell

Accepted Answer

The Answer of an equation that produces a result and is...

Question 5

A ________ is labeled with a number,such as 1,2,or 3.

Accepted Answer

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

Question 6

A spreadsheet can be used as a basic collection of data where each column is a(n)________.

Accepted Answer

The answer of A spreadsheet can be used as a...

Question 7

A(n)________ is an intersection of a row and column.

Accepted Answer

The answer of A(n)________ is an intersection of a row...

Question 8

The intersection of row 1 and column Q is known as 1Q,

Accepted Answer

A) True 
 B)False

Question 9

Which of the following represents a cell range?

Accepted Answer

A)  C6-E10 
B)  $B$6 
C)  A4 + D14 
D)  N8:P9 
A)  C6-E10 
B)  $B$6 
C)  A4 + D14 
D)  N8:P9

Question 10

Rows are represented by letters.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following is an example of portrait dimensions?

Accepted Answer

A)  8.5 inches wide by 11 inches tall 
B)  11 inches wide by 8.5 inches tall 
C)  5 inches wide by 5 inches tall 
D)  All are examples of portrait dimensions. 
A)  8.5 inches wide by 11 inches tall 
B)  11 inches wide by 8.5 inches tall 
C)  5 inches wide by 5 inches tall 
D)  All are examples of portrait dimensions.

Question 12

Microsoft's spreadsheet application is known as ________.

Accepted Answer

A)  Publisher 
B)  Excel 
C)  Access 
D)  Outlook 
A)  Publisher 
B)  Excel 
C)  Access 
D)  Outlook

Question 13

A cell can also be referred to as a field.

Accepted Answer

A) True 
 B)False

Question 14

AutoFill allows users to ________ using the fill handle.

Accepted Answer

A)  delete formulas from within cells 
B)  move content from one cell to another 
C)  copy information to the office clipboard to paste in to another worksheet 
D)  copy information from one cell, or a series of cells, in to another set of cells 
A)  delete formulas from within cells 
B)  move content from one cell to another 
C)  copy information to the office clipboard to paste in to another worksheet 
D)  copy information from one cell, or a series of cells, in to another set of cells

Question 15

A formula is a built-in program that performs common tasks.

Accepted Answer

A) True 
 B)False

Question 16

Page breaks can NOT be inserted into an Excel worksheet.

Accepted Answer

A) True 
 B)False

Question 17

Shrinking data to fit on one page is known as ________.

Accepted Answer

The answer of Shrinking data to fit on one page...

Question 18

A user wishes to change values in a cell and see what the effects are on calculated values elsewhere in the worksheet.The user has executed a(n)________.

Accepted Answer

A)  AutoFill 
B)  what-if analysis 
C)  formula 
D)  function 
A)  AutoFill 
B)  what-if analysis 
C)  formula 
D)  function

Question 19

Worksheets can be hidden from view.

Accepted Answer

A) True 
 B)False

Question 20

Printable characters,including letters,numbers,and special characters,are stored as ________ data.

Accepted Answer

A)  text 
B)  date/time 
C)  numeric 
D)  none of the above 
A)  text 
B)  date/time 
C)  numeric 
D)  none of the above

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

A4:B5 is an example of a cell ________.

A group of selected cells is also known as a cell ________.

Scrolling in a worksheet moves the active cell.

A ________ is labeled with a number,such as 1,2,or 3.

A spreadsheet can be used as a basic collection of data where each column is a(n)________.

A(n)________ is an intersection of a row and column.

The intersection of row 1 and column Q is known as 1Q,

Which of the following represents a cell range?

Rows are represented by letters.

Which of the following is an example of portrait dimensions?

Microsoft's spreadsheet application is known as ________.

A cell can also be referred to as a field.

AutoFill allows users to ________ using the fill handle.

A formula is a built-in program that performs common tasks.

Page breaks can NOT be inserted into an Excel worksheet.

Shrinking data to fit on one page is known as ________.

A user wishes to change values in a cell and see what the effects are on calculated values elsewhere in the worksheet.The user has executed a(n)________.

Worksheets can be hidden from view.

Printable characters,including letters,numbers,and special characters,are stored as ________ data.

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