Excel Chapter 1 Test

auto calculate area

can obtain a total, an average, or other info about the numbers in a range

source area

cell being copied

column heading

identifies each column

row heading

identifies each row

requirements document

include a needs statement, source of data, summary of calculations, and any other requirements for the worksheet, such as charting and web support

merging cells

involved creating a single cell by combining two or more selected cells

embedded chart

it is drawn on the same worksheet as the data

name box

on the left side of the formula bar

destination area

range of cells receiving the copy

x-axis

scale along the horizontal axis

y-axis

scale along the vertical axis

range

the area of variation between upper and lower limits on a particular scale, a series of 2 or more adjacent cells in a column or row or a rectangular group of cells

cell

the basic unit of a worksheet into which you enter data

gridlines

the horizontal and vertical lines on the worksheet itself

active cell

the one into which you can enter data

fill handle

the small black square located in the lower right corner of the heavy border around the active cell

text

used to place titles, such as worksheet titles, column titles, and row tiles, on the worksheet

worksheet title, subtitle, column title, row title, & chart title

what are 3 different types of titles on a worksheet?

heavy border surrounds the cell, the cell reference shows in the name box, column & row heading are highlighted

what are 3 ways you can identify an active cell?

click in the cell, use the arrow keys on keyboard, click enter

what are the ways in which you can select a cell?

sheet tab

where the sheet name appears; on the bottom of the workbook

cell reference

which is the coordinates of the intersection of a column and a row

number

Can contain only: 0 1 2 3 4 5 6 7 8 9 + - () , / . $ % E e

It is a spreadsheet program that allows users to organize data, complete calculations, make decisions, graph data, and more

Define Excel:

1. to emphasize certain entries 2. make the worksheet easier to read and understand

Explain why a worksheet should be formatted:

B₄, B₅, B₆, B₇, and B₈ is read as B4:B8 ( : means 'to')

Give an example of how a range of cells should be written:

columns- 16,384 rows- 1,048,576

How many columns and rows a worksheet has?

3 worksheets, in office 365- only 1 opens

How many worksheets open in a workbook?

0 1 2 3 4 5 6 7 8 9 + - () , / . $ E e

In Excel, a number can contain what characters?

workbooks and worksheets, charts, tables, web support

What are the major parts of Excel?

A1:A10

What is an example of a range?

It is an area on the status bar that allows you to easily find the total average, or other information about numbers in a range. You highlight the range, right-click the auto-calculate area, and select the calculation you want.

What is the auto-calculate area and where is it found?

to know what is required (what type of info. are you trying to gain

What is the first step in creating a worksheet?

workbook

a collection of worksheets

sum function

adds all of the numbers in a range cells, provides a convenient means to accomplish a task

worksheet

allow users to enter, calculate, manipulate, and analyze data such as numbers and texts

formula bar

bar appears below the ribbon as you type, excel displays the entry