computer exam

Lucy wants to use a function to add the numbers in Cells A1 through A10. How should she enter the function in the formula bar?

Sum(A1:A10)

One big advantage of spreadsheet software is that when a number is changed in the spreadsheet, all related "answers" are automatically recalculated.

True

The cut and copy features in spreadsheet software work much the same as the cut and copy features in word processing software.

True

What does it mean to "balance" columns on a page?

Make columns the same size, evenly space them

All functions are formulas.

True

True/false? In a worksheet, rows run vertically and are labeled with a letter; columns run horizontally and are labeled with a number.

False

True/false? Underlining and ALL CAPS can make words harder to read in a newsletter.

False

True/false? You should never justify text in documents like newsletters.

False

When text is entered in a worksheet cell, it is right-aligned.

False

Excel has built-in or pre-designed formulas called functions.

True

Gridlines and roe/column heading may or may not be printed on a spreadsheet.

True

True/false? If you format a document using two newspaper-style columns, the two columns are usually of equal width, but the software allows you to make them of different widths if you choose.

True

When you use the Clear command to clear the contents of a cell, the surrounding celles are shifted to replace the deleted cell.

True

What size font should you use for most of the text in a desktop publishing document?

12

Wrap text is used to _______________.

Allow information to stack on top of each other in a cell.

Merge Cells is used to ______________________.

Combine cells

All formulas are functions.

False

By default, number that are keyed into a worksheet are displayed in the number format.

False

The notes section of PowerPoint is used to _________________.

Guide the slide/help presenter know what to say

The application and current worksheet name are displayed in the _____________________.

Title bar

Changing how a slide appears in a presentation is?

Transition

Microsoft PowerPoint is used as a _______________.

Visual aid

A group of related worksheets form a file called a _______________.

Workbook

Enhancing a presentation with specific types of ____________ can make a presentation more visually appealing. a.) Animation b.) Timing c.) Hyperlinks d.) Notes

a.) Animation

A design template is ___________________. a.) Predesigned layout b.) Chart c.) Table d.) Animation

a.) Predesigned layout

Graphics in a desktop publishing document a.) Should be placed near the text they enhance. b.) should never be in color. c.) should be made as large as possible to enhance their impact. d.) should rarely be used.

a.) Should be placed near the text they enhance.

Which of the following is NOT a type of graph? a.) Pie b.) Area c.) Object d.) Bar

b.) Area

Which of the following best describes the general number format? a.) displays numbers with $, two default decimal places, and comma separators b.) displays numbers as keyed c.) displays numbers with a fixed number of decimal places d.) multiples number keyed by 100 and displays number and two default decimal places with percent sign

b.) displays numbers as keyed

Which of the following statements about flyers is NOT true? a.) It is perfectly acceptable to use more than one color on a flyer. b.) Flyers usually consist of only one page. c.) Good design principles discourage the use of word art and shaded text in flyers. d.) It is OK to use ALL CAPS for some elements of a flyer.

c.) Good design principles discourage the use of word art and shaded text in flyers.

Which of the following statements about side margins in a desktop publishing document is NOT true? a.) Long lines tend to tire the eye quickly. b.) Short lines cause the eye to jump back and forth too often. c.) Use margins of 2" to 3". d.) The use of a few long or short lines is generally acceptable.

c.) Use margins of 2" to 3".

Which of the following type of chart always appears as an object within a worksheet? a.) pie chart b.) chart sheet c.) embedded chart d.) both b and c, but not a

c.) embedded chart

The normal order of the IB Design cycle is ______.

process of inquiring and analyzing, developing ideas, creating the solution, and evaluating

A hyperlink is used to ______________. a.) Stop a presentation b.) Begin a presentation c.) Take you to a website d.) Add animation to a visual aid

C. Take you to a website

To make the first cell in a spreadsheet active, press ______________.

Control

You can copy a range of cells, but you cannot cut a range of cells.

False

______________ should be the focal point of the presentation.

Presenter

In a worksheet, you can create or edit text in the formula bar.

True

True/false? In a newsletter, you should generally use dark shades of color for font and lighter shades of color for highlights and fills.

True

To select a range of cells, a.) highlight the cell in one corner, hold down the left mouse button, and drag to the cell in the opposite corner. b.) highlight the cell in one corner, hold down the right mouse button, and drag to the cell in the opposite corner. c.) double-click the cell in one corner with the left mouse button, then double-click the cell in the opposite corner. d.) double-click the cell in one corner with the right mouse button, then double-click the cell in the opposite corner.

a.) highlight the cell in one corner, hold down the left mouse button, and drag to the cell in the opposite corner.

Items such as shapes, pictures, and tables are used in a PowerPoint to ________________. a.) Help the audience understand the topic d.) As a visual aid c.) As a way to break things up. d.) All of the above

d.) All of the above

Which of the following can be inserted in a slide? a.) Table b.) Chart c.) Bulleted list d.) All of the above

d.) All of the above

When creating a bulleted list you should type ____________. a.) Exactly what you plan to say. b.) What you want the audience to say c.) Nothing d.) An outline of what you plan to say

d.) An outline of what you plan to say

Which one of the following is NOT part of a successful presentation? a.) Make eye contact with the audience b.) Use a variety of media in a presentation c.) Be excited about the subject matter d.) Read exactly what is on the slides to the audience

d.) Read exactly what is on the slides to the audience

Spreadsheet data that is to be used in calculations must be entered as a _______________. a.) heading b.) label c.) range d.) value

d.) value

The ___________ command deletes the contents AND formats of a cell.

delete