You will also receive a grade in each section (Beginning, Intermediate, and Advanced), and an overall grade and how your grade compares with the thousands of others who have taken the test. Once you finish the test, you will see a report containing feedback on your response to each question. Intermediate Excel (Using Functions and Writing Formulas): Arithmetic, Text and Comparison Operators, Concatenation, Named Ranges, Data Validation, Functions (Text, Financial, Logical, Math, Date, Statistical, Lookup).Īdvanced Excel: PivotTables, External Data Sources, Macros, Protection, Conditional Formatting, Graphs and Charts, Views.Ĭhoose the BEST answer from the available choices.
Topics in each category include the following:īeginning Excel: Print Preview, Working with Dates, General and Custom Formatting, The Format Cells Dialog Box, Subtotals, Sorting, Find and Replace, AutoFilters, Shapes. Please use the buttons provided to navigate within the test, and not the Back button on your browser. You will be prompted to print that page for your records. After you finish the exam, you will see a summary of the grade you made for each section. Note: Once you click the Finish button, you cannot go back to review the questions or change your answers. You are allowed and encouraged to toggle back and forth between this test and Excel to answer the test questions - the exam is hands-on! All questions are in a multiple choice format. We recommend you allow approximately 30 uninterrupted minutes to take the exam. Make sure you will be able to work undisturbed during the length of the exam. ExcelCEO Featured Video Free Excel Test Instructionsīefore clicking the Begin Test button, make sure the only two programs open on the computer are Excel and this Internet session.
0 kommentar(er)
