Lesson 1-3

Question 1

What is an Excel file that stores all the info, previous calculations, and analyses that you may have already completed and must contain at least one worksheet?

Answer 1

Workbook

Question 2

Are rows or columns numbered?

Answer 2

rows

Question 3

Are rows or columns lettered?

Answer 3

columns

Question 4

What contains data and calculations and is organized into a collection of cells arranged in the form of a table?

Answer 4

worksheet

Question 5

What are the rectangular boxes in a worksheet that store individual pieces of data/calculations called?

Answer 5

cells

Question 6

What is called when a cell is defined by the column letter and the row number that correspond to that individual cell?

Answer 6

Cell addressing scheme

Question 7

What is a group of cells in a continuous block called?

Answer 7

a range

Question 8

What does the “Fill” feature do?

Answer 8

Allows you to automatically populate cells

Question 9

What data is descriptive, such as name, location, gender called?

Answer 9

Qualitative

Question 10

What is data that is numerical and generally used as the basis for calculations called

Answer 10

Quantitative

Question 11

What is used to organize and summarize large amounts of data and also allows users to change how they summarize data and look at it in different ways?

Answer 11

PivotTables

Question 12

What function gives you all of the cells you entered added together?

Answer 12

SUM function

Question 13

What function counts the number of cells in a range of cells that contain numbers?

Answer 13

COUNT function

Question 14

What function counts the number of cells within a range of cells that are not blank?

Answer 14

COUNTA function

Question 15

What function calculates the simple average of a set of numbers?

Answer 15

AVERAGE function

Question 16

What function returns the largest value in a set of numbers?

Answer 16

MAX function

Question 17

What function returns the smallest value in a set of numbers?

Answer 17

MIN function

Question 18

What function calculates the interest rate earned for an investment given the number of payments made as a part of the investment, the payment amount, and the current value of the investment?

Answer 18

RATE function

Question 19

What function calculates the annual percentage rate for an interest rate given the number of times per year that interest is charged?

Answer 19

EFFECT function

Question 20

What function calculates the payment amount for a loan given the interest rate, number of payments to be made to pay off loan, and the original loan amount?

Answer 20

PMT function

Question 21

What function calculates the number of payments that will be made to pay off a loan given the interest rate, payment amount, and original loan amount?

Answer 21

NPER function

Question 22

What function calculates the current value (accounting for compounding interest) of an investment given the interest rate, number of payments to be made to pay off the loan, and the amount of the payment?

Answer 22

PV function

Question 23

What function calculates the future value of an investment given the interest rate, the number of payments to be made, and the amount of the payment?

Answer 23

FV function

Question 24

What stands for the number of payments?

Answer 24

NPER

Question 25

What stands for the payment amount?

Answer 25

PMT

Question 26

What stands for original loan amount?

Answer 26

PV

Question 27

What stands for future value?

Answer 27

FV

Question 28

What stands for the interest rate quoted on the loan?

Answer 28

nominal rate

Question 29

What stands for the number of times per year that interest will be charged?

Answer 29

NPERY