You can do this to the row and column titles to make larger worksheets easier to read. The titles will stay still while you scroll through the document. - PowerPoint PPT Presentation

Loading...

PPT – You can do this to the row and column titles to make larger worksheets easier to read. The titles will stay still while you scroll through the document. PowerPoint presentation | free to download - id: 68fe31-YjhjM



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

You can do this to the row and column titles to make larger worksheets easier to read. The titles will stay still while you scroll through the document.

Description:

You can do this to the row and column titles to make larger worksheets easier to read. The titles will stay still while you scroll through the document. – PowerPoint PPT presentation

Number of Views:3
Avg rating:3.0/5.0
Date added: 23 July 2019
Slides: 38
Provided by: hstea5
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: You can do this to the row and column titles to make larger worksheets easier to read. The titles will stay still while you scroll through the document.


1
You can do this to the row and column titles to
make larger worksheets easier to read. The
titles will stay still while you scroll through
the document.
  • Freeze the panes

2
Values in cells that you can change to determine
new values for formulas.
  • assumptions

3
This feature allows you to check which cells are
referenced in an active cells formula.
  • Range finder

4
How many spaces does the Increase Indent button
move the cursor in each time you click it?
  • 3

5
A reserved place in the computers memory that
allows you to collect text and graphic items to
be pasted into any document.
  • Office Clipboard

6
Using the mouse to move or copy cells. (d d)
  • Drag and drop

7
This clears the data from the cell, but the cells
remain in the worksheet.
  • clearing

8
This erases all the data and the cell itself and
the rows and columns adjust.
  • delete

9
What does HREF! Indicate?
  • A cell reference error

10
This date function inserts the current date and
time, following the system date set in your
computer.
  • NOW function

11
What kind of cell reference is B20? (absolute
or relative)
  • absolute

12
What does an absolute cell reference mean?
  • If the cell is copied, the formula stays the same

13
What does a relative cell reference mean?
  • When you copy a formula, it automatically
    readjusts the formulas to different rows or
    columns

14
Which function key can you hit to turn a relative
cell reference into an absolute?
  • F4

15
Use this function when you want to assign a value
to a cell based on a logical test.
  • IF

16
What does ltgt mean?
  • Not equal to

17
Which 2 keys do you hit to display the formula
version of a worksheet?
  • Ctrl and Accent mark

18
DIV/0!
  • Error message tried to divide by zero

19
NAME?
  • Error messageformula uses a name that Excel does
    not recognize

20
N/A
  • Error messagerefers to a value not available

21
NULL!
  • Error messagespecifies an invalid intersection
    of two areas

22
NUM!
  • Error message uses a number incorrectly

23
REF
  • Error messagerefers to a cell that is not valid

24
VALUE
  • Error messageuses an incorrect argument

25
  • Error messagecell is not wide enough to display
    the entire entry

26
A function in which the action to be taken for
the true or false case includes yet another IF
function.
  • Nested IF function

27
How are negative numbers displayed?
  • (in parentheses)

28
What type of information does a Pie Chart show?
  • Relationship of parts to a whole

29
A curve that is applied to soften the appearance
of a straight edge.
  • bevel

30
Exploding a slice of a pie chart to emphasize it.
  • offsetting

31
When you have a formula and some of the numbers
change, the numbers automatically recalculate.
What kind of analysis is this called?
  • What-if

32
When you know the result you want a formula to
produce, you can use this function to determine
the value of a cell on which the formula depends.
  • Goal seeking

33
What kind of dollar sign is this? (floating or
fixed) 500.00
  • Fixed--it always stays in the left corner,
    regardless of length of number

34
What kind of dollar sign is this?500.00
  • floating

35
Which of these is not a valid format symbol?
,

36
What symbol do error messages always start with?

37
Good luck on your test!
About PowerShow.com