Sem 1- 6 week (2) Flashcards by celine obeid

What does the formula look likes, in Excel and Google Sheets, are involved in multiplying a number in A3 by a number in B3. The formula will reside in cell D3?
  Equals A3 times B3 
  A3 times B3 
  =A3/B3 
  =A3*B3

=A3*B3

How well did you know this?

Not at all

Perfectly

What is the formula for averaging the contents of cells A1 through A50 (A1:A50) and placing the answer in cell A52?

Place your cursor in a cell A52 and type equals average (A1*A50)
Place your cursor in a cell A52 and type =AVE (A1:A50)
Place your cursor in a cell A52 and type AVE (A1:A50)
Place your cursor in a cell A52 and type =A1:A50/50

Place your cursor in a cell A52 and type equals average (A1*A50)

How well did you know this?

Not at all

Perfectly

What is the easiest method for adding these values in A1, A2, A3, A4 and A5?
Place your cursor in cell A1 and click the AutoSum icon.
Place your cursor in cell A6 and type the formula: =A1+A2+A3+A4+A5.click the AutoSum icon.
In cell A6, type the formula: =sum(A1:A6)
Place your cursor in cell A6 and click the AutoAdd icon.

Place your cursor in cell A6 and type the formula: =A1+A2+A3+A4+A5.click the AutoSum icon.

How well did you know this?

Not at all

Perfectly

What is the easiest for placing a chart in Word or Google Sheets?

Create the table in Excel or Sheets, then copy and paste it to Word or Docs and create the chart.
Create the chart in Excel or Sheets, then copy and paste it to Word or Docs.
Create the chart in Excel or Sheets, then copy and paste it to Word or Docs
Create the chart in Word or Docs, then paste and copy it to in Excel or Sheet.

Create the chart in Excel or Sheets, then copy and paste it to Word or Docs

How well did you know this?

Not at all

Perfectly

What are the steps for resizing a column? Place the cursor on the line between the gray headings (e.g., between “A” and “B” for columns or between “1” and “2” for rows).

When the cursor changes to a plus with a vertical line down the middle, you can drag the cursor to resize the column or row size.
When the cursor changes to a plus with two arrows with a vertical line down the middle, you can drag the cursor to resize the column or row size.
When the cursor changes to a vertical line down the middle, you can drag the cursor to resize the column or row size.
When the cursor changes to a plus with two arrows with a vertical line down the middle, you can drag the cursor to reshape the column or row size.

When the cursor changes to a plus with two arrows with a vertical line down the middle, you can drag the cursor to resize the column or row size.

How well did you know this?

Not at all

Perfectly

A spreadsheet can generally be defined as a _____.

a. row-and-column arrangement of data
b. chart that can be used to prepare business reports
c. grid arrangement of data used by modern calculators to solve equations
d. worksheet used by mathematicians and engineers to help solve problems

a. row-and-column arrangement of data

How well did you know this?

Not at all

Perfectly

In a spreadsheet program, a collection of worksheets saved in a single spreadsheet file is called a _____.

a. project
b. workbook
c. workstation
d. document book

b. workbook

How well did you know this?

Not at all

Perfectly

Which of the following is a correctly formatted absolute cell reference for both column and row in Microsoft Excel or Google Sheets?

a. $C5
b. =#A$7
c. =$M$3
d. =$89:$S

c. =$M$3

How well did you know this?

Not at all

Perfectly

What is the default way data is organized in a spreadsheet?

a. In lists
b. In charts
c. In graphs
d. By rows and columns

d. By rows and columns

How well did you know this?

Not at all

Perfectly

=IF is an example of a _____ function.

a. logical
b. database
c. financial
d. calculation

a. logical

How well did you know this?

Not at all

Perfectly

Which choice BEST describes the meaning of the formula =AVERAGE(c1:c10)?

a. Average of values in cells C1 through C10
b. Average of values in cells C1 and C10 only
c. Average of all cells in columns 1 through 10
d. Average of column C, excluding values in cell C1 and C10

