Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Displays the name of the sheets in the workbook

Accepted Answer

A) function 
B) workbook 
C) worksheet 
D) range 
E) order of precedence
F)Name box
G)Ctrl
H)Normal view
I)AutoSum button
J)what-if analysis
K)formula view
L)sheet tabs 
A) function 
B) workbook 
C) worksheet 
D) range 
E) order of precedence
F)Name box
G)Ctrl
H)Normal view
I)AutoSum button
J)what-if analysis
K)formula view
L)sheet tabs

Question 2

Row headings identify each row using a different ____.

Accepted Answer

A)  operator 
B)  number 
C)  letter 
D)  number and letter combination 
A)  operator 
B)  number 
C)  letter 
D)  number and letter combination

Question 3

____ makes it easier to enter repetitive text in cells.

Accepted Answer

A)  Editing mode 
B)  AutoFit 
C)  AutoComplete 
D)  AutoFill 
A)  Editing mode 
B)  AutoFit 
C)  AutoComplete 
D)  AutoFill

Question 4

To view formulas,rather than the resulting values in a worksheet,switch to ____.

Accepted Answer

A)  formula view 
B)  normal view 
C)  editing mode 
D)  AutoSum view 
A)  formula view 
B)  normal view 
C)  editing mode 
D)  AutoSum view

Question 5

Microsoft Excel 2010 stores spreadsheets in files called workbooks.

Accepted Answer

A) True 
 B)False

Question 6

-In the figure above,the formula shown SUM(H6:H9)appears in the ____.

Accepted Answer

A)  address box 
B)  address bar 
C)  formula box 
D)  formula bar 
A)  address box 
B)  address bar 
C)  formula box 
D)  formula bar

Question 7

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Multiplication before addition

Accepted Answer

A) function 
B) workbook 
C) worksheet 
D) range 
E) order of precedence
F)Name box
G)Ctrl
H)Normal view
I)AutoSum button
J)what-if analysis
K)formula view
L)sheet tabs 
A) function 
B) workbook 
C) worksheet 
D) range 
E) order of precedence
F)Name box
G)Ctrl
H)Normal view
I)AutoSum button
J)what-if analysis
K)formula view
L)sheet tabs

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

To change a column width,you can click ____ on the Column submenu to make the column(s)as wide as the longest entry of the cells in the column.

Accepted Answer

A)  QuickFit 
B)  AutoFit 
C)  FullColumn 
D)  Longest 
A)  QuickFit 
B)  AutoFit 
C)  FullColumn 
D)  Longest

Question 10

The order of precedence for arithmetic operators is exponentiation,multiplication,division,addition,subtraction.In your opinion,what is the best order of precedence for the following Excel tasks and why: 1)work in editing mode,2)switch to formula view,3)rename sheet tabs,4)resize columns and rows,5)create a planning analysis sheet,and 6)enter data?

Accepted Answer

Instructors: There is some flexibility i

Question 11

What type of operation does the formula "C9/B10" use?

Accepted Answer

A)  division 
B)  multiplication 
C)  fraction 
D)  exponentiation 
A)  division 
B)  multiplication 
C)  fraction 
D)  exponentiation

Question 12

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 13

It is recommended to set your column widths based on the maximum number of characters you wish to display,rather than ____.

Accepted Answer

A)  pixels 
B)  picas 
C)  points 
D)  decimal spaces 
A)  pixels 
B)  picas 
C)  points 
D)  decimal spaces

Question 14

Sam is happy with the results of the formula.All of a sudden he realizes that the cell that once displayed the result is now displaying the formula and all of the columns are wider.He must have ____.

Accepted Answer

A)  switched to editing mode by double-clicking the results cell 
B)  switched to formula view by pressing Ctrl + Alt 
C)  switched to editing mode by pressing Ctrl + Alt 
D)  switched to formula view by pressing Ctrl + ` 
A)  switched to editing mode by double-clicking the results cell 
B)  switched to formula view by pressing Ctrl + Alt 
C)  switched to editing mode by pressing Ctrl + Alt 
D)  switched to formula view by pressing Ctrl + `

Question 15

Press the ____ key to switch to editing mode.

Accepted Answer

A)  ` (grave key) 
B)  Num Lock 
C)  F2 
D)  F9 
A)  ` (grave key) 
B)  Num Lock 
C)  F2 
D)  F9

Question 16

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-Displays contents of a spreadsheet

Accepted Answer

