Spreadsheets

Question 1

What does a formula always start with?

Answer 1

Equals sign

Question 2

What is the formula to find the highest number?

Answer 2

=MAX(reference:reference)

Question 3

What’s the best way to duplicate a formula from cell to cell?

Answer 3

Fill handle (small box at the bottom right of a cell) and drag

Question 4

What is Excel?

Answer 4

Excel is a popular spreadsheet program developed by Microsoft. It is widely used for organizing

Question 5

What is a cell in Excel?

Answer 5

cell is the basic unit of a spreadsheet in Excel. It is the intersection point of a column and a row

Question 6

How do you enter data into a cell in Excel?

Answer 6

To enter data into a cell, you can simply click on the desired cell and start typing the data.

Question 7

What is a formula in Excel?

Answer 7

formula in Excel is an equation that performs calculations on data. It starts with an equal sign (=) and can include numbers, cell references, mathematical operators

Question 8

How do you create a formula in Excel?

Answer 8

To create a formula in Excel, you need to start by typing the equal sign (=) in a cell, followed by the desired formula

Question 9

Give an example of a commonly used function in Excel.

Answer 9

The SUM function is a commonly used function in Excel. It calculates the sum of a range of cells

Question 10

What is a cell address/reference in Excel?

Answer 10

It is the name of the column and row put together, indicating the location of the cell at the intersection of them two