Quiz 1 (Excel Chapter 1)
b. Wrap Text
(Figure 3.) The four cells shown in figure below, are the result of clicking ______. a. Orientation b. Wrap Text c. Merge & Center d. Word Wrap
C. Merge & Center
(Refer to Figure 1.) For A1:K1 you want to make "Skyline Estates" the full header of the table after applying Heading Style 1. In this situation the best option would be? A. Wrap Text B. Decrease font size C. Merge & Center D. Change font style
C. =(F8-H8)/H8
(Refer to Figure 1.) What is the correct formula for Actual Increase/Decrease in cell K8? A. (F8-H8)/H8 B. F8*H8 C. =(F8-H8)/H8 D. =F8-H8
C. =C9+D9+E9
(Refer to Figure 1.) What is the correct formula for total in cell F9 (of those listed)? A. =(C9+D9+E9)/E9 B. =C9*D9 C. =C9+D9+E9 D. E5+E6+E7
a. Use mouse to get black cross in lower right of K6, lets you auto-fill by dragging.
(Refer to Figure 2.) After entering the correct formula in cell K6, what is the fastest/easiest and correct way to apply that same formula to cell K7? a. Use mouse to get black cross in lower right of K6, lets you auto-fill by dragging. b. Use mouse to get black arrow in middle of K6, lets you select a range of cells. c. Use mouse to get cross hair in K6 lets you move a cell or cells. d. Use mouse to select K6, lets you auto-fill by dragging.
c. 10%
(Refer to Figure 2.) What are the contents of cell F8? a. 22 b. 12% c. 10% d. Project Management e. Cell F8 is empty
a. =E7*G7
(Refer to Figure 2.) What is the correct formula to enter in cell I7 (in the formula bar) to calculate "Corporate" for Big Data Analytics? a. =E7*G7 b. $26,388 c. = E7/G7 d. =I7+J7 e. C9*C8
e. =(1-F6)*E6*H6
(Refer to Figure 2.) You were instructed in Grader Project Assessment, Excel Chapter 1 to enter a formula in cell J6 that calculated Education for Systems analyst. What is correct to enter in cell J6 (in the formula bar)? a. $30,786.00 b. =F6-E6*H6 c. =I7+J7 d. =E6*G6 e. =(1-F6)*E6*H6
B. Contains sheets of columns and rows which can use formulas on information and repeat formulas easily.
10. The best description of Excel from the following choices is... A. A database management system. B. Contains sheets of columns and rows which can use formulas on information and repeat formulas easily. C. A file which resides on a web server and can be seen by anyone with an internet connection. D. A device to train and simulate students in a psuedo-environment.
D. The two cells and all cells between
A colon between two cell references indicates a range of cells that includes ________. A. The entire worksheet B. All cells in the worksheet except the two cells C. The two cells D. The two cells and all cells between
D. Increase the column width
According to the eBook, what should you do if you see a column of pound signs (####) instead of values or results of a formula? A. Increase the zoom percentage B. Delete the column C. Adjust the row height D. Increase the column width
b. Is adjustable so you can display more or less characters in a column.
Column width: a. Always switches back to default. b. Is adjustable so you can display more or less characters in a column. c. Is best left unchanged unless you absolutely have to. d. Is not adjustable so keep the formulas as short as possible.
A. 45
Given the formula =B1^2+B3/4*B2+B4 where B1 contains 3, B2 contains 4, B3 contains 32, and B4 contains 4, what is the result? A. 45 B. 15 C. 73 D. 14
a. add a zero in front of the decimal point
If .25 is typed and Enter or Tab is pressed, Excel will automatically ___________. a. add a zero in front of the decimal point b. insert a formula c. delete the number d. add a percent sign after the number
D. Click the File tab, and then click Print
If you want to see a preview of how a worksheet will appear on a hard copy, what do you do? A. Click the Page Layout tab, and then click the Print check box in the Sheet Options group. B. Change the Zoom to 100%. C. Click the Page Setup Dialog Box Launcher. D. Click the File tab, and then click Print
a. range of cells
In the formula =SUM (B5:B30), B5:B30 indicates the ________. a. range of cells b. type of calculation c. variable d. cells excluded from the calculation
c. Learning web pages, Excel and Access.
OMIS 259 is mostly about a. Making my life difficult with computers. b. Making me into a tech specialist. c. Learning web pages, Excel and Access. d. Excel.
b. Enables data to appear on two or more lines within a cell.
The wrap text feature in Excel: a. Enables long formulas to wrap to two or more lines within a single cell. b. Enables data to appear on two or more lines within a cell. c. Is most useful with very short titles or column headings. d. Can be downloaded as an add-on to Excel 2013.
D. column S row 4
We want to put the formula for course percentage in the cell labeled S4. S4 refers to ______. A. row S column 4 B. the function available in that cell C. function #4 D. column S row 4
B. Content appearing at the top of every printed page
What is a header? A. Content appearing at the bottom of every printed page B. Content appearing at the top of every printed page C. Content appearing at the right margins of every printed page D. Content appearing at the left margins of every printed page
C. A what-if analysis
Which of the following can be performed by managers using Excel? A. who/what/where/when/why analysis B. A grammatical analysis C. A what-if analysis D. A philosophical analysis
a. https://z123456.niu.edu/Google.Sites/z123456/
Which of the following is NOT a correct url format for your NIU student Google site if your znumber is z123456? a. https://z123456.niu.edu/Google.Sites/z123456/ b. https://sites.google.com/sites/z123456 c. https://sites.google.com/ sites/NIUz123456 d. https://sites.google.com/sites/YourName/z123456
e. ST (10%) - SE (40%) - GPHW (10%) - GPA (40%)
Which of the following is the recommended order and correct weight for MyITLab Assignments? a. ST (10%) - GPA (10%) - GPHW (40%) - SE (40%) b. ST (10%) - GPHW (40%) - GPA (10%) -- SE (40%) c. GPHW (10%) - ST (10%) - GPA (40%) -- SE (40%) d. ST (10%) - SE (10%) - GPHW (40%) - GPA (40%) e. ST (10%) - SE (40%) - GPHW (10%) - GPA (40%)
