Home Library Explore SAT

Home Library Explore SAT

Excel Basics and Beyond! Flashcards | StudBud

Explore/Excel Basics and Beyond!

Columns are

Which of these statements is incorrect for a CELL REFERENCE:

Excel Basics and Beyond!

12 terms·StudBud Administration·48 plays

Quizs! to look at basic Excel terms

Flashcards12 cardsFPractice quizPHost liveL

Questions 12

Answers

1
Which of these statements is incorrect for a CELL REFERENCE:
consists of column letter & row number, in that order
identifies the location of a cell/group of cells
consists of row number & column letter in that order
2
Columns are
identified by letters at top of worksheet
meeting point of two rows
identified by numbers on left of worksheet
3
A workbook is part of a worksheet
true
false
4
A numerical entry can be formatted as
currency
scientific notation
text
a date
5
Excel can not be used to
do calculations
spell check a paper
create graphs &charts
as a database
6
Formulas do NOT include....
titles
constants
pre-defined functions
cell references
7
Functions are predefined formulas that perform calculations by using
mathematical intuition
numbers and letters in a title
user-defined capability
arguments in a particular order
8
You will not find this option in the Cell Formatting box
border
alignment
delete
fill
9
Excel is a useful tool?
true
false
10
A Formula Bar.....
shows data being entered in an active cell
calculates the answer of an equation
11
Which one of these options DOES NOT apply formulas?
calculate numeric values in a cell
always begin with = sign
perform operations only on numbers
performs functions on alphanumeric values
12
Which is NOT a way to change the column or row size
move the double-arrow boundary line
highlight cells in row/column and drag
double click on column/row header
use AutoFit from Home Ribbon