Microsoft Excel 2010 Online Test-1

This online test section contains the next top best multiple-choice type questions with answers (MCQs) based on Microsoft Excel 2010. This online Quiz / Practice Test is suitable for various exams conducted by various educational organizations.These Objective questions cover various aspects of Microsoft Excel 2010, from basic functions and formulas to data management and formatting.

Test Instructions
Question type	Questions remain the same unless test is updated
Total Number of Questions	25
Time Limit	20 Minutes
Points	1 Point for each Question

TIME LEFT : 0

Test-summary

0 of 25 questions completed

Questions:

Information

You have already completed the Test before. Hence you can not start it again.

Test is loading...

You must sign in or sign up to start the Test.

You have to finish following Test, to start this Test:

Results

0 of 25 questions answered correctly

Time Taken by You:

Time has elapsed

You have reached 0 of 0 points, (0)

Categories

Not categorized 0%

Answered
Review

Question 1 of 25

Q-1. How would you assign a macro to a graphic?

On the Developer tab, in the Code group, click on Macros.

On the View tab, click on Macros and then click on Assign Macro on the shortcut menu. In the Macro name box, click on the macro that you want to assign.

On a worksheet, right-click on the graphic, then click on Assign Macro on the shortcut menu. In the Macro name box, click on the macro that you want to assign.

Your Answer : Correct

Your Answer : Incorrect

Question 2 of 25

Q-2. State whether following statement regarding cell references in Microsoft Excel 2010 is true or false:A Relative cell reference consists of the column letter and row number surrounded by dollar signs ($).

True

False

Your Answer : Correct

Your Answer : Incorrect

Question 3 of 25

Q-3. Slicers are filtering components which are used to filter the data in a PivotTable report or CUBE functions. Which of the following data sources is/are supported by Slicers in Microsoft Excel 2010?

Office Database connections

Online Analytical Processing (OLAP) Queries

Online Analytical Processing (OLAP) Cube Files

All of the above

Your Answer : Correct

Your Answer : Incorrect

Question 4 of 25

Q-4. Which of the following components of Excel Services enables the user to edit a published workbook inside a web browser?

Excel Calculation Services (ECS)

Excel Web Access (EWA)

Excel Web Services (EWS)

Your Answer : Correct

Your Answer : Incorrect

Question 5 of 25

Q-5. What is the filename extension of Excel workbooks which are saved as ‘Excel Templates’?

.xlsx

.xslt

.xltx

.slk

Your Answer : Correct

Your Answer : Incorrect

Question 6 of 25

Q-6. What is Microsoft Excel 2010 primarily used for?

Creating presentations

Managing emails

Data analysis and spreadsheet calculations

Word processing

Your Answer : Correct

Your Answer : Incorrect

Question 7 of 25

Q-7. In Excel 2010, what is the term for a single spreadsheet containing rows and columns?

Worksheet

Workbook

Table

Cell

Your Answer : Correct

Your Answer : Incorrect

Question 8 of 25

Q-8. Which Excel 2010 function is used to add up a range of numbers?

SUM()

ADD()

TOTAL()

CALC()

Your Answer : Correct

Your Answer : Incorrect

Question 9 of 25

Q-9. What does "Ctrl + C" do in Excel 2010?

Close the program

Copy selected content to the clipboard

Save the workbook

Undo the last action

Your Answer : Correct

Your Answer : Incorrect

Question 10 of 25

Q-10. Which feature in Excel 2010 allows you to visually represent data using charts and graphs?

Formulas

Filters

PivotTables

Charts

Your Answer : Correct

Your Answer : Incorrect

Question 11 of 25

Q-11. What is the term for a cell that is the intersection of a row and a column in Excel 2010?

Block

Square

Cell

Element

Your Answer : Correct

Your Answer : Incorrect

Question 12 of 25

Q-12. In Excel 2010, what does "Ctrl + V" do?

Close the program

Copy selected content to the clipboard

Save the workbook

Paste content from the clipboard

Your Answer : Correct

Your Answer : Incorrect

Question 13 of 25

Q-13. What function in Excel 2010 is used to find the average of a range of numbers?

AVG()

AVERAGE()

MEAN()

SUM()

Your Answer : Correct

Your Answer : Incorrect

Question 14 of 25

Q-14. What is the term for a predefined formula in Excel 2010 that performs a specific calculation?

Equation

Script

Function

Macro

Your Answer : Correct

Your Answer : Incorrect

Question 15 of 25

Q-15. How can you freeze rows and columns in Excel 2010 to keep them visible while scrolling?

Right-click and select "Freeze Panes"

Press "Ctrl + F"

Double-click on the row or column header

Use the "View" tab in the ribbon

Your Answer : Correct

Your Answer : Incorrect

Question 16 of 25

Q-16. What is the function of the Excel 2010 "AutoFill" feature?

To automatically correct errors in formulas

To fill cells with color

To quickly copy and fill data into adjacent cells

To perform complex calculations

Your Answer : Correct

Your Answer : Incorrect

Question 17 of 25

Q-17. In Excel 2010, which symbol is used to indicate a relative cell reference in a formula?

None of the above (Relative cell references don't use symbols.)

Your Answer : Correct

Your Answer : Incorrect

Question 18 of 25

Q-18. What does the "IF" function in Excel 2010 allow you to do?

Create macros

Perform text formatting

Perform conditional calculations

Insert images

Your Answer : Correct

Your Answer : Incorrect

Question 19 of 25

Q-19. In Excel 2010, what does the "SUMIF" function do?

Adds a range of numbers

Calculates the average of a range

Sums values in a range based on a specified condition

Subtracts one range from another

Your Answer : Correct

Your Answer : Incorrect

Question 20 of 25

Q-20. What is the purpose of the "Data Validation" feature in Excel 2010?

To validate the accuracy of formulas

To ensure data is entered correctly into cells

To automatically update data

To create charts

Your Answer : Correct

Your Answer : Incorrect

Question 21 of 25

Q-21. In Excel 2010, what does "Ctrl + Z" do?

Close the program

Save the workbook

Undo the last action

Redo the last action

Your Answer : Correct

Your Answer : Incorrect

Question 22 of 25

Q-22. Which feature in Excel 2010 allows you to filter and sort data in a table?

Conditional formatting

Data validation

PivotTables

Sort and Filter

Your Answer : Correct

Your Answer : Incorrect

Question 23 of 25

Q-23. What is the purpose of the Excel 2010 "VLOOKUP" function?

To search for text in a worksheet

To find and replace data

To vertically search for a value in a table and return a corresponding value

To create a chart

Your Answer : Correct

Your Answer : Incorrect

Question 24 of 25

Q-24. In Excel 2010, how can you create a chart from selected data?

Right-click and select "Create Chart"

Use the "Format Painter" tool

Go to the "Insert" tab and choose a chart type

Use the "Find and Replace" feature

Your Answer : Correct

Your Answer : Incorrect

Question 25 of 25

Q-25. What is the keyboard shortcut to save an Excel 2010 workbook?

Ctrl + S

Ctrl + C

Ctrl + P

Ctrl + X

Your Answer : Correct

Your Answer : Incorrect

EXAMRADAR

For Solo Learner Computer science

Microsoft Excel 2010 Skills Online Test-1

Test-summary

Information

Results

Categories