Getting Started with Excel Tutorial One

Ace your homework & exams now with Quizwiz!

Pixel

A single point on a cell

Worksheet

A single spreadsheet made up of cells organized by rows and columns

ScreenTip

A box with descriptive text about a command that appears when you point to a button on the ribbon.

Point

Approximately 1/72 of an inch, used to measure height of a row

AutoFit

Changes the column width or row height to siplay the longest or tallest entry within the column or row

Name box

Displays the cell reference of the active cell

Formula bar

Displays the value or formula entered in the active cell

Range Reference

Identifes a range; includes the cell reference of the upper-left cell and the lower-right cell in a box

Sheet tab

Identifies a sheet by a name

Zoom controls

Increase or decrease the magnification of the worksheet content

Restore Down button

Restores a window to its previous size

Touch Mode

Mode in which the ribbon increases in height, the buttons are bigger, and more space appears around each button

Edit mode

Mode that allows you to replace only part of a cell's content

Groups

Organized group for buttons for related commands

Text string

String of text characters, another name for Text data

active sheet

Sheet currently displayed in the workbook window

Tabs

Has commands related to particular activities or tasks

Maximize button

Button that expands the window to fit the screen

Minimize button

Button that hides a window so that only its program button ins visible on the taskbar

Spreadsheet

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

Keybroard Shortcut

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

Shortcut Menu

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

Date and Time Data

Commonly recognized formats for date and time values

AutoComplete

Feature that makes entering repetitive text easier

template

A preformatted workbook with many design features and some content already filled in

Microsoft Excel 2013 (or Excel)

An application used to enter, analyze, and present quantitative data

Text data

Any combination of letters , numbers, and symbols

Numeric data

Any number that can be used in a mathematical calculation

nonadjacent range

Blocks that are not connected

Ribbon

Conatains buttons that you click to execute commands to work with Excel.

Chart Sheet

Contains a chart that provides a visual representation of worksheet data

Active cell

Currently selected cell

Cell

Each intersection of a row and a column

Cell range (range)

Group of cells in a rectangular box

Planning analysis sheet

Includes questions that help you think about the workbook's purpose and how to achieve desired results

Key Tips

Labels that appear over each tab and command on the ribbon.

Column headings

Letters along the top of the workbook window that identify the different columns in the worksheet

Sheets

Make up a workbook

Row headings

Numbers along the left side of the workbook window that identify the different rows of the worksheet

Backstage view

Provides access to various screens with commands that allow you to manage files and Excel options

Status bar

Provides information about the workbook

Cell reference

Something that identifies a cell by its column and row

Workbooks

Where excel stores spreadsheets


Related study sets

Statistics Math 125 - Module 1 Homework 1.6

View Set

Chp 16: Reentry into the Community

View Set

STAAR Vocab English 9th grade: Set 1

View Set

Chapter 1: General Principles of Pharmacology - PrepU

View Set

5.7A Formación de rocas sedimentarias y combustibles fósiles

View Set

Bones of the upper limbs or upper extremities

View Set

NU 226 Prep U Chapter 39: Oxygenation & Perfusion

View Set