Question 1

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 2

Which of the following happens when you enter the formula =G15 into a cell?

Accepted Answer

A) Excel recalculates all formulas in the worksheet 
B) Excel assigns the sum of the values in the previous 15 cells to the active cell 
C) Excel assigns the value in cell G15 to the active cell 
D) Nothing;=G15 is an invalid formula 
A) Excel recalculates all formulas in the worksheet 
B) Excel assigns the sum of the values in the previous 15 cells to the active cell 
C) Excel assigns the value in cell G15 to the active cell 
D) Nothing;=G15 is an invalid formula

Question 3

-Point mode allows you to ____,as shown in the accompanying figure.

Accepted Answer

A) select cells for use in a formula using the keyboard 
B) select a function from the Sum button list 
C) select cells for use in a formula using the mouse pointer 
D) edit cell contents directly in the cell 
A) select cells for use in a formula using the keyboard 
B) select a function from the Sum button list 
C) select cells for use in a formula using the mouse pointer 
D) edit cell contents directly in the cell

Question 4

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
-Copies a formula.

Accepted Answer

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

Question 5

Which of the following is the path to the Copy and Paste buttons?

Accepted Answer

Question 6

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

Accepted Answer

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

Question 7

To use ____________________ to verify that a formula contains the intended cell references,double-tap or double-click the cell with the formula you want to check.

Accepted Answer

The answer of To use ____________________ to verify that a...

Question 8

When more than one arithmetic operator is involved in a formula,Excel follows the same basic order of ____ that you use in algebra.

Accepted Answer

A) placement 
B) operations 
C) positioning 
D) selections 
A) placement 
B) operations 
C) positioning 
D) selections

Question 9

The most common error when entering a formula is to reference the wrong cell in the formula.

Accepted Answer

A) True 
 B)False

Question 10

The equal sign (=)precedes a formula.

Accepted Answer

A) True 
 B)False

Question 11

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

Question 13

The ____ Option button lists formatting options following an insertion of cells,rows,or columns.

Accepted Answer

A) AutoCorrect 
B) Insert 
C) Auto Fill 
D) Paste 
A) AutoCorrect 
B) Insert 
C) Auto Fill 
D) Paste

Question 14

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 15

The default font for the Basis theme is different than the default font for the Office theme.

Accepted Answer

A) True 
 B)False

Question 16

You can use the arrow keys to complete an entry in Point mode.

Accepted Answer

A) True 
 B)False

Question 17

The arithmetic operator,^,directs Excel to perform the division operation.

Accepted Answer

A) True 
 B)False

Question 18

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Accepted Answer

A) 	Normal 
B) 	Page Layout 
C) 	Page Break Preview 
D) 	Full Screen 
A) 	Normal 
B) 	Page Layout 
C) 	Page Break Preview 
D) 	Full Screen

Question 19

Which of the following are valid formulas?

Accepted Answer

A) =3 ^ 4 
B) =H3/H11 
C) =11+9 
D) =22-F15 
A) =3 ^ 4 
B) =H3/H11 
C) =11+9 
D) =22-F15

Question 20

The / arithmetic operator indicates ____________________.

Accepted Answer

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

The default view in Excel is called ____ view.

Which of the following happens when you enter the formula =G15 into a cell?

-Point mode allows you to ____,as shown in the accompanying figure.

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 -Copies a formula.

Which of the following is the path to the Copy and Paste buttons?

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

To use ____________________ to verify that a formula contains the intended cell references,double-tap or double-click the cell with the formula you want to check.

When more than one arithmetic operator is involved in a formula,Excel follows the same basic order of ____ that you use in algebra.

The most common error when entering a formula is to reference the wrong cell in the formula.

The equal sign (=)precedes a formula.

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

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

The ____ Option button lists formatting options following an insertion of cells,rows,or columns.

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

The default font for the Basis theme is different than the default font for the Office theme.

You can use the arrow keys to complete an entry in Point mode.

The arithmetic operator,^,directs Excel to perform the division operation.

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Which of the following are valid formulas?

The / arithmetic operator indicates ____________________.

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

The default view in Excel is called ____ view.

Which of the following happens when you enter the formula =G15 into a cell?

-Point mode allows you to ____,as shown in the accompanying figure.

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 -Copies a formula.

Which of the following is the path to the Copy and Paste buttons?

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

To use ____________________ to verify that a formula contains the intended cell references,double-tap or double-click the cell with the formula you want to check.

When more than one arithmetic operator is involved in a formula,Excel follows the same basic order of ____ that you use in algebra.

The most common error when entering a formula is to reference the wrong cell in the formula.

The equal sign (=)precedes a formula.

Best fit means that the width of the column will be increased or decreased by a percentage you specify.

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

The ____ Option button lists formatting options following an insertion of cells,rows,or columns.

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

The default font for the Basis theme is different than the default font for the Office theme.

You can use the arrow keys to complete an entry in Point mode.

The arithmetic operator,^,directs Excel to perform the division operation.

____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

Which of the following are valid formulas?

The / arithmetic operator indicates ____________________.

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