Vocabulary MS Excel 2019 Part 1 Worksheet Basics

Local Drive

The hard drive located inside your computer.

Network Drive

A shared computer drive containing files from all users in an organization and requires a login.

Removable Drive

A small portable device that stores a large amount of data; often used to transfer information between computers.

File Manager

Used to view your computer's folder structure. It allows the user to see folders and files located on the computer's hard drive, network drive, and any connected removable drives.

Cloud Drive

Online storage that's available to you from any computer, tablet, phone, or other device with Internet access.

Syncing

The process of updating computer files that are in two or more locations according to specific rules.

AutoSave

A feature in an application program that saves the current file after a specified amount of time has elapsed

Office 365

A version of Microsoft Office to which you subscribe for an annual fee

Start Screen

Used to open existing workbooks from a list of recent, pinned, or shared files, or create a new workbook or spreadsheet

Backstage View

Opens when you click the File tab, containing commands for managing files, setting program options, and printing.

Application Window

The main window that serves as the primary interface between the user and the application with access to tools needed to enter, edit, and format data.

Ribbon Parts

A strip of icons that appears across the top of the window; divided into tabs, each of which contains groups of related tools.

Worksheet

A "page" within an workbook that contains columns, rows, and cells.

View Controls

Adjust zooming in and out of a worksheet, as well as selecting page view options

Status Bar

The area along the lower edge of the window that displays, on the left side, the current cell mode, page number, and worksheet information; on the right side, when numerical data is selected, common calculations such as Sum and Average display.

Blank Workbook

A new, empty workbook that contains one worksheet (sheet).

Save

A button in the Quick Access Toolbar or Backstage view that keeps an existing document.

Browse

Used in the backstage view to see different places where your workbook can be saved.

Close the Workbook

Used in the backstage view to shutdown the workbook you are working on.

Open Recent Workbook

Used in the backstage view or start screen to utilize a previously saved workbook

Save As Command

A command used to keep an open file with a different name or in a different location.

Print a worksheet

Used in the backstage view to create a hardcopy of a worksheet.

Preview a Worksheet

Used to see what a hard copy printout will look like without actually printing.

Share

Used to attach a copy of a workbook to an email or save to PDF or even OneDrive

Adjust row height and column width

The two sided arrow that appears between rows and columns that can be double clicked or manually slid

Delete Cells

Used to remove individual cells or cell contents without impacting data surrounding.

Insert Row/Column

Placing a new, blank row or column in the spreadsheet.

Freeze Panes

To keep selected rows and/or columns of the worksheet visible on the screen as the rest of the worksheet scrolls.

Delete row(s) / column(s)

Used to remove a column or row in a worksheet.

Cut/Copy/Paste

a feature that enables you to move or copy text from one place to another

Undo

A command that allows users to cancel or undo their last command or action.

Spelling

A tool used to assist you in finding and correcting typographical or spelling errors.

Thesaurus

A feature that allows the user to view synonyms and antonyms, and automatically replace words for enhanced writing

Paste Options

Commands that appear below and to the right of pasted text with a menu of options for formatting the pasted text.

Quick Access Toolbar

A toolbar that contains commands that users use more often, such as Save, Undo, and Redo.

Redo

The command used to redo an action you have undone.

Search

Used to learn about features or get help with a specific task

Smart Lookup

The feature that displays the definition and additional information from the Internet of a selected word or words.

Advanced Properties

Used to manage document controls including descriptive and identifying details about the file.

Inspect Document

Used to detect and remove unwanted private or proprietary information from a document