AIS

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

cell reference.

using cell addresses to create a formula

grave accent

what is this ` called?

double click formula bar

what to do to view formula in the cell

cell reference

will ensure that your formulas are always accurate because you can change the value of ____cells without having to rewrite the formula.

Formulas and functions

Cells can contain _____&____ that calculate cell values.

name or cell address

Each cell has its own ___

Fill handle

Good alternative to copy and paste commands, can also be used to continue a series

reference style

If the columns in your spreadsheet are labeled with numbers instead of letters, you'll need to change the default ___for Excel.

Parenthesis

Makes any equation easier to read and to clarify that they will be calculated before the addition or etc.

Name box

Note that the cell address also appears in the ___ in the top-left corner, and that a cell's column and row headings are highlighted when the cell is selected.

calculate numerical information using formulas

One of the most powerful features in Excel is the ability to

Pound signs

Result of a formula when it is too large to be displayed in a cell

cutting

allows you to move content between cells

Cells

basic building blocks of a worksheet

text

cells can contain ___ such as letters, numbers, and dates

Formatting attributes

change the way letters, numbers, and dates are displayed

letters

columns are identified as ___

Cells

thousands of rectangles,

esc / cancel

to avoid accidentally making changes to your formula

ctrl + `

to show all formulas in the spreadsheet and to switch back to normal view

cell range.

A group of cells

equals sign (=).

All formulas in Excel must begin with an

text, formatting, formulas, and functions

different types of content,

change default reference style

if the columns of the spreadsheet are labeled with numbers instead of words, what is done

name box

located in the top-left corner where the cell address appears

numbers

rows are identified as ___

plus sign, minus sign, asterisk, forward slash, caret

standard operators for formula of excel:

Cells

the intersection of a row and a column


Set pelajaran terkait

Nutrition Final Exam Chapter 9 review

View Set

Chapter 29: Mental Health Disorders of Older Adults

View Set

NUTR 3362 Ch.6: Fats and Other Lipids

View Set

Chapter 7 (Business in a Changing World)

View Set

chp 6 mktg, chp 6 mktg, Marketing Ch.6, Marketing Chapter 8, MKTG test 2 ch 6, MKTG ch 3, Marketing 351 Chapter 1, Marketing, MKTG Chapter 1, MKTG Chapter 5, MKT 230 - chp. 5

View Set

Sociology chapter 3 & guided reading

View Set

ap comp sci principles midterm review

View Set