Final

Question 1

When typing a formula, begin the formula with this sign

Answer 1

=

Question 2

This is the keyboard shortcut to display formulas in a worksheet.

Answer 2

Control ~

Question 3

To identify an absolute cell reference, type this symbol before the column and row.

Answer 3

$

Question 4

This function returns the lowest value in a set of values.

Answer 4

MIN

Question 5

If Excel detects an error in a formula, a _____ ____ button appears and a dark green triangle displays in the upper left corner of the cell.

Answer 5

Trace Error

Question 6

Use 1-inch top, bottom, and side margins for MLA reports. True or False

Answer 6

True

Question 7

Including your class name is a required item in the running head. True or False

Answer 7

False. Just last name and page number

Question 8

The first line in the header includes the student name. True or False

Answer 8

True

Question 9

The third line in the header includes the class name. True or False

Answer 9

True

Question 10

For parenthetical references that have one or two authors, just list the first authors last name followed by et al. True or False

Answer 10

False. et al. is for four or more authors

Question 11

For up to three authors list all authors’ last names with page numbers as long as the authors name has not been previously cited. True or False

Answer 11

True

Question 12

(119). is an example of a parenthetical reference where the author’s last name has been previously cited. True or False

Answer 12

True

Question 13

In PowerPoint, these are effects that are in place when you switch from one slide to the next.

Answer 13

transitions

Question 14

Animations that bring a slide element onto the screen are called

Answer 14

Entrance effects

Question 15

This is the website we used to create headline logos.

Answer 15

Flamingtext.com

Question 16

If you want to add a sound to a custom animation, you would look for a _________ sound.

Answer 16

wav sound

Question 17

To select all, press control _ on your keyboard.

Answer 17

a

Question 18

MLA reports should be double spaced 2.0 or single spaced 1.0?

Answer 18

double spaced 2.0

Question 19

The date in a MLA report should be in military style.

day month year

True or False

Answer 19

True

Question 20

The running head information includes your first name and page number.

True or False

Answer 20

False

it’s last name and page number.

Question 21

The second line of the header includes the student name.

True or False

Answer 21

False

The second line is the Teacher’s Name

Question 22

Which of the following is the correct way to list 2 authors on the Works Cited page in the MLA format?

Smith, J., & S. Jones.

John Smith and Susan Jones.

Smith, John, and Susan Jones.

Smith, J., & Jones, S.

Answer 22

Smith, John, and Susan Jones.

First name is backwards and second name is normal order.

Question 23

Your list of citations at the end of your paper, according to MLA standards, should be titled:

Answer 23

Works Cited

Question 24

Do not repeat an Author’s name when listing more than 1 book. Instead key —. before the title.

True or False

Answer 24

True

In this case, Marie Boroff wrote two books.

Question 25

The best way to get a slide show to stop when you’re in slide show view is to:

Answer 25

press esc

Question 26

I want a graphic to fly in so I would…

Answer 26

use the Animation tab and set a custom animation, entrance effect

Question 27

If you want to add background music to your PowerPoint presentation, you would add what kind of audio?

Answer 27

MP3

Question 28

To add bold, press control _ on your keyboard.

Answer 28

b

Question 29

To copy, press control _ on your keyboard.

Answer 29

c

Question 30

To paste, press control _ on your keyboard.

Answer 30

v

Question 31

To shrink the font, press control _ on your keyboard.

Answer 31

[

Question 32

To close the program, press alt _ on your keyboard.

Answer 32

F4

Question 33

Seeing (###) in a cell means that the cell width isn’t wide enough to see the number.

True or False

Answer 33

True

Question 34

In Excel, all formulas begin with what?

Answer 34

=

Question 35

In the following formula =Sum(A1:A5), the : represents what?

Answer 35

through

Question 36

In the following formula =Sum(A1:A3), Sum means to?

Answer 36

add

Question 37

This is the operator for division that is used when writing a formula.

Answer 37

/

Question 38

This is the operator for multiplication that is used when writing a formula

Answer 38

*

Question 39

This function returns the largest value in a set of values.

Answer 39

MAX

Question 40

This is the keyboard shortcut to display formulas in a worksheet.

Answer 40

control ~

Question 41

This function finds the periodic payment for a loan based on constant payments and a constant interest rate.

Answer 41

PMT

Question 42

This function returns the future value of an investment periodic, constant payments and a constant interest rate.

Answer 42

FV

Question 43

1.

Answer 43

File Tab

Question 44

2.

Answer 44

Quick Access toolbar

Question 45

3.

Answer 45

Tabs

Question 46

4.

Answer 46

title bar

Question 47

5.

Answer 47

active cell

Question 48

6.

Answer 48

name box

Question 49

7.

Answer 49

formula bar

Question 50

8.

Answer 50

merge and center button

Question 51

9.

Answer 51

autosum

Question 52

10.

Answer 52

ribbon

Question 53

11.

Answer 53

vertical scroll bar

Question 54

12.

Answer 54

horizontal scroll bar

Question 55

13.

Answer 55

sheet tabs

Question 56

14.

Answer 56

status bar

Question 57

15.

Answer 57

fill handle

Question 58

16.

Answer 58

select all

Question 59

17.

Answer 59

rows

Question 60

18.

Answer 60

columns