Comp Prog Quiz 1 Jjmz

Front 1

small, onscreen boxes that display descriptive text when you rest the pointer on a command or control.

Back 1

Screen Tips

Front 2

It gives you fast and easy access to the tools you use most often in any given Excel session

Back 2

Quick Access Toolbar

Front 3

It automatically fill cells with data and/or formatting.

Back 3

Auto fill

Front 4

It is a group of adjacent cells that you select to perform operations on all of the selected cells.

Back 4

Range

Front 5

is a formatted series of text or numbers that are in a normal sequence such as months, weekdays, numbers, or times.

Back 5

natural series

Front 6

With this, you can quickly fill a column of data using an example that is based on existing data in adjacent columns.

Back 6

Flash Fill

Front 7

It collects and stores up to 24 copied or cut items that are then available to be used in the active workbook, in other workbooks, and in other Microsoft Office programs.

Back 7

Office Clipboard

Front 8

These are pre-set options that determine how Excel will behave when performing an action.

Back 8

Default settings

Front 9

These are pre-set options that determine how Excel will behave when performing an action.

Back 9

Default settings

Front 10

These identify the values to be used in the calculation. It can be a constant value, or a variable such as a cell reference, a range of cells, or another formula.

Back 10

Operands

Front 11

a number or text value that is entered directly into a formula.

Back 11

Constant

Front 12

It is an equation that performs calculations, such as addition, subtraction, multiplica-tion, and division, on values in a worksheet.

Back 12

Formula

Front 13

A symbol or name that represents something else, which can be a cell address, a range of cells, and so on.

Back 13

Variable

Front 14

It specifies the calculations to be performed.

Back 14

Calculation operators

Front 15

Parentheses inside of parentheses

Back 15

Nested parentheses

Front 16

It identifies a cell’s location in the worksheet, based on its column letter and row number.

Back 16

Cell reference

Front 17

It is the one that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.

Back 17

Relative cell reference

Front 18

It refers to a specific cell or range of cells regardless of where the formula is located in the worksheet.

Back 18

absolute cell reference

Front 19

It is a cell reference that uses an absolute column or row reference, but not both.

Back 19

mixed cell reference

Front 20

It refers to a cell or range in a worksheet in another Excel workbook, or to a defined name in another workbook.

Back 20

external reference

Front 21

It is a group of cells, and occasionally a single cell, with a designated name

Back 21

named range

Front 22

It totals all of the cells in a range, easily and accurately.

Back 22

Sum function

Front 23

calculates (by default) the total from the adjacent cell up to the first nonnu-meric cell, using the SUM function in its formula.

Back 23

AutoSum

Front 24

It determines how many cells in a range contain a number.

Back 24

COUNT function

Hint 24

There are other variations of the COUNT function. The COUNTA function counts all nonblank entries in a range, whether they include text or numbers. The COUNT-BLANK function counts the number of blank cells in a range.

Front 25

It allows you to determine the minimum value in a range of cells.

Back 25

MIN function

Front 26

It returns the largest value in a set of values.

Back 26

Max function

Front 27

It means to ar-range in a line or bring into alignment

Back 27

Align

Front 28

is a set of text properties that affect the typeface, size, and style of text.

Back 28

Font

Front 29

a formatting tool that appears above or below the shortcut menu when you right-click a cell.

Back 29

Mini toolbar

Front 30

a formatting characteristic, such as bold, italic, or underlined text

Back 30

Attribute

Front 31

When a data inside a cell is too long, this format automatically displays texts on the next line within the cell

Back 31

wrap text

Front 32

combines two or more cells into a single cell.

Back 32

Merged cell

Front 33

It allows you to quickly copy formatting attributes that you have already applied and “paint” those attributes onto other text, shapes, pictures, and worksheet cells.

Back 33

Format Painter

Front 34

It enables you to control specifically what you want to paste after using the Copy or Cut command, such as cell content, formulas, values, formatting, and much more.

Back 34

Paste special

Front 35

a set of formatting attributes that you can apply to a cell or range of cells more easily than by setting each attribute individually.

Back 35

style

Front 36

a shortcut of sorts that enables you to navigate to a web page or a location in another file in just one click of the mouse.

Back 36

hyperlink

Front 37

enables you to set the order of multiple rules, fine-tune rule settings, and more.

Back 37

Rules Manager

Front 38

a powerful Excel feature that enables you to specify how cells that meet a given condition should be displayed.

Back 38

Conditional formatting

Front 39

the line between rows or columns.

Back 39

boundary

Front 40

top-to-bottom measurement of a row, measured in points;

Back 40

Row height

Hint 40

one point is equal to 1/72 inch. The default row height is 15 points, but you can specify a row height of 0 to 409 points.

Front 41

is the left-to-right measurement of a column.

Back 41

Column width

Hint 41

you can specify a column width of 0 to 255 characters, the default column width is 8.43 characters (based on the default font and font size).

Front 42

the empty area of a document, in which no content appears.

Back 42

White space

Front 43

It causes your cell data to change orientation.

Back 43

Transposing a row or column

Front 44

a predefined set of colors, fonts, and effects that can be applied to a workbook

Back 44

document theme

Front 45

the lines that display around worksheet cells

Back 45

Gridlines

Front 46

A screen that appears when you click the File tab and then click Print, or if you click Print Preview in a dialog box that provides the button.

Back 46

Print preview

Front 47

a line of text that appears at the top of each page of a printed worksheet.

Back 47

Header

Front 48

a line of text that appears at the bottom of each page

Back 48

Footer

Front 49

a divider that breaks a worksheet into separate pages for printing

Back 49

page break

Front 50

refers to shrinking or stretching printed output to a percentage of its actual size

Back 50

Scaling

Front 51

indicates the current cell you are in as well as gives you the opportunity to name the

Back 51

Name box