Question 1

You cannot format an entire column at once.

Accepted Answer

A) True 
 B)False

Question 2

Clicking the Create Function box opens the Function Arguments dialog box.

Accepted Answer

A) True 
 B)False

Question 3

The ____ function displays the highest value in a range.

Accepted Answer

A)  MIN 
B)  SUM 
C)  MAX 
D)  AVERAGE 
A)  MIN 
B)  SUM 
C)  MAX 
D)  AVERAGE

Question 4

Briefly discuss displaying the formulas version of a worksheet.

Accepted Answer

The values version of the worksheet show

Question 5

Of warmer and cooler colors,the kind of colors that tend to reach toward the reader are ____________________ colors.

Accepted Answer

The answer of Of warmer and cooler colors,the kind of...

Question 6

When Excel recognizes that you entered a date in mm / dd / yy format,it automatically formats the date as ____________________.

Accepted Answer

The answer of When Excel recognizes that you entered a...

Question 7

Which of the following calculations multiplies 23 by 0.01?

Accepted Answer

A)  =23% 
B)  =23 
C)  =23+.01 
D)  =24-.01 
A)  =23% 
B)  =23 
C)  =23+.01 
D)  =24-.01

Question 8

To print a range of cells in the active worksheet,click ____ in the Settings area in the Print gallery.

Accepted Answer

A)  Print Active Sheets 
B)  Print Selection 
C)  Print Entire Workbook 
D)  none of the above 
A)  Print Active Sheets 
B)  Print Selection 
C)  Print Entire Workbook 
D)  none of the above

Question 9

Which of the following is the path to the Spelling button?

Accepted Answer

Question 10

A ____ is text and graphics that print at the top of each page.

Accepted Answer

A)  header 
B)  topper 
C)  margin 
D)  crown 
A)  header 
B)  topper 
C)  margin 
D)  crown

Question 11

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

Accepted Answer

A) True 
 B)False

You cannot format an entire column at once.

Clicking the Create Function box opens the Function Arguments dialog box.

The ____ function displays the highest value in a range.

Briefly discuss displaying the formulas version of a worksheet.

Of warmer and cooler colors,the kind of colors that tend to reach toward the reader are ____________________ colors.

When Excel recognizes that you entered a date in mm / dd / yy format,it automatically formats the date as ____________________.

Which of the following calculations multiplies 23 by 0.01?

To print a range of cells in the active worksheet,click ____ in the Settings area in the Print gallery.

Which of the following is the path to the Spelling button?

A ____ is text and graphics that print at the top of each page.

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

Creating a Worksheet and a Chart

Working With Large Worksheets,Charting,and What-If Analysis

Financial Functions,Data Tables,and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters

Exam 2: Formulas,Functions,and Formatting

You cannot format an entire column at once.

Clicking the Create Function box opens the Function Arguments dialog box.

The ____ function displays the highest value in a range.

Briefly discuss displaying the formulas version of a worksheet.

Of warmer and cooler colors,the kind of colors that tend to reach toward the reader are ____________________ colors.

When Excel recognizes that you entered a date in mm / dd / yy format,it automatically formats the date as ____________________.

Which of the following calculations multiplies 23 by 0.01?

To print a range of cells in the active worksheet,click ____ in the Settings area in the Print gallery.

Which of the following is the path to the Spelling button?

A ____ is text and graphics that print at the top of each page.

Excel attempts to guess which cells you want to include in the function by looking for ranges that are adjacent to the selected cell and that contain numeric data.

Creating a Worksheet and a Chart

Working With Large Worksheets,Charting,and What-If Analysis

Financial Functions,Data Tables,and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters