Question 1

The range automatically selected by Excel is always correct.

Accepted Answer

A) True 
 B)False

Question 2

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

Accepted Answer

A) True 
 B)False

Question 3

The AVERAGE function requires that the argument be included within parentheses following the function name.

Accepted Answer

A) True 
 B)False

Question 4

The default view in Excel is called ____ view.

Accepted Answer

A)  Normal 
B)  Standard 
C)  Basic 
D)  Values 
A)  Normal 
B)  Standard 
C)  Basic 
D)  Values

Question 5

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

Accepted Answer

A)  Formula Finder 
B)  Range Finder 
C)  Calculation Finder 
D)  Function Finder 
A)  Formula Finder 
B)  Range Finder 
C)  Calculation Finder 
D)  Function Finder

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

When you decrease the row height to ____, the row is hidden.

Accepted Answer

A)  0 
B)  1 
C)  2 
D)  3 
A)  0 
B)  1 
C)  2 
D)  3

Question 8

All of the following are valid Excel arithmetic operators EXCEPT ____.

Accepted Answer

A)  ^ 
B)  * 
C)  % 
D)  > 
A)  ^ 
B)  * 
C)  % 
D)  >

Question 9

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 10

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 11

Critical Thinking Questions Case 2-1
Leo, owner of Leo's Bread Company, recently installed Excel 2013 and created a new workbook to track sales of different types of bread. He wants to determine which types of bread are the most popular among his customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo has formatted the sales numbers with the Accounting number format.
Leo wants the sales numbers for rye bread, onion rolls, and bagels to look different each time the sales for each exceeds $500. What Excel feature can Leo use to accomplish this?

Accepted Answer

A)  Spell checker 
B)  Conditional formatting 
C)  Point mode 
D)  Formulas version 
A)  Spell checker 
B)  Conditional formatting 
C)  Point mode 
D)  Formulas version

Question 12

Critical Thinking Questions Case 2-1
Leo, owner of Leo's Bread Company, recently installed Excel 2013 and created a new workbook to track sales of different types of bread. He wants to determine which types of bread are the most popular among his customers. He is particularly interested in sales of rye bread, onion rolls, and bagels. Leo has formatted the sales numbers with the Accounting number format.
After Leo enters the sales numbers into the cells, he decides he does not want the fixed dollar sign to appear on the far left of the cell, separated by spaces from the actual value. He would prefer that the dollar sign appear immediately to the left of the first digit of the value. To specify a floating dollar sign, which of the following formats should Leo apply?

Accepted Answer

A)  Comma style 
B)  Percent style 
C)  Currency style 
D)  General number 
A)  Comma style 
B)  Percent style 
C)  Currency style 
D)  General number

Question 13

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

Accepted Answer

A) True 
 B)False

Question 14

You can press the ____________________ key to quit Range Finder.

Accepted Answer

The answer of You can press the ____________________ key to...

Question 15

While holding down the ALT key, you can select nonadjacent ranges and cells. _________________________

Accepted Answer

A) True 
 B)False

Question 16

A formula in a cell that contains a reference back to itself is called a(n) ____________________.

Accepted Answer

The answer of A formula in a cell that contains...

Question 17

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

Accepted Answer

The answer of The ____________________ is a small black square...

Question 18

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 19

The / arithmetic operator indicates ____________________.

Accepted Answer

The answer of The / arithmetic operator indicates ____________________....

Question 20

A ____ is text and graphics that print at the bottom of every page.

Accepted Answer

A)  footer 
B)  toe 
C)  margin 
D)  stopper 
A)  footer 
B)  toe 
C)  margin 
D)  stopper

The range automatically selected by Excel is always correct.

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

The AVERAGE function requires that the argument be included within parentheses following the function name.

The default view in Excel is called ____ view.

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

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

When you decrease the row height to ____, the row is hidden.

All of the following are valid Excel arithmetic operators EXCEPT ____.

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

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

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

You can press the ____________________ key to quit Range Finder.

While holding down the ALT key, you can select nonadjacent ranges and cells. _________________________

A formula in a cell that contains a reference back to itself is called a(n) ____________________.

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

The ____ function displays the highest value in a range.

The / arithmetic operator indicates ____________________.

A ____ is text and graphics that print at the bottom of every page.

Access 1 Databases and Database Objects: an Introduction

Access 2 Querying a Database

Excel 1 Creating a Worksheet and a Chart

Ppt 1 Creating and Editing a Presentation With Pictures

Ppt 2 Enhancing a Presentation With Pictures, Shapes, and Wordart

Word 1 Creating, Formatting, and Editing a Word Document With a Picture

Word 2 Creating a Research Paper With References and Sources

Office 2016 and Windows 10: Essential Concepts and Skills

Productivity Apps for School and Work

Filters

Exam 4: Excel 2 Formulas, Functions, and Formatting

The range automatically selected by Excel is always correct.

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

The AVERAGE function requires that the argument be included within parentheses following the function name.

The default view in Excel is called ____ view.

You can use the ____ to check which cells are referenced in the formula assigned to the active cell.

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

When you decrease the row height to ____, the row is hidden.

All of the following are valid Excel arithmetic operators EXCEPT ____.

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

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

To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.

You can press the ____________________ key to quit Range Finder.

While holding down the ALT key, you can select nonadjacent ranges and cells. _________________________

A formula in a cell that contains a reference back to itself is called a(n) ____________________.

The ____________________ is a small black square in the lower-right corner of the active cell or active range.

The ____ function displays the highest value in a range.

The / arithmetic operator indicates ____________________.

A ____ is text and graphics that print at the bottom of every page.

Access 1 Databases and Database Objects: an Introduction

Access 2 Querying a Database

Excel 1 Creating a Worksheet and a Chart

Ppt 1 Creating and Editing a Presentation With Pictures

Ppt 2 Enhancing a Presentation With Pictures, Shapes, and Wordart

Word 1 Creating, Formatting, and Editing a Word Document With a Picture

Word 2 Creating a Research Paper With References and Sources

Office 2016 and Windows 10: Essential Concepts and Skills

Productivity Apps for School and Work

Filters