Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Secure Byte Excel Definitions > Module 1Excel Definitions > Flashcards

Module 1Excel Definitions Flashcards

Learn Excel Definitions

1
Q

active cell

A

The cell currently selected in the active worksheet.

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

active sheet

A

The sheet currently displayed in the workbook window.

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

arithmetic operator

A

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

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

AutoComplete

A

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.

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

AutoFit

A

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

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

AutoSum

A

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.

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

Backstage view

A

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

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

border

A

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

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

cell

A

The intersection of a single row and a single column.

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

cell range (or range)

A

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

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

cell reference

A

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

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

chart sheet

A

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

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

clear

A

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

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

column headings

A

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

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

date data

A

A value in a recognized date format.

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

drag and drop

A

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

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

Edit mode

A

The mode in which you can edit cell contents.

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

delete

A

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

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

Excel

A

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

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

Flash Fill

A

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

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

font size

A

A measurement of the size of text.

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

formatting

A

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

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

formula

A

A mathematical expression that calculates a value.

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

formula bar

A

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

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

function

A

A named operation that replaces the action of an arithmetic expression

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

group

A

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

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

keyboard shortcut

A

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

28
Q

landscape orientation

A

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

29
Q

Maximize button

A

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

30
Q

Microsoft Excel 2016 (Excel)

A

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

31
Q

hide

A

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

32
Q

Minimize button

A

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

33
Q

Name box

A

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

34
Q

nonadjacent range

A

Two or more adjacent ranges that are not connected.

35
Q

Normal view

A

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

36
Q

numeric data

A

Any number that can be used in a mathematical calculation.

37
Q

operator

A

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

38
Q

order of operations

A

The sequence in which operators are applied in a calculation.

39
Q

Page Break Preview

A

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

40
Q

Page Layout view

A

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

41
Q

Page orientation

A

The direction in which content is printed.

42
Q

portrait orientation

A

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

43
Q

range

A

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

44
Q

range reference

A

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.

45
Q

ribbon

A

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

46
Q

Ribbon Display Options button

A

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

47
Q

row headings

A

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

48
Q

scale

A

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

49
Q

ScreenTip

A

A box with descriptive text about a command.

50
Q

sheet

A

An individual page within a workbook.

51
Q

sheet tab

A

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

52
Q

shortcut menu

A

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

53
Q

spreadsheet

A

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

54
Q

status bar

A

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

55
Q

SUM function

A

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

56
Q

syntax

A

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

57
Q

tab

A

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

58
Q

Tell me what you want to do box

A

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

59
Q

text data

A

Any combination of letters, numbers, and symbols.

60
Q

text string

A

A series of text characters.

61
Q

time data

A

A value in a recognized time format.

62
Q

unhide

A

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

63
Q

workbook

A

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

64
Q

workbook window

A

The Excel window containing the contents of the worksheet

65
Q

worksheet

A

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

66
Q

Zoom controls

A

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

Secure Byte Excel Definitions (4 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions