INFO-1292 Excel and Powerpoint

Refer to the image to determine which statement is considered true.

• The data in B8 will indicate an error

• The data in B8 will be null

• The data in B8 will be SUM(B3:B7)

• 
  The data in B8 will be 8

An MS Excel file can be saved in HTML format and posted on a website.

• True

• False

Which feature(s) in Excel allow you to apply several formatting options simultaneously to one or more cells?

• Cell styles

• Cell formulas

• Cell functions

• AutoComplete

Refer to the image to determine which Excel features are being used in the selected cell

• Cell merging

• Text wrapping

• Date function

• Text centering

Refer to the exhibit to determine which statements are considered true.

• All formulas in C column will refer to the value F4 as the second value in the formula

• This is an example of an absolute cell reference

• This is an example of a 3D cell reference

• $F$4 enables formatting to include the $ symbol in the cell

Which features of MS Excel make it easier to view data on screen for larger files?

• Freeze panes

• Themes

• Styles

• Formatting

Refer to the screen capture to determine what why the user is having difficulty with their formula.

• The formula contains a circular reference which causes errors

• Nothing is wrong with the formula, you are trying to trick me

• The formula does not follow the mathematical order of operations

• The formula contains a circular reference, but the other cells need to be populated

Refer to the screen capture to determine which statements are considered true.

• The fee for Rosa will be $20

• The fee for Avery will be $20

• The fee for Amy will be $18

• The fee for Valentina will be $18

• The fee for Essa will be $20

Which statements are considered true regarding views in PowerPoint.

• The master views are used to change formatting that applies to the entire presentation

• The slide sorter view helps to organize the slides in a presentation

• PowerPoint does not use views

After a theme has been selected for a PowerPoint presentation it cannot be changed.

• True

• False