Excel Basics – Questions & Answers

These flashcards cover the key concepts and questions from the lecture on Excel basics.

What is the difference between a worksheet and a chart sheet?

Worksheets contain cells arranged in rows and columns, while chart sheets display only a chart with no visible cells.

What is the cell reference for the cell located in the fourth column and fifth row?

D5

How do you reference the range of cells from A10 through D15?

A10:D15

How do you reference the ranges A10 through C20 and A22 through C32?

A10:C20, A22:C32

What happens to the text in cell A3 if it exceeds the cell’s width and the next cell is empty?

The text spills over into the next empty cell.

What happens to the text in cell A3 if the next cell contains content?

The text is cut off.

What numeric value is stored in cell B10 if it contains 75%?

0.75

Is the date May 3, 2029 stored as a text string or a number in cell C10?

It is stored as a number.

What does a series of hashtag symbols (#####) in a cell indicate?

The column is too narrow to display the full value.

What formula adds the values in cells A1, B1, and C1 without using a function?

=A1+B1+C1

What formula sums the values in cells A1 to C1 using a function?

=SUM(A1:C1)

What formula counts the number of numeric values in the range A1:A30?

=COUNT(A1:A30)

What formula counts both numeric and text values in the range A1:A30?

=COUNTA(A1:A30)

If you insert cells into the range C1:D10 shifting cells to the right, what is the new location of data originally in F4?

H4

How is the formula in cell E11 adjusted when a new row is inserted above row 5?

It becomes =SUM(E1:E11).

In the AVERAGE function, what are the required and optional arguments?

Required: number1. Optional: number2, number3, etc.

What formula sums all numeric values in column E?

=SUM(E:E)

What is the difference between deleting a range and clearing a range?

Deleting removes the cells and shifts others, while clearing removes only the contents.

What are the four ways of viewing worksheet content in Excel?

Normal View, Page Layout View, Page Break Preview, and Full Screen/Reading View.