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