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