Excel 1: Essentials (module)
describe the three parts of a function...
functions must start with an equal sign in the first character of the cell. the function name indicates the operation to be performed, such as a sum. arguments contain the information you want to use in the function's calculation.
what is alignment?
how the text is positioned within the borders of the cell. alignment commands include left align, right align, center align, increase indent, decrease indent, and wrap text.
what do the increase decimal and decrease decimal commands do?
increase decimal shows one more decimal place for the selected cells and decrease decimal shows one fewer decimal place for the selected cells
what does the format "general" indicate about a number in the cell?
it is just a regular number, and not a date or amount of money
describe the wrap text command...
it wraps the text around to another line so it all fits within the cell
what can a cell contain?
numbers, text, formulas, and functions
how can you force a certain order of operations in a formula?
parenthesis
ctrl + v
paste
what are format attributes?
pieces of information that describe the appearance of the cell's content. they are associated with a cell and not with the cell's content.
a cell in a spreadsheet contains a formula. how can you see what formula is in the cell?
select the cell to see the formula in the formula bar
what is the process described in this lesson for formatting a number using the ribbon?
select the cell. on the home tab, in the numbers group, click the number format drop-down menu. select the desired format.
what is a worksheet?
spreadsheets. the first worksheet is called sheet 1, by default. you can add, reposition, and rename worksheets.
what is the name box?
the address of the cell you have selected
explain how the color coding of cell references in a formula works and why it is useful...
the colors are used to highlight the cell references in the formula, and the referenced cell in the worksheet. the color coding of cell references provides an easy way to see what cells in the worksheet are being used in the formula.
what is an active cell?
the currently selected cell.
describe the three parts of a formula...
the equal sign must be the first character in the cell. it tells the spreadsheet you are starting a formula. the operand is a value or the data used in the formula's calculation. the operator indicates the type of calculation to be done.
describe the two ways you can enter cell references into a formula...
type the cell reference or point and click on the cell
ctrl + z
undo
when should you use the ctrl key method for selecting multiple cells?
when you want to select cells that are scattered across the worksheet. click on the first cell you want to select. press the ctrl key. click on the remaining cells. release the ctrl key.
when should you use the shift key method for selecting multiple cells?
when you want to select very large groups of cells. click on the first cell in the group. find the last cell in the group. press the shift key and then click on the last cell in the group.
what is the cell's address?
where a row and column intersect
why do formulas make spreadsheets more powerful?
you can calculate additional information that helps analyze already existing data
what is the benefit of entering or editing a formula using the formula bar?
you can see more of the formula
what is the order of operations? (in order)
PEMDAS
what is a row?
a group of cells that runs horizontally, from left to right. they are identified by numbers.
what is a column?
a group of cells that runs vertically, from top to bottom. they are identified by letters.
what is a function?
a predefined formula that allows you to quickly enter a formula
what is a cell reference?
a way to point to a cell location on the spreadsheet
SUM
adds all values in a range of cells
what is edit mode?
allows you to edit existing data in a cell. to format the cell, you should not be in editing mode.
what is a formula?
an equation that is entered in a cell, such as 3+5
what is a workbook?
an excel file
AVERAGE
calculates the average of the range of cells by summing the cells and dividing by the number of cells used to find the sum
escape
cancel current command
describe the three clear commands covered in this lesson...
clear formats deletes the format from the selected cells. clear contents deletes the content from the selected cells. clear all deletes the content and format from the selected cells.
which method is the most common way to select multiple cells?
click and drag method. click and hold down the mouse button on the first cell. drag the mouse to select the desired cells. release the mouse button.
what are three ways to change the column width in excel?
click and drag the column's boundary line to the desired width, double-click on the column's boundary line to adjust the width to the widest data in the column, or right-click on the column header and then click column width.
what is a complex formula?
contains more than one type of operator
what is a simple formula?
contains one type of operator.
ctrl + c
copy
COUNT
counts the cells with numerical values in the range of cells
ctrl + x
cut
what keyboard shortcut is used to clear contents for selected cells?
delete button
what is the order of operations? (definition)
determines which parts of a complex formula to calculate first
describe the two ways to edit a formula...
double-click on the cell and edit the formula directly in the cell or select the cell and edit the formula in the formula bar
what is a cell?
each rectangle in a spreadsheet
describe two ways to enter a formula in a spreadsheet...
enter the formula directly in the cell or select the cell and enter the formula in the formula bar
where would you click to delete cell content and format information?
eraser
MAX
finds the largest value included in a range of cells
MIN
finds the smallest value in a range of cells
describe how format attributes affect a cell and its content...
format attributes are how a cell looks, such as color, and does not affect its contents.
