Preview

Excel Chapter 1

Satisfactory Essays
Open Document
Open Document
4708 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Excel Chapter 1
Exploring Microsoft Office 2010 Volume 1
Excel Chapter 1
Testbank

1) A spreadsheet
A) is the core of a slide presentation.
B) is an electronic file that is used to write text and graphics on the web.
C) is an electronic file that contains a grid of columns and rows for related data.
D) is another word for a letter written on a computer.
Answer: C
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel

2) A spreadsheet PROGRAM is defined as
A) a software application used to create and modify spreadsheets.
B) a software application used to create and modify text-based documents.
C) a software application used to create and modify video presentations.
D) a software application used to create and modify a database.
Answer: A
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel

3) A worksheet is defined as
A) the background color of a cell.
B) the current cell location of the insertion point as indicated by a dark border.
C) a single spreadsheet that often contains formulas, functions, values, text, and visual aids.
D) an unfinished project.
Answer: C
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel

4) A workbook is defined as
A) similar to a spreadsheet but bound rather than electronic.
B) an un-editable "picture" of data.
C) the address of the current cell.
D) a file containing related worksheets.
Answer: D
Diff: 1
Reference: Introduction to Spreadsheets
Objective: 1
AppChap: Excel 1: Introduction to Excel
5) An Input Area (as it applies to Excel 2010) is defined as
A) a range of cells containing results based on the output area.
B) displays the name of a worksheet within a workbook.
C) a range of cells containing values for variables used in formulas.
D) displays the content of the active cell.
Answer: C
Diff: 1
Reference: Introduction to

