CIT 130 Quiz 2 excel sheet - 75446

Request Posted by
chrisdrsy

chrisdrsy

Rating : No Rating
Earned: $0
Request Detail
Price: $30
  • From: Computer Science, PHP
  • Due on: Mon 06 Oct, 2014 (08:51pm)
  • Asked on: Mon 06 Oct, 2014
  • Due date has passed, but you can still Post Solution.
Description

Need in 2 hours

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)

Available memory:  The Excel versions that are listed in the "Applies to" section do not impose a limit on the size of worksheet arrays. Instead, you are limited only by the available memory on your computer. Therefore, you can create very large arrays that contain hundreds of thousands of cells.

The "entire column" rule:  Although you can create very large arrays in Excel, you cannot create an array that uses a whole column or multiple columns of cells. Because recalculating an array formula that uses a whole column of cells is time consuming, Excel does not allow you to create this kind of array in a formula.

In Excel, arrays in worksheets are limited by available random access memory, by the total number of array formulas, and by the "entire column" rule.

 

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

There are 65,536 cells in a column in Microsoft Office Excel 2003 and in earlier versions of Excel. There are 1,048,576 cells in a column in Microsoft Office Excel 2007.

 

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
brandis_berry-Quiz_#_2-1.docx
brandis_berry-Q...
1 Solution for CIT 130 Quiz 2 excel sheet
Please Login or Register to Submit the Solution for the Request