Question 1

To start a new line in a cell,press the ____ keys.

Accepted Answer

A) CTRL+ENTER 
B) TAB+ENTER 
C) ALT+ENTER 
D) SHIFT+ENTER 
A) CTRL+ENTER 
B) TAB+ENTER 
C) ALT+ENTER 
D) SHIFT+ENTER C

Question 2

Using the Excel spell checker,you can ____.

Accepted Answer

A) check the spelling in a single cell 
B) check the spelling of words in a selected range 
C) add words to the dictionary 
D) add words to the AutoCorrect list 
A) check the spelling in a single cell 
B) check the spelling of words in a selected range 
C) add words to the dictionary 
D) add words to the AutoCorrect list A,B,C,D

Question 3

When you enter a two-digit year that is less than 30,Excel changes the year to ____.

Accepted Answer

A) 20xx 
B) 30xx 
C) 18xx 
D) 19xx 
A) 20xx 
B) 30xx 
C) 18xx 
D) 19xx A

Question 4

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

Accepted Answer

A) DIVSUM 
B) RANGEAVG 
C) AVERAGE 
D) MAX 
A) DIVSUM 
B) RANGEAVG 
C) AVERAGE 
D) MAX

Question 5

When Excel follows the order of operations,the formula,8 * 3 + 2,equals ____.

Accepted Answer

A) 40 
B) 26 
C) 48 
D) 13 
A) 40 
B) 26 
C) 48 
D) 13

Question 6

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

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

As in algebra,you can use brackets to override the order of operations Excel follows to perform formula calculations.

Accepted Answer

A) True 
 B)False

Question 9

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 10

You should ____ a function name in the Formula AutoComplete list to select the function.

Accepted Answer

A) double-click or double-tap 
B) click or tap 
C) right-click or triple-tap 
D) none of the above 
A) double-click or double-tap 
B) click or tap 
C) right-click or triple-tap 
D) none of the above

Question 11

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 12

You cannot format an entire column at once.

Accepted Answer

A) True 
 B)False

Question 13

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 14

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

Accepted Answer

The answer of While holding down the ALT key,you can...

Question 15

Which of the following is the path to the Conditional Formatting button?

Accepted Answer

Question 16

A(n)____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

Accepted Answer

A) contiguous 
B) indexed 
C) direct 
D) indirect 
A) contiguous 
B) indexed 
C) direct 
D) indirect

Question 17

In the order of operations,the last operation Excel performs is ____________________.

Accepted Answer

subtractio

Question 18

Which of the following is the path to the Comma Style button?

Accepted Answer

Question 19

A(n)____________________ is a dot on the screen that contains a color.

Accepted Answer

The answer of A(n)____________________ is a dot on the screen...

Question 20

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
a.ALT+ENTER
f.CTRL+1
b.order of operations
g.function
c.circular reference
h.F7
d.MAX
i.CTRL+ACCENT MARK (`)
e.CTRL+C
j.CTRL+V
-Negation comes first in this.

Accepted Answer

The answer of MATCHING
Identify the letter of the choice that...

To start a new line in a cell,press the ____ keys.

Using the Excel spell checker,you can ____.

When you enter a two-digit year that is less than 30,Excel changes the year to ____.

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

When Excel follows the order of operations,the formula,8 * 3 + 2,equals ____.

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

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

As in algebra,you can use brackets to override the order of operations Excel follows to perform formula calculations.

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

You should ____ a function name in the Formula AutoComplete list to select the function.

The ____ function displays the highest value in a range.

You cannot format an entire column at once.

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

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

Which of the following is the path to the Conditional Formatting button?

A(n)____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

In the order of operations,the last operation Excel performs is ____________________.

Which of the following is the path to the Comma Style button?

A(n)____________________ is a dot on the screen that contains a color.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+ENTER f.CTRL+1 b.order of operations g.function c.circular reference h.F7 d.MAX i.CTRL+ACCENT MARK (`) e.CTRL+C j.CTRL+V -Negation comes first in this.

Introduction to Technology

Office 365 Essentials

Office 2013 and Windows 8 Essential Concepts and Skills

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Excel: Creating a Worksheet and a Chart

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

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

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

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Filters

Exam 8: Excel: Formulas, Functions, and Formatting

To start a new line in a cell,press the ____ keys.

Using the Excel spell checker,you can ____.

When you enter a two-digit year that is less than 30,Excel changes the year to ____.

The ____ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.

When Excel follows the order of operations,the formula,8 * 3 + 2,equals ____.

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

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

As in algebra,you can use brackets to override the order of operations Excel follows to perform formula calculations.

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

You should ____ a function name in the Formula AutoComplete list to select the function.

The ____ function displays the highest value in a range.

You cannot format an entire column at once.

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

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

Which of the following is the path to the Conditional Formatting button?

A(n)____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

In the order of operations,the last operation Excel performs is ____________________.

Which of the following is the path to the Comma Style button?

A(n)____________________ is a dot on the screen that contains a color.

MATCHING Identify the letter of the choice that best matches the phrase or definition. a.ALT+ENTER f.CTRL+1 b.order of operations g.function c.circular reference h.F7 d.MAX i.CTRL+ACCENT MARK (`) e.CTRL+C j.CTRL+V -Negation comes first in this.

Introduction to Technology

Office 365 Essentials

Office 2013 and Windows 8 Essential Concepts and Skills

Access: Databases and Database Objects: an Introduction

Access: Querying a Database

Access: Maintaining a Database

Excel: Creating a Worksheet and a Chart

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

Outlook: Managing Email Messages With Outlook

Outlook: Managing Calendars With Outlook

Powerpoint: Creating and Editing a Presentation With Pictures

Powerpoint: Enhancing a Presentation With Pictures, Shapes, and Wordart

Powerpoint: Reusing a Presentation and Adding Media and Animation

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

Word: Creating a Research Paper With References and Sources

Word: Creating a Business Letter With a Letterhead and Table

Filters