Question 1

Columns are lettered in descending sequence from left to right.

Accepted Answer

A) True 
 B)False

Question 2

Changing the cell alignment so words fit on to multiple lines is also known as wrapping text.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following statements is FALSE?

Accepted Answer

A)  Worksheets contain rows and columns. 
B)  Worksheets contain workbooks. 
C)  The number of worksheets that be contained in a workbook is a function of the amount of available memory. 
D)  Another term for worksheets is spreadsheets. 
A)  Worksheets contain rows and columns. 
B)  Worksheets contain workbooks. 
C)  The number of worksheets that be contained in a workbook is a function of the amount of available memory. 
D)  Another term for worksheets is spreadsheets.

Question 4

A worksheet is made up of rows and columns.

Accepted Answer

A) True 
 B)False

Question 5

A new Excel workbook contains three worksheets,by default named Book1,Book2,and Book3.

Accepted Answer

A) True 
 B)False

Question 6

The white space left at the edges of the printed page are known as page ________.

Accepted Answer

The answer of The white space left at the edges...

Question 7

Which of the following is not a valid cell reference?

Accepted Answer

A)  A3 
B)  J21 
C)  AA3 
D)  4C 
A)  A3 
B)  J21 
C)  AA3 
D)  4C

Question 8

Rows are numbered in ascending sequence from top to bottom.

Accepted Answer

A) True 
 B)False

Question 9

A column can also be referred to as a record.

Accepted Answer

A) True 
 B)False

Question 10

A that is page wider than it is tall is in ________ orientation.

Accepted Answer

The answer of A that is page wider than it...

Question 11

A(n)________ is a powerful computer program with a user interface that is a grid of rows and columns.

Accepted Answer

The answer of A(n)________ is a powerful computer program with...

Question 12

A cell can be made an active cell by clicking on it.

Accepted Answer

A) True 
 B)False

Question 13

In order to see a facsimile of how a document will look on paper,use the ________ option found under the File tab.

Accepted Answer

The answer of In order to see a facsimile of...

Question 14

The intersection of column F and row 5 has the cell reference ________.

Accepted Answer

The answer of The intersection of column F and row...

Question 15

Which of the following statements is FALSE?

Accepted Answer

A)  Scaling can fit all columns on a single page. 
B)  Scaling may make data too small to be readable. 
C)  A worksheet in landscape orientation may be 11 inches wide by 8.5 inches tall. 
D)  Portrait orientation means a page is wider than it is tall. 
A)  Scaling can fit all columns on a single page. 
B)  Scaling may make data too small to be readable. 
C)  A worksheet in landscape orientation may be 11 inches wide by 8.5 inches tall. 
D)  Portrait orientation means a page is wider than it is tall.

Question 16

Text that is too lengthy to fit in one cell can have text wrapping applied,or the user can add a ________ to break up the data inside a cell.

Accepted Answer

A)  date/time 
B)  range 
C)  section break 
D)  hard return 
A)  date/time 
B)  range 
C)  section break 
D)  hard return

Question 17

In order to see what a worksheet will look like when printed,use the Print ________ feature.

Accepted Answer

A)  Preview 
B)  Range 
C)  White Space 
D)  Setup 
A)  Preview 
B)  Range 
C)  White Space 
D)  Setup

Question 18

Cells can contain text,numbers,formulas,and/or functions.

Accepted Answer

A) True 
 B)False

Question 19

Spreadsheets are used to perform ________,where you can change values in spreadsheet cells to investigate the effect on calculated values of interest.

Accepted Answer

The answer of Spreadsheets are used to perform ________,where you...

Question 20

A spreadsheet is a computer program.

Accepted Answer

A) True 
 B)False

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

Columns are lettered in descending sequence from left to right.

Changing the cell alignment so words fit on to multiple lines is also known as wrapping text.

Which of the following statements is FALSE?

A worksheet is made up of rows and columns.

A new Excel workbook contains three worksheets,by default named Book1,Book2,and Book3.

The white space left at the edges of the printed page are known as page ________.

Which of the following is not a valid cell reference?

Rows are numbered in ascending sequence from top to bottom.

A column can also be referred to as a record.

A that is page wider than it is tall is in ________ orientation.

A(n)________ is a powerful computer program with a user interface that is a grid of rows and columns.

A cell can be made an active cell by clicking on it.

In order to see a facsimile of how a document will look on paper,use the ________ option found under the File tab.

The intersection of column F and row 5 has the cell reference ________.

Which of the following statements is FALSE?

Text that is too lengthy to fit in one cell can have text wrapping applied,or the user can add a ________ to break up the data inside a cell.

In order to see what a worksheet will look like when printed,use the Print ________ feature.

Cells can contain text,numbers,formulas,and/or functions.

Spreadsheets are used to perform ________,where you can change values in spreadsheet cells to investigate the effect on calculated values of interest.

A spreadsheet is a computer program.

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