Excel 2010 - Chapter 2

Description

Flashcards on Excel 2010 - Chapter 2, created by dee.walker217 on 19/08/2014.
dee.walker217
Flashcards by dee.walker217, updated more than 1 year ago
dee.walker217
Created by dee.walker217 over 9 years ago
347
0

Resource summary

Question Answer
When typing a formula, begin the formula with this sign. EQUAL (=)
This the operator for division that is used when writing a formula FORWARD SLASH (/)
This is the operator for multiplication that is used when writing a formula ASTERISK (*)
As an alternative to the fill handle, use this button to copy a formula relatively in a worksheet. FILL BUTTON
A function operates on this, which may consist of a constant, a cell reference, or other function. ARGUMENT
This function returns the largest value in a set of values MAX
This is the keyboard shortcut to display formulas in a worksheet CTRL + `
This function finds the periodic payment for a loan based on constant payments and a constant interest rate PMT
This function returns the serial number of the current date and time. NOW
This function is considered a conditional function IF
To identify an absolute cell reference, type this symbol before the column and row DOLLAR SIGN ($)
This is used to copy a formula up, down, left, or right within a worksheet. FILL HANDLE
Show full summary Hide full summary

Similar

KEE3
harrym
Electromagnetism: Magnetic Flux Density & Magnetic Flux 2
tatemae.honne
Kenya- Tropical Mass Tourism Case Study
a a
Command or Process Words for Essay Writing
Bekki
English Placement Test
CoachDanielDixon
AS Economics Key Terms
Fred Clayton
Compensation and Benefits PHR Study Guide
Cari Hawthorne
AS English language terminology revision
Caitlin Hadfield
FV modules 1-4 infinitives- ENTER SPANISH
Pamela Dentler
World War I
Lydia Klein
AAHI_Card set 6 (Terms of movement)
Tafe Teachers SB