FB Business Computer • Excel 1 Test • LEARN MODULE Due 11/3/25 7:30 AM

Write a formula that totals all the numbers in the range that begins with cell A1 and ends with cell B8.

=SUM(A1:B8)

chart

conveys a visual representation of data

fill handle

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

format

to emphasize certain entries and to make the worksheet easier to read and understand

font face

defines the appearance and shape of the letters, numbers, and special characters

font style

indicates how the characters are emphasized

function

a predefined formula

range

a series of two or more adjacent cells in a column, row, or rectangular group of cells

relative reference

a reference that automatically adjusts for the new position when copied

font size

specifies the size of the characters

font colors

changes the color of the letters, numbers, and symbols

cell style

a predefined font, font size, and font color that you can apply to a cell

Theme Colors

colors that are included in the current workbook's theme

Merging cells

creating a single cell by combining two or more selected cells

text

any set of characters containing a letter, hyphen, or space

hard copy

information that exists on paper

What 2 ways can you perform calculations in Excel?

using a function or an operator

Why should you use functions in Excel instead of performing calculations by hand?

to prevent errors and to work more efficiently

What options are available in the AutoSum drop-down menu?

SUM, AVERAGE, COUNT, MAX, MIN

What is the easiest way to copy text, numbers, or formulas to adjacent cells?

Use the Autofill handle

With what does every formula begin in Excel?

an equal sign

How do you center a single cell's text across a number of cells

by pressing the Merge & Center button on the Home Row

What does the SUM function do?

adds all the numbers in a range

What are the two popular forms of digital image copies?

PDF, XPS

portrait orientation

short edge (8 1/2") at the top

landscape orientation

long edge (11") at the top

How many past actions does Excel remember?

100

What are the worksheets named by default?

Sheet1, Sheet2, etc.

What are the chart sheets named by default?

Chart1, Chart2, etc.

How are font sizes measured?

with points

How do you unmerge a cell?

Splitting it by clicking the Merge & Center button on the Home Row again

What should you do if your numbers display like hashtags? (####.##)

widen your column

What should a worksheet subtitle include?

a more detailed description of the content

What do sheet tab names often match?

the worksheet title

What is the most efficient way to enter numbers?

Use the 10-key pad on your keyboard

What is one of the most powerful features of Excel?

performs calculations on numeric data

What happens when you copy formulas from one cell to another regarding the referenced cells with relative references?

The references automatically adjust for each new position.

Why does Excel highlight the cell references in the formula in color?

because the most common error when entering a formula is to reference the wrong cell

Why should you save your workbook frequently?

In case your computer crashes so you don't have replicate work

What are the default Font Face, Size, Style, and Color when you start a blank workbook in Excel?

Calbiri, 11-point, regular, black

What happens if you merge two cells that both contain data?

the data in the second cell is deleted

How do you widen your column?

Position your mouse pointer between the two column headers until the pointer turns to a double-headed black arrow. Then either drag or double-click.

What determines which type of chart you will choose?

the type and quantity of data you have and the message or analysis you want to convey

Why would you explode a pie chart?

to draw attention to a particular slice in the pie chart

How do you explode a slice in a pie chart?

click the slice two times to select (do not double-click) and then drag the slice outward

Why should you change the name of your worksheets and chart sheets?

because it is easier when the sheets are named according to the data they hold

Why should you move a chart to its own chart sheet?

the chart will increase in size, which will improve readability

How do you make a worksheet a PDF?

File tab, Save as, select PDF as file type

How do you clear a range of cells?

Select the cells and press DELETE

Why are the numbers right-aligned?

in order to vertically align decimal and integer values

How do you select a nonadjacent range?

Click and drag on the first range, then press CTRL, then click and drag on the second range while you are holding CTRL.

What is the first step in creating an effective worksheet?

to make sure you understand what is required

Should you enter dollar signs and commas when you enter data? Why or why not?

No. You will use Excel's formatting features to put these in.

What is the easiest way to insert a column or row?

Click on the column or row heading of the one after where you want to insert, right-click, choose Insert

What is the easiest way to delete a column or row?

Click on the column or row heading you want to delete, right-click, choose Delete