Question 1

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

Accepted Answer

subtractio

Question 2

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 3

Using the Excel spell checker,you can ____.

Accepted Answer

A)  check the spelling of words in a selected range 
B)  add words to the dictionary 
A)  check the spelling of words in a selected range 
B)  add words to the dictionary

Question 4

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

Accepted Answer

A) True 
 B)False

Question 5

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 6

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

One of the reasons Excel is such a valuable tool is that you can assign a(n)____________________ to a cell,and Excel will calculate the result.

Accepted Answer

The answer of One of the reasons Excel is such...

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

Which of the following calculations multiplies 23 by 0.01?

Using the Excel spell checker,you can ____.

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

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

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

Which of the following are valid formulas?

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

One of the reasons Excel is such a valuable tool is that you can assign a(n)____________________ to a cell,and Excel will calculate the result.

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 Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

Exam 2: Formulas, Functions, and Formatting

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

Which of the following calculations multiplies 23 by 0.01?

Using the Excel spell checker,you can ____.

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

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

Point mode allows you to select cells for use in a formula by using your finger or the pointer.

Which of the following are valid formulas?

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

One of the reasons Excel is such a valuable tool is that you can assign a(n)____________________ to a cell,and Excel will calculate the result.

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 Screenshots

Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

Formula Auditing, Data Validation, and Complex Problem Solving

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters