LITC01C- MS Tools-MQ1

Which of the following is NOT a feature in MS Word?

• Track Changes

• Mail Merge

• Pivot Tables

• Styles

In MS Excel, what does the function VLOOKUP do?

• Searches for a value vertically and returns a corresponding value

• Calculates the average of a range of cells

• Counts the number of cells with numbers

• Finds the maximum value in a range

Which view in PowerPoint allows you to see all your slides as thumbnails?

• Normal View

• Outline View

• Slide Sorter View

• Reading View

What is the keyboard shortcut to create a new document in MS Word?

• Ctrl + N

• Ctrl + O

• Ctrl + S

• Ctrl + W

In MS Excel, what does the '$' symbol do when used in a cell reference?

• Formats the cell as currency

• Makes the reference absolute

• Indicates a formula error

• Sums up the values in a column

Which tab in MS Word contains the 'Font' and 'Paragraph' groups?

• Home

• Insert

• Page Layout

• Review

What is the maximum number of rows in an Excel 2019 worksheet?

• 65,536

• 1,048,576

• 16,384

• 256,000

In PowerPoint, what is the term for the pre-designed slide layouts?

• Themes

• Templates

• Slide Masters

• Transitions

Which function in Excel returns the number of cells in a range that meet a given criteria?

• SUM

• COUNT

• COUNTIF

• AVERAGE

What is the purpose of the 'Backstage View' in MS Office applications?

• To change the background color of the application

• To access file management options like Open, Save, and Print

• To view hidden formatting marks

• To customize the ribbon