Question 1

For Excel to recognize a formula, it must begin with an ________ sign.

Accepted Answer

The answer of For Excel to recognize a formula, it...

Question 2

A worksheet is defined as

Accepted Answer

A)  the background color of a cell. 
B)  the current cell location of the insertion point as indicated by a dark border. 
C)  a single spreadsheet that often contains formulas, functions, values, text, and visual aids. 
D)  an unfinished project. 
A)  the background color of a cell. 
B)  the current cell location of the insertion point as indicated by a dark border. 
C)  a single spreadsheet that often contains formulas, functions, values, text, and visual aids. 
D)  an unfinished project.

Question 3

A Border (as it applies to Excel)

Accepted Answer

A)  is data from another cell that is only temporarily residing in the active cell. 
B)  is a line that surrounds a cell or a range of cells. 
C)  never prints. 
D)  is preset and weight cannot be adjusted. 
A)  is data from another cell that is only temporarily residing in the active cell. 
B)  is a line that surrounds a cell or a range of cells. 
C)  never prints. 
D)  is preset and weight cannot be adjusted.

Question 4

While it is common to center a worksheet horizontally on a page, it is not possible to center it vertically on the page in Excel 2010.

Accepted Answer

A) True 
 B)False

Question 5

Excel treats phone numbers and social security numbers as ________.

Accepted Answer

The answer of Excel treats phone numbers and social security...

Question 6

A spreadsheet

Accepted Answer

A)  is the core of a slide presentation. 
B)  is an electronic file that is used to write text and graphics on the web. 
C)  is an electronic file that contains a grid of columns and rows for related data. 
D)  is another word for a letter written on a computer. 
A)  is the core of a slide presentation. 
B)  is an electronic file that is used to write text and graphics on the web. 
C)  is an electronic file that contains a grid of columns and rows for related data. 
D)  is another word for a letter written on a computer.

Question 7

To begin a formula in a cell, first type the # symbol.

Accepted Answer

A) True 
 B)False

Question 8

In Excel 2010, there is really no way to tell what a print-out will look like until you print it.

Accepted Answer

A) True 
 B)False

Question 9

A cell address (as it applies to Excel 2010)

Accepted Answer

A)  identifies the electronic "neighborhood" of a spreadsheet. 
B)  identifies a cell by a column letter and a row number. 
C)  searches for and displays similar labels as you type. 
D)  is a number that represents a quantity and can be the basis of calculations. 
A)  identifies the electronic "neighborhood" of a spreadsheet. 
B)  identifies a cell by a column letter and a row number. 
C)  searches for and displays similar labels as you type. 
D)  is a number that represents a quantity and can be the basis of calculations.

Question 10

To copy the contents of a cell or range by dragging is called using Auto ________.

Accepted Answer

The answer of To copy the contents of a cell...

Question 11

To show a "hidden" row one or a "hidden" column A, type ________ in the name box and then press "Enter".

Accepted Answer

The answer of To show a "hidden" row one or...

Question 12

To help with Managing your Workbook, worksheets tabs can be assigned unique colors.

Accepted Answer

A) True 
 B)False

Question 13

To show a "hidden" row one (1) or a "hidden" column A.

Accepted Answer

A)  type A1 in the name box and then press "Enter" 
B)  use only a Ribbon command with arrows . 
C)  scroll to the left. 
D)  scroll to the right. 
A)  type A1 in the name box and then press "Enter" 
B)  use only a Ribbon command with arrows . 
C)  scroll to the left. 
D)  scroll to the right.

Question 14

Wrap Text (as it applies to Excel)

Accepted Answer

A)  can be downloaded as an add-on . 
B)  is no longer possible in Excel 2010 due to contract restrictions. 
C)  is most useful with very short headings. 
D)  enables data to appear on two or more lines within a cell. 
A)  can be downloaded as an add-on . 
B)  is no longer possible in Excel 2010 due to contract restrictions. 
C)  is most useful with very short headings. 
D)  enables data to appear on two or more lines within a cell.

Question 15

A Value (as it applies to Excel)

Accepted Answer

