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