Information Technology Test

Which of the following calculates the total from the adjacent cell through the first nonnumeric
cell by default, using the SUM function in its formula?

Which of the following can you not copy using Format Painter?

The degree to which a statistical model represents the data collected is known as the ______.?

The basic unit of a worksheet into which you enter data in Excel is called a _________.?

The Name box on to the left of formula bar.?

When items on a questionnaire appear to correspond to the construct that the questionnaire
claims to measure it is said to have __________________.?

Which of the following can you drag or double-click to change the width of a column?

A person who designs the programs in a software package is called _________.?

Which feature enables you to preview headers and footers, page breaks, and other features that
will print?

Components that provide internal storage to the CPU are ____________.?

Do this to display the contents of a certain drive or folder:?

The hardware device commonly referred to as the ‘brain’ of the computer is the ______.?

When you split a window, the window is divided into how many panes?

Which unit is responsible for converting the data received from the user into computer
understandable format?

____________ is the functional key to display save as box.?

Which type of graph can we use to compare frequency distributions of several groups
simultaneously?

Which of the following commands is used to insert a cell into a worksheet?

Formula in Excel start with ___________.?

Variation due to some genuine effect is known as _____________.?

Which of the following statements accurately describes the default selection for AutoSum?

__________ are often delivered to a PC through an e-mail attachment and are often designed to
do harm.?

An experimenter measured 30 children’s IQ. He then rank-ordered the children and assigned
them a score from 30 (most intelligent) to 1 (least intelligent) to create a new variable. Does this new
variable consist of _____________.?

Which of the following methods will not enter data in a cell?

The two basic types of memory in a computer are ___________________.?

Shortcut key to open pre-made Presentation is ____________.?

A Button you can click to take you to a different slide, a file, a website, sound, etc. is called
____.?

An Excel file is generally called a/an __________.?

The COUNT and MIN functions are examples of which category of functions?

___________ is the key we use to run the selected command.?

Which of the following starts off with Save, Undo, and Redo and can be customized to contain
the commands you use most frequently?

If we calculated an effect size and found it was r = .42 which expression would best describe
the size of effect?

Which part of the computer is used for calculating and comparing?

When you type a document on a computer, every letter you type is saved to the computer’s
___________ or temporary storage area.?

CPU is an abbreviation for _________.?

Smaller and less expensive PC-based servers are replacing ____________ in many businesses.?

Which of the following is not an arithmetic operator?

To generate a Spearman’s rho test, which set of instructions should you give SPSS?

The ‘heart’ of the processor which performs many different operations___________.?

“CTR+Down Arrow” is used to ______________________________.?

You want to calculate the number of nonblank cells in your worksheet. Which function should
be used?

Which command would you use to save a document for the first time?

What is the shortcut key for “Spelling Check” in document?

When all the numbers between 0 and 100 in a range should be displayed in Red color, apply
___________.?

What do you call a program in execution?

Which of the following contains the commands you use most often, such as Save, Undo, and
Repeat?

A _____________ is a collection of design choices that includes colors, fonts, and special
effects.?

In word processing, an efficient way to move the 3rd paragraph to place it after the 5th
paragraph is _________.?

____________ is not the view of Power Point.?

If you want to use a workbook in another kind of document, you have the option to save using
which of the following?

The ALU gives the output of the operations and the output is stored in the ___________.?

RAM stands for ___________.?

They normally interact with the system via user interface provided by the application software.?

How would you print a bar chart that you have just produced in SPSS?

You want to calculate the number of blank cells in your worksheet. Which function should be
used?

Which of the following is designed to control the operations of a computer?

WWW means __________.?

Which function in Excel checks whether a condition is true or not?

Which would you choose to move selected text from one place to another?

Ordinal level data are characterized by ___________.?

A desktop computer is also known as a ___________.?