Excel Calculation G2

Defination

100

What is parentheses

()

200

What is Formula bar

Used to edit the contents of cells on the spreadsheet

300

What is function

A function is a special formula that can simplify complex calculations.

400

What is Indices?

^   3²

500

What is relative reference

row and column reference will both change

Syntax

100

SUM

=SUM(number1,[number2]…)

200

SumIF

=SUMIF( range, criteria, [sum_range] )

300

CountIF

= COUNTIF ( range , criteria )

400

the syntax of vlookup

=VLOOKUP ( lookup value , table_array , col_index_num , [range_lookup] )

500

What is a systematic orderly arrangement ?

Syntax

Formula

100

=(123+321)

444

200

=(4^5)

1024

300

=(1*2+3+4^2/2)

13 

400

=(99*11)

1089

500

(123+321-44*4/2^2-[(-18)+9]*9)

(123+321-44*4/2^2-[(-18)+9]*9)

Porpose

100

Sum

to add numbers

200

And function

Find a value that meets all the criteria

300

SumIF

adds all numbers in a range of cells based on one criteria

400

CountIF

a function to count cells that meet a single criteria

500

VLOOKUP

To look up a value or a series of values from a large database

Others&ShortCut

100

Home

Move to column A in a sheet

200

F2

Edit formula or cell contents

300

Alt+Pagedown

Move one screen to right

400

F9

Recalculate the formulas

500

Which two students' English mark are the same

Susan and David