What tool would stop the words in cell a55 from overflowing into cell b55?

1. Documents
2. Teaching Methods & Materials
3. Mathematics

Download now

Jump to Page

Search inside document

What’s the correct sorng funcon to list Colors in alphabecal order (A to Z)

ColorNumber

Blue120A to Z = ASCENDINGGreen85Z to A = DESCENDINGOrange112EQUAL to A to ZRed100Yellow901)What does clicking the + sign below do?a.Adds a new Worksheetb.Adds a new Rowc.Adds a new Chartd.Adds a new Funcone.Adds a new Column2)What is the correct keyboard shortcut to cut a cell value?a.CTRL + Pb.CTRL + Xc.CTRL + Bd.CTRL + Ce.CTRL + V3)In a new worksheet, what’s the correct formula to reference Cell A1 from the ALPHA worksheet?a.=ALPHA?A1b.=A1c.=ALPHA!A1d.=”ALPHA”A1e.=’ALPHA’A14)Based on the values in Cells B77:B81, what funcon can automacally return the value in Cell C77?

A

8

Sales

 9$794 $1,020 =MAX(A9:A13)'a.

=Top()10$721 b.

=Max()11$854 c.

=Ceiling()12$912 d.

=Biggest()13$1,020 e.

=Highest()5)What does clicking and dragging the ll handle indicated by the cursor do?

SalesTax

 $794$64a. Move this formula to a new cell$721$58b.

Copy this number to other cells$854 c.

Move this cell to another locaon$912 d.

Fill this cell with a color$1,020

e.

Copy the formula to another cell

6)What value would be returned based on the formula in Cell A49?

A43

npaba. 0

44

npceb.

1

45

npfoc. 2

46

npbbd.

3

47

norp

e.

4

=COUNTIF(B9:B13,"NP*")'7)Which tools would you use to make header 1 look like Header 2? Select all that apply.

ABC

First NameLast NameRSVP 

First NameLast NameRSVP

8)Based on the values in Cells B77:B81, which funcon can automacally return the value in Cell C77?

AB2Sales

 3$794 $721

=MIN(A2:A6)a. =Min()

4$721 b. =Boom()5$854 c. =Smallest()6$912 d. =Lowest()7$1,020 e. =Floor()9)Which tools would you use to make Chart 1 look like Chart 2? Select all that apply.

Chart 1Chart 2 AA1Sales Growth

Sales Growth

2

0.19

 19%

3

0.25

 25%

4

0.49

 49%

5

0.29

 29%

6

0.34

 34%

7

0.22

 22%

8

0.12

 12%

10)What formula would produce the value in Cell C25?

 ABC22ItemTypeResulta. '=RIGHT(B23,C26)23

DoorFDoor F

=CONCATENATE(B23," ",C23)b. '=CONCATENATE(ITEM," ",TYPE)24

TableC

c. '=LEFT(B23,C23)25

ChairC

d. '=CONCATENATE(B23,C23)26

DeskF

e. '=CONCATENATE(B23," ",C23)

11)What value would be returned based on the formula in Cell D49?

DEF 

42RoomLocaonSta ID

 a. 0

43

DEast19106 b. 1

44

CNorth19122 c. 2

45

ASouth19107 d. 3

46

ESouth19104 e. #ERROR

47

BSouth19147 f. #VALUE

48

=COUNTIFS(C30:C34,"South",D30:D34,"19104")12)Which tools would you use to make Chart 1 look like Chart2

Share this document

Share or Embed Document

Sharing Options

• Share with Email, opens mail client

Footer menu

About

• About Scribd
• Press
• Our blog
• Join our team!
• Contact us
• Invite friends
• Gifts
• Scribd for enterprise

Support

• Help / FAQ
• Accessibility
• Purchase help
• AdChoices
• Publishers

Legal

• Terms
• Privacy
• Copyright
• Do not sell or share my personal information

Social

• Instagram Instagram
• Twitter Twitter
• Facebook Facebook
• Pinterest Pinterest

Get our free apps

About

• About Scribd
• Press
• Our blog
• Join our team!
• Contact us
• Invite friends
• Gifts
• Scribd for enterprise

Legal

• Terms
• Privacy
• Copyright
• Do not sell or share my personal information

Support

• Help / FAQ
• Accessibility
• Purchase help
• AdChoices
• Publishers

Social

• Instagram Instagram
• Twitter Twitter
• Facebook Facebook
• Pinterest Pinterest

Get our free apps

• Books
• Audiobooks
• Magazines
• Podcasts
• Sheet Music
• Documents
• Snapshots

Language:

close menu

• English(selected)
• Español
• Português
• Deutsch
• Français
• Русский
• Italiano
• Română
• Bahasa Indonesia

Copyright © 2022 Scribd Inc.

Language:

close menu

• English(selected)
• Español
• Português
• Deutsch
• Français
• Русский
• Italiano
• Română
• Bahasa Indonesia

Copyright © 2022 Scribd Inc.

Quick navigation

• Home

• Books

• Audiobooks

• Documents

  , active