Question 1

The active cell (as it applies to Excel 2010)

Accepted Answer

A)  is where all the functions of the database perform the calculations. 
B)  is the cell that always holds the current date. 
C)  is the location of the insertion point as indicated by a dark border. 
D)  is where all the formulas of the workbook do the math. 
A)  is where all the functions of the database perform the calculations. 
B)  is the cell that always holds the current date. 
C)  is the location of the insertion point as indicated by a dark border. 
D)  is where all the formulas of the workbook do the math.

Question 2

The page setup dialog box Header / Footer tab is one way of adding a header and / or footer to your spreadsheet.

Accepted Answer

A) True 
 B)False

Question 3

Column width

Accepted Answer

A)  is adjustable so you can display more or less characters in a column. 
B)  is not adjustable so keep the formulas as short as possible. 
C)  always switches back to default. 
D)  is best left unchanged unless you absolutely have to. 
A)  is adjustable so you can display more or less characters in a column. 
B)  is not adjustable so keep the formulas as short as possible. 
C)  always switches back to default. 
D)  is best left unchanged unless you absolutely have to.

Question 4

The Formula Bar (as it applies to Excel 2010)

Accepted Answer

A)  displays the name of a worksheet within a workbook. 
B)  is at the intersection of a column and a row. 
C)  identifies the address of the current cell. 
D)  displays the content of the active cell. 
A)  displays the name of a worksheet within a workbook. 
B)  is at the intersection of a column and a row. 
C)  identifies the address of the current cell. 
D)  displays the content of the active cell.

Question 5

To put a long text label on two or more lines within a single cell

Accepted Answer

A)  type the first line, then hit "Enter". 
B)  insert a line break with the "Alt + Enter" key combination. 
C)  type the second line then use the Backspace key. 
D)  insert a text box using F4. 
A)  type the first line, then hit "Enter". 
B)  insert a line break with the "Alt + Enter" key combination. 
C)  type the second line then use the Backspace key. 
D)  insert a text box using F4.

Question 6

"Copy as Picture" can be a useful command when

Accepted Answer

A)  you do not have a printer available. 
B)  the formulas, functions, and headings need to be tested. 
C)  you need an un-edit able "picture" of data to use elsewhere in the workbook or other programs. 
D)  you need to make changes to the data later. 
A)  you do not have a printer available. 
B)  the formulas, functions, and headings need to be tested. 
C)  you need an un-edit able "picture" of data to use elsewhere in the workbook or other programs. 
D)  you need to make changes to the data later.

Question 7

The Name Box (as it applies to Excel 2010)

Accepted Answer

A)  is located at the intersection of a column and a row. 
B)  displays the name of a worksheet within a workbook. 
C)  identifies the address of the current cell. 
D)  displays the content of the active cell. 
A)  is located at the intersection of a column and a row. 
B)  displays the name of a worksheet within a workbook. 
C)  identifies the address of the current cell. 
D)  displays the content of the active cell.

Question 8

To display another worksheet click the sheet ________ at the bottom of the workbook window.

Accepted Answer

The answer of To display another worksheet click the sheet...

Question 9

A ________ is an electronic file that contains a grid of columns and rows.

Accepted Answer

The answer of A ________ is an electronic file that...

Question 10

Excel displays data in gridlines of columns and rows. Those grid lines always appear on the printed document.

Accepted Answer

A) True 
 B)False

The active cell (as it applies to Excel 2010)

The page setup dialog box Header / Footer tab is one way of adding a header and / or footer to your spreadsheet.

Column width

The Formula Bar (as it applies to Excel 2010)

To put a long text label on two or more lines within a single cell

"Copy as Picture" can be a useful command when

The Name Box (as it applies to Excel 2010)

To display another worksheet click the sheet ________ at the bottom of the workbook window.

A ________ is an electronic file that contains a grid of columns and rows.

Excel displays data in gridlines of columns and rows. Those grid lines always appear on the printed document.

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

The active cell (as it applies to Excel 2010)

The page setup dialog box Header / Footer tab is one way of adding a header and / or footer to your spreadsheet.

Column width

The Formula Bar (as it applies to Excel 2010)

To put a long text label on two or more lines within a single cell

"Copy as Picture" can be a useful command when

The Name Box (as it applies to Excel 2010)

To display another worksheet click the sheet ________ at the bottom of the workbook window.

A ________ is an electronic file that contains a grid of columns and rows.

Excel displays data in gridlines of columns and rows. Those grid lines always appear on the printed document.

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