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