a. Average of values in cells C1 through C10

How well did you know this?

Not at all

Perfectly

=SUM (B6…B10) is an example of a preset formula, or _____.

a. graph
b. macro
c. routine
d. function

d. function

How well did you know this?

Not at all

Perfectly

In _____ cell referencing, the formula does not change when it is copied and pasted to other cells.

a. pure
b. relative
c. absolute
d. dependent

c. absolute

How well did you know this?

Not at all

Perfectly

As treasurer of the Prom Committee, Maria must prepare a budget for prom expenses. To handle this task efficiently, Maria will use formulas in a spreadsheet program to calculate the totals. Which symbol below should she ALWAYS use to start her formulas?

a. /
b. *
c. =
d. %

c. =

How well did you know this?

Not at all

Perfectly

A mathematical equation that is used to calculate values in a spreadsheet program is called a _____.

a. macro
b. routine
c. formula
d. function

c. formula

How well did you know this?

Not at all

Perfectly

The table below shows test scores for a science class. Which formula is correct to calculate Mei’s test average?

            A	               B 	    C	        D	        E 1	Student Name   Test 1  Test 2  Test 3  Test Average

2 Mei 89 90 89
3 Mike 90 80 60
4 Sue 70 90 70
5 Ramon 80 70 80

a. =SUM(B2:D2)/3
b. =SUM(B2+C2+E2)/3
c. SUM(B2+C2+D2)/3
d. =SUM(C2+D2+E2)*3

a. =SUM(B2:D2)/3

How well did you know this?

Not at all

Perfectly

In Microsoft Excel or Google Sheets, which of the following is the correct method to subtract values in two different cells?

a. A - B
b. B4*B6
c. =46x39
d. =C10-B9

d. =C10-B9

How well did you know this?

Not at all

Perfectly

Which commands can be used to add rows and columns to an existing spreadsheet?

a. Add row ; Add column
b. Insert row ; Insert column
c. Attach row ; Attach column
d. Append row ; Append column

b. Insert row ; Insert column

How well did you know this?

Not at all

Perfectly

Which formula correctly adds the contents of two cells, and then multiplies the result by 5%?

a. +SUMA2+B4)5%
b. =SUM(A2-B4)5%
c. =SUM(A2+B4)5%
d. =SUM((A2=B4))5%

c. =SUM(A2+B4)*5%

How well did you know this?

Not at all

Perfectly

In a spreadsheet program, when a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the formula’s new location. This process is called _____ cell referencing.

a. pure
b. relative
c. absolute
d. dependent

b. relative

How well did you know this?

Not at all

Perfectly

Numbers, text, dates, or times of day that you type into a cell in a spreadsheet are called _____.

a. data sets
b. active cells
c. cell references
d. constant values

d. constant values

How well did you know this?

Not at all

Perfectly

To control the appearance of an item or the entire spreadsheet document, the user manipulates _____ commands.

a. fashion
b. dimension
c. proportion
d. formatting

d. formatting

How well did you know this?

Not at all

Perfectly

What spreadsheet criteria would you use to analyze numerical survey results?

a. Statistical functions
b. The Function formula
c. Mathematical functions
d. Trigonometric functions

a. Statistical functions

How well did you know this?

Not at all

Perfectly

Shortly after graduating from college, Sanjay began looking for a job. He quickly received two offers. The salary for each job was the same; however, the commission rates and cost of benefits were different. In order to determine the job that had higher compensation, which formula is BEST for helping Sanjay predict his estimated salary with sales projections?

a. Salary - Cost of Benefits + Commission
b. Commission + Salary + Cost of Benefits
c. Salary + (Sales ⋅ Commission) ⋅ Cost of Benefits
d. Salary + (Sales ⋅ Commission) - Cost of Benefits

d. Salary + (Sales ⋅ Commission) - Cost of Benefits

How well did you know this?

Not at all

Perfectly

