# CIT 130 Quiz 2 excel sheet - 75441

Request Posted by

## chrisdrsy

Rating : No Rating
Earned: \$0
Request Detail
Price: \$35
• From: Mathematics, Algebra
• Due on: Sun 05 Oct, 2014 (11:00pm)
• Asked on: Sun 05 Oct, 2014
• Due date has passed, but you can still Post Solution.
Description

CIT 130

Quiz 2

Name:

Quote of the day:  “It's so much easier, to push instead of pull.”               - Sammy Hagar

1.

Give the formula needed to total all numbers (use a range).

Give the formula needed to get the average of these numbers.

2.

Give the formula needed to total these numbers (do not use a range).

3.  What are some limitations of Excel? (provide at least 3)

4.    How many cells are on a spreadsheet?  Give the cell address of the last row and column.

5.    What is the Excel file program name?  What is the Excel file extension?

6.

What is the purpose of the black square circled?  Explain.

7.    How can you access another cell from another worksheet?  Give an example.

8.

Give the payment formula given the following cell data:

A1 = \$72,945

B1 = 12%

D1 = 60

9.                   What is the freeze pane?  What is its purpose?

10.               Define the three basic charts used in Excel and their definition.

Attachments
2 Solution for CIT 130 Quiz 2 excel sheet
Please Login or Register to Submit the Solution for the Request