PowerPoint and Presentations
Which action will move a presentation forward while in presentation mode?
A. Pressing the space bar
B. Clicking the mouse
C. Pressing the arrow keys
D. All of the above
All are ways to move a presentation forward in presentation mode
D
Pressing the space bar
Clicking the mouse
Pressing the arrow keys
What must be typed first when entering a formula into a spreadsheet cell?
A. Parentheses
B. A number
C. An equal sign
D. A function name
C. An equal sign
Which function is used to add values in multiple cells?
A. Average
B. Total
C. Sum
D. Count
C. Sum
During a business meal, where should your phone be?
A. On the table
B. In your hand
C. Silenced and put away
D. On speaker
C. Silenced and put away
Crossing your arms during a conversation is an example of
A. Verbal communication
B. Written communication
C. Nonverbal communication
D. Visual communication
C. Nonverbal communication
A predesigned presentation used to quickly start a project is called a
A. Style
B. Template
C. Transition
D. Theme
D. Template
Dragging the small square in the bottom right corner of a cell to continue a pattern uses which tool?
A. AutoCorrect
B. Fill handle
C. Cell reference
D. Format painter
B. Fill handle
Which symbol is used for multiplication in Excel formulas?
A. Plus sign
B. Dash
C. Slash
D. Asterisk
D. Asterisk
Which personal quality affects how you behave at work?
A. Productivity
B. Attitude
C. Supervisor
D. Schedule
B. Attitude
Sending an email is an example of which type of communication?
A. Verbal
B. Nonverbal
C. Written
D. Visual
C. Written
Which feature controls how one slide changes to the next during a presentation?
A. Animations
B. Motion paths
C. Transitions
D. Styles
D. Transitions
The cell reference E4 represents
A. Row E column 4
B. Column E row 4
C. The fourth cell in Excel
D. A function key
B. Column E row 4
Which formula correctly adds the values in cells B2 through B6?
A. =B2+B6
B. =SUM(B2:B6)
C. =B2*B6
D. SUM(B2-B6)
B. =SUM(B2:B6)
Team building activities are used to improve
A. Morale
B. Productivity
C. Employee Turnover rates
D. All of the above
D. All of the above
Which leadership style allows employees to work independently?
A. Autocratic
B. Democratic
C. Laissez faire
D. Participative
C. Laissez faire
Which feature adds movement to text or images on a slide?
A. Transitions
B. Animations
C. Templates
D. Backgrounds
B. Animations
What does it usually mean when a cell shows ##########?
A. The formula is incorrect
B. The number is too large for the column
C. The function is misspelled
D. The cell is empty
B. The number is too large for the column
Which keyboard shortcut allows you to view formulas instead of results?
A. Control and equal sign
B. Control and Accent
C. Control and shift
D. Control and star
B. Control and Accent
Why are workplace manners important?
A. They increase confidence and professionalism
B. They reduce the need for managers
C. They replace job training
D. They are only important in offices
A. They increase confidence and professionalism
Clocking in for a coworker who is late violates which principle?
A. Leadership
B. Productivity
C. Ethics
D. Teamwork
C. Ethics
When designing a presentation, which factor should be considered?
A. The audience
B. The purpose
C. Color choice
D. All of the above
D. All of the above
Why is it better to use cell references instead of typing numbers into formulas?
A. It makes formulas longer
B. It allows Excel to add charts automatically
C. Formulas update when values change
D. It prevents errors completely
C. Formulas update when values change
Which formula correctly adds three cells and then divides the total by 4?
A. =A1+A2+A3/4
B. =(A1+A2+A3)/4
C. =A1+A2+(A3/4)
D. =SUM(A1:A3^4)
B. =(A1+A2+A3)/4
Which statement about work schedules around the world is accurate?
A. All countries have a 40 hour work week
B. Work hours vary by country
C. Work schedules are illegal abroad
D. Work hours are the same worldwide
B. Work hours vary by country
Which leadership style involves employees in decision making?
A. Autocratic
B. Laissez faire
C. Democratic
D. Hands off
C. Democratic