``` When we calculate Miguel's Gross Pay in Cell E5, what formula do we use? b5*c5 =e5 *b5 =b5*c5 =b5/c5 ```

=b5*c5

``` If the tax rate for these employees is 28%, what number do we use to represent the tax rate? .0028 28 .28 .028 ```

.28

``` If Brittany’s Gross Pay found in E5 equals B4 times C4 plus B4 times (D4 times 1.5) and the tax rate is 28%, what is the formula for her taxes? =E5*28 =B4-*C4*D4*.28 =(B4-*C4)*(D4*1.5)*.28 =E5*.28 ```

=E5*.28

``` What formula would Ray’s Net Pay be in dollars? =E5-F5. and click the $ icon =E5-F5*1.00 =C5+D5-F5. and click the $ icon =G5*1.00 ```

=E5-F5. and click the $ icon

``` Using the formulas above, if E3 equals $193.68, what would Marcia’s Net Pay be in dollars? $188.26 $139.45 $145.39 $54.23 ```

$139.45

What is the formula for calculating Brittany’s taxes be in dollars? =B4*C4+B4*D4*.28, and click the $ icon (B4*C4)+(B4*D4)*.28, and click the $ icon =(B4*C4)+(B4*D4)*.28, and click the $ icon =(B4*C4)+(B4*D4)*.28*1.00

=(B4*C4)+(B4*D4)*.28, and click the $ icon

``` If Marcia’s Gross Pay equals B4 times C4 and the tax rate is 28%, what is her tax amount? 54.23 $54.23 $5.42 5.42 ```

$54.23

``` How much would Miquel's Gross Pay amount? 233.64 $350.46 350.46 $233.64 ```

$233.64

``` What is Miguel’s formula for Net Pay? =(B5*C5)-(B5*C5.28) =(B5*C5)-(B5*C5*.28) =D5-F5 (B5*C5)-(B5*C5)*.28 ```

=(B5*C5)-(B5*C5*.28)

``` What is Ray's Overtime Pay in dollars? 142.83 $142.83 $241.25 $214.25 ```

$214.25

What is a template? - Templates are slide shows that are completely developed.. - Templates are basic slide designs with backgrounds and text areas that allow you to edit and create your own slides. - Templates are advanced slide designs with open areas that allow you to change the colors. - Templates are slide with no backgrounds and limited text areas that have limited edits and create your own slides.

Templates are basic slide designs with backgrounds and text areas that allow you to edit and create your own slides.

Which of the answers is not a way to insert a new slide in PowerPoint or Google Slides? - In PowerPoint, from the Ribbon or Menu Bar, click New Slide Icon. Next, choose the slide layout you wish to use by clicking on Layout. - In Google Slides, in the Slide panel, right-click where you wish to insert a slide and choose New Slide (+). Next, choose the slide layout you wish to use by clicking on Layout. - In PowerPoint, click Ctrl + M. Next, choose the slide layout you wish to use by clicking on Layout. - In PowerPoint, choose New Slide (+). Next, choose the slide layout you wish to use by clicking on Layout.

In PowerPoint, choose New Slide (+). Next, choose the slide layout you wish to use by clicking on Layout.

Which of these answers is not one of the three ways to add text in on a slide? - You can add text to slides by using the placeholder. - By clicking the Text Box icon under the Insert menu. - You can add text to slides by right-clicking on the Text Box icon. - You can add text to slides by right-clicking on a Shape and choose Edit Text.

You can add text to slides by right-clicking on the Text Box icon.

What are text placeholders? Placeholders are predefined slides. Placeholders are preexisting slides. Placeholders are predefined text areas within preexisting slides. Placeholders are predefined text slides.

Placeholders are predefined text areas within preexisting slides.

In PowerPoint, under what menu is the "Set Up Slide Show" command? - The "Set Up Slide Show" command is in the Insert menu. - The "Set Up Slide Show" command is in the Recording menu. - The "Set Up Slide Show" command is in the Home menu. - The "Set Up Slide Show" command is in the Slide Show menu.

