PRE201_P4

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

b

14. You can edit existing Excel data by pressing the a. F1 key b. F2 key c. F3 key d. F4 key

d

15. The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is .... a. G1-G10 b. B1.G10 c. B1;G10 d. B1:G10

b

16. A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this? a. Go to File-Save As - Save As Type - Excel worksheet b. Right click on the spreadsheet tab and select DELETE c. Right click on the spreadsheet and select Insert - Entire Column d. None of above

d

4. You can open the Highlight Changes dialog box by choosing Track Changes from the .... Menu. a. Edit b. Insert c. Format d. Tools

c

5. Which of the following is not a worksheet design criterion? a. Efficiency b. Auditability c. Description d. Clarity

d

6. To copy cell contents using drag and drop, press the a. End key b. Shift key c. Esc key d. None of above

a

7. If you press ...., the cell accepts your typing as its contents. a. Enter b. Ctrl + Enter c. TAB d. Insert

a

8. The autofill feature a. Extends a sequential series of data b. Automatically adds a range of cell values c. Applies a boarder around selected cells d. None of above

D

9. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells? a. F3 b. F5 c. F7 d. F11

a

1. Which of the following is not an option in the spelling dialog box? a. Edit b. Ignore c. Ignore all d. Change

b

10. you can use the formula palette to a. format cells containing numbers b. create and edit formulas containing functions c. entered assumptions data d. copy a range of cells

c

11. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data chas changed a. Format Report b. Pivot Table c. Refresh Data d. Show Detail

Correct Answer: A

12. What is an expression that tells how the numbers in a determined set of cells are to be calculated? a. Formula b. Field c. Data d. Query

c

13. "Qtr 1, Qtr 2, Qtr 3" is an example of a a. Formula b. Function c. Series d. Syntax

d

17. What feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula? a. Goal Seek b. Scenario Summary report c. Forecasting d. Trend line

a

18. what term describes a background that appears as a grainy, non smooth surface a. gradient b. pattern c. solid d. texture

d

19. Excel is a a. Graphic program b. None of these c. Word processor d. A spreadsheet

c

2. You can quickly change the appearance of your work by choosing Auto Format from the .... Menu a. Edit b. View c. Format d. Tools

d

20. To create an interactive Pivot Table for the web, you use a Microsoft Office Web component called a. HTML b. Pivot Table Field List c. Pivot Table List d. Pivot Table Report

c

3. To protect a worksheet, you can choose Protection and the Protect Sheet from the ..... menu a. Edit b. Format c. Tools d. Data


संबंधित स्टडी सेट्स

Medical-surgical: gastrointestinal

View Set

States of Consciousness & Cognition FA

View Set

Chapter 10 Computer Programming w/ C++

View Set