Reference no: EM13948257
True or false questions
1. All functions use a range of cells for the argument. There are no single cell referenced formulas?
2. When Excel calculates averages, blank cells or cells containing text are ignored?
3. The NOW function can be used to display the current date, time, or a combination of the two in several different formats.
4. The cell containing the NOW function will always display the point in time when the function was entered into the cell?
5. When using the PMT function, if the payments are to be monthly, then the interest rate you supply to the PMT function needs to be a monthly rate?
6. You cannot use the IF function as the true or false answer to another IF function?
7. In the Page Setup dialog box, you can choose to center a worksheet horizontally but not vertically on the page?
8. Headers and footers do not show up in the worksheet area; to see them you have to Print or Print Preview the worksheet.
9. The Chart toolbar will automatically be displayed whenever a chart is selected on the worksheet.
10. Pictures inserted into a worksheet must reside within one cell. If you want the picture to take up a large area, you must resize the column and/or row to create a larger area within the cell.
11. Once an object, such as an arrow or a text box, has been inserted into a worksheet, data cannot be inserted into the cells "behind" the object without deleting the object first.
12. Formulas created in a worksheet can reference cells in another sheet if the other sheet is in the same workbook; cells in other workbook files cannot be referenced?
|
Describe your awareness and understanding of diversity
: In a 3 - 5 page double-spaced paper, assess your diversity consciousness and create an action plan to strengthen it. Although this is your personal assessment and action plan, connect your analysis to course concepts and assigned reading. The pape..
|
|
Find the mean number of births per day
: You have just started your own Airline. You have one plane for a route connecting Austin, Boise, and Chicago. One route is Austin-Boise-Chicago and a second route is Chicago-Boise-Austin. How many other routes are possible?
|
|
Write unix shell scripts using dos commands
: Assume you are an experienced DOS programmer and you want to write UNIX shell scripts using DOS commands. Use the alias command so you can type the follow DOS commands and perform UNIX functions
|
|
Evaluating financial performance
: "Evaluating Financial Performance" Please respond to the following:Indicate the ratio(s) that is (are) best for evaluating the risk an entrepreneur is engaged in and indicate how each will direct decisions made in the business. Support your response.
|
|
There are no single cell referenced formulas
: The NOW function can be used to display the current date, time, or a combination of the two in several different formats.
|
|
Products of eutectoid iron-carbon alloy
: 1. Name the microstructural products of eutectoid iron-carbon alloy (0.76 wt% C) speci- mens that are first completely transformed to austenite, then cooled to room temperature at the following rates: (a) 1°C/s, (b) 20°C/s, (c) 50°C/s, and (d) 175°..
|
|
The impact of the sarbanes-oxley act on financial reporting
: The Impact of the Sarbanes-Oxley Act on Financial Reporting What were the major sections of the Sarbanes-Oxley Act of 2002 and how did that directly affect corporate governance? How did this affect internal controls within a company? What the heck ar..
|
|
Justification for the sections of the corporations act
: Explain the reason and justification for the sections of the Corporations Act - companys internal management is governed by a combination of replaceable rules
|
|
Design the program so that it automatically counts
: Label all output, and design the program so that it automatically counts the respondents.
|