Good Luck! The Express Link to Reporting via MS excel and powerpoint assessment here to start …

5 minutes

Express Link to Reporting via MS Excel and Powerpoint

1 / 20

Select the correct formula to use in order to combine the last name and the first name in this example so that the end result is what you see in cell D2.

Question Image

2 / 20

To obtain the result above, you must _________________.

Question Image

3 / 20

What function to calculate total Male in a department?

4 / 20

What function that can be used to calculate total years of service?

Question Image

5 / 20

After Previous in animation settings allow you to ______________________.

Question Image

6 / 20

This symbol appears when you key in Slide number in Slide Master Header & Footer.

Question Image

7 / 20

What result will the formula in cell B34 return?

Question Image

8 / 20

I would like to insert a flying text box and an audio to my slides, to play the audio and animations simultaneously, the animations timing setting should be:

Question Image

9 / 20

What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data changed

10 / 20

There are four types of PivotTable fields. Which of the followings is NOT part of it?

11 / 20

When a Theme is inserted in Slide Master, all following slides will have the same theme

Question Image

12 / 20

The above image refers to ________________.

Question Image

13 / 20

How to convert a Bullet List to a SmartArt?

Question Image

14 / 20

The action above (as circled) will perform Presenter View, presenter can have a full control on the presentation and review the ________________.

Question Image

15 / 20

Slide Master allows you to ___________________.

16 / 20

What function to sum a value based on 2 different criteria in a table?

17 / 20

The result of the formula in cell B6 will be _____________.

Question Image

18 / 20

Based on the picture, we can use ____________ to filter data in easier ways.

Question Image

19 / 20

To see the timing for each slide, user can go to __________________.

Question Image

20 / 20

Which function is not available in the Consolidate dialog box?