AnswersIntroduction to Information Technology - EL3701Create a Presentation

Create a Presentation — Unit test Answers

25 verified answers1 views
21
Free Preview

What is the difference between independent variables and dependent variables in spreadsheets?

A
Independent variables are the values entered into formulas, while dependent variables are the calculations made by formulas.
B
Independent variables are usually displayed in columns, while dependent variables are usually displayed in rows.
C
Independent variables are usually numbers, while dependent variables are usually text.
D
Independent variables can be formatted into charts and graphs, while dependent variables cannot.
22
Free Preview

Which function can be used to insert the current date into a spreadsheet?

A
DATE
B
TODAY
C
MM/DD/YYYY
D
DATE&TIME
23

Read the spreadsheet formula below, then answer the question.cell B5=A5*2If this formula is filled into cell B6, what will the new formula be?

A
=B5*B5
B
=B5*2
C
=A5*B6
D
=A6*2
24

A presenter wants to ensure that the audience listens to her presentation rather than spending time reading and interpreting the information on the slides. Which of the following should she consider when creating her slides to enhance the communication in her presentation?

A
Consider using a list of short phrases that represent talking points rather than complete sentences and explanations.
B
Consider using complex images to represent what might have otherwise needed a written explanation.
C
Consider creating slides with multiple points of visual interest, such as colorful graphics, backgrounds, and varied transitions.
D
Consider distributing a printed copy of each slide, including thorough presenters notes.
25

A teacher uses the spreadsheet below to determine the average quiz score of each student. The teacher inserts this information into column E. In column F, which function can be cut and pasted into different cells to tell the teacher if each student exceeded the satisfactory average?

Question illustration
A
=IF(E3>E8, “Exceeded”)
B
=IF(E3>$E$8, "Exceeded")
C
=IF(AVERAGE(E3:E6)>E8, “Exceeded”)
D
=IF(AVERAGE(E3:E6)>$E$8, “Exceeded”)

Did you find these answers helpful?

More from this Course

Quiz
25 verified answers

Unit Test

Quiz
21 verified answers

Unit Test

Quiz
25 verified answers

Unit Test