Spreadsheets

Front

What is the space within the black border?

Back

a cell

Answer explanation

The space within the black border is referred to as a cell, which is a fundamental unit in tables or spreadsheets where data is stored. The other options do not accurately describe this specific area.

Front

When you type a formula, what symbol must it start with?

Back

=

Answer explanation

In spreadsheet applications, formulas must start with the '=' symbol. This indicates to the program that the following text is a formula to be calculated, making '=' the correct choice.

Front

In a cell reference, for example B2, what does the letter refer to?

Back

The column the cell is in.

Answer explanation

In a cell reference like B2, the letter 'B' indicates the column in which the cell is located. The number '2' refers to the row. Therefore, the correct answer is that the letter refers to the column the cell is in.

Front

What would a spreadsheet be best used for?

Back

keeping track of your savings or money

Answer explanation

A spreadsheet is best for organizing and analyzing numerical data, making it ideal for keeping track of savings or money. Other options like writing letters or making presentations are better suited for word processors or presentation software.

Front

In a cell reference, such as B2, what does the number stand for?

Back

the row the cell is in

Answer explanation

In the cell reference B2, the number 2 indicates the row the cell is in. Cell references are structured as a letter for the column and a number for the row, making '2' specifically denote the second row.

Front

Mathematical calculations in a spreadsheet are called:

Back

formulas

Answer explanation

Mathematical calculations in a spreadsheet are performed using formulas. Formulas allow users to perform operations on data, while values represent the data itself, and labels are used for naming.

Front

What function will add up all the numbers in a column?

Back

=SUM(E1:E5)

Answer explanation

The function =SUM(E1:E5) correctly adds up all the numbers in the specified range E1 to E5. The other options serve different purposes: IF checks conditions, AVERAGE calculates the mean, and CONCAT combines text.

Front

Example of a multiplication formula: A-B, =C10-B9, 14 x 10 = 140, =B2*B3

Back

=B2*B3

Answer explanation

The correct choice, =B2*B3, is a multiplication formula used in spreadsheet applications to multiply the values in cells B2 and B3. The other options do not represent multiplication formulas.

Front

Which of the following cannot be used to create a spreadsheet? Microsoft Excel, Google Sheets, Google Docs, Open Office Calc

Back

Google Docs

Answer explanation

Google Docs is primarily a word processing tool and does not have the functionality to create spreadsheets, unlike Microsoft Excel, Google Sheets, and Open Office Calc, which are specifically designed for that purpose.

Front

Example of an addition formula: =B4+D7, 2+3+6=11, F3*G7, =B9/B6

Back

=B4+D7

Answer explanation

The correct choice, =B4+D7, is an addition formula as it uses the '+' operator to sum the values in cells B4 and D7. The other options involve multiplication or division, not addition.