Question

What is the difference between the Paste and Paste Special options?
A. You use Paste Special when you need to paste charts.
B. Paste Special allows you to paste more quickly between applications.
C. Paste Special gives extra pasting options to fit your needs.

Answer 1

B. Paste Special allows you to paste more quickly between applications.

Answer 2

Hey, just call me on testimonial, I'll check your questions :)

Answer 3

Jeremy has created a document that has images and a chart. The chart has to be updated manually, and double-clicking on the chart does not take him to the spreadsheet software.
Which Paste option has Jeremy used?

A. Paste Link
B. Paste Special as Formatted Text
C. Paste
D. It keeps hyperlink format when copying and pasting between applications.

Answer 4

A. Paste Link

Answer 5

because you can updated automatically!

Answer 6

Linda has written a research paper that contains a data table. The data table does not update automatically but gives her access to the spreadsheet software.
Which Paste option has Linda used?
A. Paste Link as a Microsoft Office Excel Object
B. Paste Special as a Microsoft Office Excel Object
C. Paste Special as a Bitmap

Answer 7

B. Paste Special as a Microsoft Office Excel Object

Answer 8

"The data table does not update automatically but gives her access to the spreadsheet software."

Answer 9

Which type of chart is best for showing groups of data in proportion to the whole data set?
A. pie chart
B. line chart
C. bar chart

Answer 10

A. pie chart
proportion as percentage!

Answer 11

Creating a chart using a spreadsheet Chart Wizard involves four steps. Which is the first step?
A. Chart Options
B. Chart Type
C. Chart Location
D. Chart Source Data

Answer 12

B. Chart Type

Answer 13

What formula would appear if you copied and pasted the fomula
=SUM(A1:A4) from cell A5 to cell C6?
A. =SUM(C1:C4)
B. =SUM(C2:C4)
C. =SUM(C2:C5)
D. =SUM(C1:C5)

Answer 14

I need to think!

Answer 15

lol ok

Answer 16

That's weird, I test it, it's still same address!
Let make a wild guess:
C. =SUM(C2:C5)

Answer 17

What does the Auto Fill tool do?
A. It applies a consistent format to all of the cells in the worksheet.
B. It automatically fills a cell with color according to the value entered into the cell.
C. It automatically populates data into cells that reference other cells.

Answer 18

C. It automatically populates data into cells that reference other cells.

Answer 19

While traveling in India, Sabina notes all of her daily expenses in rupees in her spreadsheet. At the end of the day, she wants to see how much each expense was in U.S. dollars.
Which is the quickest way she can convert the currency values?

A. use the Auto Fill feature to convert the currency
B. multiply or divide each expense using a formula in the spreadsheet
C. multiply or divide each expense using a calculator

Answer 20

A. use the Auto Fill feature to convert the currency

Answer 21

Jim has entered the age of each of his classmates in cells A1 through A65 of a spreadsheet.
Which function should Jim use to find the most common age of his classmates?
A. =AVERAGE(A1:A65)
B. =MODE(A1:A65)
C. =MEDIAN(A1:A65)

Answer 22

B. =MODE(A1:A65)

Answer 23

In which of these scenarios would the Top 10 option be most helpful?
A. to find the lowest-paid employee of a company
B. to find all of the employees on the sales team
C. to find the first 10 employees in alphabetical order

Answer 24

A. to find the lowest-paid employee of a company

Answer 25

In which of these scenarios would the Find option be most useful?
A. to sort data in ascending or desending order
B. to replace an incorrect spelling with the correct one
C. to see all of the places in a spreadsheet that a specific car was entered

Answer 26

B. to replace an incorrect spelling with the correct one

Answer 27

Hey, did you check if they're correct?

Answer 28

Ms. Rogers wants to see the names of all the students who scored below 25 on the test. Which of these custom options will help her do so?
A. equals
B. is less than
C. is greater than

Answer 29

i will is 20 questions this is the last 1 than i will tell u what i got

Answer 30

B. is less than

Answer 31

My PC's as slow as turtle!!!

Answer 32

