stud
bud
Sign up
Log in
Home
Library
Explore
SAT
More
MS Excel Review Flashcards | StudBud
Explore
/
MS Excel Review
MS Excel Review
31 terms
·
StudBud Administration
·
50 plays
MS Excel Review
Flashcards
31 cards
F
Practice quiz
P
Host live
L
Questions
31
Answers
1
A series of related worksheets within the same file is called ________.
Page
Workspace
Working Document
Workbook
2
Use this tool or menu to arrange data in a worksheet in a particular order.
Data, Sort
Data, Subtotals
Data, Form
Data, Table
3
This symbol represents what mathematical operation in Excel?
Subtraction
Addition
Multiplication
Division
4
When this symbol appears in a cell of a worksheet it means this.
Misspelled Words
A Wrong Value
Not enough space in cell
5
This is best used when data can be categorized or averaged making simplistic & easy figures.
Images
Lines
Charts
Circles
6
In Excel, columns are identified by the use of this.
Numbers
Letters
7
In Excel, you can sum a large range of data by simply selecting a tool button called this.
Auto Format
Auto Sum
Auto Fill
Auto Correct
8
In MS Excel, copying and pasting is done the same as MS Word.
True
False
9
Choose the name of the cell range being displayed.
F11-C5
F11:C5
C5:F11
C5-F11
10
This symbol must be typed first in order for Excel to know that you are using a formula.
+
Fx
=
Number
11
The menu command used to wrap text in a cell.
Format, Cells, Protection
Format, Cells, Number
Format, Cells, Font
Format, Cells, Alignment
12
Rows go in what direction?
Horizontal
Vertical
13
A single page in a spreadsheet program is called ______ .
Worksheet
Workbook
Working Document
Workspace
14
This symbol that represents what mathematical operation in Excel.
Subtraction
Subtraction
Addition
Multiplication
15
Which of thefollowing formulas is not entered correctly?
=B7*B1
=B7+14
=50+10
10+50
16
You are able to open, save, rename and close a file in Excel as you would in Word.
False
True
17
MS Excel can create the following products.
Databases
Budgets
All of these
Charts & Graphs
18
The intersection of a row and a column is called _______.
Space
Orifice
Rectangle
Cell
19
Which area in the Excel window toolbar allows you to enter formulas?
Menu Bar
Standard Bar
Formula Bar
Title Bar
20
This usually focuses on raw data, showing trends & changes over a period of time.
Lines
Circles
Sheet
Graph
21
This first cell in a worksheet is Excel is what?
A0
0A
1A
A1
22
MS Excel displays the current cell address in this area.
Name Box
Formula Bar
Title Bar
Status Bar
23
A program using a table comprised of rows, columns and cells.
spreadsheet
word processor
media
presentation
24
To edit something on a worksheet you need to select this first.
Columns
Rows
Data/Cell Range
Worksheet
25
In Excel, rows are identified by this.
Letters
Numbers
26
This is defined by a bold border around the cell walls.
Active Column
Active Worksheet
Active Cell
Active Row
27
Name the cell in this image.
3C
C
3
C3
28
This symbol represents what mathematical operations in Excel?
Addition
Multiplication
Division
Subtraction
29
Columns go in what direction?
Vertical
Horizontal
30
This symbol represents what mathematical process in Excel?
Division
Subtraction
Addition
Multiplication
31
Which is "NOT" a term used in MS Excel?
Workbook
Cell
Worksheet
Document