Worksheetsexcel, block3
Total questions: 7
Worksheet time: 4mins
Name
Class
Date
1.
To modify or undo Flash Fill you must -
a)
Exit out of Excel
b)
Click the Back Arrow at the top left of the screen
c)
click the Flash Fill button next to recently added Flash Fill data
d)
Delete the 1st cell and the rest will automatically reset it to the original format
2.
What keyboard command do you use to create a new table?
a)
Ctrl-W
b)
Ctrl-T
c)
Ctrl-R
d)
Ctrl-P
3.
What Is a VLOOKUP function used for?
a)
To find a value in the spreadsheet.
b)
To add a column to a datasheet from some other table based
on some unique (attribute) s.
on some unique (attribute) s.
c)
To find the answer to every problem.
d)
To get a Function and solve it.
4.
What does Ctrl+A do on a excel spread sheet?
a)
Highlights the left half of the spreadsheet
b)
Highlights the right half of the spreadsheet
c)
Highlights the bottom half of the spreadsheet
d)
Highlights the whole spreadsheet
5.
How many colors are in the Nyan cat rainbow?
a)
5
b)
9
c)
4
d)
7
6.
What color was the Pac Man you created?
a)
purple
b)
blue
c)
red
d)
yellow
7.
What is the name of the button to have quick commands?
a)
Quick Toolbar
b)
Customize Quick Access Toolbar
c)
Customize Quick Toolbar
d)
Easy Toolbar
100 %
