Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Business Info Mgmt 1 > Sem 1- 6 week (2) > Flashcards

Sem 1- 6 week (2) Flashcards

1
Q 
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
A

=A3*B3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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
A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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.

A

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?
1
Not at all
2
3
4
5
Perfectly
4
Q

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.
A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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.
A

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?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

a. row-and-column arrangement of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

b. workbook

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

c. =$M$3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

d. By rows and columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

=IF is an example of a _____ function.

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

A

a. logical

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

a. Average of values in cells C1 through C10

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

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

A

d. function

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

c. absolute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

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. %

A

c. =

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

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

A

c. formula

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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

a. =SUM(B2:D2)/3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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

A

d. =C10-B9

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

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

A

b. Insert row ; Insert column

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

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%

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

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

A

b. relative

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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

A

d. constant values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

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

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

A

d. formatting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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

a. Statistical functions

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q 
When we calculate Miguel's Gross Pay in Cell E5, what formula do we use?
  b5*c5 
  =e5 *b5 
  =b5*c5 
  =b5/c5
A

=b5*c5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q 
If the tax rate for these employees is 28%, what number do we use to represent the tax rate?
  .0028 
  28 
  .28 
  .028
A

.28

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q 
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
A

=E5*.28

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q 
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
A

=E5-F5. and click the $ icon

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q 
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
A

$139.45

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
30
Q

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

A

=(B4C4)+(B4D4)*.28, and click the $ icon

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
31
Q 
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
A

$54.23

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
32
Q 
How much would Miquel's Gross Pay amount?
  233.64 
  $350.46 
  350.46 
  $233.64
A

$233.64

33
Q 
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
A

=(B5C5)-(B5C5*.28)

34
Q 
What is Ray's Overtime Pay in dollars?
  142.83 
  $142.83 
  $241.25 
  $214.25
A

$214.25

35
Q

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.
A

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

36
Q

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.
A

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

37
Q

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.
A

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

38
Q

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.

A

Placeholders are predefined text areas within preexisting slides.

39
Q

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.
A

The “Set Up Slide Show” command is in the Slide Show menu.

40
Q 
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
A

all elements

41
Q

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

A

control animation on an object-by-object basis

42
Q

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.
A

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

43
Q

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.
A

Use the Rehearse Timing feature in the Slideshow menu.

44
Q 
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

A presentation program

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

Transitioning

46
Q

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.
A

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

47
Q 
\_\_\_\_\_ is a setting that causes a PowerPoint to continuously repeat itself.
  Wipe 
  Appear 
  Rehearse 
  Loop continuously
A

Loop continuously

48
Q

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.
A

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

49
Q

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

A

Manipulating and analyzing large amounts of sales data

50
Q 
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
A

bullet

51
Q 
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
A

multi-level

52
Q 
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
A

Rule of Thirds

53
Q 
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
A

Microsoft PowerPoint

54
Q 
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
A

two

55
Q 
\_\_\_\_\_\_\_\_\_\_\_ 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

A presentation

56
Q 
\_\_\_\_\_\_\_\_\_\_\_\_\_ 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
A

PowerPoint Presentation

57
Q 
A (n) \_\_\_\_\_\_\_\_\_\_ allows you to create a new area to add text to your slide.
  template 
  animation 
  new slide 
  textbox
A

textbox

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

themes

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

Transitions

60
Q 
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.
A

Use messaging symbols.

61
Q 
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

A flyer.

62
Q 
The input device used in all Desktop Publishing systems is the \_\_\_\_\_.
  USB drive 
  scanner 
  joystick 
  keyboard
A

keyboard

63
Q 
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
A

footer

64
Q

In most cover letters submitted with resumes, the left and right margins are set to _____.

  1. 88”
  2. 90”
  3. 00”
  4. 11”
A

1.00”

65
Q 
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
A

Card inserts

66
Q 
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.
A

Use a chart.

67
Q 
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.
A

Create a data table.

68
Q 
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.
A

Mail Merge.

69
Q 
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
A

SmartArt

70
Q 
Desktop Publishing is often referred to as \_\_\_\_\_\_\_.
  DTP 
  DP 
  DPP 
  DSKP
A

DTP

71
Q 
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
A

brochure

72
Q 
Th most common brochure has \_\_\_\_ panels?
  three 
  four 
  six 
  eight
A

six

73
Q 
One of the uses for a \_\_\_\_\_\_\_\_\_\_ would be to distribute company information door-to-door.
  flyer 
  letter 
  postcard 
  hanger
A

flyer

74
Q 
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

A flyer

75
Q 
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
A

Desktop Publishing

76
Q 
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
A

an outline

77
Q 
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

a table

78
Q

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.

A

Use the text from your online employee manual.

79
Q 
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
A

mail-merge

Business Info Mgmt 1 (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions