Question 1

A(n)________ is an equation that produces a result and may contain numbers,text,and other such data.

Accepted Answer

formula

Question 2

Worksheet navigation refers to scrolling up and down (or left and right)in a worksheet using the scroll bar.

Accepted Answer

A) True 
 B)False  False

Question 3

All functions must begin with the ________ character.

Accepted Answer

A)  $ 
B)  = 
C)  > 
D)  $?$ 
A)  $ 
B)  = 
C)  > 
D)  $?$ B

Question 4

Which of the following statements about workbooks is TRUE?

Accepted Answer

A)  Workbooks must contain three worksheets. 
B)  New, blank workbooks contain three worksheets, by default. 
C)  There is a maximum of five worksheets in a workbook. 
D)  Workbooks have a file extension of .xls. 
A)  Workbooks must contain three worksheets. 
B)  New, blank workbooks contain three worksheets, by default. 
C)  There is a maximum of five worksheets in a workbook. 
D)  Workbooks have a file extension of .xls.

Question 5

If data is too wide to fit on a printed page,scaling may solve the problem.

Accepted Answer

A) True 
 B)False

Question 6

The intersection of a row and column is known as a record.

Accepted Answer

A) True 
 B)False

Question 7

Printouts are generally sent to square sheets of paper.

Accepted Answer

A) True 
 B)False

Question 8

The part of a document that does not contain data is known as ________.

Accepted Answer

The answer of The part of a document that does...

Question 9

If the background of a worksheet is yellow,the area without data or documentation is referred to as yellow space rather than white space.

Accepted Answer

A) True 
 B)False

Question 10

Another word for a spreadsheet is ________.

Accepted Answer

A)  workbook 
B)  field 
C)  worksheet 
D)  record 
A)  workbook 
B)  field 
C)  worksheet 
D)  record

Question 11

A worksheet is a spreadsheet contained in a workbook.

Accepted Answer

A) True 
 B)False

Question 12

Portrait orientation means the page is taller than it is wide.

Accepted Answer

A) True 
 B)False

Question 13

Worksheet footers appear at the top of the page.

Accepted Answer

A) True 
 B)False

Question 14

Each worksheet contains a number of ________,each of which can contain text,numbers,formulas,and/or functions.

Accepted Answer

The answer of Each worksheet contains a number of ________,each...

Question 15

If a user inserts a few blank rows around some data to create a sense of order,they have inserted ________.

Accepted Answer

The answer of If a user inserts a few blank...

Question 16

SUM and AVERAGE are examples of ________.

Accepted Answer

A)  formulas 
B)  functions 
C)  cell references 
D)  records 
A)  formulas 
B)  functions 
C)  cell references 
D)  records

Question 17

A set of selected cells that are not next to each other are also known as ________.

Accepted Answer

The answer of A set of selected cells that are...

Question 18

Sheet1 is an example of a default ________ within a workbook.

Accepted Answer

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

Question 19

A worksheet that is 11 inches tall and 8.5 inches wide is in ________ orientation.

Accepted Answer

The answer of A worksheet that is 11 inches tall...

Question 20

Worksheet navigation is defined as moving the location of the active ________.

Accepted Answer

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

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

A(n)________ is an equation that produces a result and may contain numbers,text,and other such data.

Worksheet navigation refers to scrolling up and down (or left and right)in a worksheet using the scroll bar.

All functions must begin with the ________ character.

Which of the following statements about workbooks is TRUE?

If data is too wide to fit on a printed page,scaling may solve the problem.

The intersection of a row and column is known as a record.

Printouts are generally sent to square sheets of paper.

The part of a document that does not contain data is known as ________.

If the background of a worksheet is yellow,the area without data or documentation is referred to as yellow space rather than white space.

Another word for a spreadsheet is ________.

A worksheet is a spreadsheet contained in a workbook.

Portrait orientation means the page is taller than it is wide.

Worksheet footers appear at the top of the page.

Each worksheet contains a number of ________,each of which can contain text,numbers,formulas,and/or functions.

If a user inserts a few blank rows around some data to create a sense of order,they have inserted ________.

SUM and AVERAGE are examples of ________.

A set of selected cells that are not next to each other are also known as ________.

Sheet1 is an example of a default ________ within a workbook.

A worksheet that is 11 inches tall and 8.5 inches wide is in ________ orientation.

Worksheet navigation is defined as moving the location of the active ________.

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