AnswersAL-Career PreparednessSpreadsheet Basics

Spreadsheet Basics Answers

14 verified answers2 views
1
Free Preview

Question text not available

Answers:
Selection 1:row
Selection 2:column
Selection 3:workbook
Selection 4:cell
Selection 5:sheet
2
Free Preview

What is the proper way to name the range of cells located in column A row 3 through column C row 7?

A
3A:7C
B
7C:3A
C
A3:C7
D
C7:A3
3

The spreadsheet below shows how much money each store raised for charity during the months of January, February, and March.

Answers:
Selection 1:B2:B4
Selection 2:SUM
4

Suppose one hundred stores participated in the fund-raiser for one year. What would be the most efficient way to calculate totals and store averages by month?

A
Using the sum and average functions on the range of cells
B
Manually adding and averaging values
C
Using formulas that reference values instead of cell addresses
5

What is the best way to set up the spreadsheet?

A
List each expense in a row. List each income source in a column.
B
List each expense and income source in a separate column. List each month in a row.
C
List each month in a column. List each expense in a row.
D
List each expense in a column. List each month in a row.
6

How would you identify the cell located in column B row 12?

A
12B
B
B12
C
B:12
D
12:B
7

The cell address ZZ123 means

A
the cell located at the intersection of row ZZ and column 123.
B
the cell located at the intersection of column ZZ and row 123.
C
the range of cells from Z1 to Z23.
D
the range of cells from ZZ1 to ZZ23.
8

Which type of formatting would you apply to spreadsheet data so that each cell is outlined?

A
text alignment
B
font color
C
theme
D
border
9

Question text not available

Answers:
Selection 1:formulas and functions
Selection 2:charts and graphs
10

You are preparing a spreadsheet that contains population data for each nation. How can you present your data to provide a visual comparison of the differences in population between nations?

A
Enter a formula to yield total populations for each nation.
B
Apply a yellow background color to your spreadsheet.
C
Use the AVERAGE function to calculate the average population per nation.
D
Create a bar graph showing population totals for each nation.
11

You have a spreadsheet of x values that need to be entered into the following formula to calculate y values:y = 5x + 19 - 7Which of the following is the quickest way to accomplish this task?

A
Use a calculator to find the y value for each x value, then enter those results into the spreadsheet.
B
Enter the formula into the spreadsheet to calculate the y value for each x value.
12

The text =SUM(A1:A4) means

A
the sum of values in cells A2 and A3.
B
the sum of values in cells A1 and A4.
C
the sum of values in the range of cells from A1 through A4.
D
the sum of values in the range of cells from A2 to A3.
13

Which type of formatting would you apply to spreadsheet data to include dollar signs for numerical data?

A
fill color
B
number type
C
border
D
text alignment
14

Your manager has requested you keep a timesheet showing how many hours you work each day and what projects you work on during that time. Using spreadsheet software, how can you total your hours at the end of each week to provide a quick and accurate amount?

A
Use the MIN and MAX functions.
B
Use the AVERAGE function.
C
Use the SUM function.

Did you find these answers helpful?

More from this Course

Assignment
7 verified answers

Principles of Financial Planning

Quiz
10 verified answers

Principles of Financial Planning

Quiz
46 verified answers

Unit Test