# Nc Computer Skills Quiz-spreedsheets

19 Questions | Total Attempts: 910  Settings  NC Computer Skills Quiz-Spreedsheets

• 1.
The most useful functions of a spreadsheet are:
• A.

Lines and pictures

• B.

Fonts and borders

• C.

Formulas and graphs

• D.

Labels and envelopes

• 2.
Mathematical calculations in a spreadsheet are called
• A.

Words

• B.

Labels

• C.

Formulas

• D.

Values

• 3.
Your math teacher has asked you to create a chart comparing candy sales for the last 3 years. Which chart will best display your data?
• A.

Pie chart

• B.

Bar chart

• C.

Scattergram

• D.

Line graph

• 4.
Which of the following is an example of an addition formula?
• A.

=B4+D7

• B.

2+3+6=11

• C.

F3*G7

• D.

B9/B6

• 5.
Which of the following is an example of a subtraction formula?
• A.

A-B

• B.

=C10-B9

• C.

\$14.00-\$5.00=\$9.00

• D.

B9/B6

• 6.
Which of the following is an example of a multiplication formula?
• A.

=L3*C7

• B.

B2+B3/C4

• C.

B4 X B6

• D.

46 X 39

• 7.
Which type of chart best illustrates values as part of a whole picture?
• A.

Line graph

• B.

Scattergram

• C.

Bar chart

• D.

Pie chart

• 8.
All of the following tasks can be completed using a spreadsheet, except:
• A.

Create a graph comparing class attendance rate

• B.

Create a brochure for the band camp

• C.

Track batting averages for the softball team

• D.

Keep track of field trip payments for the class trip

• 9.
What is the relationship between spreadsheets and graphs?
• A.

There isn’t one

• B.

• C.

Graphs generate formulas

• D.

• 10.
The numbers in a spreadsheet from cell A1:A49 show candy bar sales last year. How can you find the total number of candy bars sold?
• A.

Add the numbers in cell A1 and A49 together

• B.

Subtract the number in cell A49 from cell A1

• C.

Multiply cell A1 by cell A49

• D.

Add the range of numbers from A1 through A49

• 11.
A space near the top of the spreadsheet where the formulas or other information in the active cell can be viewed is called the:
• A.

• B.

Title bar

• C.

Formula bar

• D.

Active cell

• 12.
Which of the following is an example of a questions that can be answer by a spreadsheet?
• A.

Where?

• B.

Why?

• C.

What if?

• D.

When?

• 13.
A spreadsheet is a tool that allows you to:
• A.

Manipulate data with numbers and text

• B.

View and manipulate text

• C.

Manipulate graphics

• D.

Make nice banners and posters

• 14.
How could the total cost of food sold in the cafeteria for one day be calculated?
• A.

• B.

• C.

• D.

• 15.
If 189 more hamburgers were sold, which cell would change?
• A.

A3 and A5

• B.

A4 and B4

• C.

A3 and D3

• D.

B3 and C3

• 16.
What does COST/UNIT mean?
• A.

Quantity multiplied by Total Cost

• B.

• C.

Cost of one single item

• D.

Quantity multiplied by Item

• 17.
Which of the following best describes the places where the costs in Column C are entered?
• A.

Fields

• B.

Values

• C.

Formulas

• D.

Cells

• 18.
Which column contains data generated by formulas?
• A.

Column A

• B.

Column B

• C.

Column D

• D.

Column 6

• 19.
If you wanted to predict how many fries would have to be sold for the TOTAL COST of fries to be equal to \$200.00, which cell would you change the value until the desired was reached?
• A.

A6

• B.

B6

• C.

C6

• D.

D6

Related Topics Back to top