Critical Thinking Questions
Case 1-1
?
You work in the Sales department of a company that has three store locations; Downtown, Midtown, and Uptown. You are creating a summarized worksheet about the company's sales to send to the General Manager. So far, you have created a worksheet that lists each store location in cells A4 through A6. Quarterly sales for Downtown are in cells B4 through E4, Midtown are in cells B5 through E5, and Uptown quarterly sales are in cells B6 through E6.
?
?
Write the complete formulas for finding the Yearly Sales figures in cell F4 for the Downtown store.
a.=TOT(B4:E4)c.=AVERAGE(B4:E4)b.=SUM(B4:E4)d.=ADD(B4:E4)
What will be an ideal response?
Answer: B
You might also like to view...
Which of the following is a valid consideration when implementing physical database design?
A. normalization diminishes database integrity B. normalized views of the data improve query performance C. all relationships should be explicitly defined in the database D. it's best to use data types that require conversion
Identify the letter of the choice that best matches the phrase or definition.
1. A Bridge component that hides all files except those specified
2. A file format that uses lossy compression
3. Decreases the resolution of an image
4. An additive color mode
5. A color mode that uses a color lookup table of 256 colors
6. Allows you to cut out image data while also controlling additional features
7. A file format that uses lossless compression
8. Adds pixels to an image
9. Allows you to see a different area of an image
10. A subtractive color mode
11. A file format that can store both vector and bitmap data
12. Information describing how data is formatted or how it was collected
A(n) ____ is the easiest kind of document to import because it is formatted with styles.
A. Word outline B. Excel spreadsheet C. Publisher document D. Access database
Match the following Word options to the tab where located:
I. insert form controls II. modify a macro from the Macros dialog box III. add a digital signature IV. display Restrict Editing pane V. insert Signature Line A. Insert tab B. Review tab C. File tab D. Developer tab E. View tab