Microsoft Excel (Quiz 2)
 Date January 21, 2022
Quiz Summary
0 of 40 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 40 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
 Not categorized 0%
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
 25
 26
 27
 28
 29
 30
 31
 32
 33
 34
 35
 36
 37
 38
 39
 40
 Current
 Review
 Answered
 Correct
 Incorrect

Question 1 of 40
1. Question
In Excel to delete an embedded objects, first
CorrectIncorrect 
Question 2 of 40
2. Question
In Excel comments can be added to cells using
CorrectIncorrect 
Question 3 of 40
3. Question
In Excel which of the following is not a worksheet design criterion?
CorrectIncorrect 
Question 4 of 40
4. Question
In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?
CorrectIncorrect 
Question 5 of 40
5. Question
In Excel a fast way to add up this column of number is to click in the cell below the numbers and then
CorrectIncorrect 
Question 6 of 40
6. Question
In Excel which of the following is an absolute cell reference?
CorrectIncorrect 
Question 7 of 40
7. Question
In Excel what symbol is used before a number to make it a label?
CorrectIncorrect 
Question 8 of 40
8. Question
In Excel which symbol must all formula begin with?
CorrectIncorrect 
Question 9 of 40
9. Question
In Excel which of the following formulas is not entered correctly?
CorrectIncorrect 
Question 10 of 40
10. Question
In Excel which of the following formulas will Excel not be able to calculate?
CorrectIncorrect 
Question 11 of 40
11. Question
In Excel typical worksheet has …. Number of columns
CorrectIncorrect 
Question 12 of 40
12. Question
In Excel how many characters can be typed in a single cell?
CorrectIncorrect 
Question 13 of 40
13. Question
In Excel worksheet can have a maximum of…. Number of rows
CorrectIncorrect 
Question 14 of 40
14. Question
In Excel the following is not an example of a value
CorrectIncorrect 
Question 15 of 40
15. Question
In Excel chart wizard term data series refers to
CorrectIncorrect 
Question 16 of 40
16. Question
In Excel Chart wizard term data categories refers to
CorrectIncorrect 
Question 17 of 40
17. Question
In Excel worksheet range is a
CorrectIncorrect 
Question 18 of 40
18. Question
In Excel getting data from a cell located in a different sheet is called
CorrectIncorrect 
Question 19 of 40
19. Question
In Excel Tab scrolling button
CorrectIncorrect 
Question 20 of 40
20. Question
In Excel numeric value can be treated as a label value if it precedes with
CorrectIncorrect 
Question 21 of 40
21. Question
In Excel concatenation of text can be done using
CorrectIncorrect 
Question 22 of 40
22. Question
In Excel data can be arranged in a worksheet in a easy to understand manner using
CorrectIncorrect 
Question 23 of 40
23. Question
In Excel you can use draganddrop to embed excel worksheet data in a word document
CorrectIncorrect 
Question 24 of 40
24. Question
In Excel the auto calculate feature
CorrectIncorrect 
Question 25 of 40
25. Question
In Excel to view a cell comment
CorrectIncorrect 
Question 26 of 40
26. Question
In Excel say that you want to paste a formula result – but not the underlying formula – to another cell. In excel 2002, you would copy the cell with the formula, then place the insertion point in the cell you want to copy to what next?
CorrectIncorrect 
Question 27 of 40
27. Question
In Excel you can select a single range of cells by
CorrectIncorrect 
Question 28 of 40
28. Question
All formula in Excel start with
CorrectIncorrect 
Question 29 of 40
29. Question
In Excel you can use a function to combine text from two cells into one cell. But you can use an operator to do the same thing. Which operator is that?
CorrectIncorrect 
Question 30 of 40
30. Question
In Excel two common wildcard characters that Excel recognizes are
CorrectIncorrect 
Question 31 of 40
31. Question
In Excel divide symbol is
CorrectIncorrect 
Question 32 of 40
32. Question
In Excel to add two cells (A1 and A2) together you use the following formula
CorrectIncorrect 
Question 33 of 40
33. Question
In Excel on an excel sheet the active cell in indicated by
CorrectIncorrect 
Question 34 of 40
34. Question
In Excel on an Excel sheet the active cell in indicated by
CorrectIncorrect 
Question 35 of 40
35. Question
In Excel using the F11 shortcut key to create a chart on chart sheet creates
CorrectIncorrect 
Question 36 of 40
36. Question
In Excel you can print
CorrectIncorrect 
Question 37 of 40
37. Question
In Excel you can create only a horizontal page break by first selecting
CorrectIncorrect 
Question 38 of 40
38. Question
In Excel you can create hyperlinks from the Excel workbook to
CorrectIncorrect 
Question 39 of 40
39. Question
In Excel cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is
CorrectIncorrect 
Question 40 of 40
40. Question
In Excel advantage of using a spreadsheet is
CorrectIncorrect