BUSIM: Fall Semester Exam (2023)

Which two date formats should NOT be used in an American business letter?

• 12 December 2019

• Dec. 12, 2019

• December 12, 2019

Which one of these statements is TRUE about the correct business letter formats?

• Block format has everything left aligned and mixed punctuation.

• Modified block has indented paragraphs.

• Semi-modified block uses indents, and some parts are center aligned.

In MS Word, Find and Replace is used to...

• Sort information

• Edit and change words

• As a short cut key

Templates are available in which MS programs? (Choose 2 answers.)

• Excel

• Power Point

• Word

• Mail Merge

In Excel, the insertion point is... (choose two answers)

• the formula bar

• where your cursor is located

• the active cell

• the cell showing the SUM total

In Power Point, a placeholder is... (choose 3 answers)

• a text box

• part of a template

• where you create a hyperlink

• where text, an image, or video can be placed

What is the correct way to write the Excel function?

• SUM=(B4:B12)

• =SUM (B4+B5+B6+B7)/3

• =AVG(E6+F6+G6) / 3

• =(E6+F6+G6) / 3

In Power Point, the Slide Sorter view....

• is on the Home tab

• is shown in the Navigation pane

• helps you move slides or show added effects

• used to add transitions to slides

In Excel, a feature that allows you to quickly apply the contents of one cell to another cell(s) is called--

• Active cell

• Function

• Auto fill

In Excel, a combination of numbers and symbols used to express a calculation, and starting with = is called

• Function

• Label

• Cell address

• Formula