Excel Chapter 1 Test Flashcards

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is an Excel worksheet?

Allows data easily to be summarized and charted.

What is a requirement document?

Includes a needs statement, a source of data, a summary of calculations, any special requirements for the worksheet, such as charting and Web support.

What is the first step in creating an effective worksheet?

Make sure you understand what is required.

What is a cell?

Intersection between a row and column. Signup and view all the answers

What is an active cell?

When a heavy border surrounds the cell, active cell references appear in the name box on the left side of the formula bar, and headings change to a gold color. Signup and view all the answers

What is text used for in an Excel worksheet?

Used to place titles, such as worksheet titles, column titles, and row titles on the worksheet. Signup and view all the answers

What key on the keyboard do you hit to cancel an entire entry before entering it into a cell?

Cancel box or escape key. Signup and view all the answers

What box do you hit to complete an entry?

Enter box. Signup and view all the answers

What is an insertion point?

Blinking vertical line that indicates where the next typed character will appear. Signup and view all the answers

What does the AutoCorrect feature do?

Works behind the scenes, correcting common mistakes when you complete a text entry in a cell. Signup and view all the answers

What are two ways to complete an entry and activate the adjacent cell to the right?

Use the arrow keys Signup and view all the answers

What alignment does text have in a cell by default?

Left-alignment. Signup and view all the answers

What characters does Excel consider numbers?

0 1 2 3 4 5 6 7 8 9 + - () , /.$ % E e. Signup and view all the answers

Instead of entering 6,000,000,000,000,000 you can type ______.

6E15 which translates to 6x10^15. Signup and view all the answers

What is a range?

A series of two or more adjacent cells in a column or a rectangular group of cells. Signup and view all the answers

How do you separate a range while manually typing a formula?

A colon. Signup and view all the answers

What character do you use to enter a number and have Excel treat that number as text?

Apostrophe. Signup and view all the answers

What is the cell that is being copied called?

Source area or copy area. Signup and view all the answers

What is a relative cell reference?

Each adjusted cell reference. Signup and view all the answers

What are your choices in the Auto Fill Options menu?

Allows you to choose whether you want to copy the values from the source area to the destination area with formatting, do so without formatting, or copy only the format. Signup and view all the answers

What is the fill handle and where is it located?

Small black square located in the lower-right corner of the heavy border around the active cell. Signup and view all the answers

What does formatting do for a worksheet?

To emphasize certain entries and make the worksheet easier to read and understand. Signup and view all the answers

What is the general rule for how many font types to use in a worksheet?

Use no more than two fonts in a worksheet because the use of more fonts can make a worksheet difficult to read. Signup and view all the answers

What are the shortcut keys for bolding a font?

Ctrl+B. Signup and view all the answers

What tab and group is Cell Styles in on the Ribbon?

Home tab | Styles group. Signup and view all the answers

What is the Accounting Number Format and what does it do when applied to numbers?

Causes cells to be displayed with two decimal places so that decimal places in cells below the selected cells align vertically. Signup and view all the answers

What is the Comma Style format and what does it do when applied to numbers?

Causes the cells to be displayed with two decimal places and commas as thousands separators. Signup and view all the answers

What are the keyboard shortcut keys to get to cell A1 from anywhere in the worksheet?

Ctrl+Home. Signup and view all the answers

How many chart types are in Excel?

<ol start="11"> <li></li> </ol> Signup and view all the answers

What is an embedded chart?

It is drawn on the same worksheet as the data. Signup and view all the answers

What does a chart legend do?

Identifies the colors assigned to each bar in the chart. Signup and view all the answers

What are the standard properties of an Excel workbook and what is included in them?

They are associated with all Microsoft Office documents and include author, title, and subject. Signup and view all the answers

Study Notes

Excel Worksheet Basics

An Excel worksheet enables easy data summarization and charting.
A requirement document includes a needs statement, data sources, calculations summary, and specific needs like charting and web support.

Creating Effective Worksheets

Understanding requirements is the first step in creating an effective worksheet.

Cells and Active Cells

A cell is the intersection of a row and a column.
The active cell is highlighted by a heavy border, shows references in the name box, and features gold-colored headings.

Text and Data Entry

Text is used for worksheet titles, column titles, and row titles.
To cancel a cell entry, press the cancel box or escape key.
Complete an entry by hitting the enter box or by using the arrow keys or tab key to move to the adjacent cell.

Indicators and Features

The insertion point is a blinking vertical line showing where the next character will be typed.
AutoCorrect works in the background to fix common mistakes when entering text in a cell.

Default Formatting and Numeric Types

By default, text in a cell is left-aligned.
Excel recognizes numbers as any characters: 0-9, +, -, (), , , /, . , $, %, E, e.
To enter large numbers succinctly, instead of typing 6,000,000,000,000,000, use 6E15 (which means 6 x 10^15).

Ranges and References

A range is two or more adjacent cells in a column or a rectangular group of cells.
Ranges are separated in formulas using a colon.
To enter a number as text, use an apostrophe.
The source area (or copy area) refers to the cell being copied.
A relative cell reference adjusts based on the position of the copied cell.

Auto Fill and Formatting

The Auto Fill Options menu lets you choose how to copy values between the source and destination areas.
The fill handle is a black square in the lower-right corner of the active cell's border used for autofilling.

Formatting Best Practices

Formatting helps emphasize entries and enhances worksheet readability.
A general rule is to use no more than two fonts in a worksheet for clarity.
Use ctrl + b for bolding text.
Cell Styles can be found in the home tab under the styles group.

Number Formats

Accounting Number Format displays numbers with two decimal places, aligning them vertically.
Comma Style format shows numbers with two decimal places and uses commas as thousands separators.

To navigate to cell A1, use the shortcut ctrl + home.
Excel features 11 chart types, with an embedded chart appearing on the same worksheet as the corresponding data.

Chart Elements

A chart legend identifies colors assigned to each data series in a chart.

Workbook Properties

Standard properties of an Excel workbook include author, title, and subject, linked to all Microsoft Office documents.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

Test your knowledge of the essential concepts from Excel Chapter 1 with these flashcards. Each card contains a term or question related to worksheets, requirements, and their importance in data management. Perfect for students and professionals looking to enhance their Excel skills.