Question 1

To Transpose Columns and Rows

Accepted Answer

A)  select and copy the original range then click the top left corner of the destination range, click the Paste Arrow, and then click Transpose. 
B)  save and close the document, then reopen it in "Transpose mode". 
C)  drag and drop A-Z onto 1-26. 
D)  drag the range to a new location on the worksheet. 
A)  select and copy the original range then click the top left corner of the destination range, click the Paste Arrow, and then click Transpose. 
B)  save and close the document, then reopen it in "Transpose mode". 
C)  drag and drop A-Z onto 1-26. 
D)  drag the range to a new location on the worksheet. A

Question 2

Row Height

Accepted Answer

A)  is the adjustable vertical measurement of a row. 
B)  changes the background color of the selected cells. 
C)  is controlled by the fill handle of the adjacent cell. 
D)  is not adjustable so use only smaller fonts for formulas. 
A)  is the adjustable vertical measurement of a row. 
B)  changes the background color of the selected cells. 
C)  is controlled by the fill handle of the adjacent cell. 
D)  is not adjustable so use only smaller fonts for formulas. A

Question 3

An ________ area is a range of cells containing values for variables used in formulas.

Accepted Answer

input

Question 4

An Output Area (as it applies to Excel 2010)is defined as

Accepted Answer

A)  a range of cells containing results based upon manipulation of the variables in the input area. 
B)  displays the name of a worksheet within a workbook. 
C)  a range of cells containing values for variables used in formulas. 
D)  displays the content of the active cell. 
A)  a range of cells containing results based upon manipulation of the variables in the input area. 
B)  displays the name of a worksheet within a workbook. 
C)  a range of cells containing values for variables used in formulas. 
D)  displays the content of the active cell.

Question 5

You should use cell references in formulas instead of constant values so

Accepted Answer

A)  you can easily include letters, numbers, and spaces. 
B)  it is easier to debug the errors. 
C)  you can change the input values without changing the formulas. 
D)  you can control the sequence in which Excel performs arithmetic operations. 
A)  you can easily include letters, numbers, and spaces. 
B)  it is easier to debug the errors. 
C)  you can change the input values without changing the formulas. 
D)  you can control the sequence in which Excel performs arithmetic operations.

Question 6

Text can be any letters, numbers, and symbols and Excel can use them in calculations.

Accepted Answer

A) True 
 B)False

Question 7

An ________ area is a range of cells containing results based on manipulating the variables.

Accepted Answer

The answer of An ________ area is a range of...

Question 8

Increase / Decrease Indent tool is a good way to make certain text stand out from a list.

Accepted Answer

A) True 
 B)False

Question 9

A ________ is the intersection of a column and a row.

Accepted Answer

The answer of A ________ is the intersection of a...

Question 10

=A2+A3 is a (better or worse) ________ formula than =10+2 because of flexibility.

Accepted Answer

The answer of =A2+A3 is a (better or worse) ________...

Question 11

The data type "Text" (as it applies to Excel)

Accepted Answer

A)  should be entered into every cell of the spreadsheet. 
B)  includes letters, numbers, and spaces not used in calculations. 
C)  includes formulas, functions, and formatting. 
D)  is of little concern to Excel because Excel does calculations on numbers. 
A)  should be entered into every cell of the spreadsheet. 
B)  includes letters, numbers, and spaces not used in calculations. 
C)  includes formulas, functions, and formatting. 
D)  is of little concern to Excel because Excel does calculations on numbers.

Question 12

You should plan the structure of the worksheets in a workbook before you begin entering data.

Accepted Answer

A) True 
 B)False

Question 13

A cell ________ identifies a cell by a column letter and a row number.

Accepted Answer

The answer of A cell ________ identifies a cell by...

Question 14

Worksheets name "tabs" automatically reflect the contents of the worksheets.

Accepted Answer

A) True 
 B)False

Question 15

If the column is too narrow, part of the data you enter in the cell will get deleted.

Accepted Answer

A) True 
 B)False

Question 16

Merge and Center is not a good tool for creating titles of headings in Excel.

Accepted Answer

A) True 
 B)False

Question 17

Sheet ________ show the names of the worksheets contained in the workbook.

Accepted Answer

The answer of Sheet ________ show the names of the...

Question 18

Vertical Alignment (as it applies to Excel)

Accepted Answer

A)  refers to the up-down position of contents in a cell. 
B)  removes the vertical lines and the tangent lines on the print-out. 
C)  shows the vertical lines but not the tangent lines on the print-out. 
D)  refers to the left-right position of contents in a cell. 
A)  refers to the up-down position of contents in a cell. 
B)  removes the vertical lines and the tangent lines on the print-out. 
C)  shows the vertical lines but not the tangent lines on the print-out. 
D)  refers to the left-right position of contents in a cell.

Question 19

To adjust the column width and / or row height of many cells at once

Accepted Answer

A)  just type longer or taller formulas in some of them. 
B)  click and drag across the cells to select them and use any sizing method you choose. 
C)  drag the fill handle across the cells. 
D)  type A1 in the "Go To" dialog box. 
A)  just type longer or taller formulas in some of them. 
B)  click and drag across the cells to select them and use any sizing method you choose. 
C)  drag the fill handle across the cells. 
D)  type A1 in the "Go To" dialog box.

Question 20

A ________ is a file containing related one or more worksheets.

Accepted Answer

The answer of A ________ is a file containing related...

To Transpose Columns and Rows

Row Height

An ________ area is a range of cells containing values for variables used in formulas.

An Output Area (as it applies to Excel 2010)is defined as

You should use cell references in formulas instead of constant values so

Text can be any letters, numbers, and symbols and Excel can use them in calculations.

An ________ area is a range of cells containing results based on manipulating the variables.

Increase / Decrease Indent tool is a good way to make certain text stand out from a list.

A ________ is the intersection of a column and a row.

=A2+A3 is a (better or worse) ________ formula than =10+2 because of flexibility.

The data type "Text" (as it applies to Excel)

You should plan the structure of the worksheets in a workbook before you begin entering data.

A cell ________ identifies a cell by a column letter and a row number.

Worksheets name "tabs" automatically reflect the contents of the worksheets.

If the column is too narrow, part of the data you enter in the cell will get deleted.

Merge and Center is not a good tool for creating titles of headings in Excel.

Sheet ________ show the names of the worksheets contained in the workbook.

Vertical Alignment (as it applies to Excel)

To adjust the column width and / or row height of many cells at once

A ________ is a file containing related one or more worksheets.

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

To Transpose Columns and Rows

Row Height

An ________ area is a range of cells containing values for variables used in formulas.

An Output Area (as it applies to Excel 2010)is defined as

You should use cell references in formulas instead of constant values so

Text can be any letters, numbers, and symbols and Excel can use them in calculations.

An ________ area is a range of cells containing results based on manipulating the variables.

Increase / Decrease Indent tool is a good way to make certain text stand out from a list.

A ________ is the intersection of a column and a row.

=A2+A3 is a (better or worse) ________ formula than =10+2 because of flexibility.

The data type "Text" (as it applies to Excel)

You should plan the structure of the worksheets in a workbook before you begin entering data.

A cell ________ identifies a cell by a column letter and a row number.

Worksheets name "tabs" automatically reflect the contents of the worksheets.

If the column is too narrow, part of the data you enter in the cell will get deleted.

Merge and Center is not a good tool for creating titles of headings in Excel.

Sheet ________ show the names of the worksheets contained in the workbook.

Vertical Alignment (as it applies to Excel)

To adjust the column width and / or row height of many cells at once

A ________ is a file containing related one or more worksheets.

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