Question 1

What would not be a typical item to have in a header or footer?

Accepted Answer

A)  The spreadsheet designer's name 
B)  The filename or file path 
C)  The file size 
D)  The page number 
A)  The spreadsheet designer's name 
B)  The filename or file path 
C)  The file size 
D)  The page number

Question 2

A(n) ________ is a collection of one or more related worksheets.

Accepted Answer

workbook,

Question 3

Right-clicking a column heading, then selecting Insert, will add a new column to the left of the current column.

Accepted Answer

A) True 
 B)False

Question 4

What should you do if there are columns you need, but do not want to display?

Accepted Answer

A)  Delete the columns you do not want to display then undo your action when finished. 
B)  Move the columns you want to see so that they are together then move them back to their original locations with finished. 
C)  Cut and paste the columns you do not want to display to another area of the worksheet. 
D)  Hide the columns you do not want to display, then unhide them when finished. 
A)  Delete the columns you do not want to display then undo your action when finished. 
B)  Move the columns you want to see so that they are together then move them back to their original locations with finished. 
C)  Cut and paste the columns you do not want to display to another area of the worksheet. 
D)  Hide the columns you do not want to display, then unhide them when finished.

Question 5

The ________ feature helps you complete an incremental series.

Accepted Answer

The answer of The ________ feature helps you complete an...

Question 6

One point is how big?

Accepted Answer

A)  1 / 72 of an inch 
B)  1 / 36 of an inch 
C)  The same as a pixel 
D)  The same as one character 
A)  1 / 72 of an inch 
B)  1 / 36 of an inch 
C)  The same as a pixel 
D)  The same as one character

Question 7

Bottom Align is the default vertical alignment.

Accepted Answer

A) True 
 B)False

Question 8

In Excel, columns are identified by numbers and rows by letters.

Accepted Answer

A) True 
 B)False

Question 9

The wrap text feature will automatically move any text that does not fit in a cell to the cell directly below it.

Accepted Answer

A) True 
 B)False

Question 10

In the formula, =1+(2-3)+5 / 6-6^2, what will Excel evaluate second?

Accepted Answer

A)  5 / 6 
B)  1+ 
C)  (2-3) 
D)  6^2 
A)  5 / 6 
B)  1+ 
C)  (2-3) 
D)  6^2

Question 11

The ________ feature allows you to move some text to another line within the same row.

Accepted Answer

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

Question 12

The ________ area is where you store the variable you will be using in the worksheet.

Accepted Answer

The answer of The ________ area is where you store...

Question 13

The intersection between a column and a row is called a(n) ________.

Accepted Answer

The answer of The intersection between a column and a...

Question 14

Match the following Paste options with their description:
i. Values
II. Picture
III. Paste Link
IV. Linked Picture
v. Paste

Accepted Answer

A)  A reference to the cells, not the cell contents 
B)  Unformatted results of formulas 
C)  Cell contents and all formatting 
D)  A non-editable copy of your data 
E)  Changes if the content changes 
A)  A reference to the cells, not the cell contents 
B)  Unformatted results of formulas 
C)  Cell contents and all formatting 
D)  A non-editable copy of your data 
E)  Changes if the content changes

Question 15

A(n) ________ is a type of file that organizes data in rows and columns.

Accepted Answer

The answer of A(n) ________ is a type of file...

Question 16

The contents of a cell can be seen in the Name box.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is not included when you use a cell style?

Accepted Answer

A)  Font 
B)  Cell protection 
C)  Alignment 
D)  Borders 
A)  Font 
B)  Cell protection 
C)  Alignment 
D)  Borders

What would not be a typical item to have in a header or footer?

A(n) ________ is a collection of one or more related worksheets.

Right-clicking a column heading, then selecting Insert, will add a new column to the left of the current column.

What should you do if there are columns you need, but do not want to display?

The ________ feature helps you complete an incremental series.

One point is how big?

Bottom Align is the default vertical alignment.

In Excel, columns are identified by numbers and rows by letters.

The wrap text feature will automatically move any text that does not fit in a cell to the cell directly below it.

In the formula, =1+(2-3)+5 / 6-6^2, what will Excel evaluate second?

The ________ feature allows you to move some text to another line within the same row.

The ________ area is where you store the variable you will be using in the worksheet.

The intersection between a column and a row is called a(n) ________.

Match the following Paste options with their description: i. Values II. Picture III. Paste Link IV. Linked Picture v. Paste

A(n) ________ is a type of file that organizes data in rows and columns.

The contents of a cell can be seen in the Name box.

Which of the following is not included when you use a cell style?

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

What would not be a typical item to have in a header or footer?

A(n) ________ is a collection of one or more related worksheets.

Right-clicking a column heading, then selecting Insert, will add a new column to the left of the current column.

What should you do if there are columns you need, but do not want to display?

The ________ feature helps you complete an incremental series.

One point is how big?

Bottom Align is the default vertical alignment.

In Excel, columns are identified by numbers and rows by letters.

The wrap text feature will automatically move any text that does not fit in a cell to the cell directly below it.

In the formula, =1+(2-3)+5 / 6-6^2, what will Excel evaluate second?

The ________ feature allows you to move some text to another line within the same row.

The ________ area is where you store the variable you will be using in the worksheet.

The intersection between a column and a row is called a(n) ________.

Match the following Paste options with their description: i. Values II. Picture III. Paste Link IV. Linked Picture v. Paste

A(n) ________ is a type of file that organizes data in rows and columns.

The contents of a cell can be seen in the Name box.

Which of the following is not included when you use a cell style?

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