4-6

Question 1

What type of formula cell reference instructs Microsoft excel to keep the cell reference constant in the formula as it copies it to the destination area?

Answer 1

absolute

Question 2

what method is the most efficient way to copy five separate formulas to adjacent cells simultaneously?

Answer 2

copy by using the fill handle

Question 3

Jennifer is calculating her GPA. if she uses “=(A1+A2+A3+A4)/4”, this is an example of which type of entry?

Answer 3

formulas

Question 4

how is a cell reference in a formula and its corresponding location in a worksheet identified?

Answer 4

cell reference and cell location are outlined in matching colors

Question 5

tyler created a monthly sales workbook that contains the formula =(January!B3). “January” is an example of an

Answer 5

External Reference

Question 6

when copying values in Microsoft Excel, which features automatically adjusts cell references for the new copy location?

Answer 6

relative reference

Question 7

tyler created a monthly sales workbook that contains the formula =SUM(Sales). “Sales” is an example of a

Answer 7

named range

Question 8

Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?

Answer 8

$B$1+25

Question 9

what do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?

Answer 9

worksheet reference

Question 10

Sandra is creating a formula to subtract the values in cell B4 and C4. which formula should she use?

Answer 10

=B4-C4

Question 11

snadra is creating a formula to multiply the values in cell B4 and C4. which formula should she use?

Answer 11

=B4*C4

Question 12

Joshua created a budget workbook that contains the formulas =(Summary!B3). “Summary” is an example of an

Answer 12

external reference

Question 13

which group on the formulas ribbon enables a user to specify when a formula is completed

Answer 13

calculation

Question 14

what is a prewritten formula that is built into the Microsoft Excel called

Answer 14

function

Question 15

Larkeysha has created a spreadsheet containing students grades. which function would she use to return the current date in cell A1

Answer 15

TODAY

Question 16

what function adds all of the numbers in a range of cells

Answer 16

SUM

Question 17

Amanda has created a spreadsheet containing test grades for the first nine weeks. which function would she use to find the highest test grade

Answer 17

MAX

Question 18

which command on the home tab displays the total of the selected cells directly after the selected cells

Answer 18

AutoSum

Question 19

Amanda has created a spreadsheet containing test grades for the first nine weeks. which function would she use to estimate the grade on her next test

Answer 19

AVERAGE

Question 20

which group on the formulas ribbon contains the command that checks for common errors found in a formula?

Answer 20

formula auditing

Question 21

where can you find the insert function button in Microsoft Excel

Answer 21

formula bar

Question 22

angie is calculating her average sales for the past four months. if she uses “=AVERAGE(B1:B4)”, this is an example of which type of entry

Answer 22

function

Question 23

Gabriel needs to create a shortcut formula in cell B40 to calculate total sales located in cells B1 through B39. which function should he create?

Answer 23

=SUM(B1:B39)

Question 24

which group on formulas ribbon contains a command that allows a user to create names for cells to use in a formula

Answer 24

defined names

Question 25

which of the following are valid Microsoft Excel functions

Answer 25

AVERAGE, MAX, MIN

Question 26

which function do you use to interest today's date un a worksheet so that it automatically updates each time the worksheet is opened?

Answer 26

Today

Question 27

which function would she use to return the current date and time in cell A1

Answer 27

NOW

Question 28

which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet

Answer 28

Format cells

Question 29

on the home ribbon, what di you use to change the font size of the characters in a cell

Answer 29

font size drop down list

Question 30

trey would like to outline the cell range A1:F20. which formatting style should he select

Answer 30

borders

Question 31

where can you fine the command to apply a fill color to a cell or range of cells in a worksheet

Answer 31

home ribbon

Question 32

K would like to apply the Title format to the data in row 1 of a spreadsheet. which formatting style should he select

Answer 32

cell style

Question 33

which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles

Answer 33

cell style

Question 34

carl notices the last two lines of text in cell B4 are not showing up in his worksheet. How could carl format the cell to correct this problem

Answer 34

Autofit

Question 35

needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select

Answer 35

Merge and Center

Question 36

which command on the home ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet

Answer 36

orientation

Question 37

what defines the color of the characters in a Mircorsoft Excel worksheet

Answer 37

font color

Question 38

which dialog box in Microsoft Excel do you use to set the rotation of text in a cell to a specific degree

Answer 38

format cells

Question 39

K needs the text in cell A1 to bee angled at 90 degrees. Which alignment option should she select

Answer 39

orientation

Question 40

On the home ribbon, what do you use to change the text color of characters in a cell

Answer 40

font color drop down list

Question 41

which command on the insert ribbon creates a link to a web page, picture, email address, or program in a worksheet

Answer 41

hyperlink

Question 42

what type of formatting appears only when the value in a cell meets conditions specified by a user

Answer 42

conditional

Question 43

which command on the home ribbon joins selected cells into one and centers the content into a larger single cell?

Answer 43

merge and center

Question 44

trey would like to apply a rule to the date in cell range A1:F20 that will highlight number greater than 50,000 with a yellow fill color and dark yellow text. which formatting style should he select

Answer 44

conditional formatting

Question 45

what command do you use to apply a background color to cells in a worksheet

Answer 45

fill color

Question 46

which quick-number style button formats number to display as currency in the worksheet

Answer 46

accounting

Question 47

column D in a spreadsheet contains information about regional sales. which formatting would be most appropriate for the date in column D

Answer 47

Currency

Question 48

column D in a spreadsheet contains employee ID Number. which formatting would be most appropriate for the data in column D

Answer 48

Text

Question 49

Carl notices that the date in cell E4 reads #####. what command could carl choose to correct this problem

Answer 49

autofit

Question 50

which command do you use to reduce the margin between the borders and the text in an indented Cell

Answer 50

decrease indent

Question 51

which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel

Answer 51

Font