Section 3: Excel Environment

Question 1

What is Line-up Break and its Short-Key?

Answer 1

Option+Enter(return) and it is building up rows inside one cell.

Question 2

What is Short-Key for quick move AND select till end of a row?

Answer 2

Shit+command+(right arrow key)

Question 3

What is Short-Key for quick move AND select till end of a column?

Answer 3

Shit+command+(down arrow key)

Question 4

What is the Short-Key for selecting another cells with addition of previous selected cells?

Answer 4

Shift+Arrow Keys(up, down, left or write)

Question 5

What is Pivot table?

Answer 5

When we have a large data in a table and want to sort based count, average, sum or etc…. we can use Pivot table for grouping the data for better decision making. For example we have sales of different years of different products in a large table and now we want to group years in columns, products in rows and their sold volume inside the table. Here, Pivot table will be the solution.

Question 6

Where is Pivot table?

Answer 6

Insert

Question 7

What segments are inside one Pivot Table?

Answer 7

Filters, Rows, Columns and Values.

Question 8

What is the process for using a Pivot Table option?

Answer 8

First, select the area then click on Pivot table and then choose each column to appropriate segment(Column, Row, Value) and set a right value by clicking on (i).

Question 9

I want to change value of a Pivot table after creation how?

Answer 9

Right click on the Pivot and then select Fields Settings.

Question 10

What is Text to Column?

Answer 10

When we have a sentence or a code and we want to put certain segments of this into separated columns inside excel. For example, a file named PI-SL.1-Mariusz-PL into 4 columns between dashes.

Question 11

Under which factors Text to Column can be?

Answer 11

First group can be upon elements between words like: (-) OR (.) OR (,) …OR any other we give by ourselves. Second option is operated based on specific dimension.

Question 12

Can we choose Text to Column while pasting?

Answer 12

No! First paste and then from the Data tab select Text to Column.

Question 13

Where is Text to Column?

Answer 13

Data

Question 14

How to see borders of print area?

Answer 14

First select the section(or select whole sheet from top left corner)—> Second, From Page layout select Print Area —> Third: From same tab set the Size and choose the appropriate size e.g. A4.

Question 15

Where is the Print Area?

Answer 15

Inside the Page Layout.

Question 16

Where is Page Layout? .

Answer 16

Inside the View tab

Question 17

What is the differences between Print Area and Page Layout?

Answer 17

Print Area is inside Page Layout tab and Page Layout is inside the View tab. Inside the Print Area we will see only a borders in dotted blue lines but inside Page Layouts we see separated pages.