Module 2

Question 1

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

Answer 1

Max

Question 2

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

Answer 2

Min

Question 3

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

Answer 3

Hlookup

Question 4

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

Answer 4

Vlookup

Question 5

A function that adds a range of cells

Answer 5

Total

Question 6

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

Answer 6

Formula bar

Question 7

Excel refers to files as

Answer 7

Workbooks

Question 8

The letters in excel represent the

Answer 8

Column

Question 9

The numbers in excel represent the

Answer 9

Row

Question 10

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

Answer 10

=

Question 11

The cell in the worksheet in which you can type data

Answer 11

Active cell

Question 12

An excel file format extension is

Answer 12

Xls

Question 13

Text in excel is automatically aligned

Answer 13

Left

Question 14

Numbers in excel are automatically aligned

Answer 14

Right

Question 15

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

Answer 15

Autofill

Question 16

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

Answer 16

Row

Question 17

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

Answer 17

Column

Question 18

The intersection of a row and column

Answer 18

Cell

Question 19

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

Answer 19

Countif

Question 20

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

Answer 20

Predefined functions

Question 21

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

Answer 21

If

Question 22

A group of selected cells

Answer 22

Range

Question 23

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

Answer 23

Worksheet

Question 24

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

Answer 24

Animation pane

Question 25

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

Answer 25

Animation painter

Question 26

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?

Answer 26

Powerpoint

Question 27

Shortcut to duplicate slide

Answer 27

Ctrl + D

Question 28

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

Answer 28

Duplicate slide

Question 29

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

Answer 29

Shape

Question 30

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

Answer 30

Form

Question 31

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

Answer 31

Color

Question 32

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

Answer 32

Texture

Question 33

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

Answer 33

Emphasis

Question 34

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

Answer 34

Unity

Question 35

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

Answer 35

Space

Question 36

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

Answer 36

Value

Question 37

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

Answer 37

Balance

Question 38

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

Answer 38

Movement

Question 39

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

Answer 39

Formulas

Question 40

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

Answer 40

Pattern

Question 41

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

Answer 41

Line

Question 42

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

Answer 42

File management

Question 43

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

Answer 43

=ISNUMBER()

Question 44

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

Answer 44

Harmony

Question 45

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

Answer 45

=ISBLANK()

Question 46

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

Answer 46

Hypertext Markup Language

Question 47

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

Answer 47

Proportion

Question 48

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

Answer 48

Google drive

Question 49

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

Answer 49

One drive