Excel All Recap

MS Excel

All Recap​

This slideshow will recap all the knowledge gained n the previous lessons.

​MS Excel

MS Excel is a SPREADSHEET Software

​

The icon of MS Excel is Green color icon with an X​

​

MS Excel is very similar to Google Sheets

​

MS Excel is a software to create TABLES and CHARTS​

Some text here about the topic of discussion

Multiple Choice

What type of software is MS Excel?

• Spreadsheet

• Word Processing

• Picture

• Presentation

Multiple Choice

Which one of the following is the icon of MS Excel?

Multiple Select

Which of the followings can be created with MS Excel?

• Tables

• Charts

• Stories

• Pictures

One Excel tab is called a Worksheet

Many worksheets make a workbook

In this picture 7 sheets are open

Click on the + sign to add more sheets​

​Some text here about the topic of discussion.

Tabs/Sheets

​MS Excel

​

The tabs of MS Excel can be renamed.

To rename, double click on any tab

The tabs of MS Excel can be assigned colors

To color, right click and change the "tab color" ​

Some text here about the topic of discussion

Multiple Choice

IN Ms Excel, a collection of sheets is called?

• Workbook

• Story Book

• Excel Book

• Google Sheets

Multiple Choice

IN Ms Excel, to add more sheets, which button do you press?

• $$f\left(x\right)$$  

Formulas (Functions)

Many formulae are used in Excel for calculations

Auto sum button in Excel adds up all the values above

The auto sum button has Average, count, max and min functions too.

To count the number of values, use COUNT function

To find GREATEST value, use MAX function

To find SMALLEST value, use MIN function​

Some text here about the topic of discussion

Multiple Select

Which functions are available in auto sum button?

• COUNT

• MAX

• MIN

• AVERAGE

Multiple Choice

Which function is used to calculate the GREATEST value?

• =Max()

• =Min()

• =COUNT()

• =AVERAGE()

Multiple Choice

Which function is used to calculate the SMALLEST value?

• =Max()

• =Min()

• =COUNT()

• =AVERAGE()

Multiple Choice

Which function is used to COUNT value?

• =Max()

• =Min()

• =COUNT()

• =AVERAGE()

MS Excel - Formulas

Every formula in MS Excel starts with = sign

The sign for sum (or add) is +

The sign for subtract (minus) is -

The sign for divide is /

The sign for multiplication (times) is *​

Some text here about the topic of discussion

Multiple Choice

Which sign is used to start a formula in MS Excel?

• =

• +

• /

• *

MS Excel - Formula

Absolute Cell Reference

If you want to add, subtract, multiply or divide each value in the table with one specific value, we use ABSOLUTE CELL REFERENCE. For this, you will need to lock the specific cell by using $ sign.

For example, cell D5 can be locked like $D$5​

Some text here about the topic of discussion

Multiple Choice

Which on of the following is correct ABSOLUTE formula?

• (A1*$D$5)

• =(A1*$D$5)

• =(A1*$D5)

• =(A1*D$5$)

MS Excel - Sorting

You can sort values in Ascending or Descending orders

To sort from SMALLEST to BIGGEST --> Sort Ascending Order

​

To Sort from BIGGEST to SMALLEST --> Sort Descending Order​

Some text here about the topic of discussion

MS Excel - Sorting

You can sort values in Ascending or Descending orders

The sort sign in Excel looks like this

Some text here about the topic of discussion