The "Set Up Slide Show" command is in the Slide Show menu.

``` When using PowerPoint or Google Slides, it is useful to use the Normal view (on the left side) because it includes _____ in each individual slide. text only images fonts all elements ```

all elements

When Jan wanted to enhance her presentation, she decided to add animation effects. These effects will allow her to _____. add cartoon images control animation on a slide-by-slide basis control animation on an object-by-object basis set slide transitions

control animation on an object-by-object basis

In which of the following situations would a presentation be MOST effective? - Compiling large amounts of data and creating charts based on that data. - Designing and printing brochures for a travel agency. - Delivering a sales pitch to potential investors about a new business plan. - Writing and editing a lengthy paper for class.

Delivering a sales pitch to potential investors about a new business plan.

Michelle has created a slideshow in PowerPoint with timed transitions. What can she do to make sure the transitions are the appropriate length before she delivers the presentation? - View the slideshow in outline view to see how long it is. - Use the Rehearse Timing feature in the Slideshow menu. - Use sections to divide the presentation. - Change the setting on the Slideshow menu to Loop Continuously.

Use the Rehearse Timing feature in the Slideshow menu.

``` Which type of software would BEST help Karalla to create a human resource training session at the office and one off-site location? A database program A spreadsheet program A presentation program A word processing program ```

A presentation program

``` What is it called when you move from one PowerPoint (Slides) slide to the next in a presentation? Flipping Skipping Page-turning Transitioning ```

Transitioning

Jeremy is pitching a new product to the design board at his company. He has multiple charts and photographs of the product. Is PowerPoint a good option for Jeremy's product pitch? - Yes, it would allow him to organize his presentation and allow him to show the board his charts and images. - No, PowerPoint (Slides) is not designed to include charts. - No, PowerPoint (Slides) will not allow Jeremy to focus on the product presentation because he will be required to manually switch between slides. - No, Jeremy should use Excel (Sheets) to design his presentation.

Yes, it would allow him to organize his presentation and allow him to show the board his charts and images.

``` _____ is a setting that causes a PowerPoint to continuously repeat itself. Wipe Appear Rehearse Loop continuously ```

Loop continuously

What is the difference between templates and (design) themes in PowerPoint? - Only themes include animations, transitions, and sample text, whereas templates only change slide color and font. - Themes must be opened from the Home menu before designing a presentation, whereas templates can be applied at an time to an existing presentation. - Only templates include text in placeholders and subject-specific content, whereas themes contain formatting such as coordinated font color and background. - There is no difference between templates and themes.

Only templates include text in placeholders and subject-specific content, whereas themes contain formatting such as coordinated font color and background.

In which of the following situations would PowerPoint (Slides) NOT be an appropriate software choice? Pitching a new marketing strategy at a board meeting Making a family photo album or scrap book Manipulating and analyzing large amounts of sales data A company policy presentation for new employees

Manipulating and analyzing large amounts of sales data

``` A symbol such as a heavy dot or another character that precedes text in a presentation is called a(n) ____. asterisk list bullet title slide ```

bullet

``` A slide that consists of more than one level of bulleted text is called a ____ bulleted list slide. extra-level slide many-level multi-level super-level ```

multi-level

``` The ____ states that each slide should have ample space to rest the eyes. Rule of Thirds Rule of Thumb Rule of Thunder Rule of Thirty ```

Rule of Thirds

``` To start PowerPoint, click the Start button on the Windows taskbar, point to Programs, and then select ____. Accessories Microsoft Office Tools Start PowerPoint Microsoft PowerPoint ```

Microsoft PowerPoint

``` To maintain balance and simplicity in your presentation, designers recommend using a maximum of ____ fonts and two font styles or effects. three two four five ```

two

``` ___________ is a collection of data and information that is to be delivered to a specific audience. A Slideshow presentation A PowerPoint presentation A presentation An Effective presentation ```

A presentation

