Term
Is the following an example of a formula or a function?
=A1 + B3 |
|
Definition
|
|
Term
| Which of the following formulas divides the sum of cells E9 through H9 by cell D1? |
|
Definition
|
|
Term
| With what symbol do all spreadsheet formulas begin? |
|
Definition
|
|
Term
| Which of the following formulas is equivalent to =SUM(A1:A3)? |
|
Definition
|
|
Term
| Which of the following formulas subtracts cell G2 from the sum of cells F1 through F5? |
|
Definition
| =(F1) + (F2) + (F3) + (F4) + (F5) - (G2) |
|
|
Term
| If you type "=2+6" into a spreadsheet cell, what will the cell display? |
|
Definition
|
|
Term
| Which of the following formulas calculates 45% of cell E19? |
|
Definition
|
|
Term
| Which of the following accurately describes the function of this formula: =(B1)*(C5)? |
|
Definition
| Multiplies cells B1 and C5 |
|
|
Term
| Which of the following formulas adds cells B5 through D5? |
|
Definition
|
|
Term
| Which of the following formulas multiplies cell F4 by cell G8? |
|
Definition
|
|
Term
| If you type "5+8=" into a spreadsheet cell, what will the cell display? |
|
Definition
|
|
Term
| Which of the following formulas subtracts 15 from 80% of cell G10? |
|
Definition
|
|
Term
| Which of the following formulas calculates the mean of cells E11 through E16? |
|
Definition
|
|
Term
| What is the selected cell in a worksheet called? |
|
Definition
|
|
Term
| To insert an image into a spreadsheet, it must be imported from another program, such as a word processing application. |
|
Definition
|
|
Term
| In OpenOffice.org Calc, the "Borders" tab in the "Page Style" window will allow you to set borders around the cells in your spreadsheet. |
|
Definition
|
|
Term
| Information in the header of a spreadsheet is printed on the top of every page. |
|
Definition
|
|
Term
| What are boundaries of white space immediately inside the boundaries of a page? |
|
Definition
|
|
Term
| Footers are not an option in most spreadsheet software programs. |
|
Definition
|
|
Term
| How many margins does a page contain? |
|
Definition
|
|
Term
| What is standard paper called? |
|
Definition
|
|
Term
| Which of the following let’s you decide what appears in the spreadsheet based on criteria that you define? |
|
Definition
|
|
Term
| What is it called when paper is turned so the longest side is the width? |
|
Definition
|
|
Term
| To format dollar amounts correctly, you have to type in the dollar sign ($) manually. |
|
Definition
|
|
Term
| When using the chart wizard in OpenOffice.org Calc, what is indicated by the data surrounded in blue? |
|
Definition
| This is the data that will be presented in the chart. |
|
|
Term
| What is the way the printed page is laid out called? |
|
Definition
|
|
Term
| What is it called when paper is turned so the longest side is the height? |
|
Definition
|
|
Term
| What are interactive tables that allow you to group and summarize information into a table that can be easily changed so you can look at the data in different ways? |
|
Definition
|
|
Term
| Which of the following determines whether the database should automatically place a value in this field if it is left blank? |
|
Definition
|
|
Term
| If you want to set the kind of data that will be inputted into a field, which of the following settings would you change? |
|
Definition
|
|
Term
| You should always delete the primary key before completing a database. |
|
Definition
|
|
Term
| What is a collection of organized data? |
|
Definition
|
|
Term
| A table is one object that you'll find in a database. |
|
Definition
|
|
Term
| Which of the following are electronic tools that store large amounts of data in one place in a systematic way? |
|
Definition
|
|
Term
| Which of the following indicates what will actually be shown in the field? |
|
Definition
|
|
Term
| Which of the following is a program that can be used to create databases? |
|
Definition
|
|
Term
| Which of the following requires the database to refuse to move to the next field unless the person entering data puts an integer here? |
|
Definition
|
|
Term
| Which of the following are uses for a database? (Choose all that apply.) |
|
Definition
| Find data, Organize data, Track data |
|
|
Term
| All spreadsheet formulas must begin with a plus sign. |
|
Definition
|
|
Term
| Tools are mechanisms that aid us physically, while technology includes mechanisms that aid us cognitively. |
|
Definition
|
|
Term
| Which of the following are presentation programs that can help you create digital presentations? (Choose all that apply.) |
|
Definition
| Microsoft PowerPoint OpenOffice Impress |
|
|
Term
| When you copy information in order to paste it in another location within a document, where is this information temporarily stored? |
|
Definition
|
|
Term
| What is the purpose of a digital presentation? |
|
Definition
| Serve as a supplement or enhancement to a person's physical lecture |
|
|
Term
| Which one of the following is the most accurate definition of technology? |
|
Definition
| Any type of tool that serves a practical function |
|
|
Term
| Emoticons are a good way to show emotion in an e-mail while remaining professional. |
|
Definition
|
|
Term
| Which one of the following describes an inappropriate use of technology? |
|
Definition
| Purposely posting inaccurate information online as the truth |
|
|
Term
| Which of the following commands will copy information, leaving it in its original location, but making it available to be pasted in another location? |
|
Definition
|
|
Term
| In 2 to 3 sentences, describe the difference between the Cut and Copy tools. |
|
Definition
| Copy will copy the text and leave the original text there. Cut will copy the text but the original text will no longer be there. |
|
|
Term
| Using word processing software is similar to using which one of the following? |
|
Definition
|
|
Term
| The e-mail address of the main recipient of an e-mail belongs in which field? |
|
Definition
|
|
Term
| The e-mail address of any third party recipient of an e-mail belongs in which field? |
|
Definition
|
|
Term
| Any tool that helps make our physical and mental processes more efficient can be referred to as which one of the following? |
|
Definition
|
|
Term
| Which one of the following is true about the subject line of an e-mail? |
|
Definition
| It should be a short phrase that describes the contents of an e-mail. |
|
|
Term
| Which of the following can spreadsheet programs help a person with? (Choose all that apply.) |
|
Definition
| Calculating Data,Organizing Data |
|
|
Term
| :O is an example of an Internet slang. |
|
Definition
|
|
Term
| Marlon needed to move the text in his opening paragraph to the closing paragraph because it would better fit in that part of his paper. Which function should Marlon use to accomplish the move? |
|
Definition
|
|
Term
| Shelby decided to make his own birthday invitations. He wanted to fit two invitations per page. Which function should Shelby use to accomplish this task? |
|
Definition
|
|
Term
| A pencil can be considered a piece of technology. |
|
Definition
|
|
Term
| Which one of the following describes an appropriate use of technology? |
|
Definition
| Sharing information with others |
|
|
Term
| In 1-2 sentences, briefly describe the main difference between the Internet and the World Wide Web. |
|
Definition
| The internet includes all of the networks and servers that we normally don't see. The World Wide Web is the part of the internet that we have access to. |
|
|
Term
| Which of the following are guidelines you should follow when designing a digital presentation? (Choose all that apply.) |
|
Definition
| Be consistent.Keep it simple. Make it readable. |
|
|
Term
| Which of the following commands will grab information, removing it from its original location and making it available to be pasted in another location? |
|
Definition
|
|
Term
| Charlie e-mailed a customer and sent a copy of it to his boss. In which field did Charlie type in his boss' e-mail address? |
|
Definition
|
|
Term
Is the following an example of a formula or a function?
=A1 + B3 |
|
Definition
|
|
Term
| Which of the following formulas divides the sum of cells E9 through H9 by cell D1? |
|
Definition
|
|
Term
| With what symbol do all spreadsheet formulas begin? |
|
Definition
|
|
Term
| Which of the following formulas is equivalent to =SUM(A1:A3)? |
|
Definition
|
|
Term
| Which of the following formulas subtracts cell G2 from the sum of cells F1 through F5? |
|
Definition
| =(F1) + (F2) + (F3) + (F4) + (F5) - (G2) |
|
|
Term
| What is animation that serves a purpose without distracting the audience? |
|
Definition
|
|
Term
| What term defines pieces of hardware that add functionality to a computer? |
|
Definition
|
|
Term
| When using the chart wizard in OpenOffice.org Calc, what is indicated by the data surrounded in blue? |
|
Definition
| This is the data that will be presented in the chart. |
|
|
Term
| If a friend of yours accesses the Internet to find out personal information about another friend of yours, and then tells you what she learned from that Internet research, what would be the most appropriate thing for you to say when given that information? |
|
Definition
| "That is most likely an inappropriate use of the Internet, so don't share that information with me or with anyone else." |
|
|
Term
| What is a single computer document called? |
|
Definition
|
|
Term
| Which of the following is a directory that can hold a collection of files? |
|
Definition
|
|
Term
| Which button reduces the active window to an icon or task bar button when clicked? |
|
Definition
|
|
Term
| Barney is sending an email to his boss to ask if he can reschedule their meeting on Friday because he has a doctor's appointment. Which one of the following would be the most appropriate subject line for him to use? |
|
Definition
| Rescheduling Friday's Meeting |
|
|
Term
| What is it called when paper is turned so the longest side is the width? |
|
Definition
|
|
Term
| Which one of the following is NOT considered to be an inappropriate use of technology? |
|
Definition
| Researching information on a new technology that might assist the company for which you work with its own research in a similar area |
|
|
Term
| Mrs. Fitzgerald is sending an e-mail to (e-mailing) to her friend to invite her to her New Year's Eve party. Which one of the following would be the most appropriate subject line for her to use? |
|
Definition
|
|
Term
| What is a paper format whose width is 8.5” and height is 11”? |
|
Definition
|
|
Term
| Which of the following is a slide that acts as a template for one or more slides in your presentation called? |
|
Definition
|
|
Term
| Miranda used the same reference several times in her research paper. Which function did she most likely use after she created the first reference? |
|
Definition
|
|
Term
| What is a paper format whose width is 11” and height is 8.5”? |
|
Definition
|
|
Term
| Karen double-clicks on a small image on her desktop which opens a folder that contains her homework files. What is the small image on which she clicked called? |
|
Definition
|
|
Term
| In a spreadsheet, what are the blank fields where rows and columns intersect? |
|
Definition
|
|
Term
| Which of the following are ways to keep a presentation simple? (Choose all that apply.) |
|
Definition
| Avoid filling the screen with information and graphics. Provide only necessary information on charts and tables. Use bulleted information rather than complete sentences. |
|
|
Term
Is the following a formula or a function?
=(5C - 8D)/2 |
|
Definition
|
|
Term
| What are interactive tables that allow you to group and summarize information into a table that can be easily changed so you can look at the data in different ways? |
|
Definition
|
|
Term
| When the user clicks on an icon, holds down the mouse button, and moves the icon across the screen, what is the user doing? |
|
Definition
|
|
Term
| What is standard paper called? |
|
Definition
|
|
Term
Is the following a formula or a function?
=A2+B2+C2 |
|
Definition
|
|
Term
| Which of the following is mostly used to manage cash flow, maintain budgets, estimate costs, and so forth? |
|
Definition
|
|
Term
Is the following a formula or a function?
=7C*13 |
|
Definition
|
|
Term
| What are the boundaries of white space immediately inside the boundaries of a page? |
|
Definition
|
|
Term
| When used as part of online communication, LOL stands for "laugh out loud." What is this an example of? |
|
Definition
|
|
Term
| Which of the following are file extensions for presentation files? (Choose all that apply.) |
|
Definition
|
|
Term
| In a presentation, how should each slide look? (Choose all that apply.) |
|
Definition
| Every slide should be the same style. The same color scheme should be used on each slide. The same transition effects should be used on each slide. |
|
|
Term
| In a spreadsheet, what would the fourth cell down in the second column be labeled? |
|
Definition
|
|
Term
| Monita wants to create a field in a database that will only allow the user to input a date. Which of the following would she want to set? |
|
Definition
|
|
Term
| When a summary slide is inserted into a presentation, where does it appear? |
|
Definition
| At the end of the presentation |
|
|
Term
| Which of the following is a template for the notes pages in a presentation called? |
|
Definition
|
|
Term
| When searching for a key word on the internet, what are you actually querying? |
|
Definition
|
|
Term
| Which of the following is an example of interactivity? |
|
Definition
| A button that links to another slide |
|
|
Term
Is the following a formula or a function?
=SUM(A2:A11) |
|
Definition
|
|
Term
Is the following a formula or a function?
=C9/C2 |
|
Definition
|
|
Term
| Navigating through a layout should require the viewer to use critical thinking skills. |
|
Definition
|
|
Term
| What is the invisible structure that serves as the foundation for a design? |
|
Definition
|
|
Term
| Dividing a composition into four quadrants enhances the layout by creating a sense of balance. |
|
Definition
|
|
Term
| Elements that are aligned to each other are often perceived as being related. |
|
Definition
|
|
Term
| Which of the following would be most appropriate to use when designing a website? |
|
Definition
|
|
Term
| People from cultures who read up and down and right to left look at designs in what shape pattern? |
|
Definition
|
|
Term
| People from cultures who read left to right look at designs in what shape pattern? |
|
Definition
|
|
Term
| When the letter strokes on regular type are adjusted and thickened, what type of font is created? |
|
Definition
|
|
Term
| When designers apply the rule of thirds, where do they place the most important elements? |
|
Definition
| At any point where the lines intersect |
|
|
Term
| Which of the following would be most appropriate to use when designing an animation? |
|
Definition
|
|
Term
| Which of the following is a slanted version of regular type? |
|
Definition
|
|
Term
| Which of the following type attributes would be good to use for paragraph text? |
|
Definition
|
|
Term
| Designers should place the most important elements in a composition at the mathematical center rather than at the visual center. |
|
Definition
|
|
Term
| Where is the visual center of a page in comparison to the mathematical center? |
|
Definition
| Slightly above and to the right |
|
|
Term
| To create a sense of balance and stability, which part of a composition should have more white space? |
|
Definition
|
|
Term
| What is the arrangement of design elements in a composition? |
|
Definition
|
|
Term
| Grid units should never be compromised; a single element should not span more than one grid unit. |
|
Definition
|
|
Term
| Which of the following is one of the first things a designer does when faced with a project? |
|
Definition
| Design a comprehensive layout |
|
|
Term
| Drew included stock photography in his comprehensive layout for the advertisement. What are these photographs called? |
|
Definition
|
|
Term
| What is another term for comprehensive layout? |
|
Definition
|
|
Term
| What is regular type with a line below it called? |
|
Definition
|
|
Term
| Which of the following would be most appropriate to use when designing a print advertisement? |
|
Definition
|
|
Term
| What is a series of images that summarizes the layouts of each frame in an interactive application? |
|
Definition
|
|
Term
|
Definition
| The ease or difficulty with which a product is used |
|
|
Term
| What is the most important thing a designer should be concerned about when designing an interface? |
|
Definition
| How the interface design affects the product's user |
|
|
Term
| Which of the following are lists of links that illustrate the hierarchy of the frames the user has visited to reach the current location within an application? |
|
Definition
|
|
Term
| Designers should be concerned with how the design of an interface will affect the use of a product. |
|
Definition
|
|
Term
| Users have to create queries when using a WYSIWYG interface. |
|
Definition
|
|
Term
| Poor interface design might cause the validity of an application's content to be questioned. |
|
Definition
|
|
Term
| Which of the following is a visual element that links a user with the tools and functionalities of a computer program? |
|
Definition
|
|
Term
| Which of the following is a motto graphic designers follow when designing the underlying structure of an application? |
|
Definition
|
|
Term
| Which of the following is an organized hierarchy of links that can take the user to any page or frame in an application? |
|
Definition
|
|
Term
| Which type of navigation is simliar to a book because users can move back and forth between frames? |
|
Definition
|
|
Term
| Which of the following is the amount of space available on a screen to display information? |
|
Definition
|
|
Term
| Which of the following is an important initial step in designing an interface? |
|
Definition
|
|
Term
| WYSIWYG-based interfaces tend to confuse users and should be avoided. |
|
Definition
|
|
Term
| Designers should take into consideration the users' technical experience when designing an interface. |
|
Definition
|
|
Term
| How many items should a menu system have? |
|
Definition
|
|
Term
| Which of the following is a way to organize information that has multiple levels? |
|
Definition
|
|
Term
| WYSIWYG interfaces offer a friendly buffer between which of the following? |
|
Definition
| Users and technical information |
|
|
Term
| Which type of navigation organizes groups of information structures into various levels? |
|
Definition
|
|
Term
| Which of the following should interfaces include to lead users where they want to go? |
|
Definition
|
|
Term
| Which of the following is a great way to save screen space when information on a site can be broken up into clearly defined categories? |
|
Definition
|
|
Term
| Which type of navigation only involves forward motion? |
|
Definition
|
|
Term
| Which of the following html tags indicates the end of a link? |
|
Definition
|
|
Term
| Which of the following html tags indicates the end of an html page? |
|
Definition
|
|
Term
| Which of the following html tags would you use to name a web page? |
|
Definition
|
|
Term
| Which of the following html tags indicates a horizontal rule? |
|
Definition
|
|
Term
| Which of the following html tags indicates a line break? |
|
Definition
|
|
Term
| Which of the following html tags would you use after a table? |
|
Definition
|
|
Term
| Which of the following html tags indicates the beginning of a line item, or item in a list? |
|
Definition
|
|
Term
| Which of the following html tags indicates the beginning of an ordered list? |
|
Definition
|
|
Term
| Which of the following html tags indicates the beginning of a new paragraph? |
|
Definition
|
|
Term
| Typing text into a web page using Nvu is similar to use a common word processing program. |
|
Definition
|
|
Term
| What is a spot on your webpage that you can link to? |
|
Definition
|
|
Term
| You must have a complete knowledge of HTML to use Nvu and other web development applications in the creation of web pages. |
|
Definition
|
|
Term
| Which of the following menu options would upload your file as a web page? |
|
Definition
|
|
Term
| What is a piece of text or a graphic that takes the user to another location when he or she clicks on it? |
|
Definition
|
|
