Question

What is the Function Builder in Excel used for?


To create custom functions in Visual Basic for Applications (VBA)


To analyse and interpret data in a range of cells


To guide users in constructing complex formulas step-by-step


To automatically generate charts and graphs based on data inputs

Answer 1

To guide users in constructing complex formulas step-by-step

Answer 2

Which is NOT a way to edit a formula in a cell?


Right-click the cell and select Edit.


Double-click the cell 


Select the cell and then click in the formula bar


Press F2

Answer 3

Right-click the cell and select Edit.

Answer 4

What is a theme in Microsoft Word?


A feature that enables real-time collaboration with others on a document.


A function that allows you to track changes made to a document.


A collection of styles that can be applied to specific document elements.


A pre-designed set of formatting options for an entire document

Answer 5

A pre-designed set of formatting options for an entire document

Answer 6

Read the following statement and indicate whether it is true or false:

When you insert a Watermark, it appears on all the pages in your document.

True

False

Answer 7

True

Answer 8

What are Quick Parts in Microsoft Word?


Predefined text and graphics that can be inserted into a document.


Templates used for creating professional resumes.


An advanced feature for creating complex formulas in Word documents.


Keyboard shortcuts for commonly used commands in Word.

Answer 9

Predefined text and graphics that can be inserted into a document.