NEW
Font size
S
M
L
XL
WorksheetsExcel Basics
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
A(n) Excel ___ allows data to be easily summed and charted.
a)
worksheet
b)
format
c)
table
d)
display
2.
A ___________ conveys a visual representation of data.
a)
chart
b)
picture
c)
text box
d)
style
3.
_____ are vertical.
a)
Rows
b)
Columns
4.
________ are horizontal
a)
Rows
b)
Columns
5.
A(n) _________ is a prewritten formula that is built into EXCEL.
a)
function
b)
problem
c)
equation
d)
equal sign
6.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell address
b)
Worksheet
c)
Formula
7.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
8.
A3 is an example of a cell's address
a)
true
b)
false
9.
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
a)
Insert
b)
Formula bar
c)
Tables
10.
What would be a correct formula for sum in excel?
a)
=SUM(B3:B9)
b)
=SUMB3+B9
c)
SUM(B3:B9)
d)
=ADD(B3:B9)
11.
To create a formula, you first:
a)
Select the cell you want to place the formula into
b)
Type the equals sign (=) to tell Excel that you're about to enter a formula
c)
Enter the formula using any input values and the appropriate mathematical operators that make up your formula
d)
Choose the new command from the file menu
12.
How do you select an entire column?
a)
Select Edit > Select > Column from the menu
b)
Click the column heading letter
c)
Hold down the shift key as you click anywhere in the column.
d)
Hold down the Ctrl key as you click anywhere in the column
13.
The ______ feature works behind the scenes, correcting common mistakes when you complete a text entry in a cell.
a)
Autorepair
b)
Autocheck
c)
Grammar
d)
Autocorrect
14.
A formula is a combination of numbers and symbols used for calculations
a)
TRUE
b)
FALSE
15.
The cell in your worksheet that has been selected. It will have bolder gridlines around it.
a)
TRUE
b)
FALSE
16.
What allow quickly apply the content for one cell to another cell?
a)
Active cell
b)
Autocell
c)
Auto sum
d)
Auto Fill
17.
What is a worksheet?
a)
A "page" within an Excel workbook that contains columns rows and cells
b)
Homework
c)
Something you get at school
d)
All wrong
18.
What do you call the blank boxes on a spreadsheet?
a)
cells
b)
info
c)
squares
d)
spots
19.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
20.
Which tab in Excel has charts and tables?
a)
review
b)
home
c)
file
d)
insert
Reset
