Hughes Final Exam Review 25

Microsoft Word is the equivalent to Google Sheets.

• True
• False

We used what program/software to complete of Career Research Project: Google ______

Luis wants to list the sources for the information he is entering into his spreadsheet. He wants the source information to come between "Career" and "Required Education". In the picture below, what should Nathan click so he can add source information?

• Column Right

• Function

• Insert Link

• New Sheet

Christrian has added column headers in the first row of their spreadsheet. In the picture below, what should Christian click to make all of their headers bold?

• A

• B

• C

• D

James wants to text to be readable within its cell, rather than getting clipped or cut off. In the picture below, what should James click so that he can read the cut-off text in the selected cells?

• OVERFLOW

• WRAP

• CLIP

• CONDITIONAL FORMATTING

Laura wants to automatically calculate hte central value of a set of numbers in their spreadsheet. In the picture below, what should Laura click to perform this mathematical calculation?

• AVERAGE

• COUNT

• MAX

• SUM

Sonia has reasearch salaries and wants to get a realistic view of what she could earn in a future career. What should she do to find the central value (mean) of the salaries she collected?

• Add all the numbers together

• Find another source

• Add the smallest and the largest numbers together

• Calculate the average

Amber has added column headers - like career, pay rate, and cost of education - to her spreadsheet. Why are column headers helpful in a spreadsheet like this?

• Column headers help organize the information in a spreadsheet.

• Column headers automatically sort the information in a spreadsheet.

• Column headers make it easier to print the spreadsheet

• Column headrs make it possible to warp the text in each cellof a spreadsheet.

Vaz wants her total to update automatically when she add more data to her spreadsheet. What should Vaz use so her total updates automatically?

• Use the SUM formula

• Insert a new column

• Link to sources

• Use cell reference

Jasmine wants to use the same formula in two different places on her spreadsheet. What should she do to apply this formula to a new cell without having to rewrite it?

• Make the cell with the original formula bold.

• Grab and drag the cell with the original formula over to the new cell.

• Copy the formula from the original cell, then paste it into the new cell.

• Clear the formatting from the original forumla cell as well as the new cell.