FB Business Computer • 1st Semester Final Exam • Due 7:30 AM on day of final

What is an app that allows you to compose, send, receive, store, and delete email messages?

email client

What is an electronic mailbox that you receive from an email service provider?

email account

What identifies your email account?

email address

What are the 4 views of Outlook?

mail, calendar, people, tasks

What is the Outlook folder that contains incoming messages?

Inbox

Where are the primary recipients identified in the message header?

in the To box

How can you separate multiple recipients in the To box?

with a semicolon

What does the CC mean in the CC box?

courtesy copy

What does the BCC mean in the BCC box?

blind courtesy copy

What identifies the sender and may include additional information, such as a job title, business name, and phone number(s)?

Signature line(s)

Why should you use proper capitalization in your email?

ALL CAPS is considered shouting and rude; all lowercase is considered unprofessional

What should you never use in an email?

texting abbreviations

How does Outlook indicate a message is unread in the message list?

a blue vertical bar is in front of the message, and it displays the subject text and time of arrival in a blue bold font

What indicates a previously read message?

an open envelope

What does the blue number next to the Inbox folder indicate?

the number of unread messages in the Inbox

Why should you not open an email message sent from an unknown sender?

it might trigger a virus

What should you never do with an email message from an unknown sender that contains an attachment?

open the attachment (even if it seems important) or click a hyperlink

What are unsolicited email messages usually advertising a product or service?

spam or junk email

What is a word, phrase, symbol, or picture in an email message or on a webpage that, when clicked, directs you to another document or website?

hyperlink

What is a file that you send along with an email message?

attachment

How do you know if an email message has an attachment?

a paper clip icon appears on the message

Which emails should be more formal?

emails sent to an instructor, coworker, or client

Why should you never send personal emails through your work email account?

the company you work for has the right to access anything on your work computer, including the work email server

What should always apply regardless of the audience in an email message?

all standard grammar rules, such as punctuation, capitalization, and spelling

What does the Reply button do?

Sends the reply email to the person who sent the message

What does the Reply All button do?

Sends the reply email to everyone listed in the message header except those in the BCC box

What does the Forward button do?

Sends a copy of the message to additional people

How do you attach a file?

click on the paper clip in the message pane and navigate to the file you need using "Browse this computer"

When submitting work via email to Miss Castner, which one should you use and why? Suggested attachments, Browse this computer, Browse cloud locations, OR Upload and share

Browse this computer because it will send the actual file, not a link, and Miss Castner won't grade links.

If you're not sure if you sent an email or not, what should you do?

Check the Sent folder in Outlook

Why would you want to share your calendar with others?

so they can check free times, schedule meetings, and refer to contact information

What is the Outlook folder that contains your personal schedule of appointments, events, and meetings?

Calendar

What contains a date banner and a Weather Bar that display's today's weather in the selected city?

appointment area

How is the appointment area divided in Day, Work Week, or Week views?

into half-hour time slots

What is an Outlook calendar item that does not involve other people or resources, such as conference rooms?

appointment

What is an Outlook item as an activity that occurs at least once and lasts at least 24 hours?

event

When does an appointment become an event?

when you schedule it for the entire day

What is an event that occurs yearly on a specific date?

an annual event (birthday, anniversary, holiday)

When does an appointment become a meeting?

when people are invited

How many and which days does the Work Week view display?

5 days, Monday through Friday

What are the hours of the default work week?

8:00 AM - 5:00 PM

How many days does the Week view display?

7 days

What does the Month view resemble?

a regular monthly calendar

How many items appear on any one day in the Monthly view?

2 items

How do you know if there are more items on a day in the Monthly view?

an ellipsis button appears

Where do the additional items on a date appear when you click the ellipsis for that date?

on the right in a list

What is an appointment that occurs only once on a calendar?

one-time appointment

What is an appointment that repeats on a calendar at regular intervals?

recurring appointment

What do color categories allow you to do?