You May Also Find These Documents Helpful

  • Good Essays

    During the American Industrial Revolution that occurred in the 1800s, new technology and inventions were created, revolutionizing America. America's industrialization is referred to as a revolution because it's development of transportation, mass production, and immigration revolutionized America both economically and socially. Amid the 1800s, the US government encouraged the production of a transcontinental railroad by granting land to railroad companies. By 1869 a message could be sent from New York to San Francisco in 7 days. This transportation improvement allowed cattle to be sent from the West to meat packaging districts in the Midwest, then to the East for consumption without the meat going bad.…

    • 581 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Nt1330 Unit 1 Assignment 1

    • 4614 Words
    • 19 Pages

    A ______ is rectangular area that can contain a document, program, or message option1 A __________ contains icon buttons that access frequently used commands A __________ provides access to features of the program A built-in tool that performs calculations automatically is a(an) A collection of related data that has been entered into a computer is called a A collection of separate software applications that are sold as a group, like Microsoft Office, is called a(n) A database sort directs the software to find and display one or more records option2 option1 option3 option3 option4 option2…

    • 4614 Words
    • 19 Pages
    Good Essays
  • Good Essays

    Nt1210 Chapter 1 Review

    • 1315 Words
    • 6 Pages

    9. A student writes a report using a word processor, saving the repot in a file called my_report. The student stores the file on his laptop hard disk drive. Later, he pasts the file on a file-sharing site for a classmate to review the report. Then, he copies an updated version of the file to a flash drive to submit it to his instructor. Which of the following are some of the important features supplied by files as defined by a computer OS?…

    • 1315 Words
    • 6 Pages
    Good Essays
  • Powerful Essays

    Cambridge TECHNICALS OCR LEVEL 3 CAMBRIDGE TECHNICAL CERTIFICATE/DIPLOMA IN IT SPREADSHEET MODELLING Y/601/6637 LEVEL 3 UNIT 19 GUIDED LEARNING HOURS: 60 UNIT CREDIT VALUE: 10 SPREADSHEET MODELLING Y/601/6637 LEVEL 3 UNIT 19 AIM OF THE UNIT The success of a business relies on its methods of recording business transactions. With the use of complex spreadsheets this task is made relatively easy for businesses.…

    • 3515 Words
    • 19 Pages
    Powerful Essays
  • Satisfactory Essays

    Yes, our record shows that her training was under her maiden name and completed on 12/03/2015, and I have updated her information in our system. I am currently reviewing the excel spreadsheet for updates and should have it emailed back to you by next Monday.…

    • 59 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    it320 assignment 1-3

    • 1779 Words
    • 8 Pages

    9. A student writes a report using a word processor, saving the report in a file called my_report. The student stores the file on his laptop hard disk drive. Later, he posts the file on a file-sharing site for a classmate to review the report. Then, he copies an updated version of the file to a flash drive to submit it to his instructor. Which of the following are some of the important features supplied by files defined by a computer OS? ()…

    • 1779 Words
    • 8 Pages
    Good Essays
  • Satisfactory Essays

    2. Which of the following identifies the patterns used for each data series in a chart?…

    • 985 Words
    • 5 Pages
    Satisfactory Essays
  • Good Essays

    Learn Excel

    • 753 Words
    • 4 Pages

    Table_array (Required): Two or more columns of data. Use a reference to a range or a range name. The values in the first column of table_array are the values searched by lookup_value. These values can be text, numbers, or logical values. Uppercase and lowercase texts are equivalent. You cannot have duplicate values in the leftmost column of the lookup range. Page 2 of 15 MS Excel Advanced Formulas 9/7/2010:mms…

    • 753 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Excel Worksheet

    • 651 Words
    • 3 Pages

    The quickest way to get help while in Excel is to press the F1 function key, or click the blue and white question mark to open Excel 2010s help window. In this window, that does not require internet connection, and you just need to continue by searching and responding to questions to find the technique in order to create what you need.…

    • 651 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    A major one was the spreadsheet application, the very first, Visicalc which was developed in the year 1979. Today, the most popular spreadsheet can be said to be Microsoft Excel which was developed in the 1980’s. The purpose of this term-paper is to introduce at other spreadsheets other than Microsoft Excel.…

    • 2266 Words
    • 10 Pages
    Good Essays
  • Satisfactory Essays

    Excel

    • 273 Words
    • 2 Pages

    Statistics and parameters. Properties for a statistic. Central Limit Theorem. Distribution of the sample mean, difference in means and the proportion. Point and interval estimates for the mean, difference in means, and proportion. Hypotheses testing and types of errors. Significance levels and p values. Small sample testing: Chi square, t and F distributions and their properties. Applications of chi square and t distributions to interval estimates and tests. UNIT 2 : CLASSICAL TWO VARIABLE LINEAR REGRESSION MODEL Types of Data : Time Series, Cross Section and Panel Data. Concept of PRF and SRF. Estimation of the SRF using OLS. Analysis of variance and R squared. Understanding the residuals/error term. Assumptions of the model. Expectation and standard errors of the regression coefficients and the error term. Gauss Markov Theorem. Confidence intervals and tests on population regression coefficients, variance of population disturbance term, and forecasts. Testing the significance of the model as a whole. Testing the normality assumption. UNIT 3 : MULTIPLE REGRESSION MODEL The three variable case. Derivation of the coefficients. Correlation. Additional assumptions. Adjusted R square. Confidence intervals and testing of the regression coefficients. F and t tests for structural stability, contribution and justification of an explanatory variable. UNIT 4 : OTHER FUNCTIONAL FORMS Regressions in deviation form and through the origin. The log-log, log-lin, lin-log, reciprocal, log-reciprocal models with application. UNIT 5 : DUMMY VARIABLES Intercept, Slope Dummy variables. Interaction between qualitative variables. Interaction between quantitative and qualitative variables. Dummies for testing for the presences of Seasonal Trends. Main Readings 1. Christopher Dougherty, Introductory Econometrics 3rd Edition Oxford University Press (2007) 2. Gujarati , Damodar : Basic Econometrics , 3rd edition Mc.Graw Hill,…

    • 273 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Microsoft Excel is an electronic spreadsheet program that can be used for storing, organizing and manipulating data. Excel is a very handy organizational tool and is the world’s most used database.…

    • 443 Words
    • 2 Pages
    Good Essays
  • Good Essays

    Excel

    • 877 Words
    • 4 Pages

    Honestly, when I first started this assignment, I really didn’t know what a spreadsheet was, etc. So I started at: http://en.wikipedia.org/wiki/Spreadsheet. I read that and got a good base of spreadsheets and the history.…

    • 877 Words
    • 4 Pages
    Good Essays
  • Better Essays

    8 Golden

    • 1366 Words
    • 6 Pages

    Microsoft Excel 2010 for windows could categorize as one of the best spreadsheet processor ever made. It has a wide range of functions that uses for personal use and business use. Concerning the functionality that the application providing the user interface designing team has done a very good to make it user friendly and easy to learn even though there are few up and downs with the 8 golden rules.…

    • 1366 Words
    • 6 Pages
    Better Essays
  • Good Essays

    Microsoft excel

    • 575 Words
    • 3 Pages

    On the morning of April 15, 1912, the sinking of the Titanic the previous night shocked the world. The year had dawned bright with promise and the maiden voyage of the Titanic was a symbol of the advances mankind had made in the last few years.…

    • 575 Words
    • 3 Pages
    Good Essays