# MS Excel 2010 Skills Assessment! Trivia Quiz

Approved & Edited by ProProfs Editorial Team
At ProProfs Quizzes, our dedicated in-house team of experts takes pride in their work. With a sharp eye for detail, they meticulously review each quiz. This ensures that every quiz, taken by over 100 million users, meets our standards of accuracy, clarity, and engagement.
| Written by Carlson95602
C
Carlson95602
Community Contributor
Quizzes Created: 1 | Total Attempts: 10,261
Questions: 20 | Attempts: 10,261

Settings

This quiz is designed to provide an assessment of team members' level of competency in key features and functions of Excel 2010. The results of this quiz will be used to determine course placement for each team member based on the total score achieved. Please answer quiz questions without using any reference materials so that we may get an accurate measurement of skill level.

• 1.

### What is wrong with this formula?  =IF(D3=<90,"A-",0)

• A.

The operator symbols are in reverse order

• B.

There is no need to place quotation marks around the letter A

• C.

Excel doesn't use a Function named IF

• D.

The number of arguments is incorrect

• E.

I don't know the answer to this question.

A. The operator symbols are in reverse order
Explanation
The formula in question has the operator symbols in reverse order. The correct order should be =IF(D3

Rate this question:

• 2.

### Which of the following is the correct formula to use in order to combine the last name and first name in this example so that the end result is what you see in Cell D2?

• A.

=TRANSPOSE(B2, C2)

• B.

=COMBINE(B2,", ",C2)

• C.

=CONCATENATE(B2,", ",C2)

• D.

=TEXT (B2:C2, PROPER)

• E.

I don't know the answer to this question.

C. =CONCATENATE(B2,", ",C2)
Explanation
The correct formula to use in order to combine the last name and first name in this example so that the end result is what you see in Cell D2 is =CONCATENATE(B2,", ",C2). This formula uses the CONCATENATE function to join the values in cells B2 and C2 with a comma and space in between.

Rate this question:

• 3.

### What does this symbol on the status bar of Excel indicate?

• A.

That the workbook is ready to be used.

• B.

That the user can click and drag the mouse to create a square

• C.

That there are currrently NO spelling errors on the worksheet

• D.

That a macro is currently being recorded

• E.

I don't know the answer to this question.

D. That a macro is currently being recorded
Explanation
The symbol on the status bar of Excel indicates that a macro is currently being recorded. This means that the user is in the process of creating a macro, which is a sequence of commands and actions that can be automated to perform a specific task. When the macro is being recorded, Excel displays a specific symbol on the status bar to indicate this.

Rate this question:

• 4.

### What function would be used to find the total sales of both the High School and Jr High food as shown below:

• A.

GRANDTOTAL

• B.

SUMPRODUCT

• C.

TOTAL

• D.

PRODTOTAL

• E.

I don't know the answer to this question.

B. SUMPRODUCT
Explanation
The function that would be used to find the total sales of both the High School and Jr High food is SUMPRODUCT. SUMPRODUCT multiplies corresponding values in two or more arrays and then returns the sum of those products. In this case, it would be used to multiply the sales of High School food and Jr High food and then sum them up to find the total sales.

Rate this question:

• 5.

### How many columns have been set to be filtered?

• A.

None

• B.

3

• C.

2

• D.

4

• E.

I don't know the answer to this question.

B. 3
Explanation
There are 3 columns that have been set to be filtered.

Rate this question:

• 6.

### This format of numbers is known as what type?

• A.

General

• B.

Number

• C.

Currency

• D.

Accounting

• E.

I don't know the answer to this question.

D. Accounting
Explanation
The format of numbers referred to as "Accounting" is commonly used in financial documents and spreadsheets. It typically includes a currency symbol, commas as thousand separators, and parentheses to indicate negative values. This format is designed to make numbers easier to read and understand in financial contexts.

Rate this question:

• 7.

### What is the purpose of this icon?

• A.

To search for, insert, and get help with functions

• B.

To add special Effects (Fx) to the worksheet

• C.

To determine if the syntax of the current formula is correct

• D.

To use the Tool Analysis AddOn feature

• E.

I don't know the answer to this question.

A. To search for, insert, and get help with functions
Explanation
This icon is used to search for, insert, and get help with functions. It provides access to a library of functions and allows users to easily find and insert the desired function into their worksheet. Additionally, it provides helpful information and suggestions on how to use the functions correctly.

Rate this question:

• 8.

### How do you select noncontiguous cells?

• A.

Click a cell, then hold down SHIFT on the keyboard and select the other cells

• B.

Click in a cell, then hold down ALT on the keyboard as you select the other cells

• C.

Click in a cell, hold down CTRL on the keyboard and then select the other cells

• D.

Click in a cell, then hold down SHIFT as you move from cell to cell using the Arrow keys on the keyboard

• E.

I don't know the answer to this question.

C. Click in a cell, hold down CTRL on the keyboard and then select the other cells
Explanation
To select noncontiguous cells, you can click in a cell, hold down CTRL on the keyboard, and then select the other cells. This allows you to choose multiple cells that are not adjacent to each other.

Rate this question:

• 9.

### If you have a lot of rows of data and the totals are displayed in the very last row, what Excel feature can you use so that when you are working with the data you can automatically see how your edits and changes to the data affects that very last row without having to scroll down to it?

• A.

Watch Window

• B.

Show Formulas

• C.

What If Scenario

• D.

Formula Watch

• E.

I don't know the answer to this question.

A. Watch Window
Explanation
The Watch Window feature in Excel allows you to monitor the value of specific cells or ranges of cells while you are working on other parts of the worksheet. By adding the totals displayed in the very last row to the Watch Window, you can easily see how your edits and changes to the data affect those totals without having to scroll down to the last row. This helps in efficiently analyzing the impact of your changes on the overall data.

Rate this question:

• 10.

### Where is the Name Box located?

• A.

On the Formulas tab, Defined Names group

• B.

Directly above Column A

• C.

Just to the right of the Fx (Insert Function) icon

• D.

On the View tab, Windows group

• E.

I don't know the answer to this question.

B. Directly above Column A
Explanation
The Name Box is located directly above Column A.

Rate this question:

• 11.

### Where can you insert and edit Headers and Footers in Live View?

• A.

• B.

Print Preview window

• C.

Page Break Preview

• D.

Page Layout View

• E.

I don't know the answer to this question.

D. Page Layout View
Explanation
In Page Layout View, you can insert and edit headers and footers in Live View. This view allows you to see how your document will look when printed, including the headers and footers. By accessing the Header & Footer options in the Page Layout View, you can easily customize and modify the headers and footers according to your requirements.

Rate this question:

• 12.

### What is the Average, Count, and Sum of the selected cells?

• A.

Average: 46,265 Count: 6 Sum: 323,857

• B.

Average: 46,265 Count: 7 Sum: 212,313

• C.

Average: 46,265 Count: 7 Sum: 323,857

• D.

Average: 46,550 Count: 7 Sum: 43,440

• E.

I don't know the answer to this question.

C. Average: 46,265 Count: 7 Sum: 323,857
Explanation
The selected cells have an average value of 46,265, indicating that the sum of all the values divided by the count of values is equal to this average. The count of selected cells is 7, meaning that there are 7 values in total. The sum of the selected cells is 323,857, which is the total sum of all the values in the selected cells.

Rate this question:

• 13.

### What steps do you take to create the following conditional format?

• A.

Select the desired data. Home Tab. Conditional Formatting. Data Bars. Choose one.

• B.

Select the desired data. Home Tab. Conditional Formatting. Color Sets. Choose one.

• C.

Select the desired data. Home Tab. Conditional Formatting. Icon Sets. Choose one.

• D.

Select the desired data. Data Tab. Conditional Formatting. Icon Sets. Choose one.

• E.

I don't know the answer to this question.

C. Select the desired data. Home Tab. Conditional Formatting. Icon Sets. Choose one.
• 14.

### What does this icon do?

• A.

Copies the font, font size, font color, etc. from a selected cell to other cells

• B.

Copies the font, font size, font color, and formulas from a selected cell to other cells

• C.

Copies all formatting, including Conditional Formatting, to other cells

• D.

Creates headings styles that can be used throughout the workbook

• E.

I don't know the answer to this question.

A. Copies the font, font size, font color, etc. from a selected cell to other cells
Explanation
This icon allows the user to copy the font, font size, font color, and other formatting properties from a selected cell to other cells. It does not copy formulas or conditional formatting.

Rate this question:

• 15.

### If I have formatted a row of cells in a particular way...for instance, purple fill color, white font color, Calibri, 14 pt Bold...I can save these format choices as a Cell Style by clicking in any of the formatted cells and then clicking the...

• A.

Page Layout tab, Cell Styles, Save Style, type a name for the style, click OK

• B.

Insert Tab, New Style, type a name for the style, click OK

• C.

Home Tab, New Style, Save Style, type a name for the style, click OK

• D.

Home Tab, Cell Styles, New Cell Style, type a name for the new style, click OK

• E.

I don't know the answer to this question.

D. Home Tab, Cell Styles, New Cell Style, type a name for the new style, click OK
Explanation
To save the formatting choices as a Cell Style, you need to go to the Home Tab, click on Cell Styles, then select New Cell Style. After that, you should type a name for the new style and click OK. This will save the formatting choices as a Cell Style for future use.

Rate this question:

• 16.

### Which function would you use to find the largest number of a selected range?

• A.

MAXIMUM

• B.

LARGEST

• C.

MAX

• D.

LARGE

• E.

I don't know the answer to this question.

C. MAX
Explanation
The MAX function is used to find the largest number in a selected range. It returns the maximum value from a set of values.

Rate this question:

• 17.

### How is the function COUNTA different from the function COUNT?

• A.

COUNTA counts the number of cells that are not empty in a range

• B.

COUNTA counts only the cells that contain numbers

• C.

COUNTA counts only the cells that contain text

• D.

COUNTA counts every cell in a range regardless of whether they are empty, contain text, or contain numbers

• E.

I don't know the answer to this question.

A. COUNTA counts the number of cells that are not empty in a range
Explanation
COUNTA is different from COUNT because COUNTA counts every cell in a range regardless of whether they are empty, contain text, or contain numbers. On the other hand, COUNT only counts the cells that contain numbers. Therefore, COUNTA is more inclusive as it considers all types of data in the range, while COUNT only focuses on numeric values.

Rate this question:

• 18.

### Which icon below would used to create the formatted headings shown below?

• A.
• B.
• C.
• D.
• E.

I don't know the answer to this question.

D.
• 19.

### What Excel feature was used to input the note to the user?

• A.

Comment

• B.

Note

• C.

Data Validation Input Entry

• D.

Unhidden Comment

• E.

I don't know the answer to this question.

C. Data Validation Input Entry
Explanation
The correct answer is Data Validation Input Entry. Data Validation is an Excel feature that allows you to set restrictions on what can be entered into a cell. When using Data Validation, you can also add an input message that provides instructions or notes to the user when they select the cell. This input message is called the Data Validation Input Entry.

Rate this question:

• 20.

### In this Pivot Table, the Dept field is used for a Report Filter.  How can you get all of the different departments to automatically display on their own separate sheet tabs at the bottom of the workbook?

• A.

You would need to view each department as a separate Pivot Table first, then copy the worksheet to its own tab

• B.

Options contextual tab, Options icon, Show Report Filter Pages, OK

• C.

Display all departments, Options contextual tab, Move Worksheet icon, choose "New Worksheet", OK

• D.

Design tab, Move Pivot Table icon, "Move to Individual Worksheet", OK

• E.

I don't know the answer to this question.