EXCEL INTRO

Question 1

It is a spreadsheet program developed by Microsoft. iT organizes data in columns and rows and allows you to do mathematical functions. It runs on Windows, macOS, Android and iOS.

Answer 1

Excel

Question 2

The first version of excel was released in

Answer 2

1985

Question 3

Excel is typically used for:

Answer 3

Analysis
Data entry
Data management
Accounting
Budgeting
Data analysis
Visuals and graphs
Programming
Financial modeling

Question 4

Why Use Excel?

Answer 4

• It is the most popular spreadsheet program in the world
• It is easy to learn and to get started.
• The skill ceiling is high, which means that you can do more advanced things as you become better
• It can be used with both work and in everyday life, such as to create a family budget
• It has a huge community support
• It is continuously supported by Microsoft
  Templates and frameworks can be reused by yourself and others, lowering creation costs

Question 5

The easiest way to get started with Excel, is to use

Answer 5

Office 365.

Question 6

Excel’s structure is made of two pieces,

Answer 6

Ribbon and Sheet.

Question 7

is marked with a red rectangle

Answer 7

Ribbon

Question 8

is marked with a yellow rectangle:

Answer 8

Sheet

Question 9

is an action that allows you to make something happen.

Answer 9

command

Question 10

Ribbon is made up by the

Answer 10

App launcher, Tabs, Groups and Commands

Question 11

has nine dots and is called the Office 365 navigation bar. It allows you to access the different parts of the Office 365 suite, such as Word, PowerPoint and Outlook.

Answer 11

App launcher icon

Question 12

is a menu with sub divisions sorted into groups.

Answer 12

tab

Question 13

allow users to quickly navigate between options of menus which display different groups of functionality.

Answer 13

tabs

Question 14

is a set of rows and columns. It forms the same pattern as we have in math exercise books, the rectangle boxes formed by the pattern are called cells.

Answer 14

Sheet

Question 15

is used to do mathematical calculations

Answer 15

formula in Excel

Question 16

Creating formulas, step by step

Answer 16

-Select a cell
-Type the equal sign (=)
-Select a cell or type value
-Enter an arithmetic operator
-Select another cell or type value
-Press enter

Question 17

it allows you to work with selections of cells.

Answer 17

Ranges

Question 18

There are four different operations for selection;

Answer 18

• Selecting a cell
• Selecting multiple cells
• Selecting a column
• Selecting a row

Question 19

Filling can be used for:

Answer 19

• Copying
• Sequences
• Dates
• Functions (*)

Question 19

There are two ways to move cells:

Answer 19

• Drag and drop
• copy and paste.

Question 20

Excel has two types of references:

Answer 20

Relative references
Absolute references

Question 20

is when a reference has the dollar sign

Answer 20

Absolute reference

Question 21

Excel has many premade formulas

Answer 21

functions

Question 21

How to add cells:

Answer 21

1. Select a cell and type (=)
2. Select a cell
3. Type (+)
4. Select another cell
5. Hit enter

Question 22

is used to change the order of an operation.

Answer 22

Parentheses ()

Question 23

Returns TRUE or FALSE based on two or more conditions

Answer 23

XOR