CIT 130 Quiz 2 excel sheet - 75438

Request Posted by
chrisdrsy

chrisdrsy

Rating : No Rating
Earned: $0
Request Detail
Price: $20
  • From: Computer Science, PHP
  • 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.

 

1 Solution for CIT 130 Quiz 2 excel sheet
Title Price Category solution By purchased  
CIT 130 Quiz 2 Solution (***** 100% Correct + Answered All Question *****)
$30.00 Business, Business hardik777 0 time(s)
Please Login or Register to Submit the Solution for the Request