Microsoft Excel Test

Exam Type: Microsoft Excel MCQ Skill Test
Questions Type: Multiple Choice Questions
Total Questions: 35
Time Limit: 30 Minutes
Last Update June, 2025

Pass Microsoft Excel Exam

75%
Total time

1 minute 2 seconds

Total time

1 correct answers

Total time

6 incorrect answers

Total time

6 not attempted

Start

Microsoft Excel Quiz

Question 1 of 35
30:00

Some of your data in Column C is displaying as hashtags (#) because the column is too narrow. How can you widen Column C just enough to show all the data?

Which two functions check for the presence of numerical or nonnumerical characters in cells?

If cell A3 contains the text THE DEATH OF CHIVALRY, what will the function =PROPER(A3) return?

When editing a cell, what do you press to cycle between relative, mixed, and absolute cell references?

You need to add a line chart showing a sales trend over the last 12 months and you have only a little space to work with. How can you convey the required information within a single cell?

What is the best way to activate the Excel Help system?

Which format will display the value 27,500,000 as 27.5?

When using Goal Seek, you can find a target result by varying _____ at most.

Cell D1 contains the value 7.877. You want cell D1 to display this value as 7.9 but keep the original number in calculations. How can you accomplish this?

Which formula is not equivalent to all of the others?

Which function returns a reference to a cell (or cell range) that is a specified distance from a base cell?

The text filter in column A is designed to display only those rows where column A entry has a particular attribute. What is this attribute?

To ensure shapres and other objects are an equal left-to-right distance apart, select the shapes, click Page Layout > Align, and the click ____.

An organization chart, which shows the hierarchy within a company or organization, is available as _ that is included with Excel.?

You want to be able to restrict values allowed in a cell and need to create a drop-down list of values from which users can choose. Which feature should you use?

To round up a value to the nearest increment of your choice, such as the next five cents, what function should you use?

Which function returns the largest value amongst all values within the range H2:H30?

Which chart type can display two different data series as a different series type within the same chart?

Which formula returns the value in cell A1 of the worksheet named MySheet?

Which formula correctly counts the number of numeric values in both B4:E4 and G4:I4?

After activating a chart, which sequence adds a trendline to the chart?

Which Excel add-in will help you find a target result by varying multiple inputs to a formula?

What tool would you use to prevent the input in a cell of a date outside a specific range?

When you sort a list of numerical value into ascending or descending order, the value in the middle of the list is the _.

Which format setting does NOT change the background appearance of a cell?

In Excel, what do most formulas begin with?

If you start a date series by dragging down the fill handle of a single cell that contains the date 12/1/19, what will you get?

To discover how many cells in a range contain values that meet a single criterion, use the _____ function.

Of these four chart types, which works best for summarizing time-based data?

Your worksheet has the value 27 in cell B3. What value is returned by the function =MOD(B3,6)?

For an IF function to check whether cell B3 contains a value between 15 and 20 inclusively, what condition should you use?

Which of these functions returns the largest value within the range H2:H30?

Cell A20 displays an orange background when its value is 5. Changing the value to 6 changes the background color to green. What type of formatting is applied to cell A20?

What does this formula do? =Sum(Sheet1:Sheet4!D18)

If you want to create subtotals in a list, you should _____ your list first, so that you don't have too many subtotal lines.

Microsoft Excel Test Explained

© 2025 Skill Test Answer. All Rights Reserved