Fernando ADMIN Deck 1

Question 1

What is this formula used for? =SUM

Answer 1

It sums all the cells inside the formula

Question 2

What is this formula used for? =Average

Answer 2

It provides the average number inside the cells given

E.g. if the numbers given are: 5,5,5 then the average is “5” as 15/3 is

Question 3

What is this formula used for? =Concatenate

Answer 3

Is used to combine values from several cells into one cell.

E.g. if you have on cell A2 the text: “Hola” and on cell B2 the text: “w

Question 4

What is this formula used for? =Count

Answer 4

Count function counts the number of cells that contain numbers, and counts numbers within the list of arguments.

Question 5

Add this to check

What is this formula used for? =Vlookup

Add this to check

Answer 5

Find data in a table or range by row

Question 6

Add this to check

What is this graphic name?

Add this to check

Answer 6

Multi-Graphic Bar

Question 7

Add this to check

What is this graphic called?

Add this to check

Answer 7

Pareto’s graphic

Question 8

Add this to check

How do you add a new worksheet in Excel?

Answer 8

You can add a new worksheet by clicking the “+” icon at the bottom of the Excel window next to the existing sheet tabs.
Alternatively, you can right-click an existing worksheet tab and choose “Insert” > “Worksheet.”

Question 9

Add this to check

How do you apply basic formatting, like making text bold or changing the color of a cell?

Answer 9

To make text bold, highlight the cell(s) and click the Bold icon (B) on the toolbar, or use the shortcut Ctrl + B.

Question 10

Add this to check

How do you freeze rows or columns in Excel?

Answer 10

To freeze rows or columns, go to the View tab, click on Freeze Panes, and select one of the following options:
Freeze Top Row to keep the top row visible while scrolling.
Freeze First Column to keep the first column visible while scrolling horizontally.
Freeze Panes to freeze both a specific row and column.