Tester - CAD Training Centre

7 Sep	Excel Basic	10 ccd
8 Sep	Excel Intermediate	10 ccd
9 Sep	Excel Advanced	10 ccd
		wow

Excel Advanced Quiz

This is the final quiz in our level test set

Test your expertise with our advanced level quiz.

1 / 10

If you want to fix a cell reference, you will use –

d) %

b) !

a) $

c) *

2 / 10

The Not Equal operator in Excel is –

b)

d) ||

c) !=

a) =!

3 / 10

Which Excel function can perform both vertical and horizontal lookups, allowing you to search for a value in both rows and columns simultaneously?

c) HLOOKUP

a) VLOOKUP

d) INDEX

b) XLOOKUP

4 / 10

What are the benefits of using a pivot table?

c) Pivot tables allow you to store data in a table format quickly and easily.

a) Pivot tables allow you to summarize and analyze data quickly and easily.

d) All of the above.

b) Pivot tables allow you to create charts and graphs from data quickly and easily.

5 / 10

What does the "What-If Analysis" feature in Excel allow you to do?

a) Create custom formulas and functions

b) Perform statistical analysis on data sets

d) Consolidate data from multiple worksheets or workbooks

c) Analyze different scenarios by changing input values and observing the results - Answer

6 / 10

What is a pivot table?

a) A pivot table is a data analysis tool that allows you to summarize and analyze data in a table format.

c) A pivot table is a data storage tool that allows you to store data in a table format.

d) None of the above.

b) A pivot table is a data visualization tool that allows you to create charts and graphs from data.

7 / 10

In a PivotTable, what does the "Values" area represent?

a) The rows containing unique values

d) The area where you apply filters to narrow down the data

c) The area where you drag the fields you want to analyze or summarize

b) The columns containing unique values

8 / 10

How can you update the source data range for an existing PivotTable?

a) By deleting the existing PivotTable and creating a new one

d) By applying a different PivotTable style

c) By refreshing the PivotTable data

b) By manually editing the data range in the PivotTable settings

9 / 10

How do you create a pivot table?

c) Drag and drop the fields that you want to analyze into the appropriate areas of the pivot table.

d) All of the above.

a) Click on the "PivotTable" button in the "Insert" tab.

b) Select the data that you want to analyze and click on the "PivotTable" button in the "Data" tab.

10 / 10

What is the difference between VLOOKUP and HLOOKUP?

a) VLOOKUP looks up a value in a column, while HLOOKUP looks up a value in a row.

c) VLOOKUP can be used to look up a value in a table or range of cells, while HLOOKUP can only be used to look up a value in a table.

b) VLOOKUP returns the value of the first cell found that matches the search criteria, while HLOOKUP returns the value of the last cell found that matches the search criteria.

d) Both A and B.

Hey there, Thank you for completing the quiz, Please input your Name(optional) and email address and your results will be sent to you shortly.

Thank you