NEW
Font size
WorksheetsBCIM I Spring Review
Total questions: 65
Worksheet time: 33mins
Excel would NOT be used to accomplish which one of the following activities?
create charts
perform what-if analysis
word processing
The document you produce when you use Excel is a
database
worksheet
slide show presentation
The intersection of a row and a column is called a
title
cell
formula
tab
A cell can contain
numbers
text
formulas
all - numbers, text, and formulas
The area of the worksheet window that contains the menus from which you choose Excel commands is called the
name box
ribbon
formula bar
The area of the worksheet window that displays the active cell address is called the
name box
formula bar
main menu bar
Excel groups worksheets together and calls them a
binder
workbook
notebook
The cell address is identified by
its sheet tab
its location on the stutus bar
the coordinates of the intersecting column and row
The cell you are working in or the one that has the green line around it is called
active cell
status cell
menu cell
Cells contain all of the following EXCEPT
text
numbers
online help
In Excel to make a sheet tab active select it. More than one sheet can be active at a time.
true
false
Which of the following is NOT an example of an Excel cell address?
A45
C6
23B
The name box is located
To the left of the formula bar
To the right of the formula bar
At the bottom of the document
Using the arrow keys is one way to
re-position a cell
navigate (get around) in a worksheet
edit worksheet data
Which of the following methods can be used to navigate a worksheet?
Click the desired cell address
Type the address location in the name box and press enter
Press the arrow keys until the desired cell is active.
All of the answers
In Print Preview, you can make the image of a page larger by clicking the
sheet display
zoom button
setup
Information gathered for a worksheet is sometimes referred to as
input
output
When you type a formula in Excel you can see the formula in the
name box
formula bar
tabs
To change information or make corrections in a cell without double clicking in the cell use the ______________________,
name box
formula bar
tabs
Before entering data into a worksheet, determine its
purpose
results
output
To select a range of cells, click the first cell and _______ to the last cell you want to include.
paste
drag
copy
B6:C6 is an example of an
label
insertion point
range
Excel recognizes the entry, =B4/B2*C4, as a
label
value
formula
All Excel formulas begin with ________.
*
/
=
The correct formula to multiply cell D5 by cell B2 is
B2*D5
=D5*B2
D5*B2
SUM and AVERAGE are examples of
buttons
toggles
functions
$A$1 is an example of a(n)
formula
absolute cell reference
calculation
To move from one worksheet to another, click the desired sheet ______ at the bottom of the worksheet window. It is called a ________.
file
tab
marker
If you click the $ in Excel it will put that number in which style
accounting
Dollar sign
decimal
There is an icon that can be pushed to increase the number of decimal places that show on a number.
True
False
To add color inside a cell click this icon
dollar sign
paint can
A
A font is the name given to a collection of
letter
numerals
symbols and punctuation marks
all of the above
The fill color button is used to
copy a cell format
copy cell contents
apply a color to a cell's background
To rename a tab in Excel at the bottom of the worksheet
double click and type in the tab
right click in the tab and choose rename
both a or b
To change the width of column A using the mouse, be sure to position the mouse pointer
in the center of column A
so that column A is highlighted
on the border between columns A and B
To delete a row from a worksheet, click the row selector button, _____________and choose delete
left click
right click
double click
Which of the following can you insert or delete from your worksheet?
rows
columns
both a and b
A (n) ________ is a complete set of data in Access. It contains information about one item or person.
report
record
table
In Access an organized collection of information about a subject is called a
report
table
database
A powerful searching tool in Access that can isolate a group of records, determine which fields to include, place fields in the correct order and save is called a ____________.
Query
Table
Report
__________ view in Access displays the table in a column and row format similar to a spreadsheet.
Design view
Datasheet view
Form view
Formatted information form an Access Table or Query that can be sent to a printer to give to someone is a
Table
Query
Report
_________________ is a computerized filing system of related information organized into separate tables.
Excel spreadsheet
Word document
Access Database
This term refers to the type of field in Access: numeric, text, dates, currency, etc.
Data Type
Field Size
Field Name
________________ is a name in Access given to each field in a database.
field property
datatype name
field name
Which of the following should you use when you have a phone number and you want the parenthesis and the dash to appear automatically in the table?
Default value
Format
Input Mask
This type of order will sort names and numbers from A-Z or lowest to highest.
descending
ascending
sort
This feature in Access will ask yo to respond to some questions, create the report, and present you with a sample report on the screen.
Query Wizard
Table Wizard
Report Wizard
You need a computer to have a database.
True
False
In Access to run a query click on the ! icon.
True
False
Use this data type in Access when Short Text is not large enough.
Date/time
Number
Long Text
Hyperlink
In Access this datatype includes various forms of numerical data that can be used in calculations
Date/Time
Number
Memo
In Access the Date and time entries us what data type?
Date/Time
Number
Memo
Hyperlink
In Acces use this for money values with up to four digits after the decimal.
Number
Currency
Hyperlink
In Access this datatype is used to creat an identification number for each record:
Date/time
Number
Auto Number
This datatype in Access allows you to insert a Web address:
Date/time
Number
Hyperlink
Brief document which highlights an individual's experience, qualifications, and skills, in the hopes of securing a job interview is a
personal business letter
resume
memo
Individuals who can attest to your work ethic, academic performance, skills and abilities
friends
parents
references
What is cloud computing replacing?
expensive personal computer hardware
expensive software upgrades
all of the above
Google docs is a type of cloud computing.
T
F
An internet connection is needed for cloud computing.
True
False
A cloud storage service that allows you to store your documents, photos, videos, and more online. You can also create and edit various documents.
Google Drive
Google Docs
Google Cloud
In cloud computing, the word cloud is used as a metaphor for "the internet." so the phrase cloud computing means "a type of Internet-based computing." where different services are delivered to computers and devices through the internet.
True
False
Google Docs makes it easy to collaborate on homework assignments outside of the classroom.
True
False
You can upload from your computer to Google Docs, Slide, Sheets and you can download from the internet to the available software on a computer.
True
False
