Module 1Excel Definitions

Question 1

active cell

Answer 1

The cell currently selected in the active worksheet.

Question 2

active sheet

Answer 2

The sheet currently displayed in the workbook window.

Question 3

arithmetic operator

Answer 3

A mathematical symbol representing the operations of addition, subtraction, multiplication, division, or exponentiation.

Question 4

AutoComplete

Answer 4

The feature that helps make entering repetitive text easier; as you type text into the active cell, Excel displays text that begins with the same letters as a previous entry in the same column.

Question 5

AutoFit

Answer 5

The Excel feature that changes the column width or row height to display its longest or tallest entry within the column or row.

Question 6

AutoSum

Answer 6

A button that inserts Excel functions to sum, average, or count all the values in a range, or find the minimum or maximum value in a range.

Question 7

Backstage view

Answer 7

The File tab of the ribbon, which provides access to various screens with commands that allow you to manage files and Excel options.

Question 8

border

Answer 8

A line added along the edge of a cell to improve the readability of the worksheet. (EX 30)

Question 9

cell

Answer 9

The intersection of a single row and a single column.

Question 10

cell range (or range)

Answer 10

A group of cells in a rectangular block, which can be either adjacent or nonadjacent.

Question 11

cell reference

Answer 11

The column and row location that identifies a cell within a worksheet.

Question 12

chart sheet

Answer 12

A sheet that contains only a chart that provides a visual representation of worksheet data.

Question 13

clear

Answer 13

To remove data from selected cells, but leave the blank cells in the worksheet.

Question 14

column headings

Answer 14

The letters along the top of the worksheet window that identify the different columns of the worksheet.

Question 15

date data

Answer 15

A value in a recognized date format.

Question 16

drag and drop

Answer 16

The technique to move a cell or range by selecting it, positioning the pointer over the bottom border of the selection, and then dragging the selection to a new location

Question 17

Edit mode

Answer 17

The mode in which you can edit cell contents.

Question 18

delete

Answer 18

To remove both the data and the selected cells from the worksheet.

Question 19

Excel

Answer 19

A spreadsheet program used to enter, analyze, and present quantitative data.

Question 20

Flash Fill

Answer 20

The Excel feature that enters text based on patterns in the data.

Question 21

font size

Answer 21

A measurement of the size of text.

Question 22

formatting

Answer 22

A process by which a workbook’s appearance is changed to make it easier to read.

Question 23

formula

Answer 23

A mathematical expression that calculates a value.

Question 24

formula bar

Answer 24

The bar located below the ribbon that displays the value or formula entered into the active cell.

Question 25

function

Answer 25

A named operation that replaces the action of an arithmetic expression

Question 26

group

Answer 26

A part of an Excel ribbon that organizes related commands within a particular tab.

Question 27

keyboard shortcut

Answer 27

A key or combination of keys that you press to access a feature or perform a command.

Question 28

landscape orientation

Answer 28

The page orientation where the page is wider than it is tall.

Question 29

Maximize button

Answer 29

A button that expands the Excel window to fill the screen.

Question 30

Microsoft Excel 2016 (Excel)

Answer 30

A spreadsheet program used to enter, analyze, and present quantitative data.

Question 31

hide

Answer 31

A process by which a row or column is removed from a worksheet by essentially decreasing its height or weight to 0 pixels.

Question 32

Minimize button

Answer 32

A button that hides the Excel window so that only its program button is available on the taskbar.

Question 33

Name box

Answer 33

The box located at the left side of the formula bar that displays the cell reference of the active cell.

Question 34

nonadjacent range

Answer 34

Two or more adjacent ranges that are not connected.

Question 35

Normal view

Answer 35

The Excel view that shows the contents of the active sheet in the workbook window.

Question 36

numeric data

Answer 36

Any number that can be used in a mathematical calculation.

Question 37

operator

Answer 37

A mathematical symbol used in a formula to combine different values, resulting in a single value that is displayed within the cell.

Question 38

order of operations

Answer 38

The sequence in which operators are applied in a calculation.

Question 39

Page Break Preview

Answer 39

The Excel view that shows the location of page breaks in the printed sheet.

Question 40

Page Layout view

Answer 40

The Excel view that shows how the sheet will appear when printed.

Question 41

Page orientation

Answer 41

The direction in which content is printed.

Question 42

portrait orientation

Answer 42

The page orientation where the page is taller than it is wide.

Question 43

range

Answer 43

A group of cells in a rectangular block, which can be either adjacent or nonadjacent.

Question 44

range reference

Answer 44

The cell reference of the upper-left cell of the rectangular block and the cell reference of the lower-right cell separated by a colon.

Question 45

ribbon

Answer 45

The part of the Excel window containing buttons you click to execute Excel commands.

Question 46

Ribbon Display Options button

Answer 46

A button used to display all, part, or none of the ribbon.

Question 47

row headings

Answer 47

The numbers along the left side of the worksheet window that identify the different rows in the worksheet.

Question 48

scale

Answer 48

To change the size of the worksheet on the printed page.

Question 49

ScreenTip

Answer 49

A box with descriptive text about a command.

Question 50

sheet

Answer 50

An individual page within a workbook.

Question 51

sheet tab

Answer 51

The area at the bottom of the worksheet window that identifies the sheet by name.

Question 52

shortcut menu

Answer 52

A list of commands related to a selection that opens when you click the right mouse button.

Question 53

spreadsheet

Answer 53

A grouping of text and numbers in a rectangular grid or table.

Question 54

status bar

Answer 54

The part of the Excel window that provides information about the workbook.

Question 55

SUM function

Answer 55

An Excel function that adds the values in a specified range.

Question 56

syntax

Answer 56

A set of rules that specifies how a function should be written.

Question 57

tab

Answer 57

The part of the Excel ribbon containing commands related to particular activities or tasks.

Question 58

Tell me what you want to do box

Answer 58

An Excel feature that provides quick access to commands and online help.

Question 59

text data

Answer 59

Any combination of letters, numbers, and symbols.

Question 60

text string

Answer 60

A series of text characters.

Question 61

time data

Answer 61

A value in a recognized time format.

Question 62

unhide

Answer 62

A process by which a hidden row or column is redisplayed.

Question 63

workbook

Answer 63

An Excel file containing a collection of worksheets and chart sheets.

Question 64

workbook window

Answer 64

The Excel window containing the contents of the worksheet

Question 65

worksheet

Answer 65

A grid of rows and columns in which the contents of the spreadsheet are laid out.

Question 66

Zoom controls

Answer 66

Excel workbook controls that increase or decrease the magnification of the worksheet content.