Excel Functions and Features

Excel Functions and Features

Assessment

Flashcard

Instructional Technology

9th - 12th Grade

Hard

Created by

Kelly Challand

FREE Resource

Student preview

quiz-placeholder

8 questions

Show all answers

1.

FLASHCARD QUESTION

Front

Paste Special

Back

A function that allows you to paste special attributes of a cell, rather than just the contents of a cell.

2.

FLASHCARD QUESTION

Front

Office Clipboard

Back

The place where copied data can be stored for future pasting purposes. It can hold up to 24 copied items from any Microsoft application.

3.

FLASHCARD QUESTION

Front

Quick Access Toolbar

Back

The Quick Access Toolbar appears above the ribbon by default and holds the AutoSave, Save, Undo, and Redo commands. It can be customized to suit your needs.

4.

FLASHCARD QUESTION

Front

Freeze panes

Back

The function that freezes worksheet titles on screen, meaning if you move down or across to the right, the titles will remain on screen.

5.

FLASHCARD QUESTION

Front

Split

Back

The function that splits your screen into halves or quarters to help you move around huge spreadsheets.

6.

FLASHCARD QUESTION

Front

Data consolidation

Back

Data pulled together from multiple worksheets.

7.

FLASHCARD QUESTION

Front

Formula

Back

Excel functions and parameters used to perform calculations.

8.

FLASHCARD QUESTION

Front

Grouped data

Back

An outline of data that users can expand or collapse to quickly display summary rows or columns.