Question 1

A(n) ________ is a group of cells which have been selected at the same time.

Accepted Answer

The answer of A(n) ________ is a group of cells...

Question 2

A(n) ________ is a line you can put around a cell or range of cells for emphasis.

Accepted Answer

The answer of A(n) ________ is a line you can...

Question 3

Cell ________ refers to how data are located within the boundaries of the cell.

Accepted Answer

The answer of Cell ________ refers to how data are...

Question 4

Make sure to enter all cell reference in upper case when putting them in formulas.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following would not be considered text?

Accepted Answer

A)  Phone number (111.111.1111) 
B)  Social Security number (111-11-1111) 
C)  Part number (PT111) 
D)  =2*2 
A)  Phone number (111.111.1111) 
B)  Social Security number (111-11-1111) 
C)  Part number (PT111) 
D)  =2*2

Question 6

The ________ feature allows you to see how a document would print before you actually print it.

Accepted Answer

The answer of The ________ feature allows you to see...

Question 7

The best way to apply Page Setup options to multiple worksheets is to ________.

Accepted Answer

A)  group the worksheets 
B)  use the Format Painter 
C)  copy and Paste the formatting codes from one sheet to another 
D)  use the Apply to Selected Sheets formatting command 
A)  group the worksheets 
B)  use the Format Painter 
C)  copy and Paste the formatting codes from one sheet to another 
D)  use the Apply to Selected Sheets formatting command

Question 8

The row height should be the same size as the font height.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is not true of the Formula bar?

Accepted Answer

A)  You can edit cell contents there. 
B)  It is to the right of the Insert Function command. 
C)  It allows you to pick from an assortment of formulas. 
D)  It displays the contents stored in the active cell. 
A)  You can edit cell contents there. 
B)  It is to the right of the Insert Function command. 
C)  It allows you to pick from an assortment of formulas. 
D)  It displays the contents stored in the active cell.

Question 10

What is the best practice to switch the columns and rows in a range?

Accepted Answer

A)  Cut the range, then use the Paste Special option called Values 
B)  Cut the range, then use the Paste Special option called Transpose 
C)  Cut the range, then use the Paste Special option called Switch 
D)  Cut the range, paste it into a blank area, then cut and paste each cell where you want it 
A)  Cut the range, then use the Paste Special option called Values 
B)  Cut the range, then use the Paste Special option called Transpose 
C)  Cut the range, then use the Paste Special option called Switch 
D)  Cut the range, paste it into a blank area, then cut and paste each cell where you want it

Question 11

The ________ color is what is visible behind the value in a cell.

Accepted Answer

The answer of The ________ color is what is visible...

Question 12

What can you not do directly from the Backstage, Print screen view?

Accepted Answer

A)  Switch to formula view and print formulas 
B)  Select which printer you want to use 
C)  Select how much of the worksheet will be printed 
D)  Set the page orientation 
A)  Switch to formula view and print formulas 
B)  Select which printer you want to use 
C)  Select how much of the worksheet will be printed 
D)  Set the page orientation

Question 13

Where can you find more alignment options?

Accepted Answer

A)  Format Cells dialog box 
B)  Format Alignment dialog box 
C)  Format dialog box 
D)  Format Rows and Columns dialog box 
A)  Format Cells dialog box 
B)  Format Alignment dialog box 
C)  Format dialog box 
D)  Format Rows and Columns dialog box

Question 14

It is relatively easy to copy Excel cells into other Office programs.

Accepted Answer

A) True 
 B)False

Question 15

If you do not need a row or column any more it is best to hide it instead of deleting it in case you change your mind.

Accepted Answer

A) True 
 B)False

Question 16

A range is specified by its ________.

Accepted Answer

A)  top and bottom row and left and right column 
B)  top row and leftmost column 
C)  top right and bottom left cells 
D)  top left and bottom right cells 
A)  top and bottom row and left and right column 
B)  top row and leftmost column 
C)  top right and bottom left cells 
D)  top left and bottom right cells

Question 17

What is the true about an input area?

Accepted Answer

