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