Midterm Review

Question 1

Clicking the ___ buttom sums the adjacent range above or to the left

Accepted Answer

sum

Question 2

The $ symbol placed before a row or column address indicates a (n)_____ cell reference.

Accepted Answer

absolute

Question 3

What is the mission of an organization?

Accepted Answer

the reason an organization exists

Question 4

If cell A1 contained 10, A2 contained 2 and cell A3 contains =A1^A2, what would cell A3 show?

Accepted Answer

100

Question 5

You can use a spreadsheet to ___ by using variable values to investigate and sample outcomes

Accepted Answer

create what-if data scenarios

Question 6

Which of the following best describes a large company?

Accepted Answer

500+ employees

Question 7

D8+E8*.05 is a complex formula

Accepted Answer

TRUE

Question 8

_______ operators perform mathematical calculations such as adding and subtracting.

Accepted Answer

arithmetic

Question 9

Which of the following statements is true?

Accepted Answer

values help companies fulfill their mission

Question 10

Excel recognizes an entry as a value if it is a number or it begins with

Accepted Answer

all of the above

Question 11

Using the order of precedence, these formulas will calculate the same result: 22/5*5 = 22/(2*5)

Accepted Answer

FALSE

Question 12

Following order of operations, a formula calculates addition first, then multiplication

Accepted Answer

FALSE

Question 13

A (n)________ is an equation in a worksheet,

Accepted Answer

formula

Question 14

In a worksheet, the _____ is called the formula prefix.

Accepted Answer

equal sign (=)

Question 15

In this formula, =(A6*A*)+$D$1, cell references (A6*A8) are relatives cell refences.

Accepted Answer

TRUE

Question 16

The Excel operator for exponent is

Accepted Answer

^

Question 17

You type formulas in Excel to perform calculations such as adding, multiplying, and averaging.

Accepted Answer

TRUE

Question 18

____ is a built-in formula that uses arguments to calculate information.

Accepted Answer

function

Question 19

If cell A1 contained 10, cell A2 contained 2, and cell A3 contained =A1/A2, what shows in A3?

Accepted Answer

5

Question 20

The Excel operator for division is

Accepted Answer

/

Question 21

Formula AutoComplete feature suggests functions depending on the letters typed by the user

Accepted Answer

TRUE

Question 22

Predefined formulas in Excel are called functions and can be access by using insert function

Accepted Answer

TRUE

Question 23

Absolute cell references change the cell references when the formulas is copied to a new place

Accepted Answer

FALSE

Question 24

______ is an entry in a cell that contains text such as "2011 sales" or "Travel Expenses".

Accepted Answer

label

Question 25

Which of the following does a Chief Financial Officer not usually oversee?

Accepted Answer

Marketing

Question 26

All Excel formulas begin with the

Accepted Answer

equal sign

Question 27

Order of operations for arithmetic says that calculations within parentheses are performed last

Accepted Answer

FALSE

Question 28

Which of the following best describes a functional organizational structure?

Accepted Answer

An organization that groups departments by types of jobs

Midterm Review

Questions 28

Midterm Review

Questions 28