A page break is best described as:
a. causing a jump to the start of a new page
b. splitting text on the page into multiple columns
c. breaking the page into four equal sections
d. reducing the size of the page to half the original size
a. causing a jump to the start of a new page
100
The title "Second Form" in a cell is what type of data in a spreadsheet?
a. value
b. formula
c. label
d. function
c. label
100
Which of the following BEST describes the order of the basic operation of a computer system?
a. process, input, output
b. input, output, process
c. input, process, output
d. output, process, input
c. input, process, output
100
What output device is used to print architectural drawings?
Plotter
100
When a formula is created in a cell and the "Enter" key is pressed, the result is displayed in
a. the formula bar
b. the active cell
c. the status bar
d. the result cell
b. the active cell
200
Which best describes Insert Mode and Overtype Mode?
a. Insert mode adds typed character at the end of the document.
b. Overtype mode replaces characters, Insert mode adds characters.
c. Insert mode replaces characters, Overtype mode adds characters.
d. Overtype mode replaces characters at the start of the document.
b. Overtype mode replaces characters, Insert mode adds characters.
200
Cells in a formula that do not change when copied are using
a. cell addressing
b. relative addressing
c. absolute addressing
d. compound addressing
c. absolute addressing
200
All of the following are examples of input devices except:
a. keyboard
b. mouse
c. joystick
d. digital projector
d. digital projector
200
Finger printing, retina scans and facial recognition are all examples of what input device?
Biometric Systems
200
What do the following acronyms stand for?
USB
Ghz
CRT
*must answer all
Universal Serial Bus
Gigahertz
Cathode Ray Tubes
300
Which of the following is not considered a formatting feature?
a. undo
b. bold
c. underline
d. italics
a. undo
300
B3:D3 is best described as a:
a. cell range
b. row range
c. column range
d. cell address
a. cell range
300
Here is the specifications of a hard drive:
160GB, SATA HDD (7200 rpm)
What is the hard drive type?
a. 160GB
b. SATA
c. HDD
d. 7200 rpm
b. SATA
300
To advance rightward from on cell to the next in a table, press the _____ key.
tab
300
Besides the mouse and keyboard, name 3 other input devices.
camera
webcam
scanner
OCR
OMR
Biometric system
Barcode reader
light pen, touchpad, trackball
400
To erase a character to the right of the insertion point, press the _______ key.
delete
400
Which type of chart is best suited for spotting trends in weather patterns?
Line chart
400
What is the most common input device?
keyboard
400
You can reverse an action by clicking the
undo button
400
Which type of chart is best suited for representing parts of a whole?
Pie chart
500
Mail merge allows you to create multiple copies of two file. You need a primary (main) document and _______ to do this.
data source
500
What function is used to display the current date in a cell in Excel?
=today()
500
What do the following acronyms stand for?
HDD
rpm
SDRAM
*must answer all
Hard Disk Drive
Rotation per Minute
Synchronous Dynamic Random-Access Memory
500
In the formula =C3-(D3+E3)/F3^2, which operation is performed first?
D3+E3
500
In order to display text that appears at the top margin of every page, you use: