WorksheetsKey Applic. Tutorial
Total questions: 31
Worksheet time: 16mins
Name
Class
Date
1.
If You were going to specify the Print Area in an Excel document, which tab would you select?
a)
Page Layout
b)
Insert
c)
File
d)
View
2.
Which of these choices is the file extension for all Excel documents?
a)
.docx
b)
.xlsx
c)
.pptx
d)
.mdbx
3.
Which of the following would be a spreadsheet file?
a)
sales.accdb
b)
sales. pptx
c)
sales.xlsx
d)
sales.docx
4.
What is the BEST way to select all cells in a specific row? Where would you click?
a)
Select all cells in that row and click on them
b)
Click in the column on the far left that has row numbers in it to select all of the cells in that row
5.
By default, how many blank worksheets does Excel provide when you open a new workbook?
a)
0
b)
1
c)
2
d)
3
6.
In this image
which color
would let
you select all
cells in the
worksheet?
which color
would let
you select all
cells in the
worksheet?
a)
Red
b)
Yellow
c)
Green
d)
Blue
7.
In this image
what is the
name of the
worksheet?
what is the
name of the
worksheet?
a)
Contoso School
b)
Students
c)
Teachers
d)
Classroom 1
8.
Which tab would you click to save an Excel spreadsheet and send it as an email attachment?
a)
Home
b)
File
c)
Review
d)
View
9.
Which button in
this image would
you click
to change the
height of a row?
this image would
you click
to change the
height of a row?
a)
Conditional Formatting
b)
Format as a Table
c)
Format
d)
Find and Select
10.
If you wanted to delete an entire row of data in a spreadsheet, you could begin with which of these steps?
a)
Click on File tab
b)
Right click your mouse on the row
c)
Click delete
11.
Which of the
selections is
a text cell?
selections is
a text cell?
a)
Red
b)
Blue
c)
Yellow
d)
Green
12.
Which of the
selections is
a calculated
value cell?
selections is
a calculated
value cell?
a)
Red
b)
Green
c)
Blue
d)
Yellow
13.
Which of the
selections is
a number cell?
selections is
a number cell?
a)
Red
b)
Blue
c)
Yellow
d)
Green
14.
Which of the
selections is
a date cell?
selections is
a date cell?
a)
red
b)
blue
c)
yellow
d)
green
15.
If you needed to change the numbers in a column to dollars, you would format the cell as a _______ cell.
a)
currency
b)
scientific
c)
special
d)
number
16.
To change the format of data in a cell, you would first have to _______ the data.
a)
Delete
b)
Save
c)
Select
17.
In this image,
which button
would you use
to select All
Borders?
which button
would you use
to select All
Borders?
a)
The black letter B
b)
Format Painter
c)
The four-square button
18.
Which button
lets you change
the color of
the cell's
background?
lets you change
the color of
the cell's
background?
a)
The one with A
b)
The paint bucket
19.
Under which tab should you look for help in changing the style of your cells?
a)
Home
b)
Insert
c)
Design
d)
Page Layout
20.
Can you print only a small selection of cells in a spreadsheet, or do you have to print the whole spreadsheet?
a)
Yes, just select the cells you want to print.
b)
No, that's impossible
21.
Under which tab could you find an option for printing your spreadsheet WITH the gridlines showing?
a)
Data
b)
Formulas
c)
Insert
d)
Page Layout
22.
Which of these is a common use of spreadsheets?
a)
Creating budgets
b)
Writing a report
c)
document statistics
d)
grammar check
23.
In this image
which button
would allow
you to sort your
data in ascending
order?
which button
would allow
you to sort your
data in ascending
order?
a)
Conditional Formatting
b)
Auto Sum
c)
Sort & Filter
24.
True or false: In a custom sort you can sort by more than one criteria.
a)
True
b)
False
25.
The Auto Filter option which is under Sort & Filter allows you to select only certain bits of data automatically.
a)
True
b)
False
26.
What symbol would you insert into a cell's formula to change the reference for that cell to absolute column and absolute row?
a)
#
b)
$
c)
&
d)
@
27.
Which of these is a correct way of typing a formula that adds the data for a whole column of cells?
a)
sum=(A1+A5)
b)
=sum(A1:A5)
c)
=sum(A1-A5)
28.
Which of these is a correct way of typing a formula that averages the data for a whole column of cells?
a)
=average(A1-A5)
b)
average(A1:A5)=
c)
=average(A1:A5)
29.
If you want to add the numbers in a column in one step, you could select the cell where you want the sum to appear and click __________.
a)
Sort
b)
Auto Sum
c)
Insert Sum
30.
Replacing "sum" with "min" in the formula =sum(C4:C17) would calculate the smallest value.
a)
True
b)
False
31.
Replacing "sum" with "max" in the formula =sum(C4:C17) would calculate the highest value.
a)
True
b)
False
100 %
