Question 1

A saved workbook is referred to as a(n)__________.

Accepted Answer

The answer of A saved workbook is referred to as...

Question 2

Match between columns
                        Premises: Makes it easier to see and identify each cell in the worksheet.

Accepted Answer

The Answer of Ribbon and Mini toolbar and gallery and is...

Question 3

A new workbook opens with three worksheets, but additional worksheets can be added as long as your computer has enough memory to accommodate them.

Accepted Answer

A) True 
 B)False

Question 4

In Excel, a number can contain the characters __________.

Accepted Answer

A) 0 1 2 3 4 5 6 7 8 9 
B) + - ( ), / 
C) . $ % E e 
D) all of the above 
A) 0 1 2 3 4 5 6 7 8 9 
B) + - ( ), / 
C) . $ % E e 
D) all of the above

Question 5

Discuss document properties. Include definitions of these terms: metadata, keywords, standard properties, and automatically updated properties. Be sure to give at least two reasons why document properties are valuable.

Accepted Answer

Excel helps you organize and identify yo

Question 6

Figure 1-2 In the accompanying figure, the __________ located near the top of the Excel window is the control center in Excel.

Accepted Answer

A) Ribbon 
B) Menu bar 
C) Home tab 
D) live preview 
A) Ribbon 
B) Menu bar 
C) Home tab 
D) live preview

Question 7

What effect does the Accounting Number Format have on the selected cells?

Accepted Answer

A) Converts alphabetic characters to numbers 
B) Causes cells with two decimal places to align vertically correctly 
C) Performs tax calculations 
D) Copies the numbers of one cell to another 
A) Converts alphabetic characters to numbers 
B) Causes cells with two decimal places to align vertically correctly 
C) Performs tax calculations 
D) Copies the numbers of one cell to another

Question 8

Figure 1-1 A workbook contains __________, each of which has a name that displays on a sheet tab at the bottom of the workbook, as shown in the accompanying figure.

Accepted Answer

The answer of   Figure 1-1 A workbook contains...

Question 9

The following entries are considered text: 401AX21, 921-231, 619 321, 883XTY

Accepted Answer

A) True 
 B)False

Question 10

How many chart types does Excel offer?

Accepted Answer

A) 5 
B) 11 
C) 29 
D) 50 
A) 5 
B) 11 
C) 29 
D) 50

Question 11

Figure 1-2 In the accompanying figure, the __________ button and __________ button next to the Help icon are used to minimize and restore the worksheet within the Excel window.

Accepted Answer

A) Collapse, Expand 
B) Minimize, Restore 
C) Help, Answer 
D) Question, Answer 
A) Collapse, Expand 
B) Minimize, Restore 
C) Help, Answer 
D) Question, Answer

Question 12

__________ properties are associated with all Microsoft Office documents and include author, title, and subject.

Accepted Answer

A) Author 
B) Subject and author 
C) Title 
D) Standard 
A) Author 
B) Subject and author 
C) Title 
D) Standard

Question 13

__________ is a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from Web sites.

Accepted Answer

Microsoft

Question 14

Figure 1-2 Excel opens a new workbook with three __________ , as shown in the accompanying figure.

Accepted Answer

A) shakes 
B) names 
C) worksheets 
D) charts 
A) shakes 
B) names 
C) worksheets 
D) charts

Question 15

When the fill handle is used to copy a cell to adjacent cells, the range of cells receiving the copy is called the destination area or paste area.

Accepted Answer

A) True 
 B)False

Question 16

Excel derives the chart scale based on the values in the worksheet along the vertical axis, also called the y-axis or value axis of the chart.

Accepted Answer

A) True 
 B)False

Question 17

To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type __________.

Accepted Answer

A) 6,000T 
B) 6K000 
C) 6Q 
D) 6E15 
A) 6,000T 
B) 6K000 
C) 6Q 
D) 6E15

Question 18

The person or persons requesting the worksheet should supply their requirements in a __________ document.

Accepted Answer

A) blank 
B) test issues 
C) requirements 
D) certified 
A) blank 
B) test issues 
C) requirements 
D) certified

Question 19

Match between columns
                        Premises: A set of choices, often graphical, arranged in a grid or in a list.

Accepted Answer

The Answer of menu and Key Tip badge and Mini is...

Question 20

The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the __________.

Accepted Answer

A) receiver cell 
B) final cell 
C) receiving range 
D) destination area (or paste area) 
A) receiver cell 
B) final cell 
C) receiving range 
D) destination area (or paste area)

A saved workbook is referred to as a(n)__________.

A new workbook opens with three worksheets, but additional worksheets can be added as long as your computer has enough memory to accommodate them.

In Excel, a number can contain the characters __________.

