Question

A(n) ________ cell reference changes when copied to another cell.
A. reliable
B. concrete
C. relative
D. absolute

Answer 1

@Robert136

Answer 2

Hey there againXD

Answer 3

It's relative that changes

Answer 4

great way to memorize is that your relatives sometimes change due to their mysterious affairs.

Answer 5

thnx :)

Answer 6

relative=relate +tive To relate to someone you need to compromise yourself

Answer 7

you can post your future questions here so less to worry about

Answer 8

ok thnx :) hang on

Answer 9

When writing a function that contains a range of cells in the argument, a ________ is used to create the range.
dash
semicolon
colon
comma

Answer 10

@Robert136

Answer 11

comma is used to create the range. I've written a java program a while ago where I had to insert range values and according to the manual books I used commas and it worked out just fine

Answer 12

thnx :)

Answer 13

Which function would you use to add the values of several cells?
TOTAL
AVERAGE
SUM
MAX

Answer 14

lol SUM up! Thumb up

Answer 15

thnx :)

Answer 16

You can ________ to narrow down the data in your worksheet.
use the Web clipboard
use sorting
merge cells
apply filters

Answer 17

"narrow down" as in filtering or combining cells into a chunk?

Answer 18

English is a crazy language

Answer 19

haha thnx :)

Answer 20

If you wish to sort the data in part of a sheet and NOT the entire sheet, which of the following will give you the desired results?
Sort sheet option
Filter button
Sort range option
Functions button

Answer 21

Hey Miranda that wasn't my answer I asked you

Answer 22

oh lol hahahahaahahah

Answer 23

I don't know whether "narrow down" means to filter(apply filters) or to combine(merging cells)

Answer 24

i dotn know what they mean either

Answer 25

Lol alright then I'd rather you go with "merging cells"

Answer 26

Sort range option for the second question by the way.

Answer 27

thnx :)

Answer 28

how did the test go