DIT Semester Exam Study Guide

What is a worksheet in Excel?

• Collection of cells organized in rows and columns.

• A file that contains one or more pages to help you organize data

• A tool that gives helpful hints about how to complete tasks in Excel.

What is a cell when working in Excel?

• An area designated for time and date.

• A rectangular box that occurs at the intersection of a vertical column and a horizontal row in a worksheet

• An area used for entering name and location.

Columns are

• numbered 1,2,3

• horizontal.

• lettered A to Z, AA to AZ and the last column is labeled XFD

Rows are

• lettered A to Z, AA to AZ, and the last column is labeled XFD

• numbered 1, 2, 3

• named A1 - A100

An active cell in Excel is

• the selected, highlighted, or clicked-upon cell.

• an area to use functions.

• an area to use formulas.

The Quick Access Toolbar in Microsoft Word is

• a toolbar that allows access to other documents you have created.

• a toolbar that features fast typing functions.

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

What is a ribbon in Microsoft Office Word and Excel?

• A ribbon is a command bar that organizes a program's features into a series of tabs at the top of a window

• Clip art that can be inserted into the document.

• A bookmark used to keep your place in your document.

A template in Microsoft Office Word and Excel is

• a predesigned document you can use to create documents quickly without having to think about formatting

• a saved document used for email.

• a saved document for party invitations.

What is a word wrap in Microsoft Word?

• process in which words wrap around the edges of the document

• process by which a word which comes at the end of a line is automatically moved onto a new line in order to keep the text within the margins

• copies words or paragraphs to be used in another document

What is portrait orientation?

• A format commonly used for brochures, graphics, tables and so on that orients text across the longer dimension of the page.

• A format for family pictures

• A format commonly used for business documents in which text extends across the shorter length of the document.