Spreadsheets Quiz 2

Which of the following commands is found in a spreadsheet program?

• Speller

• AutoSum

• Paragraph

• References

Answer explanation

If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you're done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.

In a spreadsheet, the cell address C9 means _________.

• Column 9 and row C

• Column C and row 9

• Row C and Column 9

• Column C and column 9

Answer explanation

Each cell in the spreadsheet has a corresponding name, which is identified by its column letter and row number. For instance, the cell under column A that belongs to row 1 has the default name A1. You will see this in the name box, which is located on the upper left side of the spreadsheet, next to the formula bar.

Which symbol is displayed throughout a cell when there is not enough width to accommodate the entry?

• #

• *

• +

• &

Answer explanation

Excel spreadsheets display a series of number or pound signs like ##### in a cell when the column isn’t big enough to display the information. It also happens if you have a cell formatted to display something different than what you need the spreadsheet to show.

Which of the following reduces the time it takes to find the sum of many numbers?

• Desktop publisher

• Operating system

• Spreadsheet

• Word processor

Answer explanation

The three most common general uses for spreadsheet software are to create budgets, produce graphs and charts, and for storing and sorting data. Within business spreadsheet software is used to forecast future performance, calculate tax, completing basic payroll, producing charts and calculating revenues.

Which of the following arithmetic operators is used to determine the quotient of two numbers in a spreadsheet?

• \

• /

Answer explanation

The division symbol is the forward slash ( / ).

When sorting numerical data in ascending order, how will the data be sorted?

• Smallest number to largest number.

• Largest number to smallest number

• Numbers cannot be sorted ascending.

• Only numerical order is an option.

Answer explanation

Ascending order means to arrange numbers in increasing order, that is, from smallest to largest. To arrange numbers in any order, we first need to compare them.

Using Cell Addresses in spreadsheet calculations is known as _________.

• Cell Address

• Cell referencing

• address calculation

• Name box arithmetic

Answer explanation

A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

Each time a value is entered into the worksheet, Excel automatically ____

formulas.

• Includes the number in

• Recalculates old

• Recalculates new

• Recalculates all

Answer explanation

A formula result is automatically recalculated when you change data in cells that are used in that formula.

In a spreadsheet, the function, =MAX(A1:A5), A1:A5 is known as _______.

• column

• maximum

• range

• rows

Answer explanation

A range in a spread function is specified by writing the starting cell address followed by a full colon (colon) and the ending cell address. For example B2:G9. B2 is the starting point and G9 is the ending point while (:) is known as the full colon or colon.

In a spreadsheet program, which function can be used to multiply two or more numbers.

• Average

• Max

• Product

• Quotient

Answer explanation

The PRODUCT function multiplies all the numbers given as arguments and returns the product. For example, if cells A1 and A2 contain numbers, you can use the formula =PRODUCT(A1, A2) to multiply those two numbers together.