• ¿Documento equivocado? Cámbialo gratis
  • Escrito por estudiantes que aprobaron
  • Inmediatamente disponible después del pago
  • Leer en línea o como PDF
Vender
¿Dónde estudias?
Tu idioma
Document preview thumbnail
Vista previa 1 fuera de 3 páginas
Examen

Spreadsheets Questions and Answers

Document preview thumbnail
Vista previa 1 fuera de 3 páginas

Spreadsheets Questions and Answers To make a calculation always refer to a specific cell when copying it using the fill handle, make the cell a(n) ________ reference. absolute A common method to delete a column or row in most spreadsheet programs is to ________ on the column or row heading, and then select Delete from the menu. right-click The cost of borrowing money, quoted as an annual percentage rate (APR), is a loan's interest. What function would you use to display how many entries are made in Column A above Cell A37? COUNT Programs such as Microsoft Excel, iWork's (Apple) Numbers, Google Sheets, and OpenOffice Calc, that allow users to arrange numerical data are called spreadsheets. The stylist just did a great job and your hair is going to look good for weeks. The stylist charged $70 and you decide to add a 15% cash tip. How big is the tip? $10.50 The number 27 in the cell depicted above is a value, not a formula. If the user drags the cursor to the right, what will appear in the cell to the right? 27 Select the spreadsheet formula that would correctly calculate the average (mean) of the following values: 3, 2, 6, and 8. = (3 + 2 + 6 + 8) / 4 Pivot tables provide a quick way to organize information. In most spreadsheet programs, click the ________ tab to create a pivot table. Insert To quickly show if the values in a column or row are greater than, less than, or equal to a certain value, use the ________ function. IF A friend asks if you want to go see the new Avengers movie but you say it's too expensive. "No it's not, tickets have only gone up $2.00 since last year," says your friend. You reply, "tickets went from $8 to $10 for a matinee. That is a large percentage increase. What formula would provide the percentage increase? = (10 - 8) / 8 * 100 Because they make it easy to arrange, display, and calculate numerical data, ________ programs are often used in budgeting, accounting, finance, grading, gambling houses, and even sports analysis. spreadsheet When adjusting the width of a column or the height of a row, which pointer(s) is/are used? cross but with arrows

Vista previa del contenido

Spreadsheets Questions and Answers
To make a calculation always refer to a specific cell when copying it using the fill
handle, make the cell a(n) ________ reference. - answer absolute

A common method to delete a column or row in most spreadsheet programs is to
________ on the column or row heading, and then select Delete from the menu. -
answer right-click

The cost of borrowing money, quoted as an annual percentage rate (APR), is a loan's -
answer interest.

What function would you use to display how many entries are made in Column A above
Cell A37? - answer COUNT

Programs such as Microsoft Excel, iWork's (Apple) Numbers, Google Sheets, and
OpenOffice Calc, that allow users to arrange numerical data are called - answer
spreadsheets.

The stylist just did a great job and your hair is going to look good for weeks. The stylist
charged $70 and you decide to add a 15% cash tip. How big is the tip? - answer
$10.50

The number 27 in the cell depicted above is a value, not a formula.
If the user drags the cursor to the right, what will appear in the cell to the right? - answer
27

Select the spreadsheet formula that would correctly calculate the average (mean) of the
following values: 3, 2, 6, and 8. - answer = (3 + 2 + 6 + 8) / 4

Pivot tables provide a quick way to organize information. In most spreadsheet
programs, click the ________ tab to create a pivot table. - answer Insert

To quickly show if the values in a column or row are greater than, less than, or equal to
a certain value, use the ________ function. - answer IF

A friend asks if you want to go see the new Avengers movie but you say it's too
expensive. "No it's not, tickets have only gone up $2.00 since last year," says your
friend. You reply, "tickets went from $8 to $10 for a matinee. That is a large percentage
increase. What formula would provide the percentage increase? - answer = (10 - 8) /
8 * 100

Información del documento

Subido en
17 de diciembre de 2024
Número de páginas
3
Escrito en
2024/2025
Tipo
Examen
Contiene
Preguntas y respuestas
$13.49

¿Documento equivocado? Cámbialo gratis Dentro de los 14 días posteriores a la compra y antes de descargarlo, puedes elegir otro documento. Puedes gastar el importe de nuevo.
Escrito por estudiantes que aprobaron
Inmediatamente disponible después del pago
Leer en línea o como PDF

Seller avatar
Los indicadores de reputación están sujetos a la cantidad de artículos vendidos por una tarifa y las reseñas que ha recibido por esos documentos. Hay tres niveles: Bronce, Plata y Oro. Cuanto mayor reputación, más podrás confiar en la calidad del trabajo del vendedor.
Pogba119
4.0
(15)
Vendido
67
Seguidores
2
Artículos
5667
Última venta
1 semana hace




Por qué los estudiantes eligen Stuvia

Creado por compañeros estudiantes, verificado por reseñas

Calidad en la que puedes confiar: escrito por estudiantes que aprobaron y evaluado por otros que han usado estos resúmenes.

¿No estás satisfecho? Elige otro documento

¡No te preocupes! Puedes elegir directamente otro documento que se ajuste mejor a lo que buscas.

Paga como quieras, empieza a estudiar al instante

Sin suscripción, sin compromisos. Paga como estés acostumbrado con tarjeta de crédito y descarga tu documento PDF inmediatamente.

Student with book image

“Comprado, descargado y aprobado. Así de fácil puede ser.”

Alisha Student

Preguntas frecuentes