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
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Good Essays

    Nt1210 Chapter 1 Review
    • 1315 Words
    • 6 Pages

    Nt1210 Chapter 1 Review

    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
    Read More
  • Powerful Essays

    139187 Level 3 Unit 19 Spreadsheet Mode
    • 3515 Words
    • 19 Pages

    139187 Level 3 Unit 19 Spreadsheet Mode

    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
    Read More
  • Satisfactory Essays

    Excel Worksheet Summary
    • 59 Words
    • 1 Page

    Excel Worksheet Summary

    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
    Read More
  • Good Essays

    it320 assignment 1-3
    • 1779 Words
    • 8 Pages

    it320 assignment 1-3

    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
    Read More
  • Satisfactory Essays

    Excel Worksheet
    • 651 Words
    • 3 Pages

    Excel Worksheet

    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
    Read More
  • Good Essays

    Learn Excel
    • 753 Words
    • 4 Pages

    Learn Excel

    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
    Read More
  • Good Essays

    Using Microsoft Excel
    • 4305 Words
    • 18 Pages

    Using Microsoft Excel

    of names. You can assign a unique name to an individual cell or to a range of cells.…

    • 4305 Words
    • 18 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Excel
    • 273 Words
    • 2 Pages

    Excel

    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
    Read More
  • Good Essays

    Excel 2010: Tips and Tricks
    • 1503 Words
    • 7 Pages

    Excel 2010: Tips and Tricks

    Excel Tips and Tricks CRI CPE Week May 2011 Presented by: Francois Houde, CA, CISA Schedule of the Session        Transitioning from Excel 2003 to Excel 2010: What happened to my Excel? Managing versions Searches with wildcard characters Multiple windows of the same workbook…

    • 1503 Words
    • 7 Pages
    Good Essays
    Read More
  • Good Essays

    Spreadsheet Programs Besides Excel
    • 2266 Words
    • 10 Pages

    Spreadsheet Programs Besides Excel

    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
    Read More
  • Good Essays

    Microsoft Office, and the Colorado Fuel and Iron Company
    • 443 Words
    • 2 Pages

    Microsoft Office, and the Colorado Fuel and Iron Company

    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
    Read More
  • Better Essays

    Excel Functions
    • 2002 Words
    • 9 Pages

    Excel Functions

    You are already familiar with Microsoft Excel software. You have learnt some interesting and useful things that can be done in MS-Excel. Microsoft Excel is an electronic spreadsheet software which allows you to enter, calculate, manipulate, organize and analyze data in the form of tabular form. Let us learn more about data tools provide in Microsoft Excel.…

    • 2002 Words
    • 9 Pages
    Better Essays
    Read More
  • Good Essays

    Excel
    • 877 Words
    • 4 Pages

    Excel

    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
    Read More
  • Better Essays

    8 Golden
    • 1366 Words
    • 6 Pages

    8 Golden

    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
    Read More
  • Good Essays

    Microsoft excel
    • 575 Words
    • 3 Pages

    Microsoft excel

    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
    Read More

Related Topics