Excel Advanced Questions By Akshay Magre

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
| By Pavan86
P
Pavan86
Community Contributor
Quizzes Created: 2 | Total Attempts: 1,819
Questions: 20 | Attempts: 362

Settings

This Set of Questions are for Target Audience already aware of Basic Excel Concepts.

Questions : 20
Time Limit : 40 mins
Pass Criteria : 60 %

• 1.

Which of the following is correct Syntax in excel?

• A.

=IF(LOGICAL TEST,TRUE RESULT,FALSE RESULT)

• B.

=IF(LOGICAL TEST,FALSE RESULT,TRUE RESULT)

• C.

=IF(LOGICAL TEST,TRUE RESULT)(LOGICAL TEST, FALSE RESULT)

• D.

ALL OF THE ABOVE

A. =IF(LOGICAL TEST,TRUE RESULT,FALSE RESULT)
Explanation
The correct syntax in Excel is "=IF(LOGICAL TEST,TRUE RESULT,FALSE RESULT)". This formula is used to perform a logical test and return different values based on the result of the test. The logical test is placed in the first argument, the value to be returned if the test is true is placed in the second argument, and the value to be returned if the test is false is placed in the third argument.

Rate this question:

• 2.

Late for your investors meeting? How can you quickly apply professional formatting to your sales forecast worksheet?

• A.

Apply special attributes using Format Painter

• B.

Apply an Auto Format Style

• C.

Apply a selected background color

• D.

All of above

B. Apply an Auto Format Style
Explanation
Applying an Auto Format Style allows you to quickly and easily apply professional formatting to your sales forecast worksheet. This feature automatically applies a pre-designed format to your data, saving you time and effort in manually formatting the worksheet. It ensures consistency and a professional look throughout the document.

Rate this question:

• 3.

The cell reference fro a range of cells that starts in cell B1 and goes over to column G and down to row 10 is

• A.

B1:G10

• B.

B1-G10

• C.

B1;G10

• D.

B1&G10

A. B1:G10
Explanation
The correct answer is B1:G10 because it represents a range of cells starting from B1 and extending to column G and down to row 10. The colon (:) is used to indicate a range of cells in Excel.

Rate this question:

• 4.

Using the F11 shortcut key to create a chart on chart sheet creates

• A.

A default chart

• B.

A 2-dimensional column chart

• C.

A 2-dimensional bar chart

• D.

A 3-dimensional line chart

B. A 2-dimensional column chart
Explanation
Using the F11 shortcut key to create a chart on a chart sheet in Excel creates a 2-dimensional column chart. This means that the chart will display data in columns, with one axis representing the categories and the other axis representing the values. The chart will be in 2D, meaning it will not have any depth or perspective. This is the default chart type that is created when using the F11 shortcut key.

Rate this question:

• 5.

To add two cells (A1 and A2) together you use the following formula

• A.

=A1+A2

• B.

• C.

=together(A1:A2)

• D.

A1 plus A2

A. =A1+A2
Explanation
The correct answer is =A1+A2 because it is the correct formula to add the values in cells A1 and A2 together. The plus sign (+) is used to indicate addition in Excel formulas, so =A1+A2 means adding the value in cell A1 to the value in cell A2.

Rate this question:

• 6.

You can use drag and drop to embed excel worksheet data in a word document

• A.

By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key

• B.

By dragging a range of excel data to the Word button on the taskbar while pressing Shift key

• C.

By displaying both applications side-by-side and dragging a selected range of Excel data into the word application window while pressing the Ctrl key

• D.

A and c

D. A and c
Explanation
You can use drag and drop to embed excel worksheet data in a word document by either dragging a range of excel data to the Word button on the taskbar while pressing the Ctrl key or by displaying both applications side-by-side and dragging a selected range of Excel data into the word application window while pressing the Ctrl key.

Rate this question:

• 7.

Excel uses the …. Function when creating a data table

• A.

Average

• B.

Count

• C.

Sum

• D.

Table

D. Table
Explanation
Excel uses the "Table" function when creating a data table. This function allows users to organize and analyze data in a structured format. By converting a range of data into a table, users can easily sort, filter, and perform calculations on the data. Tables also provide automatic formatting and dynamic range expansion, making it a convenient tool for data analysis in Excel.

Rate this question:

• 8.

What chart object is horizontal or vertical line that extends across the plot area to make it easier to read and follow the values?

• A.

Category axis

• B.

Data marker

• C.

Data point

• D.

Gridline

D. Gridline
Explanation
A gridline is a horizontal or vertical line that extends across the plot area of a chart. It helps to make the chart easier to read and follow the values by providing a visual reference. Gridlines are often used in combination with axis labels to create a clear and organized chart.

Rate this question:

• 9.

Which of the following is a correct order of precedence in a formula calculation?

• A.

Multiplication and division, exponential positive and negative value

• B.

Multiplication and division, positive and negative values, addition and subtraction

• C.

Addition and subtraction, positive and negative values, exponentiation

• D.

None of above

