- Documents
- Teaching Methods & Materials
- Mathematics
Indeed Excel QuizUploaded by
Aziz Hasimmi
82%(49)82% found this document useful (49 votes)
145K views3 pagesDocument Information
click to expand document informationDescription:
Quiz Excel
Original Title
Indeed Excel Quiz.docx
Copyright
© © All Rights Reserved
Available Formats
DOCX, PDF, TXT or read online from Scribd
Share this document
Share or Embed Document
Sharing Options
- Share with Email, opens mail client
Email
Did you find this document useful?
82%82% found this document useful, Mark this document as useful
18%18% found this document not useful, Mark this document as not useful
Is this content inappropriate?
Download now
SaveSave Indeed Excel Quiz.docx For Later
82%(49)82% found this document useful (49 votes)
Indeed Excel Quiz
Original Title:
Indeed Excel Quiz.docx
Uploaded by
Aziz HasimmiDescription:
Quiz Excel
SaveSave Indeed Excel Quiz.docx For Later
82%82% found this document useful, Mark this document as useful
18%18% found this document not useful, Mark this document as not useful
EmbedShare
PrintDownload now
Jump to Page
You are on page 1of 3Search inside document
What’s the correct sorng funcon to list Colors in alphabecal 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 Funcone.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 funcon can automacally 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 locaon$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 funcon can automacally return the value in Cell C77?
AB2Sales
3$794 $721
=MIN(A2:A6)a. =Min()
4$721 b. =Boom()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
42RoomLocaonSta 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.
Home Books Audiobooks DocumentsQuick navigation