Question 1

In Excel, pressing ____ has the same effect as pressing the right arrow key.

Accepted Answer

A)  [Num Lock] 
B)  [Space] 
C)  [Tab] 
D)  [Enter] 
A)  [Num Lock] 
B)  [Space] 
C)  [Tab] 
D)  [Enter] C

Question 2

The ____ box shows the address of the selected cell.

Accepted Answer

A)  formula 
B)  data 
C)  name 
D)  address 
A)  formula 
B)  data 
C)  name 
D)  address C

Question 3

In the accompanying figure, item 3 points to the ____.

Accepted Answer

A)  name box 
B)  status bar 
C)  formula bar 
D)  Quick Access toolbar 
A)  name box 
B)  status bar 
C)  formula bar 
D)  Quick Access toolbar A

Question 4

The active sheet in a workbook is in bold on the sheet tab.

Accepted Answer

A) True 
 B)False

Question 5

You can edit cell contents by double-clicking a cell.

Accepted Answer

A) True 
 B)False

Question 6

When you copy a formula using the fill handle, Excel automatically replaces the original cell references with cell references that are in the same ____ position as those in the original formula.

Accepted Answer

A)  absolute 
B)  approximate 
C)  relative 
D)  possible 
A)  absolute 
B)  approximate 
C)  relative 
D)  possible

Question 7

Check the ____________________ text box in the Print Preview area to make sure your computer is set to the right printer.

Accepted Answer

The answer of Check the ____________________ text box in the...

Question 8

The name box shows the address of the selected cell.

Accepted Answer

A) True 
 B)False

Question 9

You are working on a very large spreadsheet that you know will print on several pages. 
 Describe how to include the page number on the bottom left of every page of your document.

Accepted Answer

Click on the Page Layout View button on

Question 10

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns. 
 Describe how to center a title over all of the columns that make up your budget.

Accepted Answer

Select the range of cells that

Question 11

When Excel guesses which word you want to type after you enter the first letter, you are experiencing a feature known as AutoComplete.

Accepted Answer

A) True 
 B)False

Question 12

When you resize a row by dragging, the pointer becomes a two-headed arrow

Accepted Answer

A) True 
 B)False

Question 13

In the accompanying figure, item 4 points to the ____.

Accepted Answer

A)  active cell 
B)  comment feature 
C)  mouse pointer 
D)  cell icon 
A)  active cell 
B)  comment feature 
C)  mouse pointer 
D)  cell icon

Question 14

The ____ bar, located just above the column headings, shows the contents of the selected cell.

Accepted Answer

A)  formula 
B)  data 
C)  name 
D)  address 
A)  formula 
B)  data 
C)  name 
D)  address

Question 15

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns. 
 You just added a new row of information, but all of the text in the left-most column is not showing, how do you fix the problem?

Accepted Answer

Double-click the col

Question 16

In the accompanying figure, item 3 points to the ____.

Accepted Answer

A)  Insert Worksheet button 
B)  Select All button 
C)  New Sheet button 
D)  sheet tab 
A)  Insert Worksheet button 
B)  Select All button 
C)  New Sheet button 
D)  sheet tab

Question 17

Labels are numeric data that can be used in calculations

Accepted Answer

A) True 
 B)False

Question 18

A worksheet is an electronic grid in which you can perform numeric calculations.

Accepted Answer

A) True 
 B)False

Question 19

In the accompanying figure, item 1 points to the ____.

Accepted Answer

A)  Insert Worksheet button 
B)  Select All button 
C)  Formula Select button 
D)  sheet tab 
A)  Insert Worksheet button 
B)  Select All button 
C)  Formula Select button 
D)  sheet tab

Question 20

Describe how to change the number format in a cell.

Accepted Answer

You can format numbers in several ways.

In Excel, pressing ____ has the same effect as pressing the right arrow key.

The ____ box shows the address of the selected cell.

In the accompanying figure, item 3 points to the ____.

The active sheet in a workbook is in bold on the sheet tab.

You can edit cell contents by double-clicking a cell.

When you copy a formula using the fill handle, Excel automatically replaces the original cell references with cell references that are in the same ____ position as those in the original formula.

Check the ____________________ text box in the Print Preview area to make sure your computer is set to the right printer.

The name box shows the address of the selected cell.

You are working on a very large spreadsheet that you know will print on several pages. Describe how to include the page number on the bottom left of every page of your document.

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns. Describe how to center a title over all of the columns that make up your budget.

When Excel guesses which word you want to type after you enter the first letter, you are experiencing a feature known as AutoComplete.

When you resize a row by dragging, the pointer becomes a two-headed arrow

In the accompanying figure, item 4 points to the ____.

The ____ bar, located just above the column headings, shows the contents of the selected cell.

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns. You just added a new row of information, but all of the text in the left-most column is not showing, how do you fix the problem?

In the accompanying figure, item 3 points to the ____.

Labels are numeric data that can be used in calculations

A worksheet is an electronic grid in which you can perform numeric calculations.

In the accompanying figure, item 1 points to the ____.

Describe how to change the number format in a cell.

Getting Started With Windows 8

Understanding File Management

Getting Started With Microsoft Office 2013

Creating a Document

Enhancing a Document

Adding Special Elements to a Document

Using Complex Formulas, Functions, and Tables

Working With Charts

Creating a Database

Working With Data

Creating Database Reports

Creating a Presentation

Polishing and Running a Presentation

Integrating Office Programs

Working in the Cloud

Understaning Essential Unit Concepts

Filters

Exam 7: Creating and Enhancing a Worksheet

In Excel, pressing ____ has the same effect as pressing the right arrow key.

The ____ box shows the address of the selected cell.

In the accompanying figure, item 3 points to the ____.

The active sheet in a workbook is in bold on the sheet tab.

You can edit cell contents by double-clicking a cell.

When you copy a formula using the fill handle, Excel automatically replaces the original cell references with cell references that are in the same ____ position as those in the original formula.

Check the ____________________ text box in the Print Preview area to make sure your computer is set to the right printer.

The name box shows the address of the selected cell.

You are working on a very large spreadsheet that you know will print on several pages. Describe how to include the page number on the bottom left of every page of your document.

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns. Describe how to center a title over all of the columns that make up your budget.

When Excel guesses which word you want to type after you enter the first letter, you are experiencing a feature known as AutoComplete.

When you resize a row by dragging, the pointer becomes a two-headed arrow

In the accompanying figure, item 4 points to the ____.

The ____ bar, located just above the column headings, shows the contents of the selected cell.

You are using Microsoft Excel to create a budget for your team at work. The budget includes numbers, formulas, and text that spans several columns. You just added a new row of information, but all of the text in the left-most column is not showing, how do you fix the problem?

In the accompanying figure, item 3 points to the ____.

Labels are numeric data that can be used in calculations

A worksheet is an electronic grid in which you can perform numeric calculations.

In the accompanying figure, item 1 points to the ____.

Describe how to change the number format in a cell.

Getting Started With Windows 8

Understanding File Management

Getting Started With Microsoft Office 2013

Creating a Document

Enhancing a Document

Adding Special Elements to a Document

Using Complex Formulas, Functions, and Tables

Working With Charts

Creating a Database

Working With Data

Creating Database Reports

Creating a Presentation

Polishing and Running a Presentation

Integrating Office Programs

Working in the Cloud

Understaning Essential Unit Concepts

Filters