Final Flashcards

1
Q

When typing a formula, begin the formula with this sign

A

=

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

Control ~

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

$

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A

MIN

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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.

A

Trace Error

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

False. Just last name and page number

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

False. et al. is for four or more authors

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

transitions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Animations that bring a slide element onto the screen are called

A

Entrance effects

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

This is the website we used to create headline logos.

A

Flamingtext.com

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

A

wav sound

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

To select all, press control _ on your keyboard.

A

a

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

double spaced 2.0

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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

day month year

True or False

A

True

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

True or False

A

False

it’s last name and page number.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

The second line of the header includes the student name.

True or False

A

False

The second line is the Teacher’s Name

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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.

A

Smith, John, and Susan Jones.

First name is backwards and second name is normal order.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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

A

Works Cited

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

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

True or False

A

True

In this case, Marie Boroff wrote two books.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

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

A

press esc

26
Q

I want a graphic to fly in so I would…

A

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

27
Q

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

A

MP3

28
Q

To add bold, press control _ on your keyboard.

A

b

29
Q

To copy, press control _ on your keyboard.

A

c

30
Q

To paste, press control _ on your keyboard.

A

v

31
Q

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

A

[

32
Q

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

A

F4

33
Q

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

True or False

A

True

34
Q

In Excel, all formulas begin with what?

A

=

35
Q

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

A

through

36
Q

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

A

add

37
Q

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

A

/

38
Q

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

A

*

39
Q

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

A

MAX

40
Q

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

A

control ~

41
Q

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

A

PMT

42
Q

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

A

FV

43
Q

1.

A

File Tab

44
Q

2.

A

Quick Access toolbar

45
Q

3.

A

Tabs

46
Q

4.

A

title bar

47
Q

5.

A

active cell

48
Q

6.

A

name box

49
Q

7.

A

formula bar

50
Q

8.

A

merge and center button

51
Q

9.

A

autosum

52
Q

10.

A

ribbon

53
Q

11.

A

vertical scroll bar

54
Q

12.

A

horizontal scroll bar

55
Q

13.

A

sheet tabs

56
Q

14.

A

status bar

57
Q

15.

A

fill handle

58
Q

16.

A

select all

59
Q

17.

A

rows

60
Q

18.

A

columns