Office Software Tests: Excel, Word and Data Entry
Office software tests online: Excel and Microsoft Word, plus data entry — the skills employers check most often when hiring for office roles.
These tools fill the working day of accountants, managers, assistants, operators, and analysts: spreadsheets and reports, contracts and letters, records that other people rely on.
The section covers Excel, Word, and data entry, each at three levels, from everyday operations to tasks given to experienced staff. Every answer comes with an explanation, and the result is saved to your profile.
Subcategories
Tests
Bulk imports and test loads, reconciling counts and control totals, encodings and data types, splitting fields, international formats, sampling, bulk corrections, incidents, and retention of personal data.
Double entry and check digits, correcting records with history, normalizing formats, duplicates, sorting and validation lists, error rates, conflicting source values, and handling personal data.
Reading source documents, standard formats for dates, codes, and phones, common keying errors, batch control, spreadsheet input, and keeping data private at the desk.
Tracked changes and restricted editing, mail merge rules and field formats, templates and Normal, navigation and table of contents settings, section numbering, linked tables, Combine, forms, and bookmarks with REF fields.
Heading styles and an automatic table of contents, multilevel numbering, sections and orientation, tables and pictures, captions, Inspect Document, Compare, fields, and mail merge.
Text and paragraph formatting, lists, page breaks and margins, headers and page numbers, tables, and saving as PDF.
INDEX and MATCH, XLOOKUP search modes, dynamic arrays, SUMPRODUCT and date conditions, data validation and cleanup, Power Query, and reports that survive new data.
Lookups with VLOOKUP and XLOOKUP, SUMIFS and COUNTIF, text and dates, conditional formatting, Excel tables, and pivot tables.
Formulas and cell references, copying formulas, common errors, sorting and filters, basic counting functions, and picking a chart.
Закрытие месяца и реформация баланса, дата запрета изменений, поиск расхождений с банком и поставщиками, экспресс-проверка, корректировка реализации, порядок документов во времени, учётная политика, амортизация и права пользователей.
Загрузка банковских выписок и договоры в оплатах, УПД и счета-фактуры, отчёты по счетам 62 и 51, возвраты, дубли контрагентов, акт сверки, сальдо по счёту 60, проведение нескольких документов сразу и отборы в журналах.
Справочники контрагентов и номенклатуры, «Записать» и «Провести», пометка на удаление, проводки документа, оплата от покупателя, выдача наличных под отчёт, копирование документов и ОСВ.