Chapter 8

Question 0

steps required to view the serial value of an existing date

Answer 0

select the cell containing the date

click home > number format > general

Question 1

How are dates stored in Excel?

Answer 1

sequential serial values

Question 2

What is added to each column in a table

Answer 2

an arrow for displaying sort and filter commands

Question 3

describe a situation where a filter could be used

Answer 3

company’s employee data displaying employees in a specific department

Question 4

why might it be necessary to separate first and last name data into two columns?

Answer 4

to filter by last name

Question 5

one way to avoid data entry errors

Answer 5

specify data entry criteria for a cell or range of cells

Question 6

a situation where it would be useful to use a PivotTable

Answer 6

state’s school performance scores, analyze by country

Question 7

CHOOSE function that displays 100, 500, 900, or 1200 in cell B20

Answer 7

=CHOOSE(B20, 100, 500, 900, 1200)

Question 8

Choose function that displays Excellent, Good, Fair, Poor in cell B20

Answer 8

=CHOOSE(B20, “Excellent”, “Good”, “Fair”, “Poor”)

Question 9

steps required to name a range using the name box

Answer 9

select the cells

type a descriptive name in the name box

Question 10

Does a named range change when it is copied as part of a formula

Answer 10

no because it is an absolute reference

Question 11

3 situations win which a VLOOKUP table could be used

Answer 11

calculate shipping fees
tax rates
discount values by number of items purchased

Question 12

what cell should be selected to freeze the cells in column A and rows 1-4 before selecting freeze panes

Answer 12

B5

Question 13

steps required to insert a hyperlink in cell B7 that links to cell k38

Answer 13

select cell B7 and click Insert > Hyperlink
Place in this Document
B7 in type the cell reference box
ok

Question 14

difference between linked and embedded objects

Answer 14

linked objects are automatically updated when the source data is updated
embedded objects keep the features of the application it was created in

Question 15

what is a macro

Answer 15

a series of recorded commands and actions that perform a specific task

Question 16

steps required to create a macro - enter label Date, format in blue font color, and right align

Answer 16

Developer > Record Macro
enter macro name and enter shortcut key/description
select ok
type date, make blue, right align
Developer > Stop Recording

Question 17

steps required to delete a macro

Answer 17

developer > macros
select name of macro
select delete
select yes

Question 18

How does the result of a time calculation need to be formatted

Answer 18

24 hour time format

Question 19

can more than one filter apply to the same table

Answer 19

true

Question 20

the argument in a CHOOSE function has to be a number between what

Answer 20

1 and 254

Question 21

can the name given to a cell or range of cells contain spaces

Answer 21

no

Question 22

how must the values in the first column of a VLOOKUP table be arranged

Answer 22

ascending order

Question 23

what is the range that defines the VLOOKUP table specified as

Answer 23

name range

Question 24

do frozen rows remain on the screen when scrolling vertically

Answer 24

no

Question 25

what is required to unfreeze cells

Answer 25

nothing

Question 26

what can a hyperlink open

Answer 26

Web browser or another place

Question 27

can macros improve productivity

Answer 27

yes

Question 28

what do you call a column in a worksheet

Answer 28

field

Question 29

what is a lookup function that returns a value from a list of many values

Answer 29

choose

Question 30

an object that keeps the features of the application it was created in

Answer 30

embedded object

Question 31

a table of data where each column is a field that can be used to summarize data

Answer 31

PivotTable

Question 32

the process of displaying only the rows that meet specific criteria

Answer 32

filter

Question 33

an object that automatically updates when the source data is updated

Answer 33

linked object

Question 34

a series of recorded commands and actions that perform a specific task

Answer 34

macro

Question 35

a single formula entered in a table cell and then automatically copied to all of the other table cells in the column

Answer 35

calculated column

Question 36

a report that allows the worksheet data to be put into small concise reports, simplifying data analysis

Answer 36

PivotTable Report

Question 37

pasted data that is not connected to the source file or to the source application

Answer 37

static

Question 38

a lookup function used to return a value from a table of values stored in the worksheet

Answer 38

VLOOKUP

Question 39

Range of related data that can be sorted and filtered

Answer 39

table

Question 40

removes all data validation criteria

Answer 40

clear all

Question 41

displays a dialogue box used to specify data entry criteria for a cell or range of cells

Answer 41

data validation

Question 42

displays a dialogue box used to define a name range

Answer 42

define name

Question 43

designates every row above the active cell and every column to the left of the active cell as frozen

Answer 43

freeze panes

Question 44

displays a dialogue box used to insert a hyperlink into the active cell

Answer 44

hyperlink

Question 45

displays a dialogue box used to edit and delete macros

Answer 45

macros

Question 46

displays a dialogue box used to delete a range name

Answer 46

name manager

Question 47

displays a dialogue box used to add a tab to the ribbon

Answer 47

options

Question 48

displays a dialogue box used to embed and link objects

Answer 48

paste special

Question 49

removes the blue underline from a text in a cell

Answer 49

remove hyperlink

Question 50

displays a dialogue box used to create a macro

Answer 50

record macro

Question 51

ends the recording of a macro

Answer 51

stop recording

Question 52

displays a dialogue box used to separate data in a column

Answer 52

text to columns

Question 53

displays a grid used to create a table

Answer 53

table

Question 54

unfreezes all the frozen cells on a worksheet

Answer 54

unfreeze panes