Question 1

In Excel, when you hide a column or row, the data is not deleted, just hidden.

Accepted Answer

A) True 
 B)False

Question 2

The fill handle (as it applies to Excel 2010)

Accepted Answer

A)  is the fastest way to type A1 in the name box. 
B)  helps carry over the fill to the remaining slides. 
C)  is the same action as pressing "enter". 
D)  is a small black square at the bottom-right corner of a cell that facilitates fill operations. 
A)  is the fastest way to type A1 in the name box. 
B)  helps carry over the fill to the remaining slides. 
C)  is the same action as pressing "enter". 
D)  is a small black square at the bottom-right corner of a cell that facilitates fill operations.

Question 3

The ________ cell is the current cell, indicated by a dark border.

Accepted Answer

The answer of The ________ cell is the current cell,...

Question 4

Which cell becomes active when you press the "Enter" key?

Accepted Answer

A)  Cell A1 . 
B)  The cell at the bottom of the next column. 
C)  The next cell down. 
D)  The cell at the end of the current row. 
A)  Cell A1 . 
B)  The cell at the bottom of the next column. 
C)  The next cell down. 
D)  The cell at the end of the current row.

Question 5

By default, new workbooks contain ________ worksheets.

Accepted Answer

The answer of By default, new workbooks contain ________ worksheets....

Question 6

Excel displays the result of a formula in its cell. You can display the formula itself by using the combination of Ctrl and ` (accent) keys at the same time.

Accepted Answer

A) True 
 B)False

Question 7

When you paste copied data, Excel displays the Paste Options button

Accepted Answer

A)  in the status bar at the left of the screen. 
B)  in the next set of nonadjacent ranges. 
C)  on the toolbar. 
D)  in the bottom right corner of the pasted data. 
A)  in the status bar at the left of the screen. 
B)  in the next set of nonadjacent ranges. 
C)  on the toolbar. 
D)  in the bottom right corner of the pasted data.

Question 8

Horizontal 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 running through the data. 
C)  puts a line horizontally through the data. 
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 running through the data. 
C)  puts a line horizontally through the data. 
D)  refers to the left-right position of contents in a cell.

Question 9

Ribbon Commands with arrows indicate

Accepted Answer

A)  a shortcut to cell A1. 
B)  there are two or more sub-commands related to the command. 
C)  the next step in the process. 
D)  directionality. 
A)  a shortcut to cell A1. 
B)  there are two or more sub-commands related to the command. 
C)  the next step in the process. 
D)  directionality.

Question 10

The Page Setup Dialog box contains additional options not found on the Excel "Ribbon".

Accepted Answer

A) True 
 B)False

Question 11

A nonadjacent range

Accepted Answer

A)  is the best tool to to use to decide which numbers to select. 
B)  is selected with the "Ctrl + Alt + Delete" key combination. 
C)  contains two or more cells or ranges that are not touching each other. 
D)  isn't possible in Excel 2010. 
A)  is the best tool to to use to decide which numbers to select. 
B)  is selected with the "Ctrl + Alt + Delete" key combination. 
C)  contains two or more cells or ranges that are not touching each other. 
D)  isn't possible in Excel 2010.

Question 12

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

Accepted Answer

A)  a range of cells containing results based on the output 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 on the output 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 13

To select a range in using the name box

Accepted Answer

A)  click in the name box and type the range address such as B15:D25 and then press "Enter". 
B)  select the name box from the 2010 File menu and choose "Range". 
C)  position the mouse pointer over the column headings holding the Alt key. 
D)  click in the first cell of the range, hold the "Ctrl" key, and then click in the last cell of the range. 
A)  click in the name box and type the range address such as B15:D25 and then press "Enter". 
B)  select the name box from the 2010 File menu and choose "Range". 
C)  position the mouse pointer over the column headings holding the Alt key. 
D)  click in the first cell of the range, hold the "Ctrl" key, and then click in the last cell of the range.

Question 14

AutoComplete (as it applies to Excel)

Accepted Answer

A)  adds all the numbers in the row automatically. 
B)  searches for and displays any other similar label in the current column as you begin to type. 
C)  adds all the numbers in the columns automatically. 
D)  is a number that represents a quantity and can be the basis of calculations. 
A)  adds all the numbers in the row automatically. 
B)  searches for and displays any other similar label in the current column as you begin to type. 
C)  adds all the numbers in the columns automatically. 
D)  is a number that represents a quantity and can be the basis of calculations.

Question 15

A cell (as it applies to Excel 2010)

Accepted Answer

A)  must have formulas entered into it. 
B)  cannot be used for labels or headings. 
C)  must have text entered into it. 
D)  is the intersection of a column and a row. 
A)  must have formulas entered into it. 
B)  cannot be used for labels or headings. 
C)  must have text entered into it. 
D)  is the intersection of a column and a row.

Question 16

Fill Color (as it applies to Excel)

Accepted Answer

A)  is handled automatically depending upon the contents of the cell. 
B)  is not adjustable. 
C)  is black by default. 
D)  is the background color of a cell. 
A)  is handled automatically depending upon the contents of the cell. 
B)  is not adjustable. 
C)  is black by default. 
D)  is the background color of a cell.

Question 17

Excel uses the / symbol to perform multiplication on operands.

Accepted Answer

A) True 
 B)False

Question 18

A spreadsheet PROGRAM is defined as

Accepted Answer

A)  a software application used to create and modify spreadsheets. 
B)  a software application used to create and modify text-based documents. 
C)  a software application used to create and modify video presentations. 
D)  a software application used to create and modify a database. 
A)  a software application used to create and modify spreadsheets. 
B)  a software application used to create and modify text-based documents. 
C)  a software application used to create and modify video presentations. 
D)  a software application used to create and modify a database.

Question 19

A sheet tab (as it applies to Excel 2010)

Accepted Answer

A)  displays the content of the active cell. 
B)  conceals the applicable formulas for the workbook. 
C)  identifies the address of the current cell. 
D)  displays the name of a worksheet within a workbook. 
A)  displays the content of the active cell. 
B)  conceals the applicable formulas for the workbook. 
C)  identifies the address of the current cell. 
D)  displays the name of a worksheet within a workbook.

Question 20

________ is a single spreadsheet that can contain formulas, functions, values, text and visual aids.

Accepted Answer

The answer of ________ is a single spreadsheet that can...

In Excel, when you hide a column or row, the data is not deleted, just hidden.

The fill handle (as it applies to Excel 2010)

The ________ cell is the current cell, indicated by a dark border.

Which cell becomes active when you press the "Enter" key?

By default, new workbooks contain ________ worksheets.

Excel displays the result of a formula in its cell. You can display the formula itself by using the combination of Ctrl and ` (accent) keys at the same time.

