Excel Test Quiz for Graphical Analysis of Data

1. All formulas in Excel must be begin with what symbol

=

SUM

,

(

All formulas in Excel must begin with the equal sign (=). This symbol indicates to Excel that the following characters constitute a formula or function that needs to be calculated. It is essential to start any formula or function in Excel with this symbol, or else Excel will interpret the entry as text or a numeric value.

Explanation

All formulas in Excel must begin with the equal sign (=). This symbol indicates to Excel that the following characters constitute a formula or function that needs to be calculated. It is essential to start any formula or function in Excel with this symbol, or else Excel will interpret the entry as text or a numeric value.

2. What is Microsoft Excel?

A program that creates and edits newsletters, brochures, flyers, and web sites.

A program that creates spreadsheets that combines worksheets, graphics, and data management into a single program.

A program that creates databases and programs to track and manage information.

A program designed to create notes and presentations.

A word processing program designed to create letters, documents, or reports.

Microsoft Excel is a program that is specifically designed for creating and editing spreadsheets. It allows users to combine worksheets, graphics, and data management into a single program, making it a powerful tool for organizing and analyzing data. It is not a program for creating newsletters, brochures, flyers, web sites, databases, notes, or presentations.

Explanation

Microsoft Excel is a program that is specifically designed for creating and editing spreadsheets. It allows users to combine worksheets, graphics, and data management into a single program, making it a powerful tool for organizing and analyzing data. It is not a program for creating newsletters, brochures, flyers, web sites, databases, notes, or presentations.

3. The graphing functions in Microsoft Excel can be found in what tab.

Graphing

Insert

Formulas

Home

The correct answer is "Insert" because the graphing functions in Microsoft Excel are located in the Insert tab. This tab contains various options for inserting different types of objects into the Excel worksheet, including charts and graphs. By selecting the Insert tab, users can access the necessary tools and features to create and customize graphs in Excel.

Explanation

The correct answer is "Insert" because the graphing functions in Microsoft Excel are located in the Insert tab. This tab contains various options for inserting different types of objects into the Excel worksheet, including charts and graphs. By selecting the Insert tab, users can access the necessary tools and features to create and customize graphs in Excel.

4. What is the correct formula to solve for the Interest of following graph?

A	B	C	D	E
Year	Opening Balance ($)	Interest Rate (%)	Annual investment ($)	Closing Balance ($)
1	1000.00	6	1000.00	2060

=B3*0.06+D3

=B3*0.06

=B3*6+D3

=B3*6

Let's break down the formula =B3\*0.06+D3 to understand how it calculates the interest and closing balance for the given graph.

The formula consists of two parts: B3\*0.06 and D3, which are added together.

B3\*0.06: This part of the formula calculates the interest earned on the opening balance. Here, B3 represents the cell containing the opening balance, and 0.06 is the interest rate (6% expressed as a decimal). By multiplying the opening balance by the interest rate, we obtain the interest earned on that balance.

D3: This part of the formula represents the annual investment, which is stored in cell D3.

When you add these two parts together (B3\*0.06 + D3), you get the total closing balance. This calculation takes into account both the interest earned on the opening balance and the additional annual investment.

In summary, this formula accurately computes the closing balance by considering the interest earned on the opening balance and adding the annual investment to it.

Explanation

Let's break down the formula =B3\*0.06+D3 to understand how it calculates the interest and closing balance for the given graph.

The formula consists of two parts: B3\*0.06 and D3, which are added together.

B3\*0.06: This part of the formula calculates the interest earned on the opening balance. Here, B3 represents the cell containing the opening balance, and 0.06 is the interest rate (6% expressed as a decimal). By multiplying the opening balance by the interest rate, we obtain the interest earned on that balance.

D3: This part of the formula represents the annual investment, which is stored in cell D3.

When you add these two parts together (B3\*0.06 + D3), you get the total closing balance. This calculation takes into account both the interest earned on the opening balance and the additional annual investment.

In summary, this formula accurately computes the closing balance by considering the interest earned on the opening balance and adding the annual investment to it.

5. The "Formula" in excel is...

A tab you see at the bottom of your workbook file.

A combination of numbers and symbols used to express a calculation.

To enter text or numbers at the position of the cursor or cell pointer.

The lines on your worksheet that separate the columns and rows.

A place in a Microsfoft Excel window where you type information, such as a file name.

The correct answer is "A combination of numbers and symbols used to express a calculation." This is because a formula in Excel is a combination of mathematical operators, cell references, and values that perform calculations or manipulate data. Formulas are used to perform calculations such as addition, subtraction, multiplication, and division, as well as more complex calculations using functions.

Explanation

The correct answer is "A combination of numbers and symbols used to express a calculation." This is because a formula in Excel is a combination of mathematical operators, cell references, and values that perform calculations or manipulate data. Formulas are used to perform calculations such as addition, subtraction, multiplication, and division, as well as more complex calculations using functions.

6. What is the correct answer given the formula ROUNDUP (A4,3), when A4 is equal to 12.34912?

12.349

12.35

12

12.348

The ROUNDUP function in spreadsheet software rounds a number up to a specified number of decimal places. In this case, the formula ROUNDUP(A4,3) rounds the value in cell A4 up to three decimal places. Given that A4 is equal to 12.34912, when you apply the ROUNDUP function with three decimal places, the result will be 12.350. However, since the third decimal place is zero, it can be omitted, so the final result is displayed as 12.35.

Explanation

The ROUNDUP function in spreadsheet software rounds a number up to a specified number of decimal places. In this case, the formula ROUNDUP(A4,3) rounds the value in cell A4 up to three decimal places. Given that A4 is equal to 12.34912, when you apply the ROUNDUP function with three decimal places, the result will be 12.350. However, since the third decimal place is zero, it can be omitted, so the final result is displayed as 12.35.

7. When is the best situation to use a pie graph?

When observing trends in a population

When observing changes over time

When comparing one category to the group

When comparing one category to another

A pie graph is best used when comparing one category to the group because it allows for easy visualization of the proportion or percentage that each category represents within the whole. By using a pie graph, it becomes simple to see the relative sizes of different categories and make comparisons between them. This type of graph is particularly effective when the goal is to understand the distribution or composition of a group in relation to a specific category.

Explanation

A pie graph is best used when comparing one category to the group because it allows for easy visualization of the proportion or percentage that each category represents within the whole. By using a pie graph, it becomes simple to see the relative sizes of different categories and make comparisons between them. This type of graph is particularly effective when the goal is to understand the distribution or composition of a group in relation to a specific category.

8. Based on the graph #1 in the assignments and hand out section of our website, what two years did the CIS boys volleyball team achieve the same amount of wins?

2010 and 2012

2009 and 2010

2010 and 2011

2011 and 2012

The graph mentioned in the question shows the number of wins achieved by the CIS boys volleyball team over the years. By analyzing the graph, it can be observed that the team achieved the same amount of wins in the years 2010 and 2012.

Explanation

The graph mentioned in the question shows the number of wins achieved by the CIS boys volleyball team over the years. By analyzing the graph, it can be observed that the team achieved the same amount of wins in the years 2010 and 2012.

9. When calculating cells what does a colon allow you to do?

Find the mean median and mode of a series of numbers

Calculate multiple cells by typing them in

Calculate multiple cells by highlighting them

Produce conditional statements like if and or not

A colon in Excel allows you to calculate multiple cells by highlighting them. This means that you can select a range of cells and perform a calculation on all of them at once, saving time and effort. By using the colon, you can easily sum up a series of numbers or perform other calculations on a group of cells without having to manually input each cell reference.

Explanation

A colon in Excel allows you to calculate multiple cells by highlighting them. This means that you can select a range of cells and perform a calculation on all of them at once, saving time and effort. By using the colon, you can easily sum up a series of numbers or perform other calculations on a group of cells without having to manually input each cell reference.

10. What is the correct answer given the formula MEDIAN(A2-A7) for the following table.

	1	2	3	4	5	6	7	8	9
A	2	5	7	9	13	23	4	16	1

9

10.5

8

11.5

To find the correct answer, we need to understand the MEDIAN function. The MEDIAN function returns the median (middle) value in a list of numbers. In this case, the formula is MEDIAN(A2:A7), which means we want to find the median value within the specified range (A2 to A7).

Let's list the values in the range A2 to A7 from the given table:

A2: 5

A3: 7

A4: 9

A5: 13

A6: 23

A7: 4

First, let's arrange these values in ascending order:

4, 5, 7, 9, 13, 23

Since there are an even number of values, the median will be the average of the two middle values. In this case, the two middle values are 7 and 9.

Median = (7 + 9) / 2

Median = 16 / 2

Median = 8

So, the correct answer given the formula MEDIAN(A2:A7) for the provided table is 8.

Explanation

To find the correct answer, we need to understand the MEDIAN function. The MEDIAN function returns the median (middle) value in a list of numbers. In this case, the formula is MEDIAN(A2:A7), which means we want to find the median value within the specified range (A2 to A7).

Let's list the values in the range A2 to A7 from the given table:

A2: 5

A3: 7

A4: 9

A5: 13

A6: 23

A7: 4

First, let's arrange these values in ascending order:

4, 5, 7, 9, 13, 23

Since there are an even number of values, the median will be the average of the two middle values. In this case, the two middle values are 7 and 9.

Median = (7 + 9) / 2

Median = 16 / 2

Median = 8

So, the correct answer given the formula MEDIAN(A2:A7) for the provided table is 8.

11. What answer will be provided given the formula =IF(A1>B2) for the cell values.

	A	B
1	5	6
2	3	4

Error

Number

Value

False

True

The formula =IF(A1>B2) is comparing the value in cell A1 with the value in cell B2. If the value in A1 is greater than the value in B2, the formula will return the value "True". In this case, the value in A1 is 5 and the value in B2 is 6, so the formula will return "False".

Explanation

The formula =IF(A1>B2) is comparing the value in cell A1 with the value in cell B2. If the value in A1 is greater than the value in B2, the formula will return the value "True". In this case, the value in A1 is 5 and the value in B2 is 6, so the formula will return "False".

12. What is the correct answer given the formula SMALL(B2-H1,3), for the following table

A	B	C	D	E	F	G	H	I	J
1	4	3	6	9	12	2	11	5	3
3	6	10	5	7	9	14	2	1	7

1

2

3

4

To determine the correct answer, we first need to understand the SMALL function. The SMALL function returns the nth smallest value from a range of cells. In this case, the formula is SMALL(B2:H1, 3), which means we want to find the third smallest value within the specified range.

Looking at the given table, we can identify the values in the range B2 to H1:

B2: 11

C2: 5

D2: 3

E2: 6

F2: 10

G2: 5

H2: 7

Now, let's arrange these values in ascending order:

3, 5, 5, 6, 7, 10, 11

The third smallest value in this sorted list is 6.

So, the correct answer given the formula SMALL(B2:H1, 3) for the provided table is 6.

Explanation

To determine the correct answer, we first need to understand the SMALL function. The SMALL function returns the nth smallest value from a range of cells. In this case, the formula is SMALL(B2:H1, 3), which means we want to find the third smallest value within the specified range.

Looking at the given table, we can identify the values in the range B2 to H1:

B2: 11

C2: 5

D2: 3

E2: 6

F2: 10

G2: 5

H2: 7

Now, let's arrange these values in ascending order:

3, 5, 5, 6, 7, 10, 11

The third smallest value in this sorted list is 6.

So, the correct answer given the formula SMALL(B2:H1, 3) for the provided table is 6.