A)  It is used when certain values are used repeatedly throughout the worksheet. 
B)  It is useful when your values change frequently throughout the worksheet. 
C)  It should be located below the rest of your data. 
D)  It should only contain one input cell. 
A)  It is used when certain values are used repeatedly throughout the worksheet. 
B)  It is useful when your values change frequently throughout the worksheet. 
C)  It should be located below the rest of your data. 
D)  It should only contain one input cell.

Question 18

What does pressing the Enter key while in a cell, do?

Accepted Answer

A)  The value is set, and the active cell remains the active cell 
B)  The value is set, and the cell to the right becomes the active cell 
C)  The value is set, and the cell below becomes the active cell 
D)  The value is set, and the action is the same as pressing the Tab key 
A)  The value is set, and the active cell remains the active cell 
B)  The value is set, and the cell to the right becomes the active cell 
C)  The value is set, and the cell below becomes the active cell 
D)  The value is set, and the action is the same as pressing the Tab key

Question 19

________ can be used in calculations, whereas text cannot.

Accepted Answer

The answer of ________ can be used in calculations, whereas...

Question 20

When you copy and paste a range the relative references do not change.

Accepted Answer

A) True 
 B)False

A(n) ________ is a group of cells which have been selected at the same time.

A(n) ________ is a line you can put around a cell or range of cells for emphasis.

Cell ________ refers to how data are located within the boundaries of the cell.

Make sure to enter all cell reference in upper case when putting them in formulas.

Which of the following would not be considered text?

The ________ feature allows you to see how a document would print before you actually print it.

The best way to apply Page Setup options to multiple worksheets is to ________.

The row height should be the same size as the font height.

Which of the following is not true of the Formula bar?

What is the best practice to switch the columns and rows in a range?

The ________ color is what is visible behind the value in a cell.

What can you not do directly from the Backstage, Print screen view?

Where can you find more alignment options?

It is relatively easy to copy Excel cells into other Office programs.

If you do not need a row or column any more it is best to hide it instead of deleting it in case you change your mind.

A range is specified by its ________.

What is the true about an input area?

What does pressing the Enter key while in a cell, do?

________ can be used in calculations, whereas text cannot.

When you copy and paste a range the relative references do not change.

Common Features

Access: Introduction to Powerpoint

Access: Tables and Queries in Relational Databases

Access: Query Calculations and Expressions

Access: Basic Forms and Reports

Excell: Formulas and Functions

Excell: Charts

Excell: Datasets and Tables

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters

Exam 6: Excell: Introduction to Excel

A(n) ________ is a group of cells which have been selected at the same time.

A(n) ________ is a line you can put around a cell or range of cells for emphasis.

Cell ________ refers to how data are located within the boundaries of the cell.

Make sure to enter all cell reference in upper case when putting them in formulas.

Which of the following would not be considered text?

The ________ feature allows you to see how a document would print before you actually print it.

The best way to apply Page Setup options to multiple worksheets is to ________.

The row height should be the same size as the font height.

Which of the following is not true of the Formula bar?

What is the best practice to switch the columns and rows in a range?

The ________ color is what is visible behind the value in a cell.

What can you not do directly from the Backstage, Print screen view?

Where can you find more alignment options?

It is relatively easy to copy Excel cells into other Office programs.

If you do not need a row or column any more it is best to hide it instead of deleting it in case you change your mind.

A range is specified by its ________.

What is the true about an input area?

What does pressing the Enter key while in a cell, do?

________ can be used in calculations, whereas text cannot.

When you copy and paste a range the relative references do not change.

Common Features

Access: Introduction to Powerpoint

Access: Tables and Queries in Relational Databases

Access: Query Calculations and Expressions

Access: Basic Forms and Reports

Excell: Formulas and Functions

Excell: Charts

Excell: Datasets and Tables

Powerpoint: Introduction to Powerpoint

Powerpoint: Effective Presentation Development

Powerpoint: Presentation Enhancement

Powerpoint: Presentation Refinement

Word: Introduction to Word

Word: Document Presentation

Word: Document Productivity

Word: Research and Collaboration

Filters