Microsoft Excel

Question 1

What is a cell?

Answer 1

a box in an excel worksheet that stores text, formulas, or numbers

Question 2

What is a row? What are they referenced by default?

Answer 2

horizontal line of cells

numbers

Question 3

What is a column? What are they referenced by default?

Answer 3

vertical line of cells

letters

Question 4

What is the difference between a worksheet and workbook?

Answer 4

worksheets contain rows and columns were data can be manipulated

workbook contains worksheets

Question 5

How can you add new rows and columns?

Answer 5

highlight the number you want to create and click insert

rows are added above and columns to the left

Question 6

How can you create a series of numbers from one or more numbers?

Answer 6

Select the starting cell and move the cursor to the bottom right corner, it changes to a ‘+’ , click the fill handle, drag in the desired direction

Question 7

What do the functions, sum, average, count, min, and max do? What about if counterparts?

Answer 7

sum: add up average: take average
count: count up min: find min value
max: find max value

same thing but with a condition

Question 8

How can you write the function y=3x+1?

Answer 8

=cell*3+1

Question 9

What can you use to represent arithmetic operations?

Answer 9

• is multiply, / is divide, ^ is power

Question 10

What is the difference between lookup value, lookup range, and result range?

Answer 10

lookup value is the result you are looking for, lookup range is the row or column with data in ascending order that the lookup function searches, result range is the same size of lookup range and is where the lookup up result could be copied