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 10 years ago
348
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

HSC Economics
lydia le
FCE Practice Fill In The Blank
Christine Sang
Exchange surfaces and breathing
megan.radcliffe16
Physical Geography
clongworth25
Checking out me History by John Agard
Eleanor Simmonds
PSYA1 - attachment, AQA psychology
T W
Computer Systems
lisawinkler10
World War One
Micheal Heffernan
1PR101 2.test - Část 16.
Nikola Truong
1PR101 2.test - Část 19.
Nikola Truong
SFDC App Builder 1 (126-150)
Connie Woolard