spreadsheets
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!
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.
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