File:///media/fuse/drivefs-0142e6928396ed2afff070ead0fbbbcd/root/JerooLessonFourLabA

Match each term in the second column with its correct definition in the first column. Write the letter of the term on the blank

Thepotemich [5.8K]

Answer:

1. Pie chart.

2. Goal seek.

3. Relative reference cell.

4. Data marker.

5. Chart sheet.

6. What-If-Analysis.

7. $Rate = \frac {Amount \; of \; increase}{Base}$

8. Order of operations.

9. Formula AutoComplete.

10. Axis.

11. Category axis.

12. Value axis

13. $Value \; after \; increase = Base * Percent \; for \; new \; value$

Explanation:

Microsoft Excel is a software application or program designed and developed by Microsoft Inc., for analyzing and visualizing spreadsheet documents.

A spreadsheet can be defined as a file or document which comprises of cells in a tabulated format (rows and columns) typically used for formatting, arranging, analyzing, storing, calculating and sorting data on computer systems.

Some of the terminologies and features of the Microsoft Excel software includes the following;

1. Pie chart: a chart that shows the relationship of each part to a whole.

2. Goal seek: a what-if-analysis tool that finds the input needed in one cell to arrive at the desired result in another cell.

3. Relative reference cell: in a formula, the address of a cell based on the relative position of the cell that contains the formula and the cell referred to in the formula.

4. Data marker: a column, bar, area, dot, pie slice, or other symbol in a chart that represents a single data point.

5. Chart sheet: a workbook sheet that contains only a chart.

6. What-If-Analysis: the process of changing the values in cells to see how those changes affect the outcome of formulas in a worksheet.

7. $Rate = \frac {Amount \; of \; increase}{Base}$ : The mathematical formula to calculate a rate of increase.

8. Order of operations: the mathematical rules for performing multiple calculations within a formula.

9. Formula AutoComplete: the excel feature which, after typing - and the first letter of a function, displays a list of function names.

10. Axis: a line that serves as a frame of reference for measurement and that borders the chart plot area.

11. Category axis: the area along the bottom of a chart the identifies the categories of data, also referred to as the x-axis.

12. Value axis: a numerical scale on the left side of a chart that shows the range of numbers for the data points, also referred to as the y-axis.

13. $Value \; after \; increase = Base * Percent \; for \; new \; value$ : the formula for calculating the value after an increase by multiplying the original value the base by the percent for new value.

5 0

2 years ago

One of the most toxic components of a computer is the

Cloud [144]

The most common is usually lead found in the glass or some circuits in rare cases

6 0

2 years ago

Given the following code fragment, what is the data type of roster[9] .name? struct student { string name; double gpa; }; studen

SVETLANKA909090 [29]

roster[50] is an array of "students", so roster[9] is a "student". Therefore, roster[9].name is a string.

3 0

2 years ago

Write a loop that reads positive integers from console input, printing out those values that are even, separating them with spac

AfilCa [17]

#include <iostream>

#include <vector>

std::vector<int> v;

int main(int argc, char* argv[]) {

while(1) {

int temp;

std::cout << "\nEnter a number: ";std::cin>>temp;

if(temp<0) {

std::cout << "\nEven number(s) is/are:\n---------------------\n";

for(int i=0;i<v.size();i++) {

if(v.at(i)%2==0) std::cout << v[i] << " ";

else continue;

}

std::cout << std::endl;

break;

}else {

v.push_back(temp);

}

return 0;

}

3 0

1 year ago

You created the following dictionary relationships = {'Jimmy':'brother', 'Carol':'sister'}. You then executed the following code

dybincka [34]

Answer:

This is because the key in relationships['jimmy'] is wrong. The first letter "j" should be uppercase. The key in the given dictionary is "Jimmy" and therefore a lowercase "j" will result in a KeyError exception. The key is case sensitive and therefore a minor mistake in a single letter either in lowercase or uppercase will cause the error. The correct usage of key to address the value should be relationships["Jimmy"].

3 0

3 years ago

File:///media/fuse/drivefs-0142e6928396ed2afff070ead0fbbbcd/root/JerooLessonFourLabA_1.pdf