Question 1

In Microsoft Excel, which function is used to find the average of a range of numbers?

Accepted Answer

AVERAGE

Answer

MAX

Answer

SUM

Answer

COUNT

Question 2

In Microsoft Excel, which tool would you use to visually represent data trends over time?

Accepted Answer

Chart

Answer

Filter

Answer

Conditional Formatting

Answer

Pivot Table

Question 3

In Microsoft Word, what is the purpose of using 'Headers' and 'Footers'?

Accepted Answer

To add consistent text or images at the top or bottom of every page

Answer

To insert page numbers

Answer

To change the document font

Answer

To create bullet points

Question 4

In Microsoft Excel, which function would you use to count the number of cells that contain numeric values?

Accepted Answer

COUNT

Answer

SUM

Answer

AVERAGE

Answer

MIN

Question 5

In Microsoft Word, what does the 'Alignment' feature control?

Accepted Answer

The position of text within a paragraph

Answer

The size of the text

Answer

The font style of the text

Answer

The color of the text

Question 6

In Microsoft Excel, what does the 'IF' function do?

Accepted Answer

Performs a logical test and returns one value for true and another for false

Answer

Finds duplicates in a list

Answer

Sorts data in ascending order

Answer

Calculates the average of a range

Question 7

Which feature in Microsoft Excel allows you to automatically fill a series of numbers or dates?

Accepted Answer

AutoFill

Answer

Data Validation

Answer

Conditional Formatting

Answer

Chart Wizard

Question 8

In Microsoft Excel&#44; which formula would you use to find the smallest number in a range of cells?

Accepted Answer

MIN

Answer

AVERAGE

Answer

SUM

Answer

<P>LEAST</P>

Question 9

What is the primary purpose of using formulas in Excel?

Accepted Answer

To perform calculations automatically

Answer

To create tables

Answer

To insert images

Answer

To format text

Question 10

In Microsoft Excel, which symbol is used to begin a formula?

Accepted Answer

=

Answer

$

Answer

&

Answer

@

Answer

%

Question 11

What feature in Microsoft Word allows you to organize text into rows and columns?

Accepted Answer

Table

Answer

Chart

Answer

Form

Answer

List

Question 12

Which Microsoft Word feature automatically checks your spelling and grammar as you type?

Accepted Answer

Spell Check

Answer

Format Painter

Answer

Track Changes

Answer

Mail Merge

Question 13

What is the keyboard shortcut for saving a document in Microsoft Word?

Accepted Answer

Ctrl + S

Answer

Ctrl + P

Answer

Ctrl + Z

Answer

Ctrl + C

Question 14

In Excel, what is the purpose of the SUM function?

Accepted Answer

To add a range of numbers

Answer

To average a set of values

Answer

To find the maximum value

Answer

To count the number of cells

Question 15

What feature in Microsoft Word allows you to create a list of sources for your research paper?

Accepted Answer

Bibliography

Answer

Margin

Answer

Header

Answer

Footer

Question 16

What is the function of the 'Freeze Panes' feature in Excel?

Accepted Answer

To keep specific rows or columns visible while scrolling

Answer

To highlight cells with specific values

Answer

To create hyperlinks

Answer

To sum up selected cells

Question 17

What type of chart is best used for showing parts of a whole?

Accepted Answer

Pie Chart

Answer

Scatter Plot

Answer

Line Chart

Answer

Bar Chart

Question 18

What tool would you use in Excel to remove duplicate entries in a dataset?

Accepted Answer

Remove Duplicates

Answer

Text to Columns

Answer

Sort

Answer

Filter

Question 19

Which formula is used to find the maximum value in a range of cells in Microsoft Excel?

Accepted Answer

MAX

Answer

MIN

Answer

SUM

Answer

AVERAGE

Question 20

What option in Microsoft Word allows you to change the overall appearance and style of your document?

Accepted Answer

Themes

Answer

Line Spacing

Answer

Font Size

Answer

Margins

Related quizzes

Related quizzes