D. None of above
Explanation
The given options do not provide a correct order of precedence in a formula calculation. The correct order of precedence is typically parentheses, exponentiation, multiplication and division (from left to right), and addition and subtraction (from left to right). Therefore, the correct answer is "None of above" as none of the options provide the correct order of precedence.

Rate this question:

• 10.

which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?

• A.

Workday

• B.

Date

• C.

Networkdays

• D.

All of the above

D. All of the above
Explanation
The correct answer is "All of the above" because all three functions (workday, date, and networkdays) can be used to calculate the number of workdays between two dates. Each function has its own syntax and parameters, but they all serve the same purpose of counting the number of workdays. Therefore, any of these functions can be used to calculate the number of workdays between 6/9/2004 and 8/12/2004.

Rate this question:

• 11.

Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

• A.

Use Ctrl to select all three cells, then click the paste button on the standard toolbar

• B.

Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify

• C.

Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to

• D.

All of above

C. Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
Explanation
The correct answer is to click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to. This option allows you to quickly copy the formatting from a selected cell to two other cells on the same worksheet by using the format painter tool. By double-clicking the format painter, you can copy the formatting to multiple cells without having to click the format painter again for each cell.

Rate this question:

• 12.

You can group noncontiguous worksheets with

• A.

The group button on the standard toolbar

• B.

The shift key and the mouse

• C.

The ctrl key and mouse

• D.

The alt+enter key

C. The ctrl key and mouse
Explanation
You can group noncontiguous worksheets by holding down the ctrl key on your keyboard and selecting the desired worksheets with your mouse. This allows you to perform actions, such as formatting or entering data, on multiple worksheets at once.

Rate this question:

• 13.

How do you change column width to fit the contents?

• A.

Single-click the boundary to the left to the column heading

• B.

Double click the boundary to the right of the column heading

• C.

Press Alt and single click anywhere in the column

• D.

All of above

B. Double click the boundary to the right of the column heading
Explanation
Double clicking the boundary to the right of the column heading will automatically adjust the column width to fit the contents.

Rate this question:

• 14.

What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.

• A.

• B.

Database program

• C.

Word processor program

• D.

Desktop publisher program

Explanation
A computer program that organizes data in rows and columns of cells is called a spreadsheet program. This type of program is commonly used to keep track of financial information, such as recording the money earned from mowing lawns over the summer.

Rate this question:

• 15.

You can copy data or formulas

• A.

With the copy, paste and cut commands

• B.

With commands on a shortcut

• C.

• D.

All of the above

D. All of the above
Explanation
The correct answer is "All of the above" because all the options mentioned (copy, paste, cut commands; commands on a shortcut; buttons on the Quick access toolbar) allow you to copy data or formulas in Excel. These options provide different ways to perform the same action, giving users flexibility and convenience in their workflow.

Rate this question:

• 16.

The LEN function does what?

• A.

Compares the content in two cells

• B.

Counts the numbers of characters in a cell

• C.

Deletes extra space in text

• D.

All of above

B. Counts the numbers of characters in a cell
Explanation
The LEN function is used to count the number of characters in a cell. It returns the total count of characters including letters, numbers, symbols, and spaces. It is commonly used in Excel to determine the length of a text string or to check if a cell contains a certain number of characters.

Rate this question:

• 17.

To move to previous sheet we need to use shortcut

• A.

CTRL + A

• B.

CTRL + PGUP

• C.

CTRL + PGDOWN

• D.

CTRL + HOME

B. CTRL + PGUP
Explanation
To move to the previous sheet in a spreadsheet, the correct shortcut is CTRL + PGUP. This combination of keys allows the user to navigate to the sheet that comes before the current one.

Rate this question:

• 18.

A value used in a formula that does not change is called a

• A.

• B.

Constant

• C.

Function

• D.

Range

B. Constant
Explanation
A constant is a value used in a formula that does not change. It remains fixed throughout the calculation process. Unlike variables, constants do not vary or fluctuate. They provide a fixed value for the formula to use in calculations. In this context, a cell address, function, or range does not accurately describe a value that does not change. Therefore, the correct answer is constant.

Rate this question:

• 19.

Weight refers to

• A.

The print density of characters

• B.

The height of the printed character

• C.

Upright or slanted shape

• D.

The design and appearance of characters

A. The print density of characters
Explanation
Weight refers to the print density of characters. It refers to how dark or light the characters appear on the printed page. A higher weight indicates a darker, more solid print, while a lower weight indicates a lighter, more transparent print. The weight of characters can affect readability and the overall visual impact of the printed material.

Rate this question:

• 20.

Can we hide a sheet????

• A.

True

• B.

False

A. True
Explanation
Yes, it is possible to hide a sheet in various spreadsheet software such as Microsoft Excel or Google Sheets. This feature allows users to hide certain sheets from view, making them invisible to anyone accessing the spreadsheet. This can be useful for organizing and managing data, especially when there are multiple sheets within a single spreadsheet.

Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

• Current Version
• Mar 22, 2023
Quiz Edited by
ProProfs Editorial Team
• Apr 18, 2013
Quiz Created by
Pavan86

Related Topics