Here is an interesting quiz about 'Excel Intermediate 2013' that is designed to test your knowledge of this subject. Do you have a good understanding of Excel Intermediate 2013? If your answer is yes, then you must take this quiz and see how well you can score. Sounds fun, right? So, let's start the quiz then! We wish you all the best and hope that you'll find this quiz interesting.
=SUM(Sheet1!A1,A2,A3)
=SUM(Sheet2!C2-Sheet2!D3)
=SUM(Sheet3!$A:$A)
=SUM(Sheet1:Sheet2!A1)
They can simplify the process of finding a particular range of cells.
They can simplify the process of referencing cell ranges in formulas.
They can simplify the process of data entry within a cell range.
They can resolve the problem of circular cell address referencing in formulas.
Underscore (_)
Hyphen (-)
Space ( )
Period (.)
It allows you to apply preset styles to selected cells.
It allows you to convert selected cells into a table while also applying a selected table format.
It allows you to apply formatting based on cell values in a table.
It allows you to convert selected cells into a PivotTable and then apply PivotTable formatting.
Top/Bottom Rules
Highlight Cell Rules
Cell Ranges
Data Bars
It allows you to paste special characters, such as the trademark symbol, into a worksheet.
It allows you to copy data from a Microsoft Word table and paste it into Excel worksheet.
It allows you to copy cells and then paste only selected elements into a new location.
It allows you to paste links between Microsoft Access and Microsoft Excel into a workbook.
All
Comments
Formats
Characters
Charts
Pictures
Macros
Named Ranges
Share workbook and allow changes by other users.
Allow changes by more than one user at a time. This also allows workbook merging.
Allow reviewing and commentary by other users.
Share workbook and allow user review.
Auditing allows you to trace relationships between worksheets.
Auditing allows you to trace formula references between cells.
Auditing allows you to spot financial errors in workbooks.
Auditing allows you to trace relationships between workbooks.
It allows you to see changing values in cells that you cannot actively view within the worksheet.
It allows you to check if cell references being displayed by auditing arrows that point to external workbooks are correct and valid.
It allows you restrict the range of values that can be entered into selected cells in a worksheet.
It allows you to validate that the functions used by formulas in Excel are backward-compatible with previous versions of Excel.
Outlining allows you to better organize the flow of ideas in a workbook.
Outlining allows you to outline the impact of scenarios on worksheet data.
Outlining allows you to create collapsible/expandable cell groupings in a worksheet.
Outlining allows you to outline the cell dependency references in a worksheet.
Data consolidation allows you to perform a mathematical calculation on data gathered frommultiple worksheets and/or workbooks.
Data consolidation allows you to create a consolidated workbook by performing a selected function upon all worksheets in the workbook.
Data consolidation allows you to perform a consolidation of data that is gathered from multiple,external Microsoft Access tables.
Data consolidation allows you to perform a mathematical calculation on data gathered from multiple, external Microsoft Word tables.
Header Row
Initial Values Row
Start Row
Footer Row
A command button
A field menu
A drop-down arrow
A subtotal
Ascending
Opposing
Reversing
Increasing
An applied sort order
A custom sort order
A list AutoFormat
A header row
Data tables allow you to change variables in a formula to view different possible outcomes.
Data tables allow you to change filters in a table to view different possible outcomes.
Data tables allow you to change scenarios in a worksheet to view different possible outcomes.
Data tables allow you to change functions in a formula to view different possible outcomes.
13
23
32
52
HLOOKUP
VLOOKUP
RLOOKUP
CLOOKUP
HLOOKUP
VLOOKUP
RLOOKUP
CLOOKUP
The “Modify Chart” tab
The “Edit Sparklines” tab
The “Sparkline Tools” contextual tab
The “Sparkline Charting” contextual tab
Chart Data
Options
Trendlines
Format
Chart AutoFormats
Chart Formatting
Chart Styles
Chart Design
Plot Area
Chart Area
Data Table
Legend
Wait!
Here's an interesting quiz for you.