Question 1

According to the order of operation in Excel:

Accepted Answer

A)  Excel performs exponentiation, then multiplication and division, then addition, and subtraction. 
B)  Excel performs multiplication, then exponentiation, then division, then addition, and then subtraction. 
C)  Excel performs exponentiation, then multiplication, then division, then subtraction, and then addition. 
D)  Excel performs multiplication, then division, then exponentiation, then addition, and then subtraction. 
A)  Excel performs exponentiation, then multiplication and division, then addition, and subtraction. 
B)  Excel performs multiplication, then exponentiation, then division, then addition, and then subtraction. 
C)  Excel performs exponentiation, then multiplication, then division, then subtraction, and then addition. 
D)  Excel performs multiplication, then division, then exponentiation, then addition, and then subtraction.

Question 2

An adjacent range is a collection of separate ranges._________________________

Accepted Answer

A) True 
 B)False

Question 3

A(n)____________________ is a named operation that replaces the arithmetic expression in a formula.

Accepted Answer

The answer of A(n)____________________ is a named operation that replaces...

Question 4

Keyboard ____________________ can help you work faster and more efficiently because you can keep your hands on the keyboard.

Accepted Answer

The answer of Keyboard ____________________ can help you work faster...

Question 5

AutoFit changes the column width or row height to display the longest or tallest entry within the column or row._________________________

Accepted Answer

A) True 
 B)False

Question 6

A ScreenTip is a box with descriptive text about a command that appears when you point to a button on the ribbon._________________________

Accepted Answer

A) True 
 B)False

Question 7

The formula bar displays the value or formula of the active cell._________________________

Accepted Answer

A) True 
 B)False

Question 8

The active cell is highlighted with a thick green border,its cell reference appears in the ____________________,and the corresponding column and row headings are highlighted.

Accepted Answer

The answer of The active cell is highlighted with a...

Question 9

Numeric data is any number that can be used in a mathematical calculation._________________________

Accepted Answer

A) True 
 B)False

Question 10

To move the active cell up one row,press ____.

Accepted Answer

A)  Shift + Enter 
B)  Ctrl + Tab 
C)  Shift + Tab 
D)  Ctrl + Enter 
A)  Shift + Enter 
B)  Ctrl + Tab 
C)  Shift + Tab 
D)  Ctrl + Enter

Question 11

Which of the following takes precedence over multiplication?

Accepted Answer

A)  division 
B)  exponentiation 
C)  addition 
D)  subtraction 
A)  division 
B)  exponentiation 
C)  addition 
D)  subtraction

Question 12

Ctrl + G is used to access the ____.

Accepted Answer

A)  Go to Next worksheet command 
B)  G column 
C)  Go to a location in the worksheet command 
D)  formula view 
A)  Go to Next worksheet command 
B)  G column 
C)  Go to a location in the worksheet command 
D)  formula view

Question 13

When you insert a new row,the existing rows are shifted down and the new row has the same width as the row above it._________________________

Accepted Answer

A) True 
 B)False

Question 14

The range reference for a(n)____________________ range includes the range reference to each range,separated by a semicolon.

Accepted Answer

The answer of The range reference for a(n)____________________ range includes...

Question 15

In the formula,=2+6*2,addition would be calculated after multiplication._________________________

Accepted Answer

A) True 
 B)False

Question 16

Identify the letter of the choice that best matches the phrase or definition.
-Shows the contents of the worksheet.

Accepted Answer

A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)minimize button
J)template 
A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)minimize button
J)template

Question 17

mm/dd/yyyy is known as ____.

Accepted Answer

A)  a text string 
B)  text data 
C)  a date format 
D)  number data 
A)  a text string 
B)  text data 
C)  a date format 
D)  number data

Question 18

Identify the letter of the choice that best matches the phrase or definition.
-A preformatted workbook with many design features and some content already filled in.

Accepted Answer

