MS Word and MS Excel

Word formatting, mail merge and track changes; Excel cells, references, formulas, functions such as SUM, IF, VLOOKUP and COUNTIF, pivot tables and keyboard shortcuts.

3 topics, 15 practice questions

1. MS Word: Formatting, Mail Merge and Track ChangesBasic

   Ribbon tabs and where each feature lives, the mail merge process, track changes and comments, page and section breaks, and the shortcuts most often asked in exams.

2. MS Excel Basics: Cells, References and FormulasBasic

   Workbooks and worksheets, row and column limits, file types, relative and absolute references, operator precedence, error values and the shortcuts asked most often.

3. MS Excel Functions and Pivot TablesBasic

   SUM, AVERAGE, COUNT, COUNTIF, SUMIF, IF, VLOOKUP and XLOOKUP with their exact syntax, plus pivot tables and the data tools used in office work.

Take the chapter test Up to 25 random questions from this chapter.