A) function 
B) workbook 
C) worksheet 
D) range 
E) order of precedence
F)Name box
G)Ctrl
H)Normal view
I)AutoSum button
J)what-if analysis
K)formula view
L)sheet tabs 
A) function 
B) workbook 
C) worksheet 
D) range 
E) order of precedence
F)Name box
G)Ctrl
H)Normal view
I)AutoSum button
J)what-if analysis
K)formula view
L)sheet tabs

Question 17

The newly inserted column has the same width as ____.

Accepted Answer

A)  the original column D 
B)  the original column E 
C)  the default width which is applied to all new columns 
D)  the average width of all columns in the worksheet 
A)  the original column D 
B)  the original column E 
C)  the default width which is applied to all new columns 
D)  the average width of all columns in the worksheet

Question 18

What is the syntax for a SUM formula adding the values of cell F6 to F9?

Accepted Answer

A)  /SUM(F9:F6) 
B)  =SUM(F6/F9) 
C)  =END(F6:F9) 
D)  =SUM(F6:F9) 
A)  /SUM(F9:F6) 
B)  =SUM(F6/F9) 
C)  =END(F6:F9) 
D)  =SUM(F6:F9)

Question 19

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-When you copy a range of cells,you must press this key while you drag the selection to its new location

Accepted Answer

A) function 
B) workbook 
C) worksheet 
D) range 
E) order of precedence
F)Name box
G)Ctrl
H)Normal view
I)AutoSum button
J)what-if analysis
K)formula view
L)sheet tabs 
A) function 
B) workbook 
C) worksheet 
D) range 
E) order of precedence
F)Name box
G)Ctrl
H)Normal view
I)AutoSum button
J)what-if analysis
K)formula view
L)sheet tabs

Question 20

To activate the AutoSum feature,Sam clicks ____.

Accepted Answer

A)  in the cell below the group of cells he wants to add 
B)  in the cell to the right of the last cell in the group of cells he wants to add 
C)  in the formula bar 
D)  in the active cell 
A)  in the cell below the group of cells he wants to add 
B)  in the cell to the right of the last cell in the group of cells he wants to add 
C)  in the formula bar 
D)  in the active cell

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays the name of the sheets in the workbook

Row headings identify each row using a different ____.

____ makes it easier to enter repetitive text in cells.

To view formulas,rather than the resulting values in a worksheet,switch to ____.

Microsoft Excel 2010 stores spreadsheets in files called workbooks.

-In the figure above,the formula shown SUM(H6:H9)appears in the ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Multiplication before addition

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

To change a column width,you can click ____ on the Column submenu to make the column(s)as wide as the longest entry of the cells in the column.

What type of operation does the formula "C9/B10" use?

mm/dd/yyyy is known as ____.

It is recommended to set your column widths based on the maximum number of characters you wish to display,rather than ____.

Sam is happy with the results of the formula.All of a sudden he realizes that the cell that once displayed the result is now displaying the formula and all of the columns are wider.He must have ____.

Press the ____ key to switch to editing mode.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays contents of a spreadsheet

The newly inserted column has the same width as ____.

What is the syntax for a SUM formula adding the values of cell F6 to F9?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -When you copy a range of cells,you must press this key while you drag the selection to its new location

To activate the AutoSum feature,Sam clicks ____.

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters

Exam 1: Getting Started With Excel

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays the name of the sheets in the workbook

Row headings identify each row using a different ____.

____ makes it easier to enter repetitive text in cells.

To view formulas,rather than the resulting values in a worksheet,switch to ____.

Microsoft Excel 2010 stores spreadsheets in files called workbooks.

-In the figure above,the formula shown SUM(H6:H9)appears in the ____.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Multiplication before addition

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

To change a column width,you can click ____ on the Column submenu to make the column(s)as wide as the longest entry of the cells in the column.

What type of operation does the formula "C9/B10" use?

mm/dd/yyyy is known as ____.

It is recommended to set your column widths based on the maximum number of characters you wish to display,rather than ____.

Sam is happy with the results of the formula.All of a sudden he realizes that the cell that once displayed the result is now displaying the formula and all of the columns are wider.He must have ____.

Press the ____ key to switch to editing mode.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Displays contents of a spreadsheet

The newly inserted column has the same width as ____.

What is the syntax for a SUM formula adding the values of cell F6 to F9?

MATCHING Identify the letter of the choice that best matches the phrase or definition. -When you copy a range of cells,you must press this key while you drag the selection to its new location

To activate the AutoSum feature,Sam clicks ____.

Formatting a Workbook

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters