Scribd
Upload
72 views12 pages

Nubers To Use: Operation: Formulas: Answers: 1 Addition (+) 3 2 Subtraction (-) - 1 3 Multiplication ( ) 2 4 Division (/) 0.5 5 Power ( )

This document contains sample data and formulas for performing various calculations and operations on numeric data including sums, averages, counts, minimums, maximums, and more. It also demonstrates the use of functions like IF, SUMIF, SUMIFS and charts. The data includes examples of fruits, vegetables, meats, baked goods and voting results.

Uploaded by

api-450904901
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
72 views12 pages

Nubers To Use: Operation: Formulas: Answers: 1 Addition (+) 3 2 Subtraction (-) - 1 3 Multiplication ( ) 2 4 Division (/) 0.5 5 Power ( )

This document contains sample data and formulas for performing various calculations and operations on numeric data including sums, averages, counts, minimums, maximums, and more. It also demonstrates the use of functions like IF, SUMIF, SUMIFS and charts. The data includes examples of fruits, vegetables, meats, baked goods and voting results.

Uploaded by

api-450904901
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 12

Nubers to use: Operation: Formulas: Answers:

1 Addition (+) 3
2 Subtraction (-) -1
3 Multiplication (*) 2
4 Division (/) 0.5
5 Power (^)
Fruit Amount Meat Amount
Apples 50 Beef 50
Oranges 20 Chicken 30
Bananas 60 Pork 10
Lemons 40 Fish 50
SUM> 170 SUM> 140

Item Amount Item Amount


Bread 50 Bread 50
Donuts 100 Donuts
Cookies 40 Cookies 40
Cakes 50 Cakes 50
Pies 20 Pies 20
SUM> 260 COUNT> 4
Fruit Amount Meat Amount
Apples 50 Beef 50
Oranges 20 Chicken 30
Bananas 60 Pork 10
Lemons 40 Fish 50
AVERAGE> 42.5 AVERAGE> 35

Item Amount Item Amount


Bread 50 Bread 50
Donuts 100 Donuts 100
Cookies 40 Cookies 40
Cakes 50 Cakes 50
Pies 20 Pies 20
AVERAGE> 52 MEDIAN> 50
Fruit Amount Meat Amount
Apples 50 Beef 50
Oranges 20 Chicken 30
Bananas 60 Pork 10
Lemons 40 Fish 50
MIN> 20 MAX> 50

Item Amount Item Amount


Bread 50 Bread 50
Donuts 100 Donuts 100
Cookies 40 Cookies 40
Cakes 50 Cakes 50
Pies 20 Pies 20
MIN or MAX 20 10
Date functions
Today's date: 3/18/2019
Your birthday: 9/6/2001
Days until your birthday: -6402

Grace period days: 12/15/2018


Bill due on: 86991
First Name Last Name Last Name, First Name Full Name
Nancy Smith Smith, Nancy Nancy Smith
Andy North North, Andy Andy North
Jan Kotas Kotas, Jan Jan Kotas
Mariya Jones Jones, Mariya Mariya Jones
Steven Thorpe Thorpe, Steven Steven Thorpe
Micheal Neipper Neipper, Micheal Micheal Neipper
Robert Zare Zare, Robert Robert Zare
Yvonne Mckay Mckay, Yvonne Yvonne Mckay

Smith, Nancy
North, Andy
Kotas, Jan
Jones, Mariya
Thorpe, Steven
Neipper, Micheal
Zare, Robert
Mckay, Yvonne
CAPSLOCK SMALL CAPS Default case
NANCY SMITH nancy smith Nancy Smith
ANDY NORTH andy north Andy North
JAN KOTAS jan kotas Jan Kotas
MARIYA JONES mariya jones Mariya Jones
STEVEN THORPE steven thorpe Steven Thorpe
MICHEAL NEIPPER micheal neipper Micheal Neipper
ROBERT ZARE robert zare Robert Zare
YVONNE MCKAY yvonne mckay Yvonne Mckay
IF statements
Melon 0
Orange 0

90 Less than 100


Fruit Amount Meat Amount
Apples 50 Beef 50
Oranges 20 Chicken 30
Bananas 60 Pork 10
Lemons 40 Fish 50

Apples 50 Pork 10
Fruit Amount Fruit Type Amount
Apples 50 Apples Fuji 50
Oranges 20 Oranges Florida 20
Bananas 60 Bananas Cavendish 60
Lemons 40 Lemons Rough 40
Apples 50 Apples Honeycrisp 50
Oranges 20 Oranges Navel 20
Bananas 60 Bananas Lady Finger 60
Lemons 40 Lemons Eureka 40
Apples 50 Apples Honeycrisp 50
Oranges 20 Oranges Navel 20
Bananas 60 Bananas Cavendish 60
Lemons 40 Lemons Eureka 40

Fruit SUMIF Fruit Type SUMIFS


Apples 150 Oranges Florida 20
Fruit Amount
Apples 50
Oranges 20
Bananas 60
Lemons 40

Apples 50
Favorite Treats Number of Votes
Candy 18
Chips 40
Cookies 80
Pizza 12

90 Favorite Treats
80
70
60
50
40 Number of Votes
30
20
10
0
Ca ndy

Cooki e s
Chi ps

Pi zza

You might also like