``` _____________ is a collection of electronic slides that can have text, pictures, graphics, tables, sound and video. This collection can run automatically or can be controlled by a presenter. Efficient presentation Google Docs Controlled presentation PowerPoint Presentation ```

PowerPoint Presentation

``` A (n) __________ allows you to create a new area to add text to your slide. template animation new slide textbox ```

textbox

``` Which of these are templates that can be applied to an entire presentation that allows for consistency throughout the presentation? styles transitions themes slides ```

themes

``` Which of these are effects that are in place when you switch from one slide to the next? Animations Designs Effects Transitions ```

Transitions

``` Prior to writing a formal business letter, you should spend some time collecting your thoughts. Which of these are NOT some simple tips? Know your audience Use messaging symbols. Be professional. Be direct. ```

Use messaging symbols.

``` Nathan wants a special style for the merchandising material he is making for his custom T-shirt store. He wants a style that is easy to read, but can be mass produce quickly. Which product would be most effective to have distributed door-to-door? An outline. A letter. A flyer. A memo. ```

A flyer.

``` The input device used in all Desktop Publishing systems is the _____. USB drive scanner joystick keyboard ```

keyboard

``` The _____ is an area of a document reserved for the text and graphics that appear at the bottom of each page. footnote footer header address bar ```

footer

In most cover letters submitted with resumes, the left and right margins are set to _____. 0. 88" 0. 90" 1. 00" 1. 11"

1.00"

``` Alessandra wants to use Microsoft Word to complete a mail merge for her business. Which of the following is NOT a common output for the mail merge procedure? Email Labels Envelopes Card inserts ```

Card inserts

``` The Crazy Creations inventory report must show monthly figures for ten products. What is the BEST way to display this data visually? Use a table. Use a chart. Use windings. Use AutoShapes. ```

Use a chart.

``` Darnell's boss has asked Darnell to create a document that will be supply management with sales information to the marketing department. Which word processing feature is the BEST way to handle this task? Create a form with data. Create a data table. Create a template with placeholders. Create a sample document for review. ```

Create a data table.

``` You can combine a data source (table) with a primary document, you can use the Mailings tab to: _____. Mail Merge. Create a form. Make blank letter document. Create a dialog box. ```

Mail Merge.

``` A gallery of text styles within Microsoft Word that you can use to create fantastic Desktop Effects, such as shadowed or mirrored text, is called _____. a style SmartArt a tab stop a text box ```

SmartArt

``` Desktop Publishing is often referred to as _______. DTP DP DPP DSKP ```

DTP

``` If an employer wanted to use Microsoft Word or Google Docs to prepare an Employment Policies document, the best choice would be a ____________? template handout flyer brochure ```

brochure

``` Th most common brochure has ____ panels? three four six eight ```

six

``` One of the uses for a __________ would be to distribute company information door-to-door. flyer letter postcard hanger ```

flyer

``` A concert promoter wants to distribute information about their next concert in a straight-forward and cost effective way? Which of these is the best choice? A poster A brochure A USB drive A flyer ```

A flyer

``` Jamie wants a program to control inventory and print results. Which of the applications is NOT appropriate? Microsoft Excel Google Sheets A workbook Desktop Publishing ```

Desktop Publishing

``` Mr. Smith, your Teacher English wants you to take notes during the lecture to be use as a study tool prior to the next exam? He suggest you use _________. a table freeform notes an outline a recorder ```

an outline

``` Desktop Publish can use a variety to text, images, charts and data. One effective way to display any or all of these items would be to use _________. a table a spreadsheet columns a design ```

a table

When you create an efficient and cost-effective brochure for newly hired employees, which is the easiest way to input data into a that document? Type it in the information. Use the text from a competitor's brochures. Send it to a professional printer. Use the text from your online employee manual.

Use the text from your online employee manual.

``` A method that uses information from a database to send customized letters to potential customers is called _________? mail-mining mail-merge data-mining letter form ```

mail-merge

Sem 1- 6 week (2) Flashcards

(79 cards)