Percentage Correct of Total: 71% (15 / 21)
Percentage Answered of Total: 100% (21 / 21)
Percentage Correct of Answered: 71% (15 / 21)

Answer 33

It's horrible :(

Answer 34

lol. ima start all over again i was suppost to have 80 % :(

Answer 35

But do we know which one wrong?

Answer 36

Introduction to Spreadsheets 0% (0 / 2) --
Formatting Spreadsheets 100% (3 / 3)
Formulas and Functions 100% (4 / 4)
Integrating Spreadsheet Data into Other Applications 25% (1 / 4) --
Sorting and Filtering Data 67% (2 / 3) --
Displaying Data in Charts 100% (4 / 4)

Answer 37

At least I know where to fix, that's great!

Answer 38

Wich is the correct process for selecting an entire row in a spreadsheet?
A. Click on any cell in the row.
B. Select Rows in the Insert menu.
C. Select Rows in the Format menu.
D. Click on the Row heading.

Answer 39

D. Click on the Row heading.

Answer 40

Which is the correct process for selecting nonconsecutive worksheets in a workbook?
A. Click the sheet tab for the first sheet you want to select and then hold down the Shift key while selecting the other sheets.
B. Click the sheet tab of each sheet you want to select while holding down the Alt key.
C. Click the sheet tab for the first sheet you want to select and then hold down the Ctrl key while selecting the other sheets.
D. Double-click the sheet tab of each sheet you want to select while holding down the Alt key.

Answer 41

C. Click the sheet tab for the first sheet you want to select and then hold down the Ctrl key while selecting the other sheets.

Answer 42

Which is the quickest way to change the font color in multiple, randomly located cells in a worksheet?
A. Click the Format menu and select the AutoFormat option.
B. Click the Font Color icon on the Formatting toolbar to change the font color of one cell, copy it with the Format Painter, and then paste it into each of the other cells.
C. Hold down the Ctrl key, click on each cell, and then change the font color by clicking on the Font Color icon on the Formatting toolbar.

Answer 43

C. Hold down the Ctrl key, click on each cell, and then change the font color by clicking on the Font Color icon on the Formatting toolbar.

Answer 44

What is the difference between a workbook and a worksheet?
A. A worksheet is a file that contains one or more workbooks.
B. The terms workbook and worksheet describe the same thing.
C. A workbook is a file that contains one or more worksheets.

Answer 45

C. A workbook is a file that contains one or more worksheets.

Answer 46

Which phrase best describes a spreadsheet?
B. a table designed to help with text data
C. a table designed to help with text and numerical data

Answer 47

we don't have option A?

Answer 48

A. a table designed to help with numerical data
B. a table designed to help with text data
C. a table designed to help with text and numerical data

Answer 49

A. a table designed to help with numerical data

Answer 50

Gina maintains a spreadsheet to record the amount of time she spends on her daily activities. Which function should she use to quickly convert the times from minutes to seconds?
A. AutoFilter
B. Auto Fill
C. Filter

Answer 51

B. Auto Fill

Answer 52

You have to calculate the total amount you spent at the mall today. Which function should you use to do so?
A. =AVERAGE( )
B. =COMBINE( )
C. =SUM( )
D. =PRODUCT( )

Answer 53

C. =SUM( )

Answer 54

The manager of a sports club has data about the club members' ages in a workbook. He wants to find which age is most common.
Which workbook function will help him find htis information?
A. =MODE( )
B. =MEDIAN( )
C. =AVERAGE( )

Answer 55

A. =MODE( )

Answer 56

In a spreadsheet, formulas always begin with which sign?
A. *
B. +
C. =
D. –

Answer 57

C. =

Answer 58

In which scenario would someone want to use the Paste Link option?
A. Becky wants to copy some data in a spreadsheet that tracks how much she spent last year.
B. Renee wants to use her planner to keep track of the number of assignments she is completing regularly.
C. Jack wants to copy a balance sheet of his expenses for last month.

Answer 59

B. Renee wants to use her planner to keep track of the number of assignments she is completing regularly.

Answer 60

Which statement about the Paste Link option is true?

A. Even if the source file (spreadsheet) is deleted, the data updates automatically in the linked documents.
B. You cannot update the source file (spreadsheet) by making changes in the linked document.
C. The source file (spreadsheet) is necessary for making automatic updates in the linked documents.

Answer 61

C. The source file (spreadsheet) is necessary for making automatic updates in the linked documents.

Answer 62

Which option will automatically update copied data?
A. After copying, click Paste.
B. After copying, click Paste Special, check Paste, and then select Bitmap.
C. After copying, click Paste Special and check Paste Link.

Answer 63

C. After copying, click Paste Special and check Paste Link.

Answer 64

Ashley is working on a weather project that requires her to update temperatures of different cities every day. She has created a document that updates automatically but may modify some formatting.
Which Paste option has Ashley used?

A. Paste Link as a Microsoft Office Excel Object
B. Paste Special as a Microsoft Office Excel Object
C. Paste Special as Unformatted TextD. Paste using Ctrl+V

Answer 65

A. Paste Link as a Microsoft Office Excel Object

Answer 66

Which type of chart is best for highlighting trends in data?
A. pie chart
B. line chart
C. bar chart

Answer 67

B. line chart

Answer 68

Which is the best way to interview high school students about which lunch items they like?
A. mailing them a questionnaire
B. handing out questionnaires during lunch
C. asking them questions over the phone

Answer 69

B. handing out questionnaires during lunch

Answer 70

Which is a qualitative question?
A. What flavor of milk shake did you drink yesterday?
B. What do you think about low-fat milk shakes?
C. Which flavor of milk shake do you prefer: vanilla or strawberry?

Answer 71

B. What do you think about low-fat milk shakes?

Answer 72

What is the difference between a chart sheet and an embedded chart?

A. A chart sheet displays all of the charts associated with data in a workbook, while an embedded chart is saved in a separate spreadsheet.
B. A chart sheet is saved on the same sheet of the workbook as its associated data, while an embedded chart is saved on a separate spreadsheet.
C. An embedded chart is saved on the same sheet of the workbook as its associated data, while a chart sheet is saved on a separate spreadsheet.

Answer 73

B. A chart sheet is saved on the same sheet of the workbook as its associated data, while an embedded chart is saved on a separate spreadsheet.

Answer 74

Which of these is a benefit of using the Sort option?
A. It helps you correct any spelling errors made in your spreadsheet.
B. It helps you retrieve only the necessary information.
C. It helps you systematically arrange your data.

Answer 75

C. It helps you systematically arrange your data.

Answer 76

In which of these scenarios is it appropriate to use the custom AutoFilter option "greater than or equal to"?
A. Ben has a spreadsheet recording his scores on every test. He now wants to look at subjects in which his score is more than 75.
B. Mrs. Parker needs information on all of the club members who are 60 years and older. She has to send them invitations to the party for senior members.
C. Mia is going to buy a new car and wants all of the necesssary information on a particular car. She is searching a car database to find it.

Answer 77

B. Mrs. Parker needs information on all of the club members who are 60 years and older. She has to send them invitations to the party for senior members.

Answer 78

Mr. Green maintains a spreadsheet containing data on all of his employees, including name, job profile, monthly salary, and home address.
Which of the following options will best help him find information on all the employess working on the technology team?

A. sorting the data by the names of the employees
B. performing a custom filter based on job profile
C. sorting the data first by name and then by job profile

Answer 79

B. performing a custom filter based on job profile

Answer 80

Percentage Correct of Total: 85% (17 / 20)
Percentage Answered of Total: 100% (20 / 20)
Percentage Correct of Answered: 85% (17 / 20)

Answer 81

:) sort of better

Answer 82

Is it all?

Answer 83

bro are u gonna be here tomorrow?

Answer 84

Yep, I'm on spring break!

Answer 85

If you want we can start over, to get better result!

Answer 86

alright hold on

Answer 87

Not right now, though!

Answer 88

Do you have some notes, lecture so I can look over the part we loosing points?