A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)minimize button
J)template 
A) function 
B) Name box 
C) worksheet 
D) range 
E) order of operations
F)sheet tabs
G)Ctrl
H)Normal view
I)minimize button
J)template

Question 19

What is the result of the expression =50+20/10*5?

Accepted Answer

A)  60 
B)  1 
C)  25 
D)  50 
A)  60 
B)  1 
C)  25 
D)  50

Question 20

The AutoComplete feature automatically completes an entry based on previous entries in a column._________________________

Accepted Answer

A) True 
 B)False

According to the order of operation in Excel:

An adjacent range is a collection of separate ranges._________________________

A(n)____________________ is a named operation that replaces the arithmetic expression in a formula.

Keyboard ____________________ can help you work faster and more efficiently because you can keep your hands on the keyboard.

AutoFit changes the column width or row height to display the longest or tallest entry within the column or row._________________________

A ScreenTip is a box with descriptive text about a command that appears when you point to a button on the ribbon._________________________

The formula bar displays the value or formula of the active cell._________________________

The active cell is highlighted with a thick green border,its cell reference appears in the ____________________,and the corresponding column and row headings are highlighted.

Numeric data is any number that can be used in a mathematical calculation._________________________

To move the active cell up one row,press ____.

Which of the following takes precedence over multiplication?

Ctrl + G is used to access the ____.

When you insert a new row,the existing rows are shifted down and the new row has the same width as the row above it._________________________

The range reference for a(n)____________________ range includes the range reference to each range,separated by a semicolon.

In the formula,=2+6*2,addition would be calculated after multiplication._________________________

Identify the letter of the choice that best matches the phrase or definition. -Shows the contents of the worksheet.

mm/dd/yyyy is known as ____.

Identify the letter of the choice that best matches the phrase or definition. -A preformatted workbook with many design features and some content already filled in.

What is the result of the expression =50+20/10*5?

The AutoComplete feature automatically completes an entry based on previous entries in a column._________________________

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What-If Analyses

Analyzing Data With Business Intelligence

Collaborating on a Shared Workbook

Working With Text Functions

Filters

Exam 1: Getting Started With Excel

According to the order of operation in Excel:

An adjacent range is a collection of separate ranges._________________________

A(n)____________________ is a named operation that replaces the arithmetic expression in a formula.

Keyboard ____________________ can help you work faster and more efficiently because you can keep your hands on the keyboard.

AutoFit changes the column width or row height to display the longest or tallest entry within the column or row._________________________

A ScreenTip is a box with descriptive text about a command that appears when you point to a button on the ribbon._________________________

The formula bar displays the value or formula of the active cell._________________________

The active cell is highlighted with a thick green border,its cell reference appears in the ____________________,and the corresponding column and row headings are highlighted.

Numeric data is any number that can be used in a mathematical calculation._________________________

To move the active cell up one row,press ____.

Which of the following takes precedence over multiplication?

Ctrl + G is used to access the ____.

When you insert a new row,the existing rows are shifted down and the new row has the same width as the row above it._________________________

The range reference for a(n)____________________ range includes the range reference to each range,separated by a semicolon.

In the formula,=2+6*2,addition would be calculated after multiplication._________________________

Identify the letter of the choice that best matches the phrase or definition. -Shows the contents of the worksheet.

mm/dd/yyyy is known as ____.

Identify the letter of the choice that best matches the phrase or definition. -A preformatted workbook with many design features and some content already filled in.

What is the result of the expression =50+20/10*5?

The AutoComplete feature automatically completes an entry based on previous entries in a column._________________________

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Working With Excel Tables, Pivottables, and Pivotcharts

Managing Multiple Worksheets and Workbooks

Developing an Excel Application

Working With Advanced Functions

Exploring Financial Tools and Functions

Performing What-If Analyses

Analyzing Data With Business Intelligence

Collaborating on a Shared Workbook

Working With Text Functions

Filters