spreadsheets

¡Supera tus tareas y exámenes ahora con Quizwiz!

in an excel file, if a label (such as the word "panda") is used in a formula, what will appear in the cell when the Enter key is pressed?

#VALUE!

Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 4, 2, 5, and 5.

= (4+2+5+5)/4

what does they symbol upper-case sigma represent in spreadsheets?

AutoSUM

In spreadsheets, all functions and calculations begin with

an equal sign

The basic unit of any spreadsheet, essentially a box where data can be entered, is called a(n)

cell

if you wish to keep a column visible while you scroll through the rest of a spreadsheet file, you can use the _ options

freeze

a common method to delete a column or row in most spreadsheet programs is to _ on the column or row heading, and then select Delete from the menu

right click

in a spreadsheet, a horizontal line of cells is called a

row

because they make it easy to arrange, display, and calculate numerical data, _ programs are commonly used in nearly every business setting

spreadsheet

You see ###### in a cell. This means that

this is not an error. The cell needs to be expanded in order to display the entire value.


Conjuntos de estudio relacionados

Inquizitive Chapter 5 (You May Ask Yourself)

View Set

Competency 004: geometry and measurement

View Set

A Beka: Grammar & Composition V 9

View Set