wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

final quiz

Total questions: 75

Worksheet time: 41mins

Name
Class
Date
1.
The feature to center text across several cells is called:
a)
Wrap Text
b)
Merge and Center
c)
Shrink to Fit
d)
Number Formatting
2.
Microsoft Excel is what type of software?
a)
Word Processing
b)
Spreadsheet
c)
Presentation
d)
Drawing
3.
Which of the following operators do you use to begin typing a formula?
a)
*
b)
+
c)
=
d)
/
4.
This icon is called the what?
a)
Arrow
b)
Fill handle
c)
Pointer
5.
For which of the following tasks would you use the fill handle?
a)
to apply shading 
b)
to apply a border
c)
to copy a formula from cell A2 to cell A3
6.
Rows are which of the following:
a)
vertical
b)
horizontal
7.
Columns are vertical.
a)
True
b)
False
8.
What does every formula or function start with?
a)
!
b)
@
c)
#
d)
=
9.
What is the formula to find the lowest number in cells C1:C4?
a)
=average(C1:C4)
b)
=max(C1:C4)
c)
=min(C1:C4)
d)
=sum(C1:C4)
10.
What instructs the software to perform a calculation?
a)
value
b)
label
c)
formula
11.
What is the Order of Operations?
a)
PEDMAS
b)
PSMADE
c)
PMSADE
d)
PEMDAS
12.
Place where you can rename each worksheet.  Located at the bottom of the worksheet window.
a)
Sheet tab
b)
Formula
c)
Name Box
d)
Chart
13.
An excel file with one or more worksheets
a)
Workbook
b)
Worksheet
c)
Formula
d)
Row
14.
What does this symbol do:
*
a)
Multiply
b)
Add
c)
Divide
d)
Minus
15.
What does this symbol do:
/
a)
Multiply
b)
Add
c)
Divide
d)
Minus
16.
The quickest way to find a total in Excel is by using __________.
a)
AutoTotal
b)
AutoSum
c)
AutoAdd
d)
AutoPlus
17.
Which option shows the fill handle?
a)
A
b)
B
c)
C
d)
D
18.
_________ allows you to perform calculations on data entered into a spreadsheet?
a)
Formulas
b)
Data
c)
Cell
d)
Cell reference
19.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
d)
create presentations
20.
What does Excel need to see in order to use auto-fill?
a)
cells
b)
numbers
c)
a pattern
d)
words
21.
To resize columns, double click between column letters
a)
true
b)
false
22.
The cell in a worksheet that has been selected. It will have bolder gridlines around it.
a)
Active cell
b)
Cell address
c)
Specific cell
23.
In a worksheet, the vertical spaces with letter headings.
a)
Rows
b)
Cell addresses
c)
Columns
24.
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
a)
Insert
b)
Formula bar
c)
Tables
25.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell address
b)
Worksheet
c)
Formula
26.

How is the COLUMN in a MS Excel Spreadsheet named?

a)

Numbers

b)

Letters

c)

Cells

d)

Columns

27.

How are ROWS in MS EXCEL spreadsheet named?

a)

numbers

b)

letters

c)

cells

d)

columns

28.

What is one way to ADD a Range of rows and columns in MS EXCEL other than using the + symbol.

a)

SUMMING

b)

SUM

c)

ALL

d)

None at all

29.

What is an EXCEL Spreadsheet used to make?

a)

Calendar

b)

Publisher

c)

Graph

d)

Card

30.

What is an example of a RANGE in MS Excel.

a)

B2-F5

b)

F5:B2

c)

B2:5F

d)

(B2:F5)

31.

Which Formula is written correctly for multiplying cell A1 and A7?

a)

=A1+A7

b)

=A1*A7

c)

A1+A7

d)

A1*A7

32.

When is a MS Excel Spreadsheet used?

a)

Making a Drawing

b)

When Reading

c)

For Collecting Information

d)

For Baking a Cake

33.

What format would you use to change the number in a cell to have a $ (dollar sign)?

a)

Currency

b)

Percent

c)

Color

d)

Dollars

e)

Decimal

34.

When printing a workbook, which feature would you use to change the page to landscape?

a)

A

b)

B

c)

C

d)

D

e)

E

35.

Is AutoSum a function?

a)

Yes

b)

No

36.
How do you insert a new row?
a)
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
b)
Select the row heading where you want to insert the new row and select Edit >Row from the menu
c)
Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar
d)
All of the above
37.
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
38.
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)
39.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
40.
In a cell reference, for example A1, what does the letter refer to?
a)
The column
b)
The cell
c)
The row
41.
A cell name contains
a)
Cell name
b)
Column numbers and row letters
c)
Column letters and row numbers
d)
Cell locator coordinates
42.
In Excel rows are labeled by
a)
letters
b)
numbers
c)
rows and numbers
43.
In excel, columns are labeled by
a)
Letters
b)
Numbers
c)
Letters and numbers
44.
Excel refers to files as
a)
Documents
b)
Workbooks
c)
data bases
45.

What kind of software is Excel?

a)

Database

b)

Spreadsheet

c)

Word Processing

d)

Desktop Publishing

46.

In Excel rows are labeled by

a)

Numbers

b)

Letters

c)

Letters and numbers

d)

Pictures

47.

In Excel columns are labeled by

a)

Numbers

b)

Letters

c)

Letters and numbers

d)

Pictures

48.

Excel is part of

a)

Microsoft Office

b)

Access

c)

PowerPoint

d)

Google

49.

Excel would be the ideal program to plan an budget.

a)

True

b)

False

50.
What does this button do? 
a)
adds cells together
b)
multiplies cells together
51.
Where is the formula bar located? 
a)
Top of screen
b)
Bottom of screen
c)
There is a formula bar? 
d)
Cyberspace
52.

What should a formula always start with?

a)

+

b)

-

c)

=

d)

@

53.

How to we add gridelines to our print out?

a)

Click page set up

b)

Click print

c)

Click landscape

d)

What are gridelines?

54.

What tab do we need to click on to add a chart

a)

Home

b)

File

c)

Insert

d)

Design

55.

How do we print in formula view?

a)

Click formula then show formula

b)

Click insert then show formula

c)

click ctrl + c

d)

click file then print as it does it automatically

56.

Why would you want to change the column width?

a)

To draw attention to the data in those cells.

b)

To make sure the column headings are always visible when scrolling.

c)

To make sure all of the information in the column is visible

57.
What is a cell?
a)
a period during which a retailer sells goods at reduced prices
b)
the smallest structural and functional unit of an organism
c)
a small room in which a prisoner is locked up
d)
an intersection of a row and column
58.
What happens when you delete the entire cell? 
a)
The cells below it will shift to fill in the gaps and replace the deleted cells.
b)
The cells above it will shift to fill in the gaps and replace the deleted cells.
c)
The cells left of it will shift to fill in the gaps and replace the deleted cells.
d)
The cells right of it will shift to fill in the gaps and replace the deleted cells.
59.
If I want to insert a column between columns A and B, which column do I select before using the Insert command?
a)
B
b)
A
c)
A and B
d)
neither
60.
What do number formats do? 
a)
They tell Excel what type of font to use.
b)
They tell Excel exactly what type of data you are using.
c)
They tell Excel what language to use.
d)
They tell Excel what color font to use.
61.

A represents:

a)

Criteria

b)

Cells

c)

Column

d)

Range

62.
True or False.  If you choose a larger font size, the height of the row is automatically made taller.
a)
True
b)
False
63.
How many columns are there in an Excel worksheet?
a)
251
b)
253
c)
256
d)
254
64.
What is the extension of Excel files?
a)
.xl
b)
.xlss
c)
.xlsx
d)
.xlx
65.
Boundary of the selected cell is known as-
a)
Cell activator
b)
Cell pointer
c)
Cell address
d)
Column letter
66.

Look at the picture. What tool is in number 4 called?

a)

Fill color

b)

Font color

c)

Border

67.

Spreadsheets can be used in everyday life by analyzing sports stats, grades, and creating a budget for expenses.

a)

True

b)

False

68.

When making a chart, what is the first thing you need to do?

a)

Highlight your data being used.

b)

Double click the active cell

c)

Pick the type of Graph

69.

When making a chart, you always highlight the entire spreadsheet.

a)

True

b)

False

70.

A Graphic representation of data. A circle is divided into sectors which shows a percentage of a whole.

a)

Column Chart

b)

Bar Chart

c)

Pie Chart

71.

A Graphic representation of data. The bar can be Vertical or Horizontal, but a vertical graph is also known as a column chart.

a)

Bar Chart

b)

Pie Chart

c)

Line Chart

72.

What type of chart is this?

a)

Column chart

b)

Bar chart

c)

Line chart

73.

What is the difference between Workbook and a worksheet?

a)

A workbook is the actual file that contains the worksheets, which turn contain the data.

b)

The worksheets contain the data and the workbook contains the tabs for each data type.

c)

A workbook is a section that contains the worksheet reports; both are contained in a spreadsheet.

d)

There is no difference other than which term you prefer to use for spreadsheets.

74.

Why might you prefer to apply a background color to a cell instead of applying a pattern

a)

There is a limited number of patterns to choose.

b)

Patterns can make it harder to read the data than using a solid color.

c)

You can choose a lighter color whereas all patterns are dark in design.

d)

Patterns should only be used with cells that have formulas.

75.

What does criteria range in a formula refer to?

a)

The worksheet data to be included in the formula's results

b)

The range containing a condition that must be met in order for data to be included in the result

c)

The type of formula being used for the calculation

d)

The type of data contained in the cells to be included in the formula

Similar Resources on Wayground

Diagnostic test

80 questions

Diagnostic test

quiz

Worksheet

•

11th Grade

PC Pro Unit 8

71 questions

PC Pro Unit 8

quiz

Worksheet

•

12th Grade

Usabilidad_3

75 questions

Usabilidad_3

quiz

Worksheet

•

University

Химия 3 сессия

70 questions

Химия 3 сессия

quiz

Worksheet

•

University

Diagnostico de aprendizaje Hardware y software BG cam

74 questions

Diagnostico de aprendizaje Hardware y software BG cam

quiz

Worksheet

•

Professional Development

Generalidades Informatica

72 questions

Generalidades Informatica

quiz

Worksheet

•

University

Normas de seguridad

80 questions

Normas de seguridad

quiz

Worksheet

•

10th Grade

EXCEL BACHILLERATO

79 questions

EXCEL BACHILLERATO

quiz

Worksheet

•

1st - 11th Grade