A)  controls the sequence in which Excel performs arithmetic operations. 
B)  is a number that represents a quantity and can be the basis of calculations. 
C)  includes letters, numbers, and spaces. 
D)  is a combination of cell references, operators, values, and / or functions used to perform calculations. 
A)  controls the sequence in which Excel performs arithmetic operations. 
B)  is a number that represents a quantity and can be the basis of calculations. 
C)  includes letters, numbers, and spaces. 
D)  is a combination of cell references, operators, values, and / or functions used to perform calculations.

Question 16

Use Horizontal alignment to move the data in a cell closer to the top or bottom of the cell.

Accepted Answer

A) True 
 B)False

Question 17

________ is any combination of letters, numbers, etc NOT used for calculations.

Accepted Answer

The answer of ________ is any combination of letters, numbers,...

Question 18

The order of ________ controls the sequence in which Excel does math.

Accepted Answer

The answer of The order of ________ controls the sequence...

Question 19

In Excel, it is possible to add, delete, or rename worksheets at any time in the process.

Accepted Answer

A) True 
 B)False

Question 20

A2+A3 is not a formula because the ________ sign is missing.

Accepted Answer

The answer of A2+A3 is not a formula because the...

For Excel to recognize a formula, it must begin with an ________ sign.

A worksheet is defined as

A Border (as it applies to Excel)

While it is common to center a worksheet horizontally on a page, it is not possible to center it vertically on the page in Excel 2010.

Excel treats phone numbers and social security numbers as ________.

A spreadsheet

To begin a formula in a cell, first type the # symbol.

In Excel 2010, there is really no way to tell what a print-out will look like until you print it.

A cell address (as it applies to Excel 2010)

To copy the contents of a cell or range by dragging is called using Auto ________.

To show a "hidden" row one or a "hidden" column A, type ________ in the name box and then press "Enter".

To help with Managing your Workbook, worksheets tabs can be assigned unique colors.

To show a "hidden" row one (1) or a "hidden" column A.

Wrap Text (as it applies to Excel)

A Value (as it applies to Excel)

Use Horizontal alignment to move the data in a cell closer to the top or bottom of the cell.

________ is any combination of letters, numbers, etc NOT used for calculations.

The order of ________ controls the sequence in which Excel does math.

In Excel, it is possible to add, delete, or rename worksheets at any time in the process.

A2+A3 is not a formula because the ________ sign is missing.

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Relational Databases and Queries

Excel: Customize, Analyze, and Summarize Query Data

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Development

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters

Exam 11: Excel: Introduction to Access

For Excel to recognize a formula, it must begin with an ________ sign.

A worksheet is defined as

A Border (as it applies to Excel)

While it is common to center a worksheet horizontally on a page, it is not possible to center it vertically on the page in Excel 2010.

Excel treats phone numbers and social security numbers as ________.

A spreadsheet

To begin a formula in a cell, first type the # symbol.

In Excel 2010, there is really no way to tell what a print-out will look like until you print it.

A cell address (as it applies to Excel 2010)

To copy the contents of a cell or range by dragging is called using Auto ________.

To show a "hidden" row one or a "hidden" column A, type ________ in the name box and then press "Enter".

To help with Managing your Workbook, worksheets tabs can be assigned unique colors.

To show a "hidden" row one (1) or a "hidden" column A.

Wrap Text (as it applies to Excel)

A Value (as it applies to Excel)

Use Horizontal alignment to move the data in a cell closer to the top or bottom of the cell.

________ is any combination of letters, numbers, etc NOT used for calculations.

The order of ________ controls the sequence in which Excel does math.

In Excel, it is possible to add, delete, or rename worksheets at any time in the process.

A2+A3 is not a formula because the ________ sign is missing.

Windows: Getting Started With Windows 7

Word: Collaboration and Research

Word: Document Presentation

Word: Introduction to Word

Word: Office Fundamentals and File Management

Powerpoint: Introduction to Excel

Powerpoint: Formulas and Functions

Powerpoint: Charts

Powerpoint: Datasets and Tables

Office Fundamentals Document Productivity

Excel: Relational Databases and Queries

Excel: Customize, Analyze, and Summarize Query Data

Excel: Creating and Using Professional Forms and Reports

Access: Introduction to Powerpoint

Access: Presentation Development

Access: Presentation Design

Access: Powerpoint Rich Media Tools

Filters