UPDATES.
About This Resource:
This all-in-one guide is designed to teach you how to confidently use Microsoft Excel and Word, two of
the most powerful tools in the Microsoft Office suite. With easy-to-follow tutorials, real-world
examples, and hands-on exercises, you’ll learn how to write and format documents in Word and
organize, analyze, and visualize data in Excel. Perfect for students, professionals, and beginners alike.
___ ___ means that the width of the column will be increased or decreased so the widest entry will fit in
the column. - ✔✔-best fit
____ _____ is a powerful spread sheet program that allows users to organize data, complete calculations,
make decisions, graph data, develop professional looking reports, publish organized data on the web, and
access real time data from web sites. - ✔✔-Microsoft Excel, Excel
____ _____ is the amount of space above and below a paragraph - ✔✔-paragraph spacing
____ -____ ____ allows you to edit the contents of the cell directly in the cell - ✔✔-In cell editing
____ allows you to type words in a paragraph continually without pressing the enter key at the end of
each line. - ✔✔-Wordwrap
____ and _____ editing allows you to select the text to be moved and the drag the selected item to the
new location to be dropped or inserted - ✔✔-drag and drop
____ are explanatory notes at the end of a document - ✔✔-endnotes
____ dollar signs appears immediately to the front of the first digit in a new cell with no spaces. - ✔✔-
floating
____ is the process of copying an item from the office clipboard into the document at the location of the
insertion point - ✔✔-pasting
, ____ mode is used to select cells for use in formulas by using the mouse. - ✔✔-point
____ or type face defines the shape and appearance of letters numbers and special characters - ✔✔-font
_____ ____ specifies the size of its characters and its determined by the measurement system called
points. - ✔✔-font size
_____ _____ are noted IN the document instead of at the bottom or end of a document. - ✔✔-
Parenthetical reference
_____ _____ is the amount of vertical space between lines of text in a paragraph. - ✔✔-line spacing
_____ _____ properties include information such as date statistics and file size. - ✔✔-Automatically
updated
_____ ______ which is activated by double clicking a cell, displays the cell entry in a formula bar and
shows a flashing insertion point. - ✔✔-edit mode
_____ an item enlarges or reduces the size, and should be done through the corners of the item. - ✔✔-
resizing, resize
_____ are words or phrases that further describe a document - ✔✔-keywords
_____ charts are used to show the relationship or proportion of parts to a whole. - ✔✔-pie
_____ is a named group of formatting characteristics - ✔✔-style
_____ is a prewritten formula in excel - ✔✔-function
_____ is the process of removing the item from the document before placing it on the office clipboard -
✔✔-cutting