Question 1

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A group of worksheet cells

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

Question 2

To go to column A of the current row,click ____.

Accepted Answer

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

Question 3

A(n)____ is a group of cells.

Accepted Answer

A)  cluster 
B)  adjunct 
C)  selection 
D)  range

Question 4

Text is truncated when the cell that it resides in is not wide enough to display all of it.

Accepted Answer

A) True 
 B)False

Question 5

-Referring to the figure above,the intersection of each row and column is called a cell.

Accepted Answer

A) True 
 B)False

Question 6

You can use the Go To dialog box to navigate to a specific worksheet.

Accepted Answer

A) True 
 B)False

Question 7

The ____________________ bar displays the contents of an active cell.

Accepted Answer

The answer of The ____________________ bar displays the contents of...

Question 8

MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A named operation that returns a value

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

Question 9

Text data is any combination of ____.

Accepted Answer

A)  letters and numbers 
B)  letters,numbers,and dates 
C)  only letters 
D)  letters,numbers,and symbols

Question 10

An Excel worksheet can have a maximum of ____ columns in a worksheet.

Accepted Answer

A)  156 
B)  256 
C)  16,385 
D)  17 million

Question 11

Text is right-aligned in cells,like number data.

Accepted Answer

A) True 
 B)False

Question 12

You have three teenage children to whom you have given cellular phones.You wish to record the monthly statements for each child's phone usage in Excel because the children have been given an incentive to keep their yearly bill under $1000.00.Do you decide to create three Excel workbooks or one Excel workbook with three worksheets and why?

Accepted Answer

The answer of You have three teenage children to whom...

Question 13

The name of the active workbook appears in the status bar of the Excel window.

Accepted Answer

A) True 
 B)False

Question 14

The contents of an active cell are displayed in the ____.

Accepted Answer

A)  toolbar 
B)  menu bar 
C)  name box 
D)  formula bar

Question 15

The ____ command gives you precise control in setting column widths and row heights.

Accepted Answer

A)  Format 
B)  AutoFit 
C)  Insert 
D)  Cells

Question 16

To change the order of operations,enclose part of the formula in ____.

Accepted Answer

A)  brackets 
B)  italics 
C)  parentheses 
D)  quotation marks

Question 17

Sam now wants to find out how much money he will make on his largest order,which is currently in row E.Cell E4 contains the number of items ordered and cell E5 contains the price per item.An appropriate formula would be ____.

Accepted Answer

A)  =E4+E5 
B)  =E5/E4 
C)  =E4*E5 
D)  =E4^E5

Question 18

Sam decides to rename his worksheet "Sam's Ceramic Business Worksheet" but he is unable to complete the word Worksheet because ____.

Accepted Answer

A)  Excel only allows for 3 words in a sheet name 
B)  Excel only allows for 31 characters in a sheet name 
C)  Excel only allows one word in a sheet name 
D)  Excel does not allow for symbols such as the apostrophe in Sam's in sheet names

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

Each cell is identified by a cell ____________________,which is its column and row location.

Accepted Answer

The answer of Each cell is identified by a cell...

Exam 1: Getting Started With Excel

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A group of worksheet cells

To go to column A of the current row,click ____.

A(n) ____ is a group of cells.

Text is truncated when the cell that it resides in is not wide enough to display all of it.

-Referring to the figure above,the intersection of each row and column is called a cell.

You can use the Go To dialog box to navigate to a specific worksheet.

The ____________________ bar displays the contents of an active cell.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -A named operation that returns a value

Text data is any combination of ____.

An Excel worksheet can have a maximum of ____ columns in a worksheet.

Text is right-aligned in cells,like number data.

The name of the active workbook appears in the status bar of the Excel window.

The contents of an active cell are displayed in the ____.

The ____ command gives you precise control in setting column widths and row heights.

To change the order of operations,enclose part of the formula in ____.

Sam now wants to find out how much money he will make on his largest order,which is currently in row E.Cell E4 contains the number of items ordered and cell E5 contains the price per item.An appropriate formula would be ____.

Sam decides to rename his worksheet "Sam's Ceramic Business Worksheet" but he is unable to complete the word Worksheet because ____.

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

Each cell is identified by a cell ____________________,which is its column and row location.