In Office 2016, the tab that takes you to Backstage view to access Save, Print, Options, and other commands.

Located below the ribbon at the left end of the formula bar. When a user types a cell location into this box and presses Enter, the insertion point moves to that cell.

A toolbar that gives you fast and easy access to the tools you use most often in Excel.

A broad band that runs across the top of the Excel window that organizes commands and tools into an easy-to-use interface. The ribbon was introduced in Office 2007.

A line of cells that start at the left edge of a worksheet, continue to the right, and are identified by numbers.

A small, onscreen rectangle that displays descriptive text when you rest the pointer on a command or control.

A collection of worksheets in a single file.

A page in a workbook that consists of a grid of rows and columns in which you can enter text, values, and formulas, and perform calculations.

An excel feature that automatically fill cells with data, formatting, or both.

To duplicate data from a worksheet to the Clipboard

An arrow with a plus sign that appears when you select the cell or range of cells you want to copy and hold down CTRL while you point to the border of the selection.

To remove data from a worksheet

A small square in the lower, right corner of a selected cell or range of cells. Used mainly to copy data to adjacent cells.

A tool identified with symbols such as dotted, dashed, or solid lines that fills the space before tabs.

A bar located between the ribbon and the worksheet in which users can edit the contents of the cell.

A word assigned to a document's properties that makes it easier to organize and file documents.

Text entered into a worksheet that identifies numeric data and is the most common type of text entered in a worksheet. Labels are also used to sort and group data.

A mouse pointer that enables users to drag a cell or range of cells to a new location, replacing any existing data in the destination cells.

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

A location that collects and stores up to 24 copied or cut items that are then available to be used on the active workbook, in other workbook , and in other office programs.

To insert data from the Clipboard to a new location in a worksheet

Highlighting that is to be changed

Items you directly change, such as keyword.

Pre-set settings that determine how Excel behaves when performing an action.

Commands on the default ribbon tabs that are related in functionality.

A pane found on the left side of Backstage view. It provides you access to workbook and file-related commands through a series of tabs.

What are "print options"?

Several settings that enable you to change how a document prints.

An area on the ribbon that contains groups of related commands; An area of the Backstage navigation pane that contains groups of related commands.

A file that includes formatting and formulas complete with designs, tools, and specific data types.

absolute cell reference

A reference to a specific cell or range of cells regardless of where the formula is located in the worksheet. An absolute cell reference uses a dollar sign in front of the column and row markers in a cell address.

Operators that specify the calculations to be performed.

A reference that identifies a cell's location in the worksheet based on its row number and column letter.

A number or text value entered directly into a formula.

What is an external reference in Excel?

A cell or range in a worksheet in another Excel workbook, or a defined name in another workbook.

An equation that performs calculations, such as addition, subtraction, multiplication, and division, on values in a worksheet.

A cell reference that uses an absolute column or row reference, but not both.

A group of cells, and occasionally a single cell, with a designated name.

Parentheses inside of parentheses within a formula.

An element that identifies the values to be used in a calculation.

The rules Excel follows to calculate any formula that contains two or more operators.

relative cell reference

A cell reference that adjusts the cell identifier automatically if you insert or delete columns or rows, or if you copy the formula to another cell.

The location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook. If you set the scope of a named range to Workbook, you can reference the named range on any sheet in the workbook.

value: A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.

A number, a cell address, a date, text, or Boolean data in Excel. Regarding formulas, it is usually a number or cell address.

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

Unit 1 Terminology Excel Flashcards

Student preview

51 questions

Show all answers

1.

FLASHCARD QUESTION

Front

active cell

Back

A cell that is highlighted or outlined by a bold black rectangle. This is also called the current or highlighted cell.

2.

FLASHCARD QUESTION

Front

Backstage view

Back

A view that shows you behind-the-scenes options for managing files such as opening, saving, printing, and documenting files.

3.

FLASHCARD QUESTION

Front

cell

Back

A box on the grid identified by the intersection of a column and a row.

4.

FLASHCARD QUESTION

Front

column

Back

Cells that run from top to bottom in a worksheet and are identified by letters.

5.

FLASHCARD QUESTION

Front

What is a command group?

Back

Task-specific groups divided among the command tabs appropriate to the work a user currently performs.

6.

FLASHCARD QUESTION

Front

What are command tabs?

Back

Task-oriented tabs that are organized on the ribbon.

7.

FLASHCARD QUESTION

Front

Dialog Box Launcher

Back

An arrow in the lower, right corner of some command groups on the ribbon that opens a dialog box related to the command group.

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

50 questions

Faire & Jouer

Flashcard

•

KG - University

48 questions

Eng 102

Flashcard

•

11th Grade

43 questions

Työ (SM 4) (KPL 1)

Flashcard

•

KG - University

40 questions

Close-up B1+ Unit 5 Quiz

Flashcard

•

12th Grade

55 questions

Psych Unit 4: Learning and Language

Flashcard

•

11th Grade - University

41 questions

Writing Final

Flashcard

•

9th - 12th Grade

Popular Resources on Wayground

5 questions

This is not a...winter edition (Drawing game)

Quiz

•

1st - 5th Grade

15 questions

4:3 Model Multiplication of Decimals by Whole Numbers

Quiz

•

5th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

10 questions

The Best Christmas Pageant Ever Chapters 1 & 2

Quiz

•

4th Grade

12 questions

Unit 4 Review Day

Quiz

•

3rd Grade

10 questions

Identify Iconic Christmas Movie Scenes

Interactive video

•

6th - 10th Grade

20 questions

Christmas Trivia

Quiz

•

6th - 8th Grade

18 questions

Kids Christmas Trivia

Quiz

•

KG - 5th Grade

Discover more resources for Business

16 questions

BizInnovator Startup - Crunching the Numbers

Quiz

•

9th - 12th Grade

40 questions

Dave Ramsey Chapter 2 Review

Quiz

•

10th - 12th Grade

17 questions

BizInnovator Startup - Know Your Customer

Quiz

•

9th - 12th Grade

13 questions

BizInnovator Startup - Experience and Overview

Quiz

•

9th - 12th Grade