When you paste copied data, Excel displays the Paste Options button

Horizontal Alignment (as it applies to Excel)

Ribbon Commands with arrows indicate

The Page Setup Dialog box contains additional options not found on the Excel "Ribbon".

A nonadjacent range

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

To select a range in using the name box

AutoComplete (as it applies to Excel)

A cell (as it applies to Excel 2010)

Fill Color (as it applies to Excel)

Excel uses the / symbol to perform multiplication on operands.

A spreadsheet PROGRAM is defined as

A sheet tab (as it applies to Excel 2010)

________ is a single spreadsheet that can contain formulas, functions, values, text and visual aids.

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

In Excel, when you hide a column or row, the data is not deleted, just hidden.

The fill handle (as it applies to Excel 2010)

The ________ cell is the current cell, indicated by a dark border.

Which cell becomes active when you press the "Enter" key?

By default, new workbooks contain ________ worksheets.

Excel displays the result of a formula in its cell. You can display the formula itself by using the combination of Ctrl and ` (accent) keys at the same time.

When you paste copied data, Excel displays the Paste Options button

Horizontal Alignment (as it applies to Excel)

Ribbon Commands with arrows indicate

The Page Setup Dialog box contains additional options not found on the Excel "Ribbon".

A nonadjacent range

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

To select a range in using the name box

AutoComplete (as it applies to Excel)

A cell (as it applies to Excel 2010)

Fill Color (as it applies to Excel)

Excel uses the / symbol to perform multiplication on operands.

A spreadsheet PROGRAM is defined as

A sheet tab (as it applies to Excel 2010)

________ is a single spreadsheet that can contain formulas, functions, values, text and visual aids.

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