Module 2 Flashcards

1
Q

You can get the largest numerical value in a range of values by using what function?

A

Max

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

You can get the smallest numerical value in a range of values using what function?

A

Min

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

We retrieve information from table by searching a row for a match data

A

Hlookup

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

We retrieve information from table by searching a column for a match data

A

Vlookup

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

A function that adds a range of cells

A

Total

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

The name of the bar where information appears as you input data in excel

A

Formula bar

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

Excel refers to files as

A

Workbooks

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

The letters in excel represent the

A

Column

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

The numbers in excel represent the

A

Row

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

To alert excel that you are entering a formula and not text, type this preceding the formula

A

=

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

The cell in the worksheet in which you can type data

A

Active cell

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

An excel file format extension is

A

Xls

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

Text in excel is automatically aligned

A

Left

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

Numbers in excel are automatically aligned

A

Right

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

The ability to quickly add a formula, set of number, months or day of the week down a column or across a row

A

Autofill

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

The set of data that runs left to right in a spreadsheet

A

Row

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

The set of data that runs up and down in a spreadsheet

A

Column

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

The intersection of a row and column

A

Cell

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

The count column found on the grade count table, can be computed by this function

A

Countif

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

Sum, average, if, min and max are examples of

A

Predefined functions

21
Q

To display the letter grade equivalent, we can use this function

A

If

22
Q

A group of selected cells

A

Range

23
Q

A computerized spreadsheet in excel can also be referred to as a

A

Worksheet

24
Q

A tool that displays the list of animated objects on your slide

A

Animation pane

25
Q

Allows the creator of the presentation to copy the animation effects of one object to another object with a single click of the mouse on each new object

A

Animation painter

26
Q

A software program used to create a collection of slides that may contain text, charts, pictures, sound, movies, or multimedia, and is often called a presentation graphics program?

A

Powerpoint

27
Q

Shortcut to duplicate slide

A

Ctrl + D

28
Q

What instruction would I give the computer if I wanted to copy the same powerpoint slide again and again?

A

Duplicate slide

29
Q

An enclosed space defined and determined by other art elements such as line, color, value, and texture

A

Shape

30
Q

An element of art that is three dimensional (height, width, and depth) and encloses volume

A

Form

31
Q

Produced by light of various wavelengths, and when light strikes an object and reflects to the eyes

A

Color

32
Q

The surface quality or “feel” of an object, its smoothness, roughness, softness, etc. It may be actual or implied

A

Texture

33
Q

Creates a disruption to the eye’s movement in an artwork and develops a center of interest, or focal point

A

Emphasis

34
Q

It occurs when all the elements you put in your artwork work well together and look like they belong there. All parts of the design must agree in a feeling or mood

A

Unity

35
Q

An element of art that refers to the distance or area between, around, above, below, or within things

A

Space

36
Q

An element of art that refers to the lightness or darkness of a color

A

Value

37
Q

Arranging the parts of the artwork equally or near equally in terms of “visual weight” on each side

A

Balance

38
Q

It is the art principle that uses some of the elements of art to produce the look of action or to cause the viewer’s eye to sweep over the artwork in a certain manner

A

Movement

39
Q

A combination of numbers and symbols used to express a calculation. Always begins with an = sign

A

Formulas

40
Q

A regular arrangement of alternated or repeated elements (shapes, lines, colors) or motifs

A

Pattern

41
Q

Horizontal, vertical, diagonal, curved, dotted is an example of this element of design

A

Line

42
Q

It is the process of naming, editing, storing and sharing files.

A

File management

43
Q

What is the syntax if I want to check whether a value is a number

A

=ISNUMBER()

44
Q

Gives the viewer the feeling that all parts of the piece form a coherent whole

A

Harmony

45
Q

What is the syntax if I want to check whether a reference is to an empty cell

A

=ISBLANK()

46
Q

It is the standard markup language for documents designed to be displayed in a web browser

A

Hypertext Markup Language

47
Q

The relationship of object with respect to size, number and so on

A

Proportion

48
Q

It is a file storage and synchronization service developed by Google. Launched on April 24, 2012

A

Google drive

49
Q

It is a file hosting service and synchronization service operated by Microsoft as part of its web version of Office

A

One drive