wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

BCIM I Spring Review

Total questions: 65

Worksheet time: 33mins

Name
Class
Date
1.

Excel would NOT be used to accomplish which one of the following activities?

a)

create charts

b)

perform what-if analysis

c)

word processing

2.

The document you produce when you use Excel is a

a)

database

b)

worksheet

c)

slide show presentation

3.

The intersection of a row and a column is called a

a)

title

b)

cell

c)

formula

d)

tab

4.

A cell can contain

a)

numbers

b)

text

c)

formulas

d)

all - numbers, text, and formulas

5.

The area of the worksheet window that contains the menus from which you choose Excel commands is called the

a)

name box

b)

ribbon

c)

formula bar

6.

The area of the worksheet window that displays the active cell address is called the

a)

name box

b)

formula bar

c)

main menu bar

7.

Excel groups worksheets together and calls them a

a)

binder

b)

workbook

c)

notebook

8.

The cell address is identified by

a)

its sheet tab

b)

its location on the stutus bar

c)

the coordinates of the intersecting column and row

9.

The cell you are working in or the one that has the green line around it is called

a)

active cell

b)

status cell

c)

menu cell

10.

Cells contain all of the following EXCEPT

a)

text

b)

numbers

c)

online help

11.

In Excel to make a sheet tab active select it. More than one sheet can be active at a time.

a)

true

b)

false

12.

Which of the following is NOT an example of an Excel cell address?

a)

A45

b)

C6

c)

23B

13.

The name box is located

a)

To the left of the formula bar

b)

To the right of the formula bar

c)

At the bottom of the document

14.

Using the arrow keys is one way to

a)

re-position a cell

b)

navigate (get around) in a worksheet

c)

edit worksheet data

15.

Which of the following methods can be used to navigate a worksheet?

a)

Click the desired cell address

b)

Type the address location in the name box and press enter

c)

Press the arrow keys until the desired cell is active.

d)

All of the answers

16.

In Print Preview, you can make the image of a page larger by clicking the

a)

sheet display

b)

zoom button

c)

setup

17.

Information gathered for a worksheet is sometimes referred to as

a)

input

b)

output

18.

When you type a formula in Excel you can see the formula in the

a)

name box

b)

formula bar

c)

tabs

19.

To change information or make corrections in a cell without double clicking in the cell use the ______________________,

a)

name box

b)

formula bar

c)

tabs

20.

Before entering data into a worksheet, determine its

a)

purpose

b)

results

c)

output

21.

To select a range of cells, click the first cell and _______ to the last cell you want to include.

a)

paste

b)

drag

c)

copy

22.

B6:C6 is an example of an

a)

label

b)

insertion point

c)

range

23.

Excel recognizes the entry, =B4/B2*C4, as a

a)

label

b)

value

c)

formula

24.

All Excel formulas begin with ________.

a)

*

b)

/

c)

=

25.

The correct formula to multiply cell D5 by cell B2 is

a)

B2*D5

b)

=D5*B2

c)

D5*B2

26.

SUM and AVERAGE are examples of

a)

buttons

b)

toggles

c)

functions

27.

$A$1 is an example of a(n)

a)

formula

b)

absolute cell reference

c)

calculation

28.

To move from one worksheet to another, click the desired sheet ______ at the bottom of the worksheet window. It is called a ________.

a)

file

b)

tab

c)

marker

29.

If you click the $ in Excel it will put that number in which style

a)

accounting

b)

Dollar sign

c)

decimal

30.

There is an icon that can be pushed to increase the number of decimal places that show on a number.

a)

True

b)

False

31.

To add color inside a cell click this icon

a)

dollar sign

b)

paint can

c)

A

32.

A font is the name given to a collection of

a)

letter

b)

numerals

c)

symbols and punctuation marks

d)

all of the above

33.

The fill color button is used to

a)

copy a cell format

b)

copy cell contents

c)

apply a color to a cell's background

34.

To rename a tab in Excel at the bottom of the worksheet

a)

double click and type in the tab

b)

right click in the tab and choose rename

c)

both a or b

35.

To change the width of column A using the mouse, be sure to position the mouse pointer

a)

in the center of column A

b)

so that column A is highlighted

c)

on the border between columns A and B

36.

To delete a row from a worksheet, click the row selector button, _____________and choose delete

a)

left click

b)

right click

c)

double click

37.

Which of the following can you insert or delete from your worksheet?

a)

rows

b)

columns

c)

both a and b

38.

A (n) ________ is a complete set of data in Access. It contains information about one item or person.

a)

report

b)

record

c)

table

39.

In Access an organized collection of information about a subject is called a

a)

report

b)

table

c)

database

40.

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 ____________.

a)

Query

b)

Table

c)

Report

41.

__________ view in Access displays the table in a column and row format similar to a spreadsheet.

a)

Design view

b)

Datasheet view

c)

Form view

42.

Formatted information form an Access Table or Query that can be sent to a printer to give to someone is a

a)

Table

b)

Query

c)

Report

43.

_________________ is a computerized filing system of related information organized into separate tables.

a)

Excel spreadsheet

b)

Word document

c)

Access Database

44.

This term refers to the type of field in Access: numeric, text, dates, currency, etc.

a)

Data Type

b)

Field Size

c)

Field Name

45.

________________ is a name in Access given to each field in a database.

a)

field property

b)

datatype name

c)

field name

46.

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?

a)

Default value

b)

Format

c)

Input Mask

47.

This type of order will sort names and numbers from A-Z or lowest to highest.

a)

descending

b)

ascending

c)

sort

48.

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.

a)

Query Wizard

b)

Table Wizard

c)

Report Wizard

49.

You need a computer to have a database.

a)

True

b)

False

50.

In Access to run a query click on the ! icon.

a)

True

b)

False

51.

Use this data type in Access when Short Text is not large enough.

a)

Date/time

b)

Number

c)

Long Text

d)

Hyperlink

52.

In Access this datatype includes various forms of numerical data that can be used in calculations

a)

Date/Time

b)

Number

c)

Memo

53.

In Access the Date and time entries us what data type?

a)

Date/Time

b)

Number

c)

Memo

d)

Hyperlink

54.

In Acces use this for money values with up to four digits after the decimal.

a)

Number

b)

Currency

c)

Hyperlink

55.

In Access this datatype is used to creat an identification number for each record:

a)

Date/time

b)

Number

c)

Auto Number

56.

This datatype in Access allows you to insert a Web address:

a)

Date/time

b)

Number

c)

Hyperlink

57.

Brief document which highlights an individual's experience, qualifications, and skills, in the hopes of securing a job interview is a

a)

personal business letter

b)

resume

c)

memo

58.

Individuals who can attest to your work ethic, academic performance, skills and abilities

a)

friends

b)

parents

c)

references

59.

What is cloud computing replacing?

a)

expensive personal computer hardware

b)

expensive software upgrades

c)

all of the above

60.

Google docs is a type of cloud computing.

a)

T

b)

F

61.

An internet connection is needed for cloud computing.

a)

True

b)

False

62.

A cloud storage service that allows you to store your documents, photos, videos, and more online. You can also create and edit various documents.

a)

Google Drive

b)

Google Docs

c)

Google Cloud

63.

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.

a)

True

b)

False

64.

Google Docs makes it easy to collaborate on homework assignments outside of the classroom.

a)

True

b)

False

65.

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.

a)

True

b)

False