to easily identify and associate groups of items in Outlook

How many color categories can you set?

up to 15

What is an alert window that briefly appears on your screen to notify you of an upcoming appointment?

reminder

What is the default appointment status?

Busy

What is quickest way to make an appointment an event?

click the "All day event" check box in the appointment

What do events not have that other calendar items do?

a location

What 3 things can a meeting attendee do once invited?

accept, accept as tentative, or decline

Who is the person who creates the meeting and sends the invitations?

meeting organizer

What is the universal calendar format used by Microsoft Outlook, Google Calendar, and Apple iCal?

iCalendar

Who should you invite to the meeting?

only those people whose attendance is absolutely necessary

Write a formula that totals all the numbers in the range that begins with cell A1 and ends with cell B8.

=SUM(A1:B8)

What conveys a visual representation of data?

chart

What is the small green square located in the lower-right corner of the heavy border around the active cell?

fill handle

What is to emphasize certain entries and to make the worksheet easier to read and understand?

format

What defines the appearance and shape of the letters, numbers, and special characters?

font face

What indicates how the characters are emphasized?

font style

What is a predefined formula?

function

What is a series of two or more adjacent cells in a column, row, or rectangular group of cells?

range

What is a reference that automatically adjusts for the new position when copied?

relative reference

What specifies the size of the characters?

font size

What changes the color of the letters, numbers, and symbols?

font colors

What is a predefined font, font size, and font color that you can apply to a cell?

cell style

What are the colors that are included in the current workbook's theme?

Theme Colors

What is creating a single cell by combining two or more selected cells?

Merging cells

What is any set of characters containing a letter, hyphen, or space?

text

What is information that exists on paper?

hard copy

What 2 ways can you perform calculations in Excel?

using a function or an operator

Why should you use functions in Excel instead of performing calculations by hand?

to prevent errors and to work more efficiently

What is the easiest way to copy text, numbers, or formulas to adjacent cells?

Use the Autofill handle

With what does every formula begin in Excel?

an equal sign

How do you center a single cell's text across a number of cells

by pressing the Merge & Center button on the Home Row

What does the SUM function do?

adds all the numbers in a range

What is portrait orientation?

short edge (8 1/2") at the top

What is landscape orientation?

long edge (11") at the top

What should you do if your numbers display like hashtags? (####.##)

widen your column

What should a worksheet subtitle include?

a more detailed description of the content

What do sheet tab names often match?

the worksheet title

What is the most efficient way to enter numbers?

Use the 10-key pad on your keyboard

What is one of the most powerful features of Excel?

performs calculations on numeric data

Why does Excel highlight the cell references in the formula in color?

because the most common error when entering a formula is to reference the wrong cell

Why should you save your workbook frequently?

In case your computer crashes so you don't have replicate work

What happens if you merge two cells that both contain data?

the data in the second cell is deleted

How do you widen your column?

Position your mouse pointer between the two column headers until the pointer turns to a double-headed black arrow. Then either drag or double-click.

Why should you move a chart to its own chart sheet?

the chart will increase in size, which will improve readability

How do you select a nonadjacent range?

Click and drag on the first range, then press CTRL, then click and drag on the second range while you are holding CTRL. (On a Mac, use CMD instead of CTRL)

What feature should you use to have a long paragraph appear in only one cell?

Wrap Text

If you want to control where each line ends rather than letting Excel automatically wrap at the end of the lines, what keystrokes you use on a PC?

ALT+ENTER

Why should you use Point mode instead of entering the formulas by keyboard?

so you don't have to worry about typographical errors when entering cell references

What does Excel usually consider a blank cell to be equal to?

0

What do the statistical functions do with blank cells?

ignore them

Which order of operation does Excel follow? (be prepared to type in order in a list)

NPPEMDAS (negation, percentages, parentheses, exponents, multiplication, division, addition, subtractions)

Why should you always verify the range Excel selects when using a function from the Sum Menu?

because Excel does not always select the correct range