Discuss document properties. Include definitions of these terms: metadata, keywords, standard properties, and automatically updated properties. Be sure to give at least two reasons why document properties are valuable.

Figure 1-2 In the accompanying figure, the __________ located near the top of the Excel window is the control center in Excel.

What effect does the Accounting Number Format have on the selected cells?

Figure 1-1 A workbook contains __________, each of which has a name that displays on a sheet tab at the bottom of the workbook, as shown in the accompanying figure.

The following entries are considered text: 401AX21, 921-231, 619 321, 883XTY

How many chart types does Excel offer?

Figure 1-2 In the accompanying figure, the button and button next to the Help icon are used to minimize and restore the worksheet within the Excel window.

__________ properties are associated with all Microsoft Office documents and include author, title, and subject.

__________ is a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from Web sites.

Figure 1-2 Excel opens a new workbook with three __________ , as shown in the accompanying figure.

When the fill handle is used to copy a cell to adjacent cells, the range of cells receiving the copy is called the destination area or paste area.

Excel derives the chart scale based on the values in the worksheet along the vertical axis, also called the y-axis or value axis of the chart.

To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type __________.

The person or persons requesting the worksheet should supply their requirements in a __________ document.

The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the __________.

Introduction to Windows Vista

Integration - Integrating Office 2007 Applications and the World Wide Web

Access: Creating and Using a Database

Access: Querying a Database

Access: Maintaining a Database

Access: Integration Feature - Sharing Data Among Applications

Essential Introduction to Computers

Excel: Formulas, Functions, Formatting, and Web Queries

Excel: What-If Analysis, Charting, and Working With Large Worksheets

Excel Web Feature - Creating Web Pages Using Excel

Outlook: Managing E-Mail and Contacts With Outlook

Powerpoint: Creating and Editing a Presentation

Powerpoint: Creating a Presentation With Illustrations and Shapes

Powerpoint Web Feature: Creating Web Pages Using Powerpoint

Word: Creating and Editing a Word Document

Word: Creating a Research Paper

Creating a Cover Letter and a Resume

Word Web Feature - Creating a Web Page Using Word

Filters

Exam 8: Excel: Creating a Worksheet and an Embedded Chart

A saved workbook is referred to as a(n)__________.

A new workbook opens with three worksheets, but additional worksheets can be added as long as your computer has enough memory to accommodate them.

In Excel, a number can contain the characters __________.

Discuss document properties. Include definitions of these terms: metadata, keywords, standard properties, and automatically updated properties. Be sure to give at least two reasons why document properties are valuable.

Figure 1-2 In the accompanying figure, the __________ located near the top of the Excel window is the control center in Excel.

What effect does the Accounting Number Format have on the selected cells?

Figure 1-1 A workbook contains __________, each of which has a name that displays on a sheet tab at the bottom of the workbook, as shown in the accompanying figure.

The following entries are considered text: 401AX21, 921-231, 619 321, 883XTY

How many chart types does Excel offer?

Figure 1-2 In the accompanying figure, the __________ button and __________ button next to the Help icon are used to minimize and restore the worksheet within the Excel window.

__________ properties are associated with all Microsoft Office documents and include author, title, and subject.

__________ is a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, develop professional looking reports, publish organized data to the Web, and access real-time data from Web sites.

Figure 1-2 Excel opens a new workbook with three __________ , as shown in the accompanying figure.

When the fill handle is used to copy a cell to adjacent cells, the range of cells receiving the copy is called the destination area or paste area.

Excel derives the chart scale based on the values in the worksheet along the vertical axis, also called the y-axis or value axis of the chart.

To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type __________.

The person or persons requesting the worksheet should supply their requirements in a __________ document.

The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the __________.

Introduction to Windows Vista

Integration - Integrating Office 2007 Applications and the World Wide Web

Access: Creating and Using a Database

Access: Querying a Database

Access: Maintaining a Database

Access: Integration Feature - Sharing Data Among Applications

Essential Introduction to Computers

Excel: Formulas, Functions, Formatting, and Web Queries

Excel: What-If Analysis, Charting, and Working With Large Worksheets

Excel Web Feature - Creating Web Pages Using Excel

Outlook: Managing E-Mail and Contacts With Outlook

Powerpoint: Creating and Editing a Presentation

Powerpoint: Creating a Presentation With Illustrations and Shapes

Powerpoint Web Feature: Creating Web Pages Using Powerpoint

Word: Creating and Editing a Word Document

Word: Creating a Research Paper

Creating a Cover Letter and a Resume

Word Web Feature - Creating a Web Page Using Word

Filters

Figure 1-2 In the accompanying figure, the button and button next to the Help icon are used to minimize and restore the worksheet within the Excel window.