MS Excel Test 3 | Computer Awareness Free Online Tests

Time limit: 0

Quiz-summary

0 of 20 questions completed

Questions:

Information

Take MS–EXCEL MCQs Test – PAPER 3

To begin Quiz, Click on start button below:

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 have to finish following quiz, to start this quiz:

Results

0 of 20 questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 points, (0)

Average score
Your score

Categories

Not categorized 0%

Your result has been entered into leaderboard

Name: E-Mail:

Captcha:

Answered
Review

Question 1 of 20

1. Question
5 points
You can use drag-and-drop to embed excel worksheet data in a word document
- By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
- By dragging a range of excel data to the word button on the taskbar while pressing Shift key
- By dragging a range of excel data to the word button on the taskbar while pressing Alt key
- None of above
Correct

Incorrect
Question 2 of 20

2. Question
5 points
What does the VLOOKUP function do?
- Looks up text that contain ‘v’
- Checks whether text is the same in one cell as in the next
- Finds related records
- All of above
Correct

Incorrect
Question 3 of 20

3. Question
5 points
Which of the following is an absolute cell reference?
- !A!1
- $A$1
- #a#1
- A1
Correct

Incorrect
Question 4 of 20

4. Question
6 points
What symbol is used before a number to make it a label?
- “ (quote)
- = (equal)
- _ (underscore)
- ‘ (apostrophe)
Correct

Incorrect
Question 5 of 20

5. Question
5 points
Which of the following formulas is not entered correctly?
- =10+50
- =B7*B1
- =B7+14
- 10+50
Correct

Incorrect
Question 6 of 20

6. Question
5 points
Which of the following formulas will Excel Not be able to calculate?
- =SUM(Sales)-A3
- =SUM(A1:A5)*.5
- =SUM(A1:A5)/(10-10)
- =SUM(A1:A5)-10
Correct

Incorrect
Question 7 of 20

7. Question
5 points
How many characters can be typed in a single cell in Excel?
- 256
- 1024
- 32,000
- 65,535
Correct

Incorrect
Question 8 of 20

8. Question
5 points
Which of the following is not an example of a value?
- 350
- May 10, 2001
- 57%
- Serial Number 50771
Correct

Incorrect
Question 9 of 20

9. Question
5 points
The chart wizard term data series refers to
- A chart legend
- A collection of chart data markers
- A set of values you plot in a chart
- A data label
Correct

Incorrect
Question 10 of 20

10. Question
5 points
Getting data from a cell located in a different sheet is called _____
- Accessing
- Referencing
- Updating
- Functioning
Correct

Incorrect
Question 11 of 20

11. Question
5 points
Tab scrolling button
- Allow you to view a different worksheet
- Allow you to view additional worksheet rows down
- Allow you to view additional worksheet columns to the right
- Allow you to view additional sheets tabs
Correct

Incorrect
Question 12 of 20

12. Question
5 points
A numeric value can be treated as a label value if it precedes with
- Apostrophe
- Exclamation (!)
- Hash (#)
- Ampersand (&Wink
Correct

Incorrect
Question 13 of 20

13. Question
5 points
Data can be arranged in a worksheet in a easy to understand manner using
- auto formatting
- applying styles
- changing fonts
- all of above
Correct

Incorrect
Question 14 of 20

14. Question
5 points
The auto calculate feature
- Can only add values in a range of cells
- Provides a quick way to view the result of an arithmetic operation on a range of cells
- Automatically creates formulas and adds them to a worksheet
- A and c
Correct

Incorrect
Question 15 of 20

15. Question
5 points
Excel uniquely identifies cells within a worksheet with a cell name
- Cell names
- Column numbers and row letters
- Column letters and row numbers
- Cell locator coordinates
Correct

Incorrect
Question 16 of 20

16. Question
5 points
When you want to insert a blank imbedded excel object in a word document you can
- Click the object command on the insert menu
- Click the office links button on the standard toolbar
- Click the create worksheet button on the formatting toolbar
- Click the import excel command on the file menu
Correct

Incorrect
Question 17 of 20

17. Question
5 points
When integrating word and excel, word is usually the
- Server
- Destination
- Client
- Both b and c
Correct

Incorrect
Question 18 of 20

18. Question
5 points
When a label is too long to fit within a worksheet cell, you typically must
- Shorten the label
- Increase the column width
- Decrease the column width
- Adjust the row height
Correct

Incorrect
Question 19 of 20

19. Question
5 points
The name box
- Shows the location of the previously active cell
- Appears to the left of the formula bar
- Appears below the status bar
- Appears below the menu bar
Correct

Incorrect
Question 20 of 20

20. Question
5 points
Comments put in cells are called
- Smart tip
- Cell tip
- Web tip
- Soft tip
Correct

Incorrect

Take More Tests in Computer Awareness:

MS Office	MS Excel	Power Point	File Extensions	Abbreviations
Test 1	Test 1	Test 1	Test 1	Test 1
Test 2	Test 2	Test 2	Test 2	Test 2
Test 3	Test 3	Test 3	Test 3	Test 3

Computer Awareness MS Excel 20 MCQ Test Questions - Test 4 »

« Books and Authors Test 2 | General Knowledge Free Online Tests | 20 MCQs with Answers

Quiz-summary

Information

Take MS–EXCEL MCQs Test – PAPER 3

To begin Quiz, Click on start button below:

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

7. Question

8. Question

9. Question

10. Question

11. Question

12. Question

13. Question

14. Question

15. Question

16. Question

17. Question

18. Question

19. Question

20. Question

Take More Tests in Computer Awareness: