Question 1

An adjacent range is a collection of separate ranges.

Accepted Answer

A) True 
 B)False  False

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

When you insert a new column, the existing columns are shifted to the ____ and the new column has the same width as the column directly to its left

Accepted Answer

A)   right
B)   up
C)   down
D)   left A

Question 4

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

Accepted Answer

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

Question 5

A formula is written using operands that combine different values, resulting in a single value that is then displayed in the cell. _________________________

Accepted Answer

A) True 
 B)False

Question 6

MATCHING
-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)  Name box
C)  worksheet
D)  range
E)  order of operationsF) sheet tabsG) CtrlH) Normal viewI) formula viewJ) template

Question 7

MATCHING
-Shows the contents of the worksheet

Accepted Answer

A)  function
B)  Name box
C)  worksheet
D)  range
E)  order of operationsF) sheet tabsG) CtrlH) Normal viewI) formula viewJ) template

Question 8

Tyler has created a spreadsheet to keep track of his customers for his house-sitting business. In the spreadsheet, he includes the owners' names, addresses, phone number, and number of days his services are needed.
-Tyler notices that the Address column is too wide. He could use that extra space for other columns so he ____.

Accepted Answer

A)   autofits the column by double-clicking the cell with the longest entry
B)   autofits the column by double-clicking its border
C)   autofits the column by selecting it, then clicking the AutoFit button in the Cells group
D)   places the mouse pointer on the column border and drags to the right

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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...

Question 11

The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions.

Accepted Answer

A)   database
B)   spreadsheet
C)   expression
D)   formula

Question 12

"AZ" is an example of a ____.

Accepted Answer

A)   column heading
B)   row heading
C)   cell reference
D)   Name box

Question 13

-In the figure above, Box 1 points to the formula =F13*G13 in the ____.

Accepted Answer

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

Question 14

The order of operations for arithmetic operators is exponentiation, multiplication, division, addition, and then 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

The answer of The order of operations for arithmetic operators...

Question 15

A common business practice is to include a worksheet named Documentation that contains a description of the workbook, the name of the person who prepared the workbook, and the date it was created. _________________________

Accepted Answer

A) True 
 B)False

Question 16

____________________ view shows how the worksheet will appear when printed.

Accepted Answer

The answer of ____________________ view shows how the worksheet will...

Question 17

Which of the following takes precedence over multiplication?

Accepted Answer

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

Question 18

To move or copy a range of cells, select the correct order:
1) Move the pointer over the border of the selection until the pointer changes shape.
2) Select the cell or range you want to move or copy.
3) To move the range, click the border and drag the selection to a new location, or to copy the range, hold down the Ctrl key and drag the selection to a new location.

Accepted Answer

A)   1,2,3
B)   3,2,1
C)   1,3,2
D)   2,1,3

Question 19

The formula used to multiply cell A1 by cell C1 is ____.

Accepted Answer

A)   =A1*C1
B)   C1*A1
C)   =A1/C1
D)   A1*C1

Question 20

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.

Accepted Answer

A)   semi-colon
B)   period
C)   colon
D)   comma

Exam 6: Getting Started With Excel

An adjacent range is a collection of separate ranges.

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

When you insert a new column, the existing columns are shifted to the ____ and the new column has the same width as the column directly to its left

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

A formula is written using operands that combine different values, resulting in a single value that is then displayed in the cell. _________________________

MATCHING -When you copy a range of cells, you must press this key while you drag the selection to its new location

MATCHING -Shows the contents of the worksheet

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

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

The advantage of an electronic ____ is that the content can be easily edited and updated to reflect changing financial conditions.

"AZ" is an example of a ____.

-In the figure above, Box 1 points to the formula =F13*G13 in the ____.

A common business practice is to include a worksheet named Documentation that contains a description of the workbook, the name of the person who prepared the workbook, and the date it was created. _________________________

____________________ view shows how the worksheet will appear when printed.

Which of the following takes precedence over multiplication?

The formula used to multiply cell A1 by cell C1 is ____.

Each range is identified with a range reference that includes the cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a ____.