QUESTIONS AND ACCURATE DETAILED ANSWERS \VERIFIED
SOLUTIONS ALREADY GRADED A+
1. Which of the following is c. Bullets
not a major part of Excel?
The ___box displays the active a. Name
cell
reference.
Excel opens a new workbook with c. 3
____________ worksheets
4. A ____ is the basic unit of a a. cell
worksheet into which you
enter data.
5. The ___ button allows you b. Auto Fill Options
to
choose whether you want
to copy the values from
the source area to the
destination area with
formatting, without
formatting, or copy only the
format.
6. The ___ Format causes the Accounting Number
cells to
display with two decimal
places so that decimal places
in cells below align
vertically
7. If the following arithmetic a. +
operations all are found in a
formula with no parentheses,
which one is completed
last?
8. To alert Excel that you b. equal sign (=)
are entering a formula and
,not text, type a(n)
____________ preceding
the formula.
9. When you copy a a. the row references change in the formula
formula with relative cell
references down a row,
____________________ _.
10. A blank cell has the b. zero
numeric value of
________.
11. The ___ function is used to d. MIN
determine the lowest number
in a given range.
12. To assign a dollar sign to b. floating dollar sign
appear
immediately to the left of
the first digit with no
spaces, use a _ _.
13. When Excel automatically c. best fit
sets the width of a column
based on the widest entry
in the column, it is called
_________________ _.
1. Microsoft Office a. presentation graphics
PowerPoint 2007 is a
complete program.
2 __are used to position the a. Layouts
content on a
slide.
3. A _ is located at the end of c. scroll arrow
each scroll
bar.
4. The is the control center in c. Ribbon
PowerPoint
5. A _ allows you to select a c. Key Tip
command
using the keyboard.
, 6. Use the to display different a. vertical scroll bar
slides in
the document window
allows you to point to a b. Live preview
gallery choice and see its
effect in the document.
8 __are designs that may . Background styles
include color,
shading, patterns and texture
add pattern and texture to a Fill effects
background.
10 _ specifies the a. Layout
arrangement of
placeholders on the slide.
11. Using the , you can choose Layout gallery
a slide
layout.
12. A single media file is b. clip
referred to as a
_____.
13. Clips that reside on the c. Web Collections
Microsoft
Website are considered to be
in the _________________ _.
Computer entails having a) literacy
knowledge
and understanding of
computers and their uses.
2. A computer contains many d) hardware
electric,
electronic, and mechanical
components known as
____.
. consist(s) of a computer's a) Memory
electronic
components that store
instructions waiting to be
executed and data needed
by those instructions.
A computer keeps data, b) storage