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 almost 10 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

River Processes and Landforms
1jdjdjd1
10 Study Techniques
PatrickNoonan
C2 - Formulae to learn
Tech Wilkinson
AQA GCSE Biology Unit 2.3
Matthew T
AS AQA Accounting Unit 1 - FLASH CARDS
Harshad Karia
C1, C2, C3 keywords
Jessica Phillips
Present Simple vs. Present Continuous
Marek Mazur
GCSE AQA Biology 1 Variation, Genetics & Reproduction
Lilac Potato
GCSE AQA Biology 3 Kidneys & Homeostasis
Lilac Potato
med chem 2 final exam
lola_smily
1PR101 2.test - Část 15.
Nikola Truong