Week 1

Question 1

The cell that is currently selected is known as ______

Answer 1

Active cell

Question 2

A cell is referenced by the column _______and row ________

Answer 2

Letter; number

Question 3

A cell B6; B refers to the ______and 6 refers to the _______

Answer 3

column ; row

Question 4

How to write date for the sake of excel class

Answer 4

International (y-m-d).

Question 5

This bar allows you to see what data is in a cell, and also edit the data.

Answer 5

Formula bar

Question 6

Where is the “quick access toolbar”?

Answer 6

Top , where “save” and “undo” are listed is known as the quick access toolbar.

Question 7

Bottom of workbook is another small bar called ______

Answer 7

Status bar

Question 8

_______ bar give you the average, count and sum of selected values.

Answer 8

Status bar

Question 9

You click on the active cell and then wants to select all of the cells what do you press?

Answer 9

Control + A

Question 10

How do you select non-continuous data?

Answer 10

Select the first set of data then press down command on your keyboard then next set of data

Question 11

What is the shortcut you used to switch between two open worksheets?

Answer 11

Ctrl + F6

Question 12

How do you use Freeze panes?

Answer 12

click in the cell directly right and directly below the columns and rows you want to freeze. So, you can see are below row three and to the right of column three

Question 13

How do you add continous dates? Like 3/14/2025 all the way down to 3/20/25 (columns?

Answer 13

Double click on the fill handle of the first date

Question 14

With dates you get a ______and with numbers you get a _____copy

Answer 14

series; copy

Question 15

There are ______________columns in an Excel spreadsheet

Answer 15

16,384

Question 16

There are _____________rows in an Excel spreadsheet.

Answer 16

1,048,576

Question 17

How do you hide columns

Answer 17

Column+Shift+”—>” or right click hide

Question 18

The large toolbar that stretches across the top of the Excel window is known as the_________

Answer 18

Ribbon

Question 19

True or False? Clicking on cell C3 and clicking Freeze Panes will freeze the top 3 rows and the first 3 columns.

Answer 19

False , it will freeze the top 2 rows (not 3 rows) and the first 2 columns.

Question 20

What is relative cell referencing?

Answer 20

For example, when you’re using the fill handle, excel automatically change the formula going down (E5; E6 , E7 etc. and the values change based on the data.

Question 21

What is ABSOLUTE CELL REFERENCING

Answer 21

Absolute cell referencing is when you’re using one cell (for example commission 5%) to fill handle other data and you want excell to use that one cell to calculate all other values.

Question 22

What sign do you use for Absolute cell referencing? Say you’re referencing cell F4

Answer 22

$F$4

Question 23

What is the quick way to convert a cell J1 to $J$1?

Answer 23

Fn + F4 (MAC users)
F4 (windows users)

Question 24

If I have two different columns with first and last name, and want to put first name and last name together on different column, what should I do?

Answer 24

First, do the first row then flash fill the remaining columns