Question 1

Keyboard navigation can be done using ________ such as pressing the Tab key to move one column right.

Accepted Answer

A)  keyboard shortcuts 
B)  magic keys 
C)  active keys 
D)  keyboard references 
A)  keyboard shortcuts 
B)  magic keys 
C)  active keys 
D)  keyboard references

Question 2

A worksheet that is not currently visible can be changed to the ________ worksheet by clicking on the worksheet tab in the bottom-left corner of the Excel window.

Accepted Answer

A)  default 
B)  referenced 
C)  dormant 
D)  active 
A)  default 
B)  referenced 
C)  dormant 
D)  active

Question 3

Which of the following is FALSE?

Accepted Answer

A)  White space is always white. 
B)  White space gives a document visual structure. 
C)  White space is a term for the part of the document that does not contain data or documentation. 
D)  White space creates a sense of order in the mind of the worksheet user. 
A)  White space is always white. 
B)  White space gives a document visual structure. 
C)  White space is a term for the part of the document that does not contain data or documentation. 
D)  White space creates a sense of order in the mind of the worksheet user.

Question 4

Pressing Alt+Tab allows a user to quickly move between open workbooks.

Accepted Answer

A) True 
 B)False

Question 5

R4:T8 is an example of a ________.

Accepted Answer

A)  row 
B)  column 
C)  cell reference 
D)  cell range 
A)  row 
B)  column 
C)  cell reference 
D)  cell range

Question 6

Match between columns
                        Premises: column
formula
cell
range
row

Accepted Answer

The Answer of K and =T3+T5 and 12 and P4:R6 is...

Question 7

A ________ is found at an intersection in Excel,and might have a name such as C8 or G11.

Accepted Answer

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

Question 8

Which of the following is least likely to be found in a single cell?

Accepted Answer

A)  operators 
B)  text 
C)  charts 
D)  functions 
A)  operators 
B)  text 
C)  charts 
D)  functions

Question 9

An equation that produces a result is known as a(n)________.

Accepted Answer

A)  function 
B)  record 
C)  formula 
D)  cell reference 
A)  function 
B)  record 
C)  formula 
D)  cell reference

Question 10

A worksheet contains all of the following EXCEPT ________.

Accepted Answer

A)  columns 
B)  rows 
C)  worksheets 
D)  cells 
A)  columns 
B)  rows 
C)  worksheets 
D)  cells

Question 11

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

Accepted Answer

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

Question 12

A ________ is labeled with letters,such as A,B,or C.

Accepted Answer

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

Question 13

Changing values in spreadsheet cells to investigate the effects is known as what-if analysis.

Accepted Answer

A) True 
 B)False

Question 14

A workbook must contain at least three worksheets.

Accepted Answer

A) True 
 B)False

Question 15

By clicking on a worksheet tab,a user makes it the ________ worksheet.

Accepted Answer

The answer of By clicking on a worksheet tab,a user...

Question 16

Unused worksheets are a form of clutter in a workbook and generally should be deleted.

Accepted Answer

A) True 
 B)False

Question 17

The intersection of a row and column is called a cell.

Accepted Answer

A) True 
 B)False

Question 18

C6 is an example of a cell range.

Accepted Answer

A) True 
 B)False

Question 19

All formulas and functions must start with the equal sign (=).

Accepted Answer

A) True 
 B)False

Question 20

A set of cells is also known as a cell ________.

Accepted Answer

The answer of A set of cells is also known...

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

Keyboard navigation can be done using ________ such as pressing the Tab key to move one column right.

A worksheet that is not currently visible can be changed to the ________ worksheet by clicking on the worksheet tab in the bottom-left corner of the Excel window.

Which of the following is FALSE?

Pressing Alt+Tab allows a user to quickly move between open workbooks.

R4:T8 is an example of a ________.

A ________ is found at an intersection in Excel,and might have a name such as C8 or G11.

Which of the following is least likely to be found in a single cell?

An equation that produces a result is known as a(n)________.

A worksheet contains all of the following EXCEPT ________.

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

A ________ is labeled with letters,such as A,B,or C.

Changing values in spreadsheet cells to investigate the effects is known as what-if analysis.

A workbook must contain at least three worksheets.

By clicking on a worksheet tab,a user makes it the ________ worksheet.

Unused worksheets are a form of clutter in a workbook and generally should be deleted.

The intersection of a row and column is called a cell.

C6 is an example of a cell range.

All formulas and functions must start with the equal sign (=).

A set of cells is also known as a cell ________.

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