Enter Title

A

5

(Fill in the blank)

The I & T in "IT subject" stands for __________. 

Information Technology

10

(Fill in the blank)

In Excel, the formula =TODAY() returns the current __________. 

Date 

15

A wrong formula in Excel will often show which error?
A) #REF!
B) #NAME?
C) #VALUE!

B) #NAME?

20

To count cells that are greater than 50 and less than 100, which function is best?
A) COUNTIFS
B) COUNTIF
C) COUNTA

A) COUNTIFS

B

5

True or False: 

A Pivot Table can summarize large amounts of data faster than normal tables.

True 

10

Which part of a computer is considered the "brain"?
A) Keyboard
B) Monitor
C) CPU 

C) CPU

15

To find the position of a value in a list, which function is used?
A) MATCH
B) INDEX
C) VLOOKUP

A) MATCH 

20

The formula =VLOOKUP(101, A2:C100, 4, FALSE) will result in an error because:
A) There are 3 columns instead of 4
B) The lookup value is not correct 
C) FALSE should be TRUE instead

A) There are 3 columns instead of 4

C

5

Which Excel function counts cells that meet one condition?
A) COUNTIF
B) COUNTIFS
C) COUNTALL

A) COUNTIF

10

True or False: A Pivot Chart can be only based on Pivot Table.

False, it can be used for normal tables 

15

In Excel, the formula =IF(A1>=80,"Pass","Fail") is a:
A) Nested IF
B) Simple IF
C) Logical IF

B) Simple IF

20

True or False: Action buttons in PowerPoint can only navigate to the first or last slide, not to a specific slide number.

False 

D

5

A Slicer in Excel is used to:
A) Filter data in a Pivot Table
B) Sort numbers from high to low
C) Merge two cells together

A) Filter data in a Pivot Table

10

True or False: Transitions in PowerPoint control how text appears inside a slide.

False

15

Which button in PowerPoint allows you to go to the next slide without clicking the mouse?
A) Action button
B) Bold button
C) Font size button

A) Action button

20

If you use SUM instead of COUNTIF to count text, the result will be:
A) Zero
B) The number of text entries
C) An error

A) Zero

E

5

Which keyboard shortcut opens the Save As dialog?
A) Ctrl + S
B) F12
C) Ctrl + O

A) Ctrl + S

10

You sent an email to this address:[e-mail]

and it doesn't get delivered to the recipient, why? 

Gmail is spelled wrong 

15

An INDEX MATCH formula requires how many closing parentheses at the end? 

A. 1

B. 2 

C. 3

B. 2

20

In PowerPoint, a hyperlink to a specific slide in the same presentation is lost if you:
A) Reorder the slides after creating the link
B) Change the slide background color
C) Apply a new transition to that slide

A) Reorder the slides after creating the link