A
(Fill in the blank)
The I & T in "IT subject" stands for __________.
Information Technology
True or False:
A Pivot Table can summarize large amounts of data faster than normal tables.
True
Which Excel function counts cells that meet one condition?
A) COUNTIF
B) COUNTIFS
C) COUNTALL
A) COUNTIF
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
(Fill in the blank)
In Excel, the formula =TODAY() returns the current __________.
Date
Which part of a computer is considered the "brain"?
A) Keyboard
B) Monitor
C) CPU
C) CPU
True or False: A Pivot Chart can be only based on Pivot Table.
False, it can be used for normal tables
True or False: Transitions in PowerPoint control how text appears inside a slide.
False
A wrong formula in Excel will often show which error?
A) #REF!
B) #NAME?
C) #VALUE!
B) #NAME?
To find the position of a value in a list, which function is used?
A) MATCH
B) INDEX
C) VLOOKUP
A) MATCH
In Excel, the formula =IF(A1>=80,"Pass","Fail") is a:
A) Nested IF
B) Simple IF
C) Logical IF
B) Simple IF
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
To count cells that are greater than 50 and less than 100, which function is best?
A) COUNTIFS
B) COUNTIF
C) COUNTA
A) COUNTIFS
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
True or False: Action buttons in PowerPoint can only navigate to the first or last slide, not to a specific slide number.
False
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