wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Formulas in Excel

Total questions: 37

Worksheet time: 19mins

Name
Class
Date
1.
In the picture, why is D2 through D5 placed in paranthesis?
a)
So Excel knows to total the cells before performing the next operation.
b)
So the total of the cells can be multiplied rather than added.
2.
If the parenthesis is removed, what will 9.5% be multiplied by? 
a)
D2 +D3+D4+D5
b)
D5
c)
D2
d)
None
3.
Which response best completes the following statement: A formula is used to 
a)
perform calculations or other actions.
b)
find averages.
4.
Cell value references should always be used when possible to avoid having to make multiple updates when one key value changes.
a)
True
b)
False
5.
Excel follows the ___________________ and first adds the values inside the parentheses.
a)
Order of Operations
b)
Formula Guidelines
6.
___________ are often the best way to define which calculations will be performed first in Excel.
a)
Parentheses
b)
Forumlas
7.
By default, all cell references are _________ references. 
a)
Absolute
b)
Relative
8.
Unlike _________ references, _________ references do not change when copied or filled. 
a)
Absolute, Relative
b)
Relative, Absolute
9.
An absolute reference is designated in a formula by the addition of a _______ sign. 
a)
%
b)
$
c)
&
d)
#
10.
The LOOKUP function in Excel is used to search one column of data and find data in the _______ row
a)
Corresponding
b)
Value
11.
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)
12.
Which button can you click to add up a series of numbers?
a)
The autosum button
b)
The Formula button
c)
The quicktotal button
d)
The total button
13.
Which formula gets the biggest value of a range of cells?
a)
MAX
b)
MIN
c)
LARGE
d)
SUM
14.
Which formula gets the smallest value of a range of cells?
a)
MAX
b)
MIN
c)
SMALL
d)
SUM
15.
Which symbol must all formula begin with?
a)
=
b)
+
c)
(
d)
@
16.

Which tab contains the tool "Freeze Panes"?

a)

Home

b)

Page Layout

c)

View

d)

Review

17.
_____ are vertical. 
a)
Rows
b)
Columns
18.
________ are horizontal
a)
Rows
b)
Columns
19.
A combination of numbers and symbols used to express a calculation. Always begins with an = sign.
a)
Cell address
b)
Worksheet
c)
Formula
20.
Excel allows you to
a)
read stories
b)
work with data
c)
invent ideas
21.
A command line above the worksheet where text, numbers, and formulas are entered into a worksheet.
a)
Insert
b)
Formula bar
c)
Tables
22.

What is the "Active Cell" in Excel?

a)

The Bottom cell in a worksheet. It is indicated by a dark border onscreen.

b)

The current cell in a worksheet. It is indicated by a dark border onscreen.

c)

The top cell in a worksheet. It is indicated by a dark border onscreen.

d)

The past cell in a worksheet. It is indicated by a dark border onscreen.

23.

Define Cell?

a)

The dark bordered box in excel.

b)

A box in Excel that has formulas.

c)

The intersection of a column or row in a worksheet or table.

d)

Fx Bar where you input data.

24.

Define Formula Bar?

a)

I don't know

b)

I don't care

c)

Don't miss this one!

d)

An element in Excel that appears below the Ribbon and to the right of the Insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function.

25.

What is a spreadsheet?

a)

An electronic file that contains a grid of columns and rows to organize related data and to display results of calculations.

b)

An electronic file that contains a grid of negatives and positives to organize related data and to display results of calculations.

c)

An electronic file that contains a grid of numbers and data to organize related data and to display results of calculations.

d)

An electronic file that contains a grid of pages and sheets to organize related data and to display results of calculations.

26.

When you open Excel you are viewing Excel in the ____ View?

a)

Backstage

b)

Frontstage

c)

Spreadsheet

d)

Template

27.

Excel spreadsheets that are already created and ready for you to edit are known as?

a)

spreadsheets

b)

templates

c)

data inputs

d)

pages

28.

To quickly add a set of number you can use the ____ feature?

a)

Plus Sum Button

b)

Add Sum Button

c)

Quick Add Button

d)

Auto Sum Button

29.

Where is the zoom function located in Excel?

a)

Bottom right of spreadsheet document

b)

Bottom left of spreadsheet document

c)

Top right of spreadsheet document

d)

Top left of spreadsheet document

30.
Where rows and columns meet are referred to as
a)
Blocks
b)
Cells
c)
Boxes
31.
A spreadsheet is a document that stores data in a grid of horizontal rows and vertical columns.
a)
Row
b)
Spreadsheet
c)
Minus
d)
Plus
32.
the largest number =MAX(the first cell address:then the second cell address) For Example: =MAX(C1:C33)
a)
Average
b)
Minimum 
c)
Filter
d)
Maximum 
33.
Completes previously typed words when you begin to repeat the typing. 
a)
AutoFill
b)
#Name?
c)
Column charts
d)
Pie Charts
34.
Tells excel to include all the cells between the two endpoints. A1:D1
a)
Range
b)
sort
c)
Cell
d)
Colon
35.
Error in your formula
a)
#div/0!
b)
AutoFill
c)
#name?
d)
Columns 
36.
the sum of all numbers divided by the amount of numbers. 
a)
Maximun
b)
Minimum 
c)
Median
d)
Average
37.
What does this mean "######'?
a)
column is not wide enough
b)
column is missing numbers
c)
column is showing an error
d)
column is too narrow

Similar Resources on Wayground

Impresión en Excel

35 questions

Impresión en Excel

quiz

Worksheet

•

12th Grade

Microsoft Teams

36 questions

Microsoft Teams

quiz

Worksheet

•

9th - 12th Grade

Midterm Exam Review

35 questions

Midterm Exam Review

quiz

Worksheet

•

12th Grade

Ujian Praktek TIK (PTS) Kelas 7

35 questions

Ujian Praktek TIK (PTS) Kelas 7

quiz

Worksheet

•

12th Grade

Trombone Slide positions and Notes

35 questions

Trombone Slide positions and Notes

quiz

Worksheet

•

6th - 8th Grade

FUNCIONES EN EXCEL

35 questions

FUNCIONES EN EXCEL

quiz

Worksheet

•

12th Grade

Hoja de Cálculo Aplicado

33 questions

Hoja de Cálculo Aplicado

quiz

Worksheet

•

11th Grade

KIỂM TRA HỌC KÌ II MÔN TIN HỌC 7

40 questions

KIỂM TRA HỌC KÌ II MÔN TIN HỌC 7

quiz

